mysql巡检剧本php技巧_MySQL数据库巡检脚本

3.2 可根据须要自定义输入干系的内容如：

缓冲池大小：SHOW GLOBAL VARIABLES LIKE 'innodb_buffer_pool_size'; 缓冲池利用率：SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool_pages_free';查询缓存

查询缓存命中率：SHOW GLOBAL STATUS LIKE 'Qcache_hits'; 查询缓存碎片率：SHOW GLOBAL STATUS LIKE 'Qcache_free_memory';读写比例和吞吐量

读写比例：SHOW GLOBAL STATUS LIKE 'Com_select';和SHOW GLOBAL STATUS LIKE 'Com_insert'; 吞吐量：SHOW GLOBAL STATUS LIKE 'Innodb_rows_read';和SHOW GLOBAL STATUS LIKE 'Innodb_rows_inserted';锁的干系信息

表锁争用：SHOW GLOBAL STATUS LIKE 'Table_locks_waited';行锁等待韶光：SHOW GLOBAL STATUS LIKE 'Innodb_row_lock_time';行锁等待韶光均匀值：SHOW GLOBAL STATUS LIKE 'Innodb_row_lock_time_avg';