Mysql命令

查看MySQL缓冲池字节大小

show variables like "%_buffer_pool_size%";

修改 innodb_buffer_pool_size的值，下面修改的是3G。

3G = 3 x 1024 x 1024 x 1024 = 67108864;

SET GLOBAL innodb_buffer_pool_size=67108864;