zabbix使用一段时间,需要查询数据库的使用情况,查询下各个表的使用情况
SELECT TABLE_NAME,DATA_LENGTH,INDEX_LENGTH,
(DATA_LENGTH+INDEX_LENGTH
) as length,TABLE_ROWS,concat
(round
((DATA_LENGTH+INDEX_LENGTH
)/1024/1024,3
),
'MB') as total_size FROM information_schema.TABLES WHERE TABLE_SCHEMA
='zabbix' order by length desc
;