Home  >  Article  >  Database  >  MySQL数据库维护中监控所用到的常用命令_MySQL

MySQL数据库维护中监控所用到的常用命令_MySQL

WBOY
WBOYOriginal
2016-06-01 13:25:22819browse

bitsCN.com

status = show status like ‘%%' [例:show status like 'Com_select']
variables = show variables like ‘%%' [例:show variables like 'query_cache_size']

1、MySQL查询次数(status)
Com_select;Com_update;Com_insert;Com_delete;Com_change_db

2、查询缓存空间大小:query_cache_size(variables)
查询缓存最大查询数据集大小:query_cache_limit(variables);
缓存中的查询个数:Qcache_inserts(status);
查询缓存命中率:(Qcache_hits/(Qcache_hits+Qcache_inserts))*100% (status)

3、索引缓存命中率
索引缓存空间大小:key_buffer_size (variables)
索引缓存命中率:(Key_reads/Key_read_requests)*100% (status)

4、并发连接数
最大充许连接数:max_connections(variables)
实际最大连接数:max_used_connections(status)
当前连接数:Threads_connected(status)
活跃连接数:Threads_running(status)
缓存连接数:Threads_cache(status)

5、流量统计(status)
Bytes_received ,Bytes_sent(status)

6、连接次数
每秒连接次数:Connections(status)
每秒实际创建连接次数:Threads_created(status)

7、表锁定统计
立即释放的表锁数:Table_locks_immediate(status)
需要等待的表锁数:Table_locks_waited(status)

bitsCN.com
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn