{"id":64,"date":"2012-03-19T16:46:33","date_gmt":"2012-03-19T15:46:33","guid":{"rendered":"http:\/\/blog.beufa.net\/?p=64"},"modified":"2012-03-19T16:46:33","modified_gmt":"2012-03-19T15:46:33","slug":"connaitre-la-taille-de-vos-bases-mysql","status":"publish","type":"post","link":"https:\/\/beufa.net\/fr\/blog\/connaitre-la-taille-de-vos-bases-mysql\/","title":{"rendered":"Conna\u00eetre la taille de vos bases MySQL"},"content":{"rendered":"<p>Pour conna\u00eetre la taille des bases de donn\u00e9es MySQL que vous h\u00e9bergez sur votre serveur, en root :<\/p>\n<p>En ko :<\/p>\n<pre class=\"brush:sql\">SELECT table_schema \"Data Base Name\", \n                     sum( data_length + index_length ) \/ 1024 \"Data Base Size in KB\",\n                     sum( data_free )\/ 1024 \"Free Space in KB\"\nFROM information_schema.TABLES \nGROUP BY table_schema ;<\/pre>\n<p>En Mo :<\/p>\n<pre class=\"brush:sql\">SELECT table_schema \"Data Base Name\", \n                     sum( data_length + index_length ) \/ 1024 \/ 1024 \"Data Base Size in MB\",\n                     sum( data_free )\/ 1024 \/ 1024 \"Free Space in MB\"\nFROM information_schema.TABLES \nGROUP BY table_schema ;<\/pre>\n<p>&nbsp;<\/p>","protected":false},"excerpt":{"rendered":"<p>Pour conna\u00eetre la taille des bases de donn\u00e9es MySQL que vous h\u00e9bergez sur votre serveur, en root : En ko : SELECT table_schema &#8220;Data Base&#8230;<\/p>\n<div class=\"more-link-wrapper\"><a class=\"more-link\" href=\"https:\/\/beufa.net\/fr\/blog\/connaitre-la-taille-de-vos-bases-mysql\/\">Continue reading<span class=\"screen-reader-text\">Conna\u00eetre la taille de vos bases MySQL<\/span><\/a><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,21],"tags":[43,114,117],"class_list":["post-64","post","type-post","status-publish","format-standard","hentry","category-db","category-mysql","tag-database","tag-db","tag-mysql","entry"],"_links":{"self":[{"href":"https:\/\/beufa.net\/fr\/wp-json\/wp\/v2\/posts\/64","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/beufa.net\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beufa.net\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beufa.net\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/beufa.net\/fr\/wp-json\/wp\/v2\/comments?post=64"}],"version-history":[{"count":0,"href":"https:\/\/beufa.net\/fr\/wp-json\/wp\/v2\/posts\/64\/revisions"}],"wp:attachment":[{"href":"https:\/\/beufa.net\/fr\/wp-json\/wp\/v2\/media?parent=64"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beufa.net\/fr\/wp-json\/wp\/v2\/categories?post=64"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beufa.net\/fr\/wp-json\/wp\/v2\/tags?post=64"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}