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