{"id":751,"date":"2014-07-26T19:38:52","date_gmt":"2014-07-26T10:38:52","guid":{"rendered":"http:\/\/tech.akat.info\/?p=751"},"modified":"2014-09-16T01:13:08","modified_gmt":"2014-09-15T16:13:08","slug":"%e3%80%90mysql%e3%80%91index","status":"publish","type":"post","link":"https:\/\/tech.akat.info\/?p=751","title":{"rendered":"\u3010mysql\u3011index"},"content":{"rendered":"<h1>index\u306b\u3064\u3044\u3066<\/h1>\n<p>InnoDB\u3068MyISAM\u306fB-Tree\u578b\u306eindex\u304c\u8cbc\u3089\u308c\u308b<br \/>\nInnoDB\u3067\u306f\u66f4\u65b0\u3084\u524a\u9664\u306a\u3069\u3067index\u304c\u30d5\u30e9\u30b0\u30e1\u30f3\u30c6\u30fc\u30b7\u30e7\u30f3\u3092\u8d77\u3053\u3059<\/p>\n<h1>index\u518d\u69cb\u7bc9<\/h1>\n<p>CREATE\/DROP INDEX\u6587\u3060\u3068\u3001InnoDB\u306f\u81ea\u52d5\u7684\u306b\u30c6\u30fc\u30d6\u30eb\u3092\u518d\u69cb\u7bc9\u3059\u308b<br \/>\n\u305d\u306e\u305f\u3081ALTER TABLE \u3082\u3057\u304f\u306f\u30c6\u30fc\u30d6\u30eb\u306eDROP\u3068CREATE\u3067\u5bfe\u5fdc\u3059\u308b\u3079\u3057<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nmysql&gt; show tables;\r\n+-------------------------+\r\n| Tables_in_techwordpress |\r\n+-------------------------+\r\n| page_fake_url           |\r\n| wp_commentmeta          |\r\n| wp_comments             |\r\n| wp_links                |\r\n| wp_options              |\r\n| wp_postmeta             |\r\n| wp_posts                |\r\n| wp_term_relationships   |\r\n| wp_term_taxonomy        |\r\n| wp_terms                |\r\n| wp_usermeta             |\r\n| wp_users                |\r\n+-------------------------+\r\n12 rows in set (0.00 sec)\r\n\r\nmysql&gt; show create table wp_options\\G\r\n*************************** 1. row ***************************\r\n       Table: wp_options\r\nCreate Table: CREATE TABLE `wp_options` (\r\n  `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r\n  `option_name` varchar(64) NOT NULL DEFAULT '',\r\n  `option_value` longtext NOT NULL,\r\n  `autoload` varchar(20) NOT NULL DEFAULT 'yes',\r\n  PRIMARY KEY (`option_id`),\r\n  UNIQUE KEY `option_name` (`option_name`)\r\n) ENGINE=InnoDB AUTO_INCREMENT=12295 DEFAULT CHARSET=utf8\r\n1 row in set (0.00 sec)\r\n\r\nmysql&gt; show index from wp_options;\r\n+------------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+\r\n| Table      | Non_unique | Key_name    | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |\r\n+------------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+\r\n| wp_options |          0 | PRIMARY     |            1 | option_id   | A         |         173 |     NULL | NULL   |      | BTREE      |         |               |\r\n| wp_options |          0 | option_name |            1 | option_name | A         |         173 |     NULL | NULL   |      | BTREE      |         |               |\r\n+------------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+\r\n2 rows in set (0.00 sec)\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>index\u306b\u3064\u3044\u3066 InnoDB\u3068MyISAM\u306fB-Tree\u578b\u306eindex\u304c\u8cbc\u3089\u308c\u308b InnoDB\u3067\u306f\u66f4\u65b0\u3084\u524a\u9664\u306a\u3069\u3067index\u304c\u30d5\u30e9\u30b0\u30e1\u30f3\u30c6\u30fc\u30b7\u30e7\u30f3\u3092\u8d77\u3053\u3059 index\u518d\u69cb\u7bc9 CREATE\/DROP INDEX\u6587\u3060\u3068\u3001 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[14],"tags":[],"_links":{"self":[{"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/posts\/751"}],"collection":[{"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tech.akat.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=751"}],"version-history":[{"count":1,"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/posts\/751\/revisions"}],"predecessor-version":[{"id":752,"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/posts\/751\/revisions\/752"}],"wp:attachment":[{"href":"https:\/\/tech.akat.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=751"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tech.akat.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=751"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tech.akat.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=751"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}