mysql指标 |mysql 参数化传值

// 查看服务器版本SELECT VERSION();// 查看数据库的总大小和使用的大小SELECT 
table_schema AS `Database`, 
SUM(data_length + index_length) / 1024 / 1024 AS `Size (MB)`, 
SUM(data_free) / 1024 / 1024 AS `Free (MB)` 
FROM 
information_schema.TABLES 
GROUP BY 
table_schema;// 查看当前连接数量SHOW STATUS like 'Threads_connected';// 查看缓存命中率SELECT 
ROUND((1 - (SUM(com_select) / (SUM(com_select) + SUM(com_insert) + SUM(com_update) + SUM(com_delete) + SUM(com_replace)))) * 100, 2) AS `Hit %` 
FROM 
information_schema.`GLOBAL_STATUS`;// 查看响应时间SELECT 
event_name AS `Name`, 
COUNT_STAR AS `Calls`, 
ROUND(SUM_TIMER_WAIT/1000000000000000, 6) AS `Time (s)`, 
ROUND(SUM_TIMER_WAIT/1000000000/COUNT_STAR, 6) AS `Avg (s)` 
FROM 
performance_schema.events_statements_summary_by_digest 
GROUP BY 
event_name 
ORDER BY 
`Time (s)` DESC;// 查看索引使用情况SELECT 
ROUND(SUM(rows_examined)/SUM(IFNULL(nullif(rows_sent, 0), 1))) AS `Scanned Rows Per Output Row` 
FROM 
performance_schema.events_statements_summary_by_digest 
WHERE 
digest_text LIKE '%FROM `table_name`%' 
AND digest_text NOT LIKE '%FROM `table_name` WHERE%';

这些MySQL指标可以帮助用户监视数据库的健康状况、性能和流量。通过对这些指标的监控，用户可以更好地了解他们的应用程序对数据库的影响，从而优化应用程序和数据存储。