Skip to content →

Tag: MySQL

Connaître la taille de vos bases MySQL

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

En ko :

1
2
3
4
5
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 :

1
2
3
4
5
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
en_USEN