Skip to content →

Tag: DB

Connaître la taille de vos bases MySQL

Published 19/03/2012 by Fabien Vincent

Pour connaître la taille des bases de données MySQL que vous hébergez sur votre serveur, en root :

En ko :

SELECT table_schema "Data Base Name", 
                     sum( data_length + index_length ) / 1024 "Data Base Size in KB",
                     sum( data_free )/ 1024 "Free Space in KB"
FROM information_schema.TABLES 
GROUP BY table_schema ;

En Mo :

SELECT table_schema "Data Base Name", 
                     sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB",
                     sum( data_free )/ 1024 / 1024 "Free Space in MB"
FROM information_schema.TABLES 
GROUP BY table_schema ;

 

Comments closed