This shows you the differences between two versions of the page.
— |
zabbix_tamanho_tabelas [2019/04/17 14:26] (current) eniocc created |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ===== Consultar tamanho tabelas MYSQL Zabbix ===== | ||
+ | '' | ||
+ | SELECT | ||
+ | TABLE_NAME AS `Table`, | ||
+ | ROUND(((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024),2) AS `Size (MB)` | ||
+ | FROM | ||
+ | information_schema.TABLES | ||
+ | WHERE | ||
+ | TABLE_SCHEMA = "zabbixserver" | ||
+ | ORDER BY | ||
+ | (DATA_LENGTH + INDEX_LENGTH) | ||
+ | DESC; | ||
+ | '' |