Mysql 5.6 Installation

has been used in the 5.1 version, because the new business needs 5.6, installed and made notes

MySQL5.6 some new features:

InnoDB can now limit the amount of memory consumed when a large number of tables are open (a third party already has patches)

InnoDB performance enhancement. such as split kernel Mutex;flush operation from the main thread separation; multiple perge threads; large memory optimization, etc.

InnoDB deadlock information can be logged to the error log for easy analysis

MySQL5.6 supports time-lapse replication, allowing the slave to control an interval between the master and primary to facilitate data recovery in special cases.

Table Partitioning Enhancements

MySQL row-level replication is enhanced to reduce resource overhead such as disk, memory, and network (only fields that determine Row records can be recorded)

Binlog Implementation Crash-safe

Replication events with CRC32 checksum for enhanced Master/slave replication data consistency

New Log_bin_basename (previously variables there is no Binlog location information, the database monitoring is not convenient)

See: http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html

[[email protected] tools]# tar xvf mysql-5.6.19.tar.gz[[email protected]  Tools]# cd mysql-5.6.19[[email protected] mysql-5.6.19]# groupadd mysql[[email  protected] mysql-5.6.19]# useradd mysql -g mysql -m -s /sbin/ Nologin[[email protected] mysql-5.6.19]# cmake -dcmake_install_prefix=/usr/local/mysql  \  #安装路径-dmysql_datadir=/usr/local/mysql/data \ #数据文件存放位置-dsysconfdir=/etc  \# MY.CNF Path-dwith_myisam_storage_engine=1 \ #支持MyIASM引擎-dwith_innobase_storage_engine=1 \# Support InnoDB engine-dwith_memory_storage_engine=1  \ #支持Memory引擎-dwith_readline=1 \ #快捷键功能-dmysql_tcp_port =3306 \ #端口-denabled_local_infile=1 \ #允许从本地导入数据-dwith_partition_storage_engine=1 \# Install the support database partition-dextra_charsets=all \ #安装所有的字符集-ddefault_charset=utf8 \ #默认字符-ddefault_collation=utf8_ General_ci[[email protected] mysql-5.6.19]# make && make install[[email protected] mysql-5.6.19]# cd /usr/local/ mysql/[[email protected] mysql]# chown -r mysql:mysql . [[email protected] mysql]# scripts/mysql_install_db --user=mysql[[email protected]  mysql]# chown -r root:mysql . [[email protected] mysql]# chown  -R mysql:mysql ./data[[email protected] mysql]# chmod -R ug+rwx   . [[email protected] mysql]# cp support-files/my-default.cnf /etc/my.cnf[[ Email protected] mysql]# bin/mysqld_safe --user=mysql &[[email protected]  mysql]# cp support-files/mysql.server /etc/init.d/mysql[[email protected] mysql ]# chmod 755 /etc/init.d/mysql [[email protected] mysql]# echo  "Export  path=/usr/local/mysql/bin: $PATH " ≫> /etc/profile[[email protected] mysql]# source /etc/profile 

Mysql 5.6 Installation