Ubuntu14.0.4安装及配置系列-mysql5.6的安装配置

安装

1
apt-get install mysql-server-5.6

启动

1
# /etc/init.d/mysql start

停止

1
# /etc/init.d/mysql stop

重启

1
# /etc/init.d/mysql restart

调整内存

修改/etc/mysql/my.cnf,在[mysqld]后面追加

1
2
3
performance_schema_max_table_instances=200
table_definition_cache=200
table_open_cache=128