Ver el tamaño de las bases de datos en MySQL o MariaDB

Para el tamaño de las bases de datos en MB

SELECT table_schema «database», sum(data_length + index_length)/1024/1024 «size in MB» FROM information_schema.TABLES GROUP BY table_schema;

1	SELECT table_schema «database», sum(data_length + index_length)/1024/1024 «size in MB» FROM information_schema.TABLES GROUP BY table_schema;

Para ver el tamaño en GB

SELECT table_schema «database», sum(data_length + index_length)/1024/1024/1024 «size in GB» FROM information_schema.TABLES GROUP BY table_schema;

1	SELECT table_schema «database», sum(data_length + index_length)/1024/1024/1024 «size in GB» FROM information_schema.TABLES GROUP BY table_schema;

Para ver el tamaño de las tablas

SELECT table_schema AS DB_NAME, TABLE_NAME, (DATA_LENGTH+INDEX_LENGTH)/1024/1024 AS TABLE_SIZE_in_MB FROM information_schema.TABLES;

1	SELECT table_schema AS DB_NAME, TABLE_NAME, (DATA_LENGTH+INDEX_LENGTH)/1024/1024 AS TABLE_SIZE_in_MB FROM information_schema.TABLES;

Si queremos ver una base de datos especifica ejecutamos

SELECT table_name AS «Table», ROUND(((data_length + index_length) / 1024 / 1024), 2) AS «Size (MB)» FROM information_schema.TABLES WHERE table_schema = «testdb» ORDER BY (data_length + index_length) DESC;

1	SELECT table_name AS «Table», ROUND(((data_length + index_length) / 1024 / 1024), 2) AS «Size (MB)» FROM information_schema.TABLES WHERE table_schema = «testdb» ORDER BY (data_length + index_length) DESC;

UDP Soporte y Comunicaciones

Ver el tamaño de las bases de datos en MySQL o MariaDB

Comentarios

Deja una respuesta Cancelar la respuesta