martes, 9 de junio de 2020

Listar el tamaño de todas las bases de datos.

mysql> SELECT table_schema AS "ebdb", ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Tamaño (MB)" FROM information_schema.TABLES GROUP BY table_schema;
+--------------------+--------------+
| ebdb               | Tamaño (MB)  |
+--------------------+--------------+
| curso1             |         4.05 |
| ebdb               |      3946.50 |
| farodb             |       640.95 |
| gym                |         0.70 |
| information_schema |         0.16 |
| live               |         8.88 |
| musica             |       712.17 |
| mysql              |         3.94 |
| netfam             |         0.55 |
| performance_schema |         0.00 |
| PFE                |        57.86 |
| plugins            |         0.67 |
| quirospacio        |         4.25 |
| sici1              |        17.09 |
| sici2              |        16.61 |
| sys                |         0.02 |
+--------------------+--------------+
16 rows in set (2.17 sec)

No hay comentarios:

Publicar un comentario