mysql 优化

set global innodb_flush_log_at_trx_commit=2;

查看
show variables like'%max_connections%';
设置
set GLOBAL max_connections=2000;

show variables like '%storage_engine%';

show variables like 'innodb_file_format';

set  global innodb_large_prefix=on;

show variables like 'innodb_large_prefix';

grant process on *.* to root;

select * from mysql.user where user='root'