MySQL运行状态数据查看分析


查看线程、连接数

show global status like 'Threads_%';

### innodb_buffer_pool

show global status like 'innodb_buffer_pool%';

show variables like 'innodb_page_size';

page大小,默认是16KB

show global status like 'Connection_%';

show variables like 'innodb_buffer_pool%';

innodb_buffer_pool_instances 缓冲池实例的数量,8 (or 1 if innodb_buffer_pool_size < 1GB)

参考文档

http://www.server110.com/mysql/201704/73311.html