{"id":5402,"date":"2020-07-30T00:20:45","date_gmt":"2020-07-29T16:20:45","guid":{"rendered":"http:\/\/39.97.231.10\/?p=5402"},"modified":"2020-07-30T00:20:45","modified_gmt":"2020-07-29T16:20:45","slug":"mysql-innodb-%e6%95%b0%e6%8d%ae%e9%a1%b5%e4%b8%80%e8%87%b4%e6%80%a7%e6%a0%a1%e9%aa%8c%e5%b7%a5%e5%85%b7-innochecksum","status":"publish","type":"post","link":"http:\/\/www.weijing.co\/?p=5402","title":{"rendered":"MySQL innodb \u6570\u636e\u9875\u4e00\u81f4\u6027\u6821\u9a8c\u5de5\u5177 innochecksum"},"content":{"rendered":"<div>\n<div>\n<div>\n<div>\nMySQL innochecksum \u5de5\u5177\u4e3b\u8981\u7528\u4e8eMySQL innodb\u8868\u7a7a\u95f4\u6587\u4ef6\u6570\u636e\u4e00\u81f4\u6027\u7684\u6821\u9a8c\uff0c\u901a\u8fc7\u8bfb\u53d6\u8868\u7a7a\u95f4\u6587\u4ef6\uff0c\u8ba1\u7b97\u9875\u7684checksum\u503c\uff0c\u5c06\u8ba1\u7b97\u7684\u7ed3\u679c\u4e0e\u9875\u5185\u5b58\u50a8\u7684checksum\u503c\u8fdb\u884c\u5bf9\u6bd4\uff0c\u68c0\u67e5\u5bf9\u6bd4\u7ed3\u679c\u662f\u5426\u4e00\u81f4\uff0c\u5982\u679c\u4e0d\u4e00\u81f4\uff0c\u8bf4\u660e\u6587\u4ef6\u9875\u53ef\u80fd\u53d1\u751f\u4e86\u635f\u574f\uff0cinnochecksum\u5de5\u5177\u540c\u65f6\u63d0\u4f9b\u4e86checksum\u6821\u9a8c\u503c\u4fee\u590d\u529f\u80fd\uff0c\u80fd\u591f\u5c06\u9875checksum\u503c\u4e0d\u6b63\u786e\u7684\u9875\u8fdb\u884c\u4fee\u590d\u3002<\/p>\n<h5>\u53ea\u80fd\u79bb\u7ebf\u6821\u9a8c\uff1a<\/h5>\n<p>innochecksum\u53ea\u80fd\u7528\u6765\u79bb\u7ebf\u6821\u9a8cinnodb\u6587\u4ef6\uff0c\u5982\u679c\u6587\u4ef6\u5df2\u7ecf\u88abmysql server\u6253\u5f00\uff0c\u5219\u4f1a\u62a5\u9519\uff0c\u62a5\u9519\u4fe1\u606f\u901a\u5e38\u5982\u4e0b\uff1a<br \/>\nError: Unable to lock file::\/data\/mysql\/data_5.7.19\/ibdata1<br \/>\nfcntl: Resource temporarily unavailable<\/p>\n<h5>\u6e90\u7801\u6587\u4ef6\uff1a<\/h5>\n<p>innochecksum\u6e90\u7801\u6587\u4ef6\u4f4d\u4e8eextra\/innochecksum.cc\uff0c\u7f16\u8bd1\u751f\u6210\u53ef\u6267\u884c\u6587\u4ef6innochecksum\u3002\u4e0b\u9762\u5c06\u57fa\u4e8eMySQL 5.7\u7248\u672c\u7684innochecksum\u8fdb\u884c\u4ecb\u7ecd\u3002<\/p>\n<h5>\u4e3b\u8981\u53c2\u6570\uff1a<\/h5>\n<ul>\n<li>&#8211;count\uff0c-c\uff0c\u8fd4\u56de\u8868\u7a7a\u95f4\u6587\u4ef6\u603b\u7684\u9875\u6570\u91cf<\/li>\n<li>&#8211;start-page=num, -s num\uff0c\u6821\u9a8c\u7684\u8d77\u59cb\u9875<\/li>\n<li>&#8211;end-page=num, -e num\uff0c\u6821\u9a8c\u7684\u7ed3\u675f\u9875<\/li>\n<li>&#8211;page=num, -p num\uff0c\u6821\u9a8c\u6307\u5b9a\u9875<\/li>\n<li>&#8211;strict-check, -C\uff0c\u6307\u5b9a\u6821\u9a8c\u7b97\u6cd5\uff0c\u53ea\u80fd\u6307\u5b9a\u4e3a innodb, crc32 \u6216 none<\/li>\n<li>&#8211;no-check, -n\uff0c\u5ffd\u7565checksum\u503c\u6821\u9a8c\uff0c\u76f4\u63a5\u91cd\u5199checksum\u503c\uff0c\u8fd9\u4e2a\u53c2\u6570\u901a\u5e38\u548c &#8211;write\u53c2\u6570\u4e00\u8d77\u4f7f\u7528<\/li>\n<li>&#8211;write=name, -w name\uff0c\u91cd\u5199\u6709\u6548\u7684checksum\u503c\uff0c\u5fc5\u987b\u6307\u5b9a\u6821\u9a8c\u7b97\u6cd5\uff0cinnodb, crc32 \u6216 none<\/li>\n<li>&#8211;allow-mismatches=num, -a num\uff0c\u5141\u8bb8checksum\u503c\u6821\u9a8c\u4e0d\u5339\u914d\u7684\u6700\u5927\u6b21\u6570\uff0c\u8d85\u8fc7\u8fd9\u4e2a\u6b21\u6570\uff0cinnochecksum\u7ec8\u6b62\u7ee7\u7eed\u6821\u9a8c<\/li>\n<li>&#8211;page-type-summary, -S\uff0c\u663e\u793a\u4e0d\u540c\u9875\u7c7b\u578b\u7684\u6570\u91cf<\/li>\n<li>&#8211;page-type-dump, -D\uff0c\u628a\u8868\u7a7a\u95f4\u4e2d\u7684\u9875\u7c7b\u578b\u4fe1\u606f\u8f93\u51fa\u5230\u6587\u4ef6\u6216\u8005\u6807\u51c6\u8f93\u51fa<\/li>\n<li>&#8211;log, -l\uff0c\u6307\u5b9a\u65e5\u5fd7\u6587\u4ef6\uff0cinnochecksum\u6267\u884c\u8fc7\u7a0b\u4e2d\u7684\u65e5\u5fd7\u4fe1\u606f\u8f93\u51fa\u5230\u65e5\u5fd7\u6587\u4ef6\u4e2d<\/li>\n<\/ul>\n<p>\u4e0b\u9762\u662f-c\u548c-S\u53c2\u6570\u7684\u793a\u4f8b\uff0c\u5982\u4e0b\uff1a<\/p>\n<pre>[root@localhost extra]# .\/innochecksum -c\u00a0\u00a0\/data\/mysql\/data_5.7.19\/ibdata1\nNumber of pages:768\n[root@localhost extra]# .\/innochecksum -S\u00a0\u00a0\/data\/mysql\/data_5.7.19\/ibdata1\nFile::\/data\/mysql\/data_5.7.19\/ibdata1\n================PAGE TYPE SUMMARY==============\n#PAGE_COUNT\u00a0\u00a0\u00a0\u00a0\u00a0PAGE_TYPE\n===============================================\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a019\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Index page\n\u00a0\u00a0\u00a0\u00a0\u00a0232\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Undo log page\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a04\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Inode page\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Insert buffer free list page\n\u00a0\u00a0\u00a0\u00a0\u00a0412\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Freshly allocated page\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Insert buffer bitmap\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a098\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0System page\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Transaction system page\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0File Space Header\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Extent descriptor page\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0BLOB page\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Compressed BLOB page\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Other type of page\n===============================================\nAdditional information:\nUndo page type: 142 insert, 90 update, 0 other\nUndo page state: 0 active, 179 cached, 2 to_free, 0\u00a0\u00a0to_purge, 0 prepared, 51 other\n<\/pre>\n<h5>\u4e3e\u4e2a\u4f8b\u5b50\uff0c\u4fee\u590d\u9875\u6821\u9a8c\u503c\uff1a<\/h5>\n<p>\u7b2c\u4e00\u6b65\uff0c\u4eba\u4e3a\u5236\u9020checksum\u503c\u4e0d\u4e00\u81f4\uff1a<br \/>\n\u4e00\u4e2a\u9875\u7684\u524d4\u4e2a\u5b57\u8282\u5b58\u50a8\u4e86\u8fd9\u4e2a\u9875\u7684\u6821\u9a8c\u503c\uff0c\u9996\u5148\u4eba\u4e3a\u5236\u9020\u9875\u6821\u9a8c\u503c\u635f\u574f\uff0c\u628a\u7b2c\u4e00\u4e2a\u9875\u7684\u524d4\u4e2a\u5b57\u8282\u4fee\u6539\u6210\u4e00\u4e2a\u65e0\u6548\u7684\u503c\u3002\u6bd4\u5982\u4e0b\u9762\u628a\u6821\u9a8c\u503c\u75310xcc5535c6\u4fee\u6539\u4e3a0x61616161\u3002<br \/>\n\u7b2c\u4e8c\u6b65\uff0c\u68c0\u6d4bchekcsum\u503c\u4e0d\u4e00\u81f4\uff1a<br \/>\n\u901a\u8fc7innochecksum\u8ba1\u7b97\u6821\u9a8c\u503c\uff0c\u53d1\u73b0page 0\u662f\u65e0\u6548\u7684\u3002<br \/>\ninnochecksum \u00a0\/data\/mysql\/data_5.7.19\/ibdata1<br \/>\nFail: page 0 invalid<br \/>\nExceeded the maximum allowed checksum mismatch count::0<br \/>\n\u7b2c\u4e09\u6b65\uff0c\u4fee\u590dchecksum\u503c\uff1a<br \/>\n\u518d\u4f7f\u7528innochecksum\u8fdb\u884c\u4fee\u590d\u3002<br \/>\ninnochecksum -w crc32 -n \/data\/mysql\/data_5.7.19\/ibdata1<br \/>\n\u4fee\u590d\u5b8c\u6210\u540e\uff0c\u518d\u770b\u4e00\u4e0b\u524d4\u4e2a\u5b57\u8282\u7684checksum\u503c\uff0c\u5df2\u7ecf\u6062\u590d\u6210\u4e860xcc5535c6\u3002<br \/>\n\u5982\u4e0b\u56fe\uff1a<\/p>\n<pre>[root@localhost extra]# hexdump -n 4 -C\u00a0\u00a0\/data\/mysql\/data_5.7.19\/ibdata1\n00000000\u00a0\u00a0cc 55 35 c6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|.U5.|\n00000004\n[root@localhost extra]# hexdump -n 4 -C\u00a0\u00a0\/data\/mysql\/data_5.7.19\/ibdata1\n00000000\u00a0\u00a061 61 61 61\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|aaaa|\n00000004\n[root@localhost extra]# .\/innochecksum\u00a0\u00a0\/data\/mysql\/data_5.7.19\/ibdata1\nFail: page 0 invalid\nExceeded the maximum allowed checksum mismatch count::0\n[root@localhost extra]# .\/innochecksum -w crc32 -n\u00a0\u00a0\/data\/mysql\/data_5.7.19\/ibdata1\n[root@localhost extra]# .\/innochecksum\u00a0\u00a0\/data\/mysql\/data_5.7.19\/ibdata1\n[root@localhost extra]# hexdump -n 4 -C\u00a0\u00a0\/data\/mysql\/data_5.7.19\/ibdata1\n00000000\u00a0\u00a0cc 55 35 c6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|.U5.|\n00000004\n<\/pre>\n<h5>\u6700\u540e\uff1a<\/h5>\n<p>innochecksum\u5de5\u5177\u63d0\u4f9b\u4e86\u975e\u5e38\u7b80\u5355\u3001\u5b9e\u7528\u7684\u65b9\u5f0f\u6765\u68c0\u67e5innodb\u8868\u7a7a\u95f4\u6587\u4ef6\u662f\u5426\u6709\u6548\uff0c\u540c\u65f6\u63d0\u4f9b\u4e86\u6821\u9a8c\u503c\u4fee\u590d\u529f\u80fd\uff0c\u6b64\u5916\u4e5f\u53ef\u4ee5\u901a\u8fc7\u8fd9\u4e2a\u5de5\u5177\uff0c\u5206\u6790\u8868\u7a7a\u95f4\u6587\u4ef6\u4e2d\u5404\u79cd\u9875\u7c7b\u578b\u7684\u6570\u91cf\uff0c\u5bf9\u4e8e\u7406\u89e3innodb\u8868\u7a7a\u95f4\u6587\u4ef6\u7ed3\u6784\u6709\u4e00\u5b9a\u7684\u5e2e\u52a9\u4f5c\u7528\u3002\n<\/p><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>MySQL innochecksum \u5de5\u5177\u4e3b\u8981\u7528\u4e8eMySQL innodb\u8868\u7a7a\u95f4\u6587\u4ef6\u6570\u636e\u4e00\u81f4\u6027\u7684\u6821\u9a8c\uff0c\u901a\u8fc7\u8bfb\u53d6 &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"http:\/\/www.weijing.co\/?p=5402\"> <span class=\"screen-reader-text\">MySQL innodb \u6570\u636e\u9875\u4e00\u81f4\u6027\u6821\u9a8c\u5de5\u5177 innochecksum<\/span> \u67e5\u770b\u5168\u6587 &raquo;<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[90,88],"tags":[],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"mailpoet_newsletter_max":false,"woocommerce_thumbnail":false,"woocommerce_single":false,"woocommerce_gallery_thumbnail":false,"shop_catalog":false,"shop_single":false,"shop_thumbnail":false},"uagb_author_info":{"display_name":"weijing","author_link":"http:\/\/www.weijing.co\/?author=4"},"uagb_comment_info":0,"uagb_excerpt":"MySQL innochecksum \u5de5\u5177\u4e3b\u8981\u7528\u4e8eMySQL innodb\u8868\u7a7a\u95f4\u6587\u4ef6\u6570\u636e\u4e00\u81f4\u6027\u7684\u6821\u9a8c\uff0c\u901a\u8fc7\u8bfb\u53d6&hellip;","_links":{"self":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts\/5402"}],"collection":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5402"}],"version-history":[{"count":0,"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts\/5402\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5402"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5402"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}