一,查看mysql缓存设置大小语句
show variables like 'innodb_buffer_pool%';
2,调整innodb_buffer_pool_size 大小语句
set global innodb_buffer_pool_size = 2147483648;
3,调整innodb_buffer_pool_chunk_size大小语句
set global innodb_buffer_pool_chunk_size= 134217728;
show variables like 'innodb_buffer_pool%';
2,调整innodb_buffer_pool_size 大小语句
set global innodb_buffer_pool_size = 2147483648;
3,调整innodb_buffer_pool_chunk_size大小语句
set global innodb_buffer_pool_chunk_size= 134217728;
本文标题:Mysql 常用语句
本文链接:https://www.haomeiwen.com/subject/zsomprtx.html
网友评论