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)
martes, 9 de junio de 2020
Listar el tamaño de todas las bases de datos.
Suscribirse a:
Enviar comentarios (Atom)
No hay comentarios:
Publicar un comentario