8 décembre 2011
[MySQL] Taille des bases
Taille de toutes les bases en Mo:
SELECT table_schema As "Base", round(sum(data_length+index_length)/1024/1024,4) AS "Taille (Mo)" FROM information_schema.tables GROUP BY table_schema;
Taille de chaque table d’une base :
SELECT table_name AS "Tables", round(((data_length + index_length) / 1024 / 1024), 2) AS "Taille (Mo)" FROM information_schema.tables WHERE table_schema = 'base';
