分类： LINUX
2009-07-01 15:46:05
显示查询缓存的统计信息
mysql> SHOW STATUS LIKE 'qcache%';
2.
mysql> SHOW STATUS LIKE 'open%tables';
3.
mysql> SHOW STATUS LIKE 'threads%';
4.
mysql> show status like '%key_read%';
5.
mysql> SHOW STATUS LIKE 'created_tmp%';
6.
mysql> SHOW STATUS LIKE "sort%";
7.
mysql> SHOW STATUS LIKE "com_select";
mysql> SHOW STATUS LIKE "handler_read_rnd_next";
