Entradas

Mostrando entradas de diciembre, 2018

ver el tamaño de las tablas MySQL

SELECT table_name AS "Tabla",         round(((data_length + index_length) / 1024 / 1024), 2) "MB"  FROM information_schema.TABLES  WHERE table_schema = "NombreDeLaBaseDeDatos" ORDER BY (data_length + index_length) DESC; SELECT table_name AS "Tabla",         round(((data_length + index_length) / 1024 / 1024 / 1024), 2) "GB"  FROM information_schema.TABLES  WHERE table_schema = "NombreDeLaBaseDeDatos" ORDER BY (data_length + index_length) DESC;