{"id":4216,"date":"2017-08-21T15:23:14","date_gmt":"2017-08-21T15:23:14","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-determiner-la-taille-de-toutes-les-bases-de-donnees-mysql-sur-un-serveur\/"},"modified":"2026-07-28T18:26:31","modified_gmt":"2026-07-28T18:26:31","slug":"comment-determiner-la-taille-de-toutes-les-bases-de-donnees-mysql-sur-un-serveur","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-determiner-la-taille-de-toutes-les-bases-de-donnees-mysql-sur-un-serveur\/","title":{"rendered":"Comment d\u00e9terminer la taille de toutes les bases de donn\u00e9es MySQL sur un serveur ?"},"content":{"rendered":"","protected":false},"template":"","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","ga_subtitle":"Les administrateurs de bases de donn\u00e9es peuvent surveiller efficacement l'utilisation de l'espace de stockage en ex\u00e9cutant des requ\u00eates SQL sp\u00e9cifiques afin de r\u00e9cup\u00e9rer la taille totale et l'espace libre de toutes les bases de donn\u00e9es MySQL.","ga_short_answer":"Pour conna\u00eetre la taille de toutes les bases de donn\u00e9es MySQL sur un serveur, ex\u00e9cutez une requ\u00eate SQL sur la table `information_schema.TABLES`. Cela permet de calculer la longueur totale des donn\u00e9es et des index, ainsi que l'espace libre, pour chaque base de donn\u00e9es. Les r\u00e9sultats peuvent \u00eatre affich\u00e9s en m\u00e9gaoctets ou en octets, offrant ainsi une vue d'ensemble claire de l'utilisation de l'espace de stockage.","ga_scenario":"Les administrateurs de bases de donn\u00e9es doivent souvent surveiller l\u2019utilisation de l\u2019espace de stockage de leurs serveurs MySQL. Il est essentiel de conna\u00eetre la taille de chaque base de donn\u00e9es ainsi que l\u2019espace libre total disponible pour planifier la capacit\u00e9, optimiser les performances et garantir une allocation efficace des ressources. Ces informations permettent d\u2019identifier les bases de donn\u00e9es volumineuses qui pourraient n\u00e9cessiter une optimisation ou un espace de stockage suppl\u00e9mentaire.","ga_solution":"Pour d\u00e9terminer la taille de toutes les bases de donn\u00e9es MySQL sur un serveur, utilisez l\u2019une des commandes SQL suivantes. Ces commandes interrogent la table `information_schema.TABLES` afin de regrouper les donn\u00e9es et les longueurs d\u2019index, ainsi que l\u2019espace libre, pour chaque sch\u00e9ma.Pour afficher la taille en m\u00e9gaoctets (Mo) :\n\n```\nSELECT 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 BYtable_schema;\n```\n\nPour afficher la taille en octets (o) :\n\n```\nSELECT table_schema \"Data Base Name\", sum( data_length + index_length) \"Data Base Size in Bytes\", sum( data_free ) \"Free Space in Bytes\"FROM information_schema.TABLES GROUP BY table_schema;\n```","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T17:23:14+02:00","ga_date_verified":"2026-07-05","ga_source_subject":"How to find size of all the MySQL databases on a server?","ga_ans_id":"ANS-0557","ga_publish_decision":"publish","ga_staleness_risk":"high","ga_review_priority":"verify_soon","ga_tier2_verdict":"still_accurate","ga_tier2_concerns":"","ga_final_category":"Other \/ Uncategorized","footnotes":""},"ga_category":[109,31,109],"ga_audience":[30],"ga_difficulty":[92],"class_list":["post-4216","qa_entry","type-qa_entry","status-publish","hentry","ga_category-autres","ga_category-other","ga_audience-it-integration-team","ga_difficulty-niveau-intermediaire"],"taxonomy_info":{"ga_category":[{"value":109,"label":"Autres"},{"value":31,"label":"Other"},{"value":109,"label":"Autres"}],"ga_audience":[{"value":30,"label":"IT\/integration team"}],"ga_difficulty":[{"value":92,"label":"Niveau interm\u00e9diaire"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/4216","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry"}],"about":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/types\/qa_entry"}],"version-history":[{"count":1,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/4216\/revisions"}],"predecessor-version":[{"id":6137,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/4216\/revisions\/6137"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=4216"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=4216"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=4216"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=4216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}