User Tools

Site Tools


zabbix_tamanho_tabelas

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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