show variables like "%_buffer%";
找 innodb_buffer_pool_size 默认是8M,显示的格式是 1M*1024*1024,修改为3G
SET GLOBAL innodb_buffer_pool_size=67108864;
持久化操作,在/etc/my.cnf中增加
[mysqld]
innodb_buffer_pool_size=1073741824
show variables like "%_buffer%";
找 innodb_buffer_pool_size 默认是8M,显示的格式是 1M*1024*1024,修改为3G
SET GLOBAL innodb_buffer_pool_size=67108864;
持久化操作,在/etc/my.cnf中增加
[mysqld]
innodb_buffer_pool_size=1073741824