{"id":49479,"date":"2023-01-19T19:44:37","date_gmt":"2023-01-19T18:44:37","guid":{"rendered":"https:\/\/kinsta.com\/nl\/?p=49479&#038;post_type=knowledgebase&#038;preview_id=49479"},"modified":"2025-10-01T21:45:20","modified_gmt":"2025-10-01T19:45:20","slug":"myisam-naar-innodb-converteren","status":"publish","type":"post","link":"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/","title":{"rendered":"MySQL storage engine &#8211; Zo converteer je MyISAM naar InnoDB"},"content":{"rendered":"<p>Een van de belangrijkste redenen waarom grote en grootschalige WordPress sites trager worden is omdat hun <a href=\"https:\/\/kinsta.com\/nl\/blog\/wordpress-database\/\">database<\/a> niet geoptimaliseerd is. Veel oudere sites gebruiken nog steeds de MyISAM storage engine in hun database. De laatste jaren is gebleken dat InnoDB <a href=\"http:\/\/dimitrik.free.fr\/blog\/archives\/2015\/12\/mysql-performance-revisiting-innodb-vs-myisam-with-mysql-57.html\" target=\"_blank\" rel=\"noopener noreferrer\">beter presteert<\/a> en betrouwbaarder is. Een grote reden om InnoDB te verkiezen boven MyISAM, is het ontbreken van full table-level locking. Hierdoor kunnen je query&#8217;s sneller verwerkt worden.<\/p>\n<ul>\n<li><a href=\"#innodb-vs-myisam\">InnoDB vs MyISAM<\/a><\/li>\n<li><a href=\"#using-myisam-or-innodb\">Gebruik je MyISAM of InnoDB?<\/a><\/li>\n<li><a href=\"#convert-myisam-innodb-phpmyadmin\">MyISAM omzetten naar InnoDB met phpMyAdmin<\/a><\/li>\n<li><a href=\"#convert-myisam-innodb-wp-cli\">MyISAM omzetten naar InnoDB met WP-CLI<\/a><\/li>\n<\/ul>\n<h2 id=\"innodb-vs-myisam\">InnoDB vs MyISAM<\/h2>\n<p>Hier zijn een paar van de belangrijkste verschillen tussen InnoDB en MyISAM:<\/p>\n<ul>\n<li>InnoDB heeft <strong>row-level locking<\/strong>. MyISAM heeft alleen full table-level locking.<\/li>\n<li>InnoDB heeft wat referential integrity wordt genoemd, wat inhoudt dat <strong>foreign keys<\/strong> (RDBMS) en relatiebeperkingen worden ondersteund. MyISAM heeft dit niet (DMBS).<\/li>\n<li>InnoDB ondersteunt <strong>transacties<\/strong>, wat betekent dat je dingen kunt vastleggen en terugdraaien. MyISAM doet dat niet.<\/li>\n<li>InnoDB is betrouwbaarder omdat het <strong>transactionele logs<\/strong> gebruikt voor automatisch herstel. MyISAM doet dat niet.<\/li>\n<\/ul>\n<h2 id=\"using-myisam-or-innodb\">Gebruik je MyISAM of InnoDB?<\/h2>\n<p>Als je op een vrij nieuwe WordPress site draait is de kans groot dat je al de InnoDB <a href=\"https:\/\/kinsta.com\/nl\/blog\/wat-is-mysql\/\" target=\"_blank\" rel=\"noopener noreferrer\">MySQL<\/a> storage engine gebruikt. Maar bij oudere WordPress sites wil je dat misschien even controleren. Sommige sites hebben misschien zelfs een mix van MyISAM en InnoDB tabellen, waarbij je verbeteringen zou kunnen zien door ze allemaal om te zetten. Volg deze eenvoudige stappen hieronder om dit te controleren.<\/p>\n<h3>Stap 1<\/h3>\n<p><a href=\"https:\/\/kinsta.com\/nl\/docs\/wordpress-hosting\/databasebeheer\/wordpress-database-toegang\/\" target=\"_blank\" rel=\"noopener noreferrer\">Log in op phpMyAdmin<\/a> en klik verder naar je mySQL database.<\/p>\n<h3>Stap 2<\/h3>\n<p>Doe een snelle scan of sorteer de kolom &#8220;Type&#8221; en je kunt zien welke Storage Engine types je tabellen gebruiken. In dit voorbeeld hieronder zie je dat twee van de tabellen nog steeds MyISAM gebruiken.<\/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:\/\/kinsta.com\/wp-content\/uploads\/2016\/12\/find-myISAM-tables-1.jpg\" alt=\"MyISAM tabellen vinden\" width=\"1422\" height=\"708\"><figcaption id=\"caption-attachment-8292\" class=\"wp-caption-text\">MyISAM tabellen vinden<\/figcaption><\/figure>\n<p>Je kunt ook een query uitvoeren om te zien of er MyISAM tabellen bestaan. Vervang &#8216;database&#8217; door de naam van je database.<\/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\">MyISAM omzetten naar InnoDB met phpMyAdmin<\/h2>\n<p>Je kunt MyISAM vrij eenvoudig omzetten naar InnoDB. Dit voorbeeld hieronder gebruikt de tabel <code>wp_comments<\/code>. Voer simpelweg\u00a0 het ALTER commando uit om het om te zetten naar de InnoDB storage engine. Opmerking: We raden altijd aan een backup te maken van je MySQL database voordat je er bewerkingen op uitvoert.<\/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\">Zorg ervoor dat je MySQL 5.6.4 of hoger draait, anders kun je tegen problemen aanlopen waar full-text indexering nog niet wordt ondersteund door InnoDB. Als je een Kinsta klant bent hoef je je hierover geen zorgen te maken.<\/div>\n<p>Als alternatief kun je ze ook handmatig omzetten met phpMyAdmin. Klik gewoon op de myISAM tabel, klik in de &#8220;Operations&#8221; tab, en verander de storage engine.<\/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:\/\/kinsta.com\/wp-content\/uploads\/2016\/12\/convert-myisam-table-to-innodb-phpmyadmin-1.jpg\" alt=\"Zet myisam tabel om naar innodb phpmyadmin\" width=\"402\" height=\"720\"><figcaption id=\"caption-attachment-8294\" class=\"wp-caption-text\">MyISAM omzetten naar InnoDB<\/figcaption><\/figure>\n<h2 id=\"convert-myisam-innodb-wp-cli\">MyISAM omzetten naar InnoDB met WP-CLI<\/h2>\n<p>WP-CLI is een commandoregeltool voor developers om veel voorkomende taken (en minder voorkomende) van een WordPress installatie te beheren. Bekijk dit artikel over hoe je <a href=\"https:\/\/guides.wp-bullet.com\/converting-wordpress-database-tables-from-myisam-to-innodb-with-wp-cli\/\" target=\"_blank\" rel=\"noopener noreferrer\">MyISAM omzet naar InnoDB met WP-CLI<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Een van de belangrijkste redenen waarom grote en grootschalige WordPress sites trager worden is omdat hun database niet geoptimaliseerd is. Veel oudere sites gebruiken nog steeds &#8230;<\/p>\n","protected":false},"author":38,"featured_media":49480,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kinsta_gated_content":false,"_kinsta_gated_content_redirect":"","footnotes":""},"tags":[],"topic":[858],"class_list":["post-49479","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 storage engine - Zo converteer je MyISAM naar InnoDB<\/title>\n<meta name=\"description\" content=\"Het is aangetoond dat de MySQL InnoDB storage engine sneller presteert en betrouwbaarder is. Volg deze korte tutorial over hoe je MyISAM converteert naar InnoDB.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL storage engine - Zo converteer je MyISAM naar InnoDB\" \/>\n<meta property=\"og:description\" content=\"Het is aangetoond dat de MySQL InnoDB storage engine sneller presteert en betrouwbaarder is. Volg deze korte tutorial over hoe je MyISAM converteert naar InnoDB.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/\" \/>\n<meta property=\"og:site_name\" content=\"Kinsta\u00ae\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Kinsta-Nederland-476213452787823\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/fm.brianleejackson\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-19T18:44:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-01T19:45:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kinsta.com\/nl\/wp-content\/uploads\/sites\/7\/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=\"Het is aangetoond dat de MySQL InnoDB storage engine sneller presteert en betrouwbaarder is. Volg deze korte tutorial over hoe je MyISAM converteert naar InnoDB.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/kinsta.com\/nl\/wp-content\/uploads\/sites\/7\/2023\/01\/convert-myisam-to-innodb-1.png\" \/>\n<meta name=\"twitter:creator\" content=\"@brianleejackson\" \/>\n<meta name=\"twitter:site\" content=\"@Kinsta_NL\" \/>\n<meta name=\"twitter:label1\" content=\"Geschreven door\" \/>\n\t<meta name=\"twitter:data1\" content=\"Brian Jackson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/\"},\"author\":{\"name\":\"Brian Jackson\",\"@id\":\"https:\/\/kinsta.com\/nl\/#\/schema\/person\/079824c00ccc2b7141504f27ea63bef7\"},\"headline\":\"MySQL storage engine &#8211; Zo converteer je MyISAM naar InnoDB\",\"datePublished\":\"2023-01-19T18:44:37+00:00\",\"dateModified\":\"2025-10-01T19:45:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/\"},\"wordCount\":494,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kinsta.com\/nl\/#organization\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kinsta.com\/nl\/wp-content\/uploads\/sites\/7\/2023\/01\/convert-myisam-to-innodb-1.png\",\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/\",\"url\":\"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/\",\"name\":\"MySQL storage engine - Zo converteer je MyISAM naar InnoDB\",\"isPartOf\":{\"@id\":\"https:\/\/kinsta.com\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kinsta.com\/nl\/wp-content\/uploads\/sites\/7\/2023\/01\/convert-myisam-to-innodb-1.png\",\"datePublished\":\"2023-01-19T18:44:37+00:00\",\"dateModified\":\"2025-10-01T19:45:20+00:00\",\"description\":\"Het is aangetoond dat de MySQL InnoDB storage engine sneller presteert en betrouwbaarder is. Volg deze korte tutorial over hoe je MyISAM converteert naar InnoDB.\",\"breadcrumb\":{\"@id\":\"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/#primaryimage\",\"url\":\"https:\/\/kinsta.com\/nl\/wp-content\/uploads\/sites\/7\/2023\/01\/convert-myisam-to-innodb-1.png\",\"contentUrl\":\"https:\/\/kinsta.com\/nl\/wp-content\/uploads\/sites\/7\/2023\/01\/convert-myisam-to-innodb-1.png\",\"width\":1460,\"height\":730},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/kinsta.com\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL database\",\"item\":\"https:\/\/kinsta.com\/nl\/onderwerpen\/mysql-database\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"MySQL storage engine &#8211; Zo converteer je MyISAM naar InnoDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kinsta.com\/nl\/#website\",\"url\":\"https:\/\/kinsta.com\/nl\/\",\"name\":\"Kinsta\u00ae\",\"description\":\"Snelle, veilige, premium hostingoplossingen\",\"publisher\":{\"@id\":\"https:\/\/kinsta.com\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kinsta.com\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kinsta.com\/nl\/#organization\",\"name\":\"Kinsta\",\"url\":\"https:\/\/kinsta.com\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/kinsta.com\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kinsta.com\/nl\/wp-content\/uploads\/sites\/7\/2023\/12\/kinsta-logo.jpeg\",\"contentUrl\":\"https:\/\/kinsta.com\/nl\/wp-content\/uploads\/sites\/7\/2023\/12\/kinsta-logo.jpeg\",\"width\":500,\"height\":500,\"caption\":\"Kinsta\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/nl\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Kinsta-Nederland-476213452787823\/\",\"https:\/\/x.com\/Kinsta_NL\",\"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:\/\/kinsta.com\/nl\/#\/schema\/person\/079824c00ccc2b7141504f27ea63bef7\",\"name\":\"Brian Jackson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/kinsta.com\/nl\/#\/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:\/\/kinsta.com\/nl\/blog\/author\/brianjackson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MySQL storage engine - Zo converteer je MyISAM naar InnoDB","description":"Het is aangetoond dat de MySQL InnoDB storage engine sneller presteert en betrouwbaarder is. Volg deze korte tutorial over hoe je MyISAM converteert naar InnoDB.","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:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/","og_locale":"nl_NL","og_type":"article","og_title":"MySQL storage engine - Zo converteer je MyISAM naar InnoDB","og_description":"Het is aangetoond dat de MySQL InnoDB storage engine sneller presteert en betrouwbaarder is. Volg deze korte tutorial over hoe je MyISAM converteert naar InnoDB.","og_url":"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/","og_site_name":"Kinsta\u00ae","article_publisher":"https:\/\/www.facebook.com\/Kinsta-Nederland-476213452787823\/","article_author":"https:\/\/www.facebook.com\/fm.brianleejackson","article_published_time":"2023-01-19T18:44:37+00:00","article_modified_time":"2025-10-01T19:45:20+00:00","og_image":[{"width":1460,"height":730,"url":"https:\/\/kinsta.com\/nl\/wp-content\/uploads\/sites\/7\/2023\/01\/convert-myisam-to-innodb-1.png","type":"image\/png"}],"author":"Brian Jackson","twitter_card":"summary_large_image","twitter_description":"Het is aangetoond dat de MySQL InnoDB storage engine sneller presteert en betrouwbaarder is. Volg deze korte tutorial over hoe je MyISAM converteert naar InnoDB.","twitter_image":"https:\/\/kinsta.com\/nl\/wp-content\/uploads\/sites\/7\/2023\/01\/convert-myisam-to-innodb-1.png","twitter_creator":"@brianleejackson","twitter_site":"@Kinsta_NL","twitter_misc":{"Geschreven door":"Brian Jackson","Geschatte leestijd":"3 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/#article","isPartOf":{"@id":"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/"},"author":{"name":"Brian Jackson","@id":"https:\/\/kinsta.com\/nl\/#\/schema\/person\/079824c00ccc2b7141504f27ea63bef7"},"headline":"MySQL storage engine &#8211; Zo converteer je MyISAM naar InnoDB","datePublished":"2023-01-19T18:44:37+00:00","dateModified":"2025-10-01T19:45:20+00:00","mainEntityOfPage":{"@id":"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/"},"wordCount":494,"commentCount":0,"publisher":{"@id":"https:\/\/kinsta.com\/nl\/#organization"},"image":{"@id":"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/#primaryimage"},"thumbnailUrl":"https:\/\/kinsta.com\/nl\/wp-content\/uploads\/sites\/7\/2023\/01\/convert-myisam-to-innodb-1.png","inLanguage":"nl-NL","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/","url":"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/","name":"MySQL storage engine - Zo converteer je MyISAM naar InnoDB","isPartOf":{"@id":"https:\/\/kinsta.com\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/#primaryimage"},"image":{"@id":"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/#primaryimage"},"thumbnailUrl":"https:\/\/kinsta.com\/nl\/wp-content\/uploads\/sites\/7\/2023\/01\/convert-myisam-to-innodb-1.png","datePublished":"2023-01-19T18:44:37+00:00","dateModified":"2025-10-01T19:45:20+00:00","description":"Het is aangetoond dat de MySQL InnoDB storage engine sneller presteert en betrouwbaarder is. Volg deze korte tutorial over hoe je MyISAM converteert naar InnoDB.","breadcrumb":{"@id":"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/#primaryimage","url":"https:\/\/kinsta.com\/nl\/wp-content\/uploads\/sites\/7\/2023\/01\/convert-myisam-to-innodb-1.png","contentUrl":"https:\/\/kinsta.com\/nl\/wp-content\/uploads\/sites\/7\/2023\/01\/convert-myisam-to-innodb-1.png","width":1460,"height":730},{"@type":"BreadcrumbList","@id":"https:\/\/kinsta.com\/nl\/blog\/myisam-naar-innodb-converteren\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kinsta.com\/nl\/"},{"@type":"ListItem","position":2,"name":"MySQL database","item":"https:\/\/kinsta.com\/nl\/onderwerpen\/mysql-database\/"},{"@type":"ListItem","position":3,"name":"MySQL storage engine &#8211; Zo converteer je MyISAM naar InnoDB"}]},{"@type":"WebSite","@id":"https:\/\/kinsta.com\/nl\/#website","url":"https:\/\/kinsta.com\/nl\/","name":"Kinsta\u00ae","description":"Snelle, veilige, premium hostingoplossingen","publisher":{"@id":"https:\/\/kinsta.com\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kinsta.com\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/kinsta.com\/nl\/#organization","name":"Kinsta","url":"https:\/\/kinsta.com\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/kinsta.com\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/kinsta.com\/nl\/wp-content\/uploads\/sites\/7\/2023\/12\/kinsta-logo.jpeg","contentUrl":"https:\/\/kinsta.com\/nl\/wp-content\/uploads\/sites\/7\/2023\/12\/kinsta-logo.jpeg","width":500,"height":500,"caption":"Kinsta"},"image":{"@id":"https:\/\/kinsta.com\/nl\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Kinsta-Nederland-476213452787823\/","https:\/\/x.com\/Kinsta_NL","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:\/\/kinsta.com\/nl\/#\/schema\/person\/079824c00ccc2b7141504f27ea63bef7","name":"Brian Jackson","image":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/kinsta.com\/nl\/#\/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:\/\/kinsta.com\/nl\/blog\/author\/brianjackson\/"}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/kinsta.com\/nl\/wp-json\/wp\/v2\/posts\/49479","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kinsta.com\/nl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kinsta.com\/nl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kinsta.com\/nl\/wp-json\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/kinsta.com\/nl\/wp-json\/wp\/v2\/comments?post=49479"}],"version-history":[{"count":11,"href":"https:\/\/kinsta.com\/nl\/wp-json\/wp\/v2\/posts\/49479\/revisions"}],"predecessor-version":[{"id":49592,"href":"https:\/\/kinsta.com\/nl\/wp-json\/wp\/v2\/posts\/49479\/revisions\/49592"}],"alternate":[{"embeddable":true,"hreflang":"es","title":"Spanish","href":"https:\/\/kinsta.com\/nl\/wp-json\/kinsta\/v1\/posts\/49479\/translations\/es"},{"embeddable":true,"hreflang":"en","title":"English","href":"https:\/\/kinsta.com\/nl\/wp-json\/kinsta\/v1\/posts\/49479\/translations\/en"},{"embeddable":true,"hreflang":"it","title":"Italian","href":"https:\/\/kinsta.com\/nl\/wp-json\/kinsta\/v1\/posts\/49479\/translations\/it"},{"embeddable":true,"hreflang":"pt","title":"Portuguese","href":"https:\/\/kinsta.com\/nl\/wp-json\/kinsta\/v1\/posts\/49479\/translations\/pt"},{"embeddable":true,"hreflang":"de","title":"German","href":"https:\/\/kinsta.com\/nl\/wp-json\/kinsta\/v1\/posts\/49479\/translations\/de"},{"embeddable":true,"hreflang":"fr","title":"French","href":"https:\/\/kinsta.com\/nl\/wp-json\/kinsta\/v1\/posts\/49479\/translations\/fr"},{"embeddable":true,"hreflang":"da","title":"Danish","href":"https:\/\/kinsta.com\/nl\/wp-json\/kinsta\/v1\/posts\/49479\/translations\/dk"},{"embeddable":true,"hreflang":"sv","title":"Swedish","href":"https:\/\/kinsta.com\/nl\/wp-json\/kinsta\/v1\/posts\/49479\/translations\/se"},{"embeddable":true,"hreflang":"ja","title":"Japanese","href":"https:\/\/kinsta.com\/nl\/wp-json\/kinsta\/v1\/posts\/49479\/translations\/jp"},{"embeddable":true,"hreflang":"nl","title":"Dutch","href":"https:\/\/kinsta.com\/nl\/wp-json\/kinsta\/v1\/posts\/49479\/translations\/nl"},{"href":"https:\/\/kinsta.com\/nl\/wp-json\/kinsta\/v1\/posts\/49479\/tree"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kinsta.com\/nl\/wp-json\/wp\/v2\/media\/49480"}],"wp:attachment":[{"href":"https:\/\/kinsta.com\/nl\/wp-json\/wp\/v2\/media?parent=49479"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kinsta.com\/nl\/wp-json\/wp\/v2\/tags?post=49479"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/kinsta.com\/nl\/wp-json\/wp\/v2\/topic?post=49479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}