{"id":1505,"date":"2023-11-08T17:19:42","date_gmt":"2023-11-08T09:19:42","guid":{"rendered":"https:\/\/www.mustenaka.cn\/?p=1505"},"modified":"2023-11-08T17:20:12","modified_gmt":"2023-11-08T09:20:12","slug":"mysql-checks-disk-usage","status":"publish","type":"post","link":"https:\/\/www.mustenaka.cn\/index.php\/2023\/11\/08\/mysql-checks-disk-usage\/","title":{"rendered":"MYSQL\u67e5\u770b\u78c1\u76d8\u5360\u7528\u60c5\u51b5"},"content":{"rendered":"<h1>MYSQL\u67e5\u770b\u78c1\u76d8\u5360\u7528\u60c5\u51b5<\/h1>\n<h4>\u67e5\u770b\u6240\u6709\u6570\u636e\u5e93\u5bb9\u91cf\u5927\u5c0f<\/h4>\n<pre class=\"pure-highlightjs\"><code class=\"\" null=\"\">use information_schema;\r\n\r\nselect\r\ntable_schema as '\u6570\u636e\u5e93',\r\nsum(table_rows) as '\u8bb0\u5f55\u6570',\r\nsum(truncate(data_length\/1024\/1024, 2)) as '\u6570\u636e\u5bb9\u91cf(MB)',\r\nsum(truncate(index_length\/1024\/1024, 2)) as '\u7d22\u5f15\u5bb9\u91cf(MB)'\r\n\r\nfrom information_schema.tables\r\ngroup by table_schema\r\norder by sum(data_length) desc, sum(index_length) desc;<\/code><\/pre>\n<h4>\u67e5\u770b\u6240\u6709\u6570\u636e\u5e93\u5404\u8868\u5bb9\u91cf\u5927\u5c0f<\/h4>\n<pre class=\"pure-highlightjs\"><code class=\"\" null=\"\">\r\nselect\r\ntable_schema as '\u6570\u636e\u5e93',\r\ntable_name as '\u8868\u540d',\r\ntable_rows as '\u8bb0\u5f55\u6570',\r\n \r\ntruncate(data_length\/1024\/1024, 2) as '\u6570\u636e\u5bb9\u91cf(MB)',\r\ntruncate(index_length\/1024\/1024, 2) as '\u7d22\u5f15\u5bb9\u91cf(MB)'\r\n \r\nfrom information_schema.tables\r\norder by data_length desc, index_length desc;<\/code><\/pre>\n<h4>\u67e5\u770b\u6307\u5b9a\u6570\u636e\u5e93\u5bb9\u91cf\u5927\u5c0f<\/h4>\n<pre class=\"pure-highlightjs\"><code class=\"\" null=\"\">select\r\ntable_schema as '\u6570\u636e\u5e93',\r\n\r\nsum(table_rows) as '\u8bb0\u5f55\u6570',\r\nsum(truncate(data_length\/1024\/1024, 2)) as '\u6570\u636e\u5bb9\u91cf(MB)',\r\nsum(truncate(index_length\/1024\/1024, 2)) as '\u7d22\u5f15\u5bb9\u91cf(MB)'\r\n \r\nfrom information_schema.tables\r\nwhere table_schema='mysql'<\/code><\/pre>\n<h4>\u67e5\u770b\u6307\u5b9a\u6570\u636e\u5e93\u5404\u8868\u5bb9\u91cf\u5927\u5c0f<\/h4>\n<pre class=\"pure-highlightjs\"><code class=\"\" null=\"\">select\r\ntable_schema as '\u6570\u636e\u5e93',\r\ntable_name as '\u8868\u540d',\r\ntable_rows as '\u8bb0\u5f55\u6570',\r\n \r\ntruncate(data_length\/1024\/1024, 2) as '\u6570\u636e\u5bb9\u91cf(MB)',\r\ntruncate(index_length\/1024\/1024, 2) as '\u7d22\u5f15\u5bb9\u91cf(MB)'\r\n \r\nfrom information_schema.tables\r\nwhere table_schema='mysql'\r\norder by data_length desc, index_length desc;<\/code><\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MYSQL\u67e5\u770b\u78c1\u76d8\u5360\u7528\u60c5\u51b5 \u67e5\u770b\u6240\u6709\u6570\u636e\u5e93\u5bb9\u91cf\u5927\u5c0f use information_schema;  [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[124],"tags":[110],"class_list":["post-1505","post","type-post","status-publish","format-standard","hentry","category-sql","tag-mysql"],"views":1495,"_links":{"self":[{"href":"https:\/\/www.mustenaka.cn\/index.php\/wp-json\/wp\/v2\/posts\/1505","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mustenaka.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mustenaka.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mustenaka.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mustenaka.cn\/index.php\/wp-json\/wp\/v2\/comments?post=1505"}],"version-history":[{"count":1,"href":"https:\/\/www.mustenaka.cn\/index.php\/wp-json\/wp\/v2\/posts\/1505\/revisions"}],"predecessor-version":[{"id":1506,"href":"https:\/\/www.mustenaka.cn\/index.php\/wp-json\/wp\/v2\/posts\/1505\/revisions\/1506"}],"wp:attachment":[{"href":"https:\/\/www.mustenaka.cn\/index.php\/wp-json\/wp\/v2\/media?parent=1505"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mustenaka.cn\/index.php\/wp-json\/wp\/v2\/categories?post=1505"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mustenaka.cn\/index.php\/wp-json\/wp\/v2\/tags?post=1505"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}