mysql常用命令

<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 11"><meta name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Cgehj%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><style> </style>

1. 显示查询缓存的统计信息

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";