Powered by Typecho)))
Optimized by EAimTY
本次文章完全使用 mysql 自带的 show 命令实现获取,从 connects、buffercache、lock、SQL、statement、Database throughputs、serverconfig7 大方面全面获取监控数据。
show status like 'Max_used_connections'
show status like 'Threads_connected'
show status like 'Innodb_buffer_pool_reads'
show status like 'Innodb_buffer_pool_read_requests'
show status like 'Innodb_buffer_pool_pages_total'
show status like 'Innodb_buffer_pool_pages_free'
(1-Innodb_buffer_pool_reads/Innodb_buffer_pool_read_requests)\*100%
((Innodb_buffer_pool_pages_total-Innodb_buffer_pool_pages_free)/Innodb_buffer_pool_pages_total)\*100%
show status like 'Innodb_row_lock_waits'
show status like 'Innodb_row_lock_time_avg'
show open TABLES where in_use>0;
有数据代表存在锁表,空为无表锁备注:锁等待统计得数量为累加数据,每次获取得时候可以跟之前得数据进行相减,得到当前统计得数据