zabbix_tamanho_tabelas
Differences
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; | ||
| + | '' | ||
zabbix_tamanho_tabelas.txt · Last modified: 2019/04/17 14:26 by eniocc
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 3.0 Unported
