{"id":2635,"date":"2021-11-27T16:41:44","date_gmt":"2021-11-27T07:41:44","guid":{"rendered":"https:\/\/www.kinryo.net\/?p=2635"},"modified":"2021-11-27T16:41:44","modified_gmt":"2021-11-27T07:41:44","slug":"mariadb-mysql-%e3%81%a7warning","status":"publish","type":"post","link":"https:\/\/www.kinryo.net\/?p=2635","title":{"rendered":"mariadb (mysql) \u3067Warning"},"content":{"rendered":"

mariadb\u306e\u5168\u30c6\u30fc\u30d6\u30eb\u3092\u30c1\u30a7\u30c3\u30af\u3059\u308b
\n#<\/span> mysqlcheck -c -u root -p -A<\/span><\/p>\n

wp_xxxxx.wp_options<\/span>
\nWarning : InnoDB: The B-tree of index option_name is corrupted.<\/span>
\nWarning : InnoDB: The B-tree of index autoload is corrupted.<\/span>
\nerror : Corrupt<\/span>
\nwp_xxxxx.wp_postmeta<\/span>
\nWarning : InnoDB: The B-tree of index post_id is corrupted.<\/span>
\nWarning : InnoDB: The B-tree of index meta_key is corrupted.<\/span>
\nerror : Corrupt<\/span>
\nwp_xxxxx.wp_posts<\/span>
\nWarning : InnoDB: The B-tree of index post_name is corrupted.<\/span>
\nWarning : InnoDB: The B-tree of index type_status_date is corrupted.<\/span>
\nWarning : InnoDB: The B-tree of index post_parent is corrupted.<\/span>
\nWarning : InnoDB: The B-tree of index post_author is corrupted.<\/span>
\nerror : Corrupt<\/span>
\n\u30ef\u30fc\u30cb\u30f3\u30b0\u90e8\u5206\u3092\u629c\u7c8b\uff1a
\n<\/span>\u30c7\u30fc\u30bf\u30fc\u30d9\u30fc\u30b9\u306b\u5165\u308a\u3001reapir table wp_options; \u3067\u30a8\u30e9\u30fc\u304c\u51fa\u308b\u3002\u305d\u3046\u3060InnoDB \u306freapir table \u3092\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u3044\u306a\u3044\u3093\u3060\u3063\u3051\u3002
\n\u306a\u306e\u3067\u3001\/etc\/my.cnf \u306e [mysqld] \u306b\u4e0b\u8a18\u3092\u8ffd\u8a18\u3057\u3066\u3092\u518d\u8d77\u52d5
\ninnodb_force_recovery = 1<\/span>
\n\u53f3\u306e\u6570\u5b57\u30923\u306b\u3057\u3001\u518d\u8d77\u52d5\u3067\u3082\u6cbb\u3063\u3066\u3044\u306a\u3044\u3002
\n\u8272\u3005\u30b0\u30b0\u308b\u3068 optimize table \u304c\u4f7f\u3048\u305d\u3046\u306a\u306e\u3067\u3001\u30c7\u30fc\u30bf\u30fc\u30d9\u30fc\u30b9\u306b\u5165\u308a\u3001DB\u540d\u3067\u4f7f\u7528\u3059\u308bDB\u3092\u6307\u5b9a\u3057<\/p>\n

\n
optimize table wp_options;\r\n+----------------------+----------+----------+-------------------------------------------------------------------+\r\n| Table                | Op       | Msg_type | Msg_text                                                          |\r\n+----------------------+----------+----------+-------------------------------------------------------------------+\r\n| wp_iguchi.wp_options | optimize | note     | Table does not support optimize, doing recreate + analyze instead |\r\n| wp_iguchi.wp_options | optimize | status   | OK                                                                |\r\n+----------------------+----------+----------+-------------------------------------------------------------------+\r\n2 rows in set (0.052 sec)<\/code><\/pre>\n<\/div>\n
\u304a\uff01 \u76f4\u305f\u307f\u305f\u3044\u3002\u4ed6\u306e2\u3064\u306e\u30c6\u30fc\u30d6\u30eb\u3082\u540c\u69d8\u306b\u3057\u3066\u304b\u3089\u3001\u518d\u5ea6
\n#<\/span> mysqlcheck -c -u root -p -A<\/span>
\n\u5168\u3066OK\u306b\u306a\u3063\u305f\u3002\u3081\u3067\u305f\u3057\u3001\u3081\u3067\u305f\u3057. \u5fd8\u308c\u305a\u306b
\ninnodb_force_recovery = 1<\/span> \u3092\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8\u3057\u3001mariadb \u3092\u518d\u8d77\u52d5\u3057\u3066\u306d\u3002<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
mariadb\u306e\u5168\u30c6\u30fc\u30d6\u30eb\u3092\u30c1\u30a7\u30c3\u30af\u3059\u308b # mysqlcheck -c -u root -p -A wp_xxxxx.wp_options Warning : InnoDB: The B-tree of index o … \u7d9a\u304d\u3092\u8aad\u3080 →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"sns_share_botton_hide":"","vkExUnit_sns_title":"","_vk_print_noindex":"","sitemap_hide":"","_veu_custom_css":"","veu_display_promotion_alert":"","vkexunit_cta_each_option":"","footnotes":""},"categories":[10],"tags":[],"class_list":["post-2635","post","type-post","status-publish","format-standard","hentry","category-linux"],"acf":[],"veu_head_title_object":{"title":"","add_site_title":""},"_links":{"self":[{"href":"https:\/\/www.kinryo.net\/index.php?rest_route=\/wp\/v2\/posts\/2635","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kinryo.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kinryo.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kinryo.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kinryo.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2635"}],"version-history":[{"count":3,"href":"https:\/\/www.kinryo.net\/index.php?rest_route=\/wp\/v2\/posts\/2635\/revisions"}],"predecessor-version":[{"id":2638,"href":"https:\/\/www.kinryo.net\/index.php?rest_route=\/wp\/v2\/posts\/2635\/revisions\/2638"}],"wp:attachment":[{"href":"https:\/\/www.kinryo.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2635"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kinryo.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2635"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kinryo.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}