Como saber el peso de una BBDD
Publicado por
xkable (1 intervención) el 21/08/2012 18:41:44
mysql> SELECT table_schema "DB_NAMEl", sum(data_length + index_length) / 1024 / 1024 "Tamaño en MB" FROM information_schema.TABLES GROUP BY table_schema;
+--------------------+---------------+
| abrecolocal | Tamaño en MB |
+--------------------+---------------+
| 480210_DBHost | 5.85407448 |
| 494349_repwal | 333.43488789 |
| abreco | 5.64062500 |
| abrecolocal | 4.40625000 |
| Brujo | 0.01562500 |
| db4 | 6.55373955 |
| information_schema | 0.00878906 |
| mysql | 0.63573170 |
| performance_schema | 0.00000000 |
+--------------------+---------------+
9 rows in set, 1 warning (5.36 sec)
mysql>