{"id":41157,"date":"2023-01-20T03:41:27","date_gmt":"2023-01-19T18:41:27","guid":{"rendered":"https:\/\/kinqsta.com\/jp\/?p=41157&#038;post_type=knowledgebase&#038;preview_id=41157"},"modified":"2025-10-02T04:47:24","modified_gmt":"2025-10-01T19:47:24","slug":"convert-myisam-to-innodb","status":"publish","type":"post","link":"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/","title":{"rendered":"MySQL\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u2501MyISAM\u304b\u3089InnoDB\u3078\u306e\u79fb\u884c\u65b9\u6cd5"},"content":{"rendered":"<p>\u5927\u898f\u6a21\u306aWordPress\u30b5\u30a4\u30c8\u3067\u9045\u5ef6\u304c\u767a\u751f\u3059\u308b\u7406\u7531\u306e1\u3064\u3068\u3057\u3066\u3001<a href=\"https:\/\/kinqsta.com\/jp\/blog\/wordpress-database\/\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9<\/a>\u304c\u6700\u9069\u5316\u3055\u308c\u3066\u3044\u306a\u3044\u3053\u3068\u304c\u6319\u3052\u3089\u308c\u307e\u3059\u3002\u3068\u306f\u8a00\u3048\u3001\u53e4\u3044\u30b5\u30a4\u30c8\u306e\u591a\u304f\u304c\u3001\u3044\u307e\u3060\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306bMyISAM\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u3092\u4f7f\u3063\u3066\u3044\u307e\u3059\u3002\u4e00\u65b9\u3067InnoDB\u3067\u306f<a href=\"http:\/\/dimitrik.free.fr\/blog\/archives\/2015\/12\/mysql-performance-revisiting-innodb-vs-myisam-with-mysql-57.html\">\u3088\u308a\u512a\u308c\u305f\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9<\/a>\u3068\u4fe1\u983c\u6027\u304c\u671f\u5f85\u3067\u304d\u307e\u3059\u3002MyISAM\u3088\u308a\u3082InnoDB\u304c\u597d\u307e\u308c\u308b\u5927\u304d\u306a\u8981\u56e0\u3068\u3057\u3066\u3001\u5b8c\u5168\u306a\u30c6\u30fc\u30d6\u30eb\u30ec\u30d9\u30eb\u306e\u30ed\u30c3\u30af\u304c\u5b58\u5728\u3057\u307e\u305b\u3093\u3002\u3053\u308c\u306b\u3088\u308a\u3001\u30af\u30a8\u30ea\u306e\u51e6\u7406\u304c\u901f\u304f\u306a\u308a\u307e\u3059\u3002<\/p>\n<ul>\n<li><a href=\"#innodb-vs-myisam\">InnoDB\u3068MyISAM\u306e\u9055\u3044<\/a><\/li>\n<li><a href=\"#using-myisam-or-innodb\">MyISAM\u3068InnoDB\u306e\u3069\u3061\u3089\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u304b\u306e\u78ba\u8a8d<\/a><\/li>\n<li><a href=\"#convert-myisam-innodb-phpmyadmin\">phpMyAdmin\u3067\u306eMyISAM\u304b\u3089InnoDB\u3078\u306e\u79fb\u884c\u65b9\u6cd5<\/a><\/li>\n<li><a href=\"#convert-myisam-innodb-wp-cli\">WP-CLI\u3067\u306eMyISAM\u304b\u3089InnoDB\u3078\u306e\u79fb\u884c\u65b9\u6cd5<\/a><\/li>\n<\/ul>\n<h2 id=\"innodb-vs-myisam\">InnoDB\u3068MyISAM\u306e\u9055\u3044<\/h2>\n<p>InnoDB\u3068MyISAM\u306e\u4e3b\u306a\u9055\u3044\u3092\u3044\u304f\u3064\u304b\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n<ul>\n<li>InnoDB\u3067\u306f<strong>\u884c\u30ec\u30d9\u30eb\u306e\u30ed\u30c3\u30af<\/strong>\u304c\u63a1\u7528\u3055\u308c\u3066\u3044\u308b<\/li>\n<li>InnoDB\u306b\u306f\u53c2\u7167\u6574\u5408\u6027\u304c\u3042\u308a\u3001<strong>\u5916\u90e8\u30ad\u30fc<\/strong>\u3068\u95a2\u4fc2\u5236\u7d04\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u3044\u308b\uff08RDBMS\uff09\u304c\u3001MyISAM\u306f\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u3044\u306a\u3044\uff08DMBS\uff09<\/li>\n<li>InnoDB\u306f<strong>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3<\/strong>\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u304a\u308a\u3001\u30b3\u30df\u30c3\u30c8\u3084\u30ed\u30fc\u30eb\u30d0\u30c3\u30af\u304c\u53ef\u80fd<\/li>\n<li>InnoDB\u306f<strong>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u30ed\u30b0<\/strong>\u3092\u4f7f\u7528\u3057\u305f\u81ea\u52d5\u30ea\u30ab\u30d0\u30ea\u3092\u884c\u3046\u305f\u3081\u3001\u3088\u308a\u4fe1\u983c\u6027\u304c\u9ad8\u3044<\/li>\n<\/ul>\n<h2 id=\"using-myisam-or-innodb\">MyISAM\u3068InnoDB\u306e\u3069\u3061\u3089\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u304b\u78ba\u8a8d\u3059\u308b\u65b9\u6cd5<\/h2>\n<p>\u65b0\u3057\u3044WordPress\u30b5\u30a4\u30c8\u3067\u3042\u308c\u3070\u3001\u3059\u3067\u306bInnoDB <a href=\"http:\/\/dimitrik.free.fr\/blog\/archives\/2015\/12\/mysql-performance-revisiting-innodb-vs-myisam-with-mysql-57.html\">MySQL<\/a>\u306e\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u53ef\u80fd\u6027\u304c\u9ad8\u3044\u3067\u3059\u3002\u4e00\u65b9\u3067\u3001\u53e4\u3044WordPress\u30b5\u30a4\u30c8\u3067\u306f\u3001\u7c21\u5358\u306a\u30c1\u30a7\u30c3\u30af\u3092\u884c\u3046\u3053\u3068\u3092\u304a\u52e7\u3081\u3057\u307e\u3059\u3002\u30b5\u30a4\u30c8\u306b\u3088\u3063\u3066\u306f\u3001MyISAM\u30c6\u30fc\u30d6\u30eb\u3068InnoDB\u30c6\u30fc\u30d6\u30eb\u304c\u6df7\u5728\u3057\u3066\u3044\u308b\u5834\u5408\u3082\u3042\u308a\u3001\u3053\u308c\u3092\u6574\u3048\u308b\u3053\u3068\u3067\u6027\u80fd\u306e\u6539\u5584\u304c\u898b\u3089\u308c\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002 \u4ee5\u4e0b\u306e\u7c21\u5358\u306a\u624b\u9806\u3067\u78ba\u8a8d\u53ef\u80fd\u3067\u3059\u3002<\/p>\n<h3>\u30b9\u30c6\u30c3\u30d71<\/h3>\n<p><a href=\"https:\/\/kinqsta.com\/jp\/docs\/wordpress-hosting\/database-management\/wordpress-database-access\/\" target=\"_blank\" rel=\"noopener noreferrer\">phpMyAdmin<\/a>\u306b\u30ed\u30b0\u30a4\u30f3\u3057MySQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n<h3>\u30b9\u30c6\u30c3\u30d72<\/h3>\n<p>\u300cType\u300d\u30ab\u30e9\u30e0\u3092\u30af\u30a4\u30c3\u30af\u30b9\u30ad\u30e3\u30f3\u307e\u305f\u306f\u30bd\u30fc\u30c8\u3059\u308b\u3068\u3001\u30c6\u30fc\u30d6\u30eb\u304c\u3069\u306e\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u30bf\u30a4\u30d7\u3092\u4f7f\u3063\u3066\u3044\u308b\u304b\u304c\u308f\u304b\u308a\u307e\u3059\u3002\u4ee5\u4e0b\u306e\u4f8b\u3067\u306f\u30012\u3064\u306e\u30c6\u30fc\u30d6\u30eb\u304c\u307e\u3060MyISAM\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n<figure id=\"attachment_8292\" aria-describedby=\"caption-attachment-8292\" style=\"width: 1422px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-8292 size-full\" src=\"https:\/\/kinqsta.com\/wp-content\/uploads\/2016\/12\/find-myISAM-tables-1.jpg\" alt=\"MyISAM\u30c6\u30fc\u30d6\u30eb\u306e\u8868\u793a\" width=\"1422\" height=\"708\"><figcaption id=\"caption-attachment-8292\" class=\"wp-caption-text\">MyISAM\u30c6\u30fc\u30d6\u30eb\u306e\u8868\u793a<\/figcaption><\/figure>\n<p>\u5225\u306e\u65b9\u6cd5\u3068\u3057\u3066\u3001\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066MyISAM\u30c6\u30fc\u30d6\u30eb\u304c\u5b58\u5728\u3057\u3066\u3044\u308b\u304b\u3069\u3046\u304b\u78ba\u8a8d\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002\u4ee5\u4e0b\u306e\u300cdatabase\u300d\u3092\u5b9f\u969b\u306e\u540d\u524d\u306b\u7f6e\u304d\u63db\u3048\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre><code class=\"language-php\">SELECT TABLE_NAME,\n ENGINE\nFROM information_schema.TABLES\nWHERE TABLE_SCHEMA = 'database' and ENGINE = 'myISAM'<\/code><\/pre>\n<h2 id=\"convert-myisam-innodb-phpmyadmin\">phpMyAdmin\u3067\u306eMyISAM\u304b\u3089InnoDB\u3078\u306e\u79fb\u884c\u65b9\u6cd5<\/h2>\n<p>MyISAM\u304b\u3089InnoDB\u3078\u306e\u79fb\u884c\u306f\u3068\u3066\u3082\u7c21\u5358\u3067\u3059\u3002\u4ee5\u4e0b\u306e\u4f8b\u306f\u3001<code>wp_comments<\/code>\u30c6\u30fc\u30d6\u30eb\u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002ALTER\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3060\u3051\u3067\u3001InnoDB\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u306b\u5909\u63db\u3067\u304d\u307e\u3059\u3002MySQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u5bfe\u3057\u3066\u4f55\u3089\u304b\u306e\u64cd\u4f5c\u3092\u884c\u3046\u524d\u306b\u3001\u5fc5\u305a\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u53d6\u308b\u3053\u3068\u3092\u304a\u52e7\u3081\u3057\u307e\u3059\u3002<\/p>\n<pre><code class=\"language-php\">ALTER TABLE wp_comments ENGINE=InnoDB;<\/code><\/pre>\n<div class=\"warning\" style=\"background: #FFFCE3;padding: 22px;margin-bottom: 22px\">\u5b9f\u884c\u524d\u306b\u5fc5\u305aMySQL 5.6.4\u4ee5\u4e0a\u3092\u5b9f\u884c\u3057\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002InnoDB\u3067\u30d5\u30eb\u30c6\u30ad\u30b9\u30c8\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c\u30b5\u30dd\u30fc\u30c8\u3055\u308c\u3066\u3044\u306a\u3044\u72b6\u6cc1\u304c\u767a\u751f\u3059\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002\u306a\u304a\u3001Kinsta\u3092\u3054\u5229\u7528\u3067\u3042\u308c\u3070\u3001\u3053\u306e\u554f\u984c\u304c\u767a\u751f\u3059\u308b\u3053\u3068\u306f\u306a\u304f\u7279\u5225\u306a\u5bfe\u51e6\u306f\u5fc5\u8981\u3042\u308a\u307e\u305b\u3093\u3002<\/div>\n<p>\u3053\u308c\u3068\u306f\u5225\u306b\u3001phpMyAdmin\u3067\u624b\u52d5\u3067\u5909\u63db\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002myISAM\u30c6\u30fc\u30d6\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001\u300c\u64cd\u4f5c\u300d\u30bf\u30d6\u3092\u958b\u304d\u3001\u300c\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u300d\u306e\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u30e1\u30cb\u30e5\u30fc\u304b\u3089\u300cInnoDB\u300d\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<figure id=\"attachment_8294\" aria-describedby=\"caption-attachment-8294\" style=\"width: 402px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-8294\" src=\"https:\/\/kinqsta.com\/wp-content\/uploads\/2016\/12\/convert-myisam-table-to-innodb-phpmyadmin-1.jpg\" alt=\"MyISAM\u3092InnoDB\u306b\u5207\u308a\u66ff\u3048\u308b\" width=\"402\" height=\"720\"><figcaption id=\"caption-attachment-8294\" class=\"wp-caption-text\">MyISAM\u3092InnoDB\u306b\u5207\u308a\u66ff\u3048\u308b<\/figcaption><\/figure>\n<h2 id=\"convert-myisam-innodb-wp-cli\">WP-CLI\u3067\u306eMyISAM\u304b\u3089InnoDB\u3078\u306e\u79fb\u884c\u65b9\u6cd5<\/h2>\n<p>WP-CLI\u306f\u3001WordPress\u306b\u95a2\u9023\u3059\u308b\u3042\u3089\u3086\u308b\u30bf\u30b9\u30af\u306e\u5b9f\u884c\u306b\u4fbf\u5229\u306a\u958b\u767a\u8005\u5411\u3051\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u30c4\u30fc\u30eb\u3067\u3059\u3002WP-CLI\u3092\u4f7f\u3063\u3066MyISAM\u3092InnoDB\u306b\u5909\u63db\u3059\u308b\u65b9\u6cd5\u306f<a href=\"https:\/\/guides.wp-bullet.com\/converting-wordpress-database-tables-from-myisam-to-innodb-with-wp-cli\/\">\u3053\u3061\u3089\u306e\u8a18\u4e8b<\/a>\u304c\u53c2\u8003\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5927\u898f\u6a21\u306aWordPress\u30b5\u30a4\u30c8\u3067\u9045\u5ef6\u304c\u767a\u751f\u3059\u308b\u7406\u7531 &#8230;<\/p>\n","protected":false},"author":38,"featured_media":41158,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kinsta_gated_content":false,"_kinsta_gated_content_redirect":"","footnotes":""},"tags":[],"topic":[790],"class_list":["post-41157","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","topic-mysql-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.6 (Yoast SEO v24.6) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u2501MyISAM\u304b\u3089InnoDB\u3078\u306e\u79fb\u884c\u65b9\u6cd5<\/title>\n<meta name=\"description\" content=\"MySQL InnoDB\u306f\u3001MyISAM\u3088\u308a\u9ad8\u901f\u304b\u3064\u4fe1\u983c\u6027\u306e\u9ad8\u3044\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u3067\u3059\u3002\u3053\u3061\u3089\u306e\u30da\u30fc\u30b8\u3067\u306f\u3001MyISAM\u304b\u3089InnoDB\u306b\u5207\u308a\u66ff\u3048\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u2501MyISAM\u304b\u3089InnoDB\u3078\u306e\u79fb\u884c\u65b9\u6cd5\" \/>\n<meta property=\"og:description\" content=\"MySQL InnoDB\u306f\u3001MyISAM\u3088\u308a\u9ad8\u901f\u304b\u3064\u4fe1\u983c\u6027\u306e\u9ad8\u3044\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u3067\u3059\u3002\u3053\u3061\u3089\u306e\u30da\u30fc\u30b8\u3067\u306f\u3001MyISAM\u304b\u3089InnoDB\u306b\u5207\u308a\u66ff\u3048\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/\" \/>\n<meta property=\"og:site_name\" content=\"Kinsta\u00ae\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Kinsta-Japan-334616080691171\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/fm.brianleejackson\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-19T18:41:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-01T19:47:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kinqsta.com\/jp\/wp-content\/uploads\/sites\/6\/2023\/01\/convert-myisam-to-innodb-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1460\" \/>\n\t<meta property=\"og:image:height\" content=\"730\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Brian Jackson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:description\" content=\"MySQL InnoDB\u306f\u3001MyISAM\u3088\u308a\u9ad8\u901f\u304b\u3064\u4fe1\u983c\u6027\u306e\u9ad8\u3044\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u3067\u3059\u3002\u3053\u3061\u3089\u306e\u30da\u30fc\u30b8\u3067\u306f\u3001MyISAM\u304b\u3089InnoDB\u306b\u5207\u308a\u66ff\u3048\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/kinqsta.com\/jp\/wp-content\/uploads\/sites\/6\/2023\/01\/convert-myisam-to-innodb-1.png\" \/>\n<meta name=\"twitter:creator\" content=\"@brianleejackson\" \/>\n<meta name=\"twitter:site\" content=\"@Kinsta_JP\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"Brian Jackson\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"1\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/\"},\"author\":{\"name\":\"Brian Jackson\",\"@id\":\"https:\/\/kinqsta.com\/jp\/#\/schema\/person\/079824c00ccc2b7141504f27ea63bef7\"},\"headline\":\"MySQL\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u2501MyISAM\u304b\u3089InnoDB\u3078\u306e\u79fb\u884c\u65b9\u6cd5\",\"datePublished\":\"2023-01-19T18:41:27+00:00\",\"dateModified\":\"2025-10-01T19:47:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/\"},\"wordCount\":82,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kinqsta.com\/jp\/#organization\"},\"image\":{\"@id\":\"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kinqsta.com\/jp\/wp-content\/uploads\/sites\/6\/2023\/01\/convert-myisam-to-innodb-1.png\",\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/\",\"url\":\"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/\",\"name\":\"MySQL\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u2501MyISAM\u304b\u3089InnoDB\u3078\u306e\u79fb\u884c\u65b9\u6cd5\",\"isPartOf\":{\"@id\":\"https:\/\/kinqsta.com\/jp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kinqsta.com\/jp\/wp-content\/uploads\/sites\/6\/2023\/01\/convert-myisam-to-innodb-1.png\",\"datePublished\":\"2023-01-19T18:41:27+00:00\",\"dateModified\":\"2025-10-01T19:47:24+00:00\",\"description\":\"MySQL InnoDB\u306f\u3001MyISAM\u3088\u308a\u9ad8\u901f\u304b\u3064\u4fe1\u983c\u6027\u306e\u9ad8\u3044\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u3067\u3059\u3002\u3053\u3061\u3089\u306e\u30da\u30fc\u30b8\u3067\u306f\u3001MyISAM\u304b\u3089InnoDB\u306b\u5207\u308a\u66ff\u3048\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002\",\"breadcrumb\":{\"@id\":\"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/#primaryimage\",\"url\":\"https:\/\/kinqsta.com\/jp\/wp-content\/uploads\/sites\/6\/2023\/01\/convert-myisam-to-innodb-1.png\",\"contentUrl\":\"https:\/\/kinqsta.com\/jp\/wp-content\/uploads\/sites\/6\/2023\/01\/convert-myisam-to-innodb-1.png\",\"width\":1460,\"height\":730},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/kinqsta.com\/jp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\",\"item\":\"https:\/\/kinqsta.com\/jp\/topics\/mysql-database\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"MySQL\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u2501MyISAM\u304b\u3089InnoDB\u3078\u306e\u79fb\u884c\u65b9\u6cd5\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kinqsta.com\/jp\/#website\",\"url\":\"https:\/\/kinqsta.com\/jp\/\",\"name\":\"Kinsta\u00ae\",\"description\":\"\u9ad8\u901f\u304b\u3064\u5805\u7262\u306a\u30d7\u30ec\u30df\u30a2\u30e0\u30b5\u30fc\u30d0\u30fc\u30b5\u30fc\u30d3\u30b9\",\"publisher\":{\"@id\":\"https:\/\/kinqsta.com\/jp\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kinqsta.com\/jp\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kinqsta.com\/jp\/#organization\",\"name\":\"Kinsta\",\"url\":\"https:\/\/kinqsta.com\/jp\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/kinqsta.com\/jp\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kinqsta.com\/jp\/wp-content\/uploads\/sites\/6\/2023\/12\/kinsta-logo.jpeg\",\"contentUrl\":\"https:\/\/kinqsta.com\/jp\/wp-content\/uploads\/sites\/6\/2023\/12\/kinsta-logo.jpeg\",\"width\":500,\"height\":500,\"caption\":\"Kinsta\"},\"image\":{\"@id\":\"https:\/\/kinqsta.com\/jp\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Kinsta-Japan-334616080691171\/\",\"https:\/\/x.com\/Kinsta_JP\",\"https:\/\/www.instagram.com\/kinstahosting\/\",\"https:\/\/www.linkedin.com\/company\/kinsta\/\",\"https:\/\/www.pinterest.com\/kinstahosting\/\",\"https:\/\/www.youtube.com\/c\/Kinsta\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/kinqsta.com\/jp\/#\/schema\/person\/079824c00ccc2b7141504f27ea63bef7\",\"name\":\"Brian Jackson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/kinqsta.com\/jp\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/79623d815f4ed4c8c2457392d728cb16?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/79623d815f4ed4c8c2457392d728cb16?s=96&d=mm&r=g\",\"caption\":\"Brian Jackson\"},\"description\":\"Brian has a huge passion for WordPress, has been using it for over a decade, and even develops a couple of premium plugins. Brian enjoys blogging, movies, and hiking. Connect with Brian on Twitter.\",\"sameAs\":[\"https:\/\/www.facebook.com\/fm.brianleejackson\",\"https:\/\/www.linkedin.com\/in\/brianleejackson\",\"https:\/\/x.com\/brianleejackson\"],\"url\":\"https:\/\/kinqsta.com\/jp\/blog\/author\/brianjackson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MySQL\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u2501MyISAM\u304b\u3089InnoDB\u3078\u306e\u79fb\u884c\u65b9\u6cd5","description":"MySQL InnoDB\u306f\u3001MyISAM\u3088\u308a\u9ad8\u901f\u304b\u3064\u4fe1\u983c\u6027\u306e\u9ad8\u3044\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u3067\u3059\u3002\u3053\u3061\u3089\u306e\u30da\u30fc\u30b8\u3067\u306f\u3001MyISAM\u304b\u3089InnoDB\u306b\u5207\u308a\u66ff\u3048\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/","og_locale":"ja_JP","og_type":"article","og_title":"MySQL\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u2501MyISAM\u304b\u3089InnoDB\u3078\u306e\u79fb\u884c\u65b9\u6cd5","og_description":"MySQL InnoDB\u306f\u3001MyISAM\u3088\u308a\u9ad8\u901f\u304b\u3064\u4fe1\u983c\u6027\u306e\u9ad8\u3044\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u3067\u3059\u3002\u3053\u3061\u3089\u306e\u30da\u30fc\u30b8\u3067\u306f\u3001MyISAM\u304b\u3089InnoDB\u306b\u5207\u308a\u66ff\u3048\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002","og_url":"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/","og_site_name":"Kinsta\u00ae","article_publisher":"https:\/\/www.facebook.com\/Kinsta-Japan-334616080691171\/","article_author":"https:\/\/www.facebook.com\/fm.brianleejackson","article_published_time":"2023-01-19T18:41:27+00:00","article_modified_time":"2025-10-01T19:47:24+00:00","og_image":[{"width":1460,"height":730,"url":"https:\/\/kinqsta.com\/jp\/wp-content\/uploads\/sites\/6\/2023\/01\/convert-myisam-to-innodb-1.png","type":"image\/png"}],"author":"Brian Jackson","twitter_card":"summary_large_image","twitter_description":"MySQL InnoDB\u306f\u3001MyISAM\u3088\u308a\u9ad8\u901f\u304b\u3064\u4fe1\u983c\u6027\u306e\u9ad8\u3044\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u3067\u3059\u3002\u3053\u3061\u3089\u306e\u30da\u30fc\u30b8\u3067\u306f\u3001MyISAM\u304b\u3089InnoDB\u306b\u5207\u308a\u66ff\u3048\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002","twitter_image":"https:\/\/kinqsta.com\/jp\/wp-content\/uploads\/sites\/6\/2023\/01\/convert-myisam-to-innodb-1.png","twitter_creator":"@brianleejackson","twitter_site":"@Kinsta_JP","twitter_misc":{"\u57f7\u7b46\u8005":"Brian Jackson","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"1\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/#article","isPartOf":{"@id":"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/"},"author":{"name":"Brian Jackson","@id":"https:\/\/kinqsta.com\/jp\/#\/schema\/person\/079824c00ccc2b7141504f27ea63bef7"},"headline":"MySQL\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u2501MyISAM\u304b\u3089InnoDB\u3078\u306e\u79fb\u884c\u65b9\u6cd5","datePublished":"2023-01-19T18:41:27+00:00","dateModified":"2025-10-01T19:47:24+00:00","mainEntityOfPage":{"@id":"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/"},"wordCount":82,"commentCount":0,"publisher":{"@id":"https:\/\/kinqsta.com\/jp\/#organization"},"image":{"@id":"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/#primaryimage"},"thumbnailUrl":"https:\/\/kinqsta.com\/jp\/wp-content\/uploads\/sites\/6\/2023\/01\/convert-myisam-to-innodb-1.png","inLanguage":"ja","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/","url":"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/","name":"MySQL\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u2501MyISAM\u304b\u3089InnoDB\u3078\u306e\u79fb\u884c\u65b9\u6cd5","isPartOf":{"@id":"https:\/\/kinqsta.com\/jp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/#primaryimage"},"image":{"@id":"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/#primaryimage"},"thumbnailUrl":"https:\/\/kinqsta.com\/jp\/wp-content\/uploads\/sites\/6\/2023\/01\/convert-myisam-to-innodb-1.png","datePublished":"2023-01-19T18:41:27+00:00","dateModified":"2025-10-01T19:47:24+00:00","description":"MySQL InnoDB\u306f\u3001MyISAM\u3088\u308a\u9ad8\u901f\u304b\u3064\u4fe1\u983c\u6027\u306e\u9ad8\u3044\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u3067\u3059\u3002\u3053\u3061\u3089\u306e\u30da\u30fc\u30b8\u3067\u306f\u3001MyISAM\u304b\u3089InnoDB\u306b\u5207\u308a\u66ff\u3048\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002","breadcrumb":{"@id":"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/"]}]},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/#primaryimage","url":"https:\/\/kinqsta.com\/jp\/wp-content\/uploads\/sites\/6\/2023\/01\/convert-myisam-to-innodb-1.png","contentUrl":"https:\/\/kinqsta.com\/jp\/wp-content\/uploads\/sites\/6\/2023\/01\/convert-myisam-to-innodb-1.png","width":1460,"height":730},{"@type":"BreadcrumbList","@id":"https:\/\/kinqsta.com\/jp\/blog\/convert-myisam-to-innodb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kinqsta.com\/jp\/"},{"@type":"ListItem","position":2,"name":"MySQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9","item":"https:\/\/kinqsta.com\/jp\/topics\/mysql-database\/"},{"@type":"ListItem","position":3,"name":"MySQL\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u2501MyISAM\u304b\u3089InnoDB\u3078\u306e\u79fb\u884c\u65b9\u6cd5"}]},{"@type":"WebSite","@id":"https:\/\/kinqsta.com\/jp\/#website","url":"https:\/\/kinqsta.com\/jp\/","name":"Kinsta\u00ae","description":"\u9ad8\u901f\u304b\u3064\u5805\u7262\u306a\u30d7\u30ec\u30df\u30a2\u30e0\u30b5\u30fc\u30d0\u30fc\u30b5\u30fc\u30d3\u30b9","publisher":{"@id":"https:\/\/kinqsta.com\/jp\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kinqsta.com\/jp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":"Organization","@id":"https:\/\/kinqsta.com\/jp\/#organization","name":"Kinsta","url":"https:\/\/kinqsta.com\/jp\/","logo":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/kinqsta.com\/jp\/#\/schema\/logo\/image\/","url":"https:\/\/kinqsta.com\/jp\/wp-content\/uploads\/sites\/6\/2023\/12\/kinsta-logo.jpeg","contentUrl":"https:\/\/kinqsta.com\/jp\/wp-content\/uploads\/sites\/6\/2023\/12\/kinsta-logo.jpeg","width":500,"height":500,"caption":"Kinsta"},"image":{"@id":"https:\/\/kinqsta.com\/jp\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Kinsta-Japan-334616080691171\/","https:\/\/x.com\/Kinsta_JP","https:\/\/www.instagram.com\/kinstahosting\/","https:\/\/www.linkedin.com\/company\/kinsta\/","https:\/\/www.pinterest.com\/kinstahosting\/","https:\/\/www.youtube.com\/c\/Kinsta"]},{"@type":"Person","@id":"https:\/\/kinqsta.com\/jp\/#\/schema\/person\/079824c00ccc2b7141504f27ea63bef7","name":"Brian Jackson","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/kinqsta.com\/jp\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/79623d815f4ed4c8c2457392d728cb16?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/79623d815f4ed4c8c2457392d728cb16?s=96&d=mm&r=g","caption":"Brian Jackson"},"description":"Brian has a huge passion for WordPress, has been using it for over a decade, and even develops a couple of premium plugins. Brian enjoys blogging, movies, and hiking. Connect with Brian on Twitter.","sameAs":["https:\/\/www.facebook.com\/fm.brianleejackson","https:\/\/www.linkedin.com\/in\/brianleejackson","https:\/\/x.com\/brianleejackson"],"url":"https:\/\/kinqsta.com\/jp\/blog\/author\/brianjackson\/"}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/kinqsta.com\/jp\/wp-json\/wp\/v2\/posts\/41157","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kinqsta.com\/jp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kinqsta.com\/jp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kinqsta.com\/jp\/wp-json\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/kinqsta.com\/jp\/wp-json\/wp\/v2\/comments?post=41157"}],"version-history":[{"count":10,"href":"https:\/\/kinqsta.com\/jp\/wp-json\/wp\/v2\/posts\/41157\/revisions"}],"predecessor-version":[{"id":47966,"href":"https:\/\/kinqsta.com\/jp\/wp-json\/wp\/v2\/posts\/41157\/revisions\/47966"}],"alternate":[{"embeddable":true,"hreflang":"es","title":"Spanish","href":"https:\/\/kinqsta.com\/jp\/wp-json\/kinsta\/v1\/posts\/41157\/translations\/es"},{"embeddable":true,"hreflang":"en","title":"English","href":"https:\/\/kinqsta.com\/jp\/wp-json\/kinsta\/v1\/posts\/41157\/translations\/en"},{"embeddable":true,"hreflang":"it","title":"Italian","href":"https:\/\/kinqsta.com\/jp\/wp-json\/kinsta\/v1\/posts\/41157\/translations\/it"},{"embeddable":true,"hreflang":"pt","title":"Portuguese","href":"https:\/\/kinqsta.com\/jp\/wp-json\/kinsta\/v1\/posts\/41157\/translations\/pt"},{"embeddable":true,"hreflang":"de","title":"German","href":"https:\/\/kinqsta.com\/jp\/wp-json\/kinsta\/v1\/posts\/41157\/translations\/de"},{"embeddable":true,"hreflang":"fr","title":"French","href":"https:\/\/kinqsta.com\/jp\/wp-json\/kinsta\/v1\/posts\/41157\/translations\/fr"},{"embeddable":true,"hreflang":"da","title":"Danish","href":"https:\/\/kinqsta.com\/jp\/wp-json\/kinsta\/v1\/posts\/41157\/translations\/dk"},{"embeddable":true,"hreflang":"sv","title":"Swedish","href":"https:\/\/kinqsta.com\/jp\/wp-json\/kinsta\/v1\/posts\/41157\/translations\/se"},{"embeddable":true,"hreflang":"ja","title":"Japanese","href":"https:\/\/kinqsta.com\/jp\/wp-json\/kinsta\/v1\/posts\/41157\/translations\/jp"},{"embeddable":true,"hreflang":"nl","title":"Dutch","href":"https:\/\/kinqsta.com\/jp\/wp-json\/kinsta\/v1\/posts\/41157\/translations\/nl"},{"href":"https:\/\/kinqsta.com\/jp\/wp-json\/kinsta\/v1\/posts\/41157\/tree"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kinqsta.com\/jp\/wp-json\/wp\/v2\/media\/41158"}],"wp:attachment":[{"href":"https:\/\/kinqsta.com\/jp\/wp-json\/wp\/v2\/media?parent=41157"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kinqsta.com\/jp\/wp-json\/wp\/v2\/tags?post=41157"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/kinqsta.com\/jp\/wp-json\/wp\/v2\/topic?post=41157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}