{"id":4086,"date":"2023-05-21T10:59:47","date_gmt":"2023-05-21T08:59:47","guid":{"rendered":"https:\/\/www.sigalou-domotique.fr\/?p=4086"},"modified":"2026-01-02T17:01:45","modified_gmt":"2026-01-02T15:01:45","slug":"verifier-la-taille-de-sa-base-de-donnees","status":"publish","type":"post","link":"https:\/\/www.sigalou-domotique.fr\/zh\/verifier-la-taille-de-sa-base-de-donnees","title":{"rendered":"\u6211\u68c0\u67e5\u6211\u7684\u6570\u636e\u5e93\u7684\u5927\u5c0f\u3002"},"content":{"rendered":"<p>\u4e5f\u8bb8\u5728\u5bb6\u5ead\u52a9\u7406\u4e0b\uff0c\u6211\u6700\u5927\u7684\u60ca\u559c\u662f\u6570\u636e\u5e93\u7684\u5927\u5c0f\u3002<\/p>\r\n<p>\u8fd9\u662f\u4e00\u4e2a\u771f\u6b63\u7684\u4e3b\u9898\uff0c\u5f53\u6211\u7684\u57fa\u7840\u8d85\u8fc710GB\u65f6\uff0c\u6211\u5f00\u59cb\u505a\u51fa\u53cd\u5e94\uff0c\u4f60\u5fc5\u987b\u62c5\u5fc3\u5b83\uff0c\u6709\u4e9b\u5f55\u97f3\u4e0d\u5e94\u8be5\u88ab\u8bb0\u5f55\u3002 \u4e00 \u53f7 \u300b<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-4096\" src=\"https:\/\/www.sigalou-domotique.fr\/wp-content\/uploads\/2023\/05\/sql0.png\" alt=\"\" width=\"299\" height=\"194\" srcset=\"https:\/\/www.sigalou-domotique.fr\/wp-content\/uploads\/2023\/05\/sql0.png 590w, https:\/\/www.sigalou-domotique.fr\/wp-content\/uploads\/2023\/05\/sql0-300x195.png 300w\" sizes=\"auto, (max-width: 299px) 100vw, 299px\" \/><!--more--><\/p>\r\n<p>\u9996\u5148\uff0c\u4f60\u5982\u4f55\u77e5\u9053\u4f60\u7684\u6570\u636e\u5e93\u7684\u5927\u5c0f\uff1f<\/p>\r\n<h3>\u6211\u76f4\u63a5\u770b\u4ed6\u7684\u6863\u6848<\/h3>\r\n<p>\u8fd9\u662f\u77e5\u60c5\u7528\u6237\u7684\u7ecf\u5178\u65b9\u6cd5\uff0c\u6211\u901a\u8fc7WinSCP\u7b49\u7ecf\u5178\u5de5\u5177\u67e5\u770b\u6587\u4ef6\u5927\u5c0f\u3002<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4087\" src=\"https:\/\/www.sigalou-domotique.fr\/wp-content\/uploads\/2023\/05\/sql1.png\" alt=\"\" width=\"698\" height=\"324\" srcset=\"https:\/\/www.sigalou-domotique.fr\/wp-content\/uploads\/2023\/05\/sql1.png 698w, https:\/\/www.sigalou-domotique.fr\/wp-content\/uploads\/2023\/05\/sql1-600x279.png 600w, https:\/\/www.sigalou-domotique.fr\/wp-content\/uploads\/2023\/05\/sql1-300x139.png 300w\" sizes=\"auto, (max-width: 698px) 100vw, 698px\" \/><\/p>\r\n<p>\u5f53\u7136\uff0c\u5b83\u4e0d\u662f\u5f88\u53cb\u597d\u7684\u7528\u6237\uff0c\u6211\u53ef\u4ee5\u505a\u5f97\u66f4\u597d\uff0c\u4f46\u5b83\u662f\u5b9e\u7528\u7684\u3002<\/p>\r\n<h3>\u6211\u5728\u5730\u56fe\u4e2d\u663e\u793a\u5b9e\u4f53\u00a0<\/h3>\r\n<p>\u8be5\u4fe1\u606f\u5728 sensor.home_assistant_v2_db_size \u4e2d\u53ef\u7528\u3002<\/p>\r\n<p>\u5b89\u88c5 \u5b89\u88c5 <a href=\"https:\/\/www.home-assistant.io\/integrations\/filesize\" target=\"_blank\" rel=\"noopener\">\u6587\u4ef6\u5927\u5c0f<\/a>, \u4e00\u5207\u90fd\u662f\u81ea\u52a8\u7684<\/p>\r\n<p><a href=\"https:\/\/my.home-assistant.io\/redirect\/config_flow_start?domain=filesize\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3632\" src=\"https:\/\/www.sigalou-domotique.fr\/wp-content\/uploads\/2023\/04\/addintegration.png\" alt=\"\" width=\"202\" height=\"27\" \/><\/a><\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4088\" src=\"https:\/\/www.sigalou-domotique.fr\/wp-content\/uploads\/2023\/05\/sql2.png\" alt=\"\" width=\"790\" height=\"155\" srcset=\"https:\/\/www.sigalou-domotique.fr\/wp-content\/uploads\/2023\/05\/sql2.png 790w, https:\/\/www.sigalou-domotique.fr\/wp-content\/uploads\/2023\/05\/sql2-600x118.png 600w, https:\/\/www.sigalou-domotique.fr\/wp-content\/uploads\/2023\/05\/sql2-300x59.png 300w, https:\/\/www.sigalou-domotique.fr\/wp-content\/uploads\/2023\/05\/sql2-768x151.png 768w\" sizes=\"auto, (max-width: 790px) 100vw, 790px\" \/><\/p>\r\n<p>\u6709\u4e86\u8fd9\u4e2a\u5b9e\u4f53\uff0c\u6211\u663e\u793a\u4fe1\u606f\uff0c\u5b83\u7ed9\u51fa\u4e86\u57fa\u7840\u7684\u5927\u5c0f\uff0c\u663e\u7136\u5b83\u53ef\u4ee5\u5b9a\u5236\u3002<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4089\" src=\"https:\/\/www.sigalou-domotique.fr\/wp-content\/uploads\/2023\/05\/sql3.png\" alt=\"\" width=\"381\" height=\"148\" srcset=\"https:\/\/www.sigalou-domotique.fr\/wp-content\/uploads\/2023\/05\/sql3.png 381w, https:\/\/www.sigalou-domotique.fr\/wp-content\/uploads\/2023\/05\/sql3-300x117.png 300w\" sizes=\"auto, (max-width: 381px) 100vw, 381px\" \/><\/p>\r\n<h3>\u6211\u8d28\u7591\u6570\u636e\u5e93<\/h3>\r\n<p>\u5f53\u7136\uff0c\u4f60\u4e0d\u5fc5\u4ec5\u4ec5\u4e3a\u6b64\u5b89\u88c5\u5b83\uff0c\u4f46\u6211\u5229\u7528\u672c\u6559\u7a0b\u6765\u7a81\u51fa\u663e\u793a\u6570\u636e\u5e93\u7684SQL\u4fe1\u606f\u7684\u4e00\u4e2a\u5f88\u597d\u7684\u96c6\u6210\u3002<\/p>\r\n<p>\u4f5c\u4e3a\u524d PHP\/MYSQL \u5f00\u53d1\u4eba\u5458\uff0c\u6211\u53d1\u73b0\u4e86 phpMyAdmin \u7684\u4e00\u4e9b\u903b\u8f91\u3002<\/p>\r\n<p>\u6211\u5fc5\u987b\u5b89\u88c5 <a href=\"https:\/\/my.home-assistant.io\/redirect\/supervisor_addon\/?addon=a0d7b954_sqlite-web&amp;repository_url=https%3A%2F%2Fgithub.com%2Fhassio-addons%2Frepository\" target=\"_blank\" rel=\"noopener nofollow ugc\">SQLite Web \u63d2\u4ef6<\/a><\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4094\" src=\"https:\/\/www.sigalou-domotique.fr\/wp-content\/uploads\/2023\/05\/sql.png\" alt=\"\" width=\"1069\" height=\"741\" srcset=\"https:\/\/www.sigalou-domotique.fr\/wp-content\/uploads\/2023\/05\/sql.png 1069w, https:\/\/www.sigalou-domotique.fr\/wp-content\/uploads\/2023\/05\/sql-600x416.png 600w, https:\/\/www.sigalou-domotique.fr\/wp-content\/uploads\/2023\/05\/sql-300x208.png 300w, https:\/\/www.sigalou-domotique.fr\/wp-content\/uploads\/2023\/05\/sql-1024x710.png 1024w, https:\/\/www.sigalou-domotique.fr\/wp-content\/uploads\/2023\/05\/sql-768x532.png 768w\" sizes=\"auto, (max-width: 1069px) 100vw, 1069px\" \/><\/p>\r\n<p>&nbsp;<\/p>","protected":false},"excerpt":{"rendered":"<p>\u4e5f\u8bb8\u5728\u5bb6\u5ead\u52a9\u7406\u4e0b\uff0c\u6211\u6700\u5927\u7684\u60ca\u559c\u662f\u6570\u636e\u5e93\u7684\u5927\u5c0f\u3002 \u8fd9\u662f\u4e00\u4e2a\u771f\u6b63\u7684\u4e3b\u9898\uff0c\u5f53\u6211\u7684\u57fa\u7840\u8d85\u8fc710GB\u65f6\uff0c\u6211\u5f00\u59cb\u505a\u51fa\u53cd\u5e94\uff0c\u4f60\u5fc5\u987b\u62c5\u5fc3\u5b83\uff0c\u6709\u4e9b\u5f55\u97f3\u4e0d\u5e94\u8be5\u88ab\u8bb0\u5f55\u3002 \u4e00 \u53f7 \u300b<\/p>","protected":false},"author":1,"featured_media":4096,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[14,53,166],"tags":[81],"class_list":["post-4086","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-domotique","category-home-assistant","category-retex","tag-developpement"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sigalou-domotique.fr\/zh\/wp-json\/wp\/v2\/posts\/4086","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sigalou-domotique.fr\/zh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sigalou-domotique.fr\/zh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sigalou-domotique.fr\/zh\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sigalou-domotique.fr\/zh\/wp-json\/wp\/v2\/comments?post=4086"}],"version-history":[{"count":0,"href":"https:\/\/www.sigalou-domotique.fr\/zh\/wp-json\/wp\/v2\/posts\/4086\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sigalou-domotique.fr\/zh\/wp-json\/wp\/v2\/media\/4096"}],"wp:attachment":[{"href":"https:\/\/www.sigalou-domotique.fr\/zh\/wp-json\/wp\/v2\/media?parent=4086"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sigalou-domotique.fr\/zh\/wp-json\/wp\/v2\/categories?post=4086"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sigalou-domotique.fr\/zh\/wp-json\/wp\/v2\/tags?post=4086"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}