{"id":29039,"date":"2019-07-16T07:40:56","date_gmt":"2019-07-16T14:40:56","guid":{"rendered":"https:\/\/kinsta.com\/?post_type=knowledgebase&#038;p=8291"},"modified":"2025-10-01T20:52:16","modified_gmt":"2025-10-01T19:52:16","slug":"convertir-myisam-vers-innodb","status":"publish","type":"post","link":"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/","title":{"rendered":"Moteur de stockage MySQL &#8211; Comment convertir MyISAM en InnoDB"},"content":{"rendered":"<p>L&rsquo;une des principales raisons pour lesquelles les sites WordPress \u00e0 grande \u00e9chelle ralentissent est que leur base de donn\u00e9es n&rsquo;a pas \u00e9t\u00e9 optimis\u00e9e. Beaucoup d&rsquo;anciens sites utilisent encore le moteur de stockage MyISAM dans leur base de donn\u00e9es. Au cours des derni\u00e8res ann\u00e9es, InnoDB s&rsquo;est montr\u00e9 <a href=\"http:\/\/dimitrik.free.fr\/blog\/archives\/2015\/12\/mysql-performance-revisiting-innodb-vs-myisam-with-mysql-57.html\">plus performant<\/a> et plus fiable. Une bonne raison d&rsquo;utiliser InnoDB plut\u00f4t que MyISAM est l&rsquo;absence de verrouillage complet au niveau de la table. Cela permet d&rsquo;acc\u00e9l\u00e9rer le traitement de vos requ\u00eates.<\/p>\n<ul>\n<li><a href=\"#innodb-vs-myisam\">InnoDB vs MyISAM<\/a><\/li>\n<li><a href=\"#using-myisam-or-innodb\">Utilisez-vous MyISAM ou InnoDB ?<\/a><\/li>\n<li><a href=\"#convert-myisam-innodb-phpmyadmin\">Convertir MyISAM en InnoDB avec phpMyAdmin<\/a><\/li>\n<li><a href=\"#convert-myisam-innodb-wp-cli\">Convertir MyISAM en InnoDB avec WP-CLI<\/a><\/li>\n<\/ul>\n<h2 id=\"innodb-vs-myisam\">InnoDB vs MyISAM<\/h2>\n<p>Voici quelques-unes des principales diff\u00e9rences entre InnoDB et MyISAM :<\/p>\n<ul>\n<li>InnoDB est dot\u00e9 d&rsquo;un <strong>verrouillage de niveau de d\u00e9bit<\/strong>. MyISAM ne dispose que d&rsquo;un verrouillage complet au niveau de la table.<\/li>\n<li>InnoDB poss\u00e8de ce qu&rsquo;on appelle l&rsquo;int\u00e9grit\u00e9 r\u00e9f\u00e9rentielle qui implique la prise en charge des <strong>cl\u00e9s \u00e9trang\u00e8res<\/strong> (SGBDR) et des contraintes relationnelles, ce que MyISAM ne fait pas (DMBS).<\/li>\n<li>InnoDB supporte les <strong>transactions<\/strong>, ce qui signifie que vous pouvez les valider et les annuler. Ce n&rsquo;est pas le cas de MyISAM.<\/li>\n<li>InnoDB est plus fiable car il utilise les <strong>logs de transactions<\/strong> pour la r\u00e9cup\u00e9ration automatique. Ce n&rsquo;est pas le cas de MyISAM.<\/li>\n<\/ul>\n<h2 id=\"using-myisam-or-innodb\">Utilisez-vous MyISAM ou InnoDB ?<\/h2>\n<p>Si vous utilisez un site WordPress relativement nouveau, il y a de fortes chances que vous utilisiez d\u00e9j\u00e0 le moteur de stockage InnoDB <a href=\"https:\/\/kinsta.com\/fr\/blog\/qu-est-ce-que-mysql\/\">MySQL. <\/a>Mais avec les anciens sites WordPress, vous pourriez vouloir faire une v\u00e9rification rapide. Certains sites peuvent m\u00eame avoir m\u00e9lang\u00e9 et fait correspondre les tables MyISAM et InnoDB, dans lesquelles vous pouvez voir des am\u00e9liorations en les convertissant partout. Suivez les \u00e9tapes simples ci-dessous pour v\u00e9rifier.<\/p>\n<h3>\u00c9tape 1<\/h3>\n<p><a href=\"https:\/\/kinsta.com\/fr\/docs\/hebergement-wordpress\/gestion-base-de-donnees\/acces-base-donnees-wordpress\/\">Connectez-vous \u00e0 phpMyAdmin<\/a> et cliquez dans votre base de donn\u00e9es mySQL.<\/p>\n<h3>\u00c9tape 2<\/h3>\n<p>Faites un balayage rapide ou un tri de la colonne \u00ab\u00a0Type\u00a0\u00bb et vous pouvez voir quels types de moteurs de stockage vos tables utilisent. Dans l&rsquo;exemple ci-dessous, vous pouvez voir que deux des tables utilisent toujours MyISAM.<\/p>\n<figure style=\"width: 1422px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2016\/12\/trouver-tables-myisam.jpg\" alt=\"Trouver les tables MyISAM\" width=\"1422\" height=\"708\"><figcaption class=\"wp-caption-text\">Trouver les tables MyISAM<\/figcaption><\/figure>\n<p>Vous pouvez \u00e9galement lancer une requ\u00eate pour savoir s&rsquo;il existe des tables MyISAM. Remplacez &lsquo;database&rsquo; par le nom de votre base de donn\u00e9es.<\/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\">Convertir MyISAM en InnoDB avec phpMyAdmin<\/h2>\n<p>Vous pouvez convertir MyISAM en InnoDB assez facilement. Cet exemple ci-dessous utilise la table <code>wp_comments<\/code>. Ex\u00e9cutez simplement la commande ALTER pour la convertir en moteur de stockage InnoDB. Remarque : Nous vous recommandons toujours de sauvegarder votre base de donn\u00e9es MySQL avant d&rsquo;ex\u00e9cuter toute op\u00e9ration sur celle-ci.<\/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\">Assurez-vous que vous utilisez MySQL 5.6.4 ou une version plus r\u00e9cente, sinon vous pourriez rencontrer des probl\u00e8mes o\u00f9 l&rsquo;indexation plain text n&rsquo;est pas encore support\u00e9e par InnoDB. Si vous \u00eates un client Kinsta, vous n&rsquo;avez pas \u00e0 vous inqui\u00e9ter de cela.<\/div>\n<p>Alternativement, vous pouvez aussi les convertir manuellement avec phpMyAdmin. Cliquez simplement sur le tableau MyISAM, cliquez dans l&rsquo;onglet \u00ab\u00a0Op\u00e9rations\u00a0\u00bb et changez le moteur de stockage.<\/p>\n<figure style=\"width: 402px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2016\/12\/convertir-myisam-innodb.jpg\" alt=\"Convertir MyISAM en InnoDB\" width=\"402\" height=\"720\"><figcaption class=\"wp-caption-text\">Convertir MyISAM en InnoDB<\/figcaption><\/figure>\n<h2 id=\"convert-myisam-innodb-wp-cli\">Convertir MyISAM en InnoDB avec WP-CLI<\/h2>\n<p>WP-CLI est un outil en ligne de commande permettant aux d\u00e9veloppeurs de g\u00e9rer les t\u00e2ches communes (et moins communes) d&rsquo;une installation WordPress. Lisez cet article pour savoir comment <a href=\"https:\/\/guides.wp-bullet.com\/converting-wordpress-database-tables-from-myisam-to-innodb-with-wp-cli\/\">convertir MyISAM en InnoDB avec WP-CLI<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>L&rsquo;une des principales raisons pour lesquelles les sites WordPress \u00e0 grande \u00e9chelle ralentissent est que leur base de donn\u00e9es n&rsquo;a pas \u00e9t\u00e9 optimis\u00e9e. Beaucoup d&rsquo;anciens sites &#8230;<\/p>\n","protected":false},"author":38,"featured_media":29043,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kinsta_gated_content":false,"_kinsta_gated_content_redirect":"","footnotes":""},"tags":[],"topic":[992],"class_list":["post-29039","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","topic-base-de-donnees-mysql"],"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>Moteur de stockage MySQL - Comment convertir MyISAM en InnoDB<\/title>\n<meta name=\"description\" content=\"Le moteur de stockage MySQL InnoDB s&#039;est av\u00e9r\u00e9 plus rapide et plus fiable. Suivez ce tutoriel rapide pour savoir comment convertir MyISAM en 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\/fr\/blog\/convertir-myisam-vers-innodb\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Moteur de stockage MySQL - Comment convertir MyISAM en InnoDB\" \/>\n<meta property=\"og:description\" content=\"Le moteur de stockage MySQL InnoDB s&#039;est av\u00e9r\u00e9 plus rapide et plus fiable. Suivez ce tutoriel rapide pour savoir comment convertir MyISAM en InnoDB.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/\" \/>\n<meta property=\"og:site_name\" content=\"Kinsta\u00ae\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/kinstafrance\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/fm.brianleejackson\" \/>\n<meta property=\"article:published_time\" content=\"2019-07-16T14:40:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-01T19:52:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2017\/12\/site-facebook-instant-articles.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1999\" \/>\n\t<meta property=\"og:image:height\" content=\"1136\" \/>\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=\"Le moteur de stockage MySQL InnoDB s&#039;est av\u00e9r\u00e9 plus rapide et plus fiable. Suivez ce tutoriel rapide pour savoir comment convertir MyISAM en InnoDB.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/kinsta.com\/wp-content\/uploads\/2016\/12\/convert-myisam-to-innodb-1.png\" \/>\n<meta name=\"twitter:creator\" content=\"@brianleejackson\" \/>\n<meta name=\"twitter:site\" content=\"@kinsta_fr\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Brian Jackson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/\"},\"author\":{\"name\":\"Brian Jackson\",\"@id\":\"https:\/\/kinsta.com\/fr\/#\/schema\/person\/079824c00ccc2b7141504f27ea63bef7\"},\"headline\":\"Moteur de stockage MySQL &#8211; Comment convertir MyISAM en InnoDB\",\"datePublished\":\"2019-07-16T14:40:56+00:00\",\"dateModified\":\"2025-10-01T19:52:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/\"},\"wordCount\":591,\"publisher\":{\"@id\":\"https:\/\/kinsta.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/07\/moteur-stockage-mysql.png\",\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/\",\"url\":\"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/\",\"name\":\"Moteur de stockage MySQL - Comment convertir MyISAM en InnoDB\",\"isPartOf\":{\"@id\":\"https:\/\/kinsta.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/07\/moteur-stockage-mysql.png\",\"datePublished\":\"2019-07-16T14:40:56+00:00\",\"dateModified\":\"2025-10-01T19:52:16+00:00\",\"description\":\"Le moteur de stockage MySQL InnoDB s'est av\u00e9r\u00e9 plus rapide et plus fiable. Suivez ce tutoriel rapide pour savoir comment convertir MyISAM en InnoDB.\",\"breadcrumb\":{\"@id\":\"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/#primaryimage\",\"url\":\"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/07\/moteur-stockage-mysql.png\",\"contentUrl\":\"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/07\/moteur-stockage-mysql.png\",\"width\":1460,\"height\":730,\"caption\":\"Moteur de stockage MySQL - Comment convertir MyISAM en InnoDB\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/kinsta.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Base de donn\u00e9es MySQL\",\"item\":\"https:\/\/kinsta.com\/fr\/sujets\/base-de-donnees-mysql\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Moteur de stockage MySQL &#8211; Comment convertir MyISAM en InnoDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kinsta.com\/fr\/#website\",\"url\":\"https:\/\/kinsta.com\/fr\/\",\"name\":\"Kinsta\u00ae\",\"description\":\"Solutions d&#039;h\u00e9bergement premium, rapides et s\u00e9curis\u00e9es\",\"publisher\":{\"@id\":\"https:\/\/kinsta.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kinsta.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kinsta.com\/fr\/#organization\",\"name\":\"Kinsta\",\"url\":\"https:\/\/kinsta.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/kinsta.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2023\/12\/kinsta-logo.jpeg\",\"contentUrl\":\"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2023\/12\/kinsta-logo.jpeg\",\"width\":500,\"height\":500,\"caption\":\"Kinsta\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/kinstafrance\/\",\"https:\/\/x.com\/kinsta_fr\",\"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\/fr\/#\/schema\/person\/079824c00ccc2b7141504f27ea63bef7\",\"name\":\"Brian Jackson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/kinsta.com\/fr\/#\/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\/fr\/blog\/author\/brianjackson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Moteur de stockage MySQL - Comment convertir MyISAM en InnoDB","description":"Le moteur de stockage MySQL InnoDB s'est av\u00e9r\u00e9 plus rapide et plus fiable. Suivez ce tutoriel rapide pour savoir comment convertir MyISAM en 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\/fr\/blog\/convertir-myisam-vers-innodb\/","og_locale":"fr_FR","og_type":"article","og_title":"Moteur de stockage MySQL - Comment convertir MyISAM en InnoDB","og_description":"Le moteur de stockage MySQL InnoDB s'est av\u00e9r\u00e9 plus rapide et plus fiable. Suivez ce tutoriel rapide pour savoir comment convertir MyISAM en InnoDB.","og_url":"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/","og_site_name":"Kinsta\u00ae","article_publisher":"https:\/\/www.facebook.com\/kinstafrance\/","article_author":"https:\/\/www.facebook.com\/fm.brianleejackson","article_published_time":"2019-07-16T14:40:56+00:00","article_modified_time":"2025-10-01T19:52:16+00:00","og_image":[{"width":1999,"height":1136,"url":"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2017\/12\/site-facebook-instant-articles.png","type":"image\/png"}],"author":"Brian Jackson","twitter_card":"summary_large_image","twitter_description":"Le moteur de stockage MySQL InnoDB s'est av\u00e9r\u00e9 plus rapide et plus fiable. Suivez ce tutoriel rapide pour savoir comment convertir MyISAM en InnoDB.","twitter_image":"https:\/\/kinsta.com\/wp-content\/uploads\/2016\/12\/convert-myisam-to-innodb-1.png","twitter_creator":"@brianleejackson","twitter_site":"@kinsta_fr","twitter_misc":{"\u00c9crit par":"Brian Jackson","Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/#article","isPartOf":{"@id":"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/"},"author":{"name":"Brian Jackson","@id":"https:\/\/kinsta.com\/fr\/#\/schema\/person\/079824c00ccc2b7141504f27ea63bef7"},"headline":"Moteur de stockage MySQL &#8211; Comment convertir MyISAM en InnoDB","datePublished":"2019-07-16T14:40:56+00:00","dateModified":"2025-10-01T19:52:16+00:00","mainEntityOfPage":{"@id":"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/"},"wordCount":591,"publisher":{"@id":"https:\/\/kinsta.com\/fr\/#organization"},"image":{"@id":"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/#primaryimage"},"thumbnailUrl":"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/07\/moteur-stockage-mysql.png","inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/","url":"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/","name":"Moteur de stockage MySQL - Comment convertir MyISAM en InnoDB","isPartOf":{"@id":"https:\/\/kinsta.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/#primaryimage"},"image":{"@id":"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/#primaryimage"},"thumbnailUrl":"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/07\/moteur-stockage-mysql.png","datePublished":"2019-07-16T14:40:56+00:00","dateModified":"2025-10-01T19:52:16+00:00","description":"Le moteur de stockage MySQL InnoDB s'est av\u00e9r\u00e9 plus rapide et plus fiable. Suivez ce tutoriel rapide pour savoir comment convertir MyISAM en InnoDB.","breadcrumb":{"@id":"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/#primaryimage","url":"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/07\/moteur-stockage-mysql.png","contentUrl":"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2019\/07\/moteur-stockage-mysql.png","width":1460,"height":730,"caption":"Moteur de stockage MySQL - Comment convertir MyISAM en InnoDB"},{"@type":"BreadcrumbList","@id":"https:\/\/kinsta.com\/fr\/blog\/convertir-myisam-vers-innodb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kinsta.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Base de donn\u00e9es MySQL","item":"https:\/\/kinsta.com\/fr\/sujets\/base-de-donnees-mysql\/"},{"@type":"ListItem","position":3,"name":"Moteur de stockage MySQL &#8211; Comment convertir MyISAM en InnoDB"}]},{"@type":"WebSite","@id":"https:\/\/kinsta.com\/fr\/#website","url":"https:\/\/kinsta.com\/fr\/","name":"Kinsta\u00ae","description":"Solutions d&#039;h\u00e9bergement premium, rapides et s\u00e9curis\u00e9es","publisher":{"@id":"https:\/\/kinsta.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kinsta.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/kinsta.com\/fr\/#organization","name":"Kinsta","url":"https:\/\/kinsta.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/kinsta.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2023\/12\/kinsta-logo.jpeg","contentUrl":"https:\/\/kinsta.com\/fr\/wp-content\/uploads\/sites\/4\/2023\/12\/kinsta-logo.jpeg","width":500,"height":500,"caption":"Kinsta"},"image":{"@id":"https:\/\/kinsta.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/kinstafrance\/","https:\/\/x.com\/kinsta_fr","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\/fr\/#\/schema\/person\/079824c00ccc2b7141504f27ea63bef7","name":"Brian Jackson","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/kinsta.com\/fr\/#\/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\/fr\/blog\/author\/brianjackson\/"}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/kinsta.com\/fr\/wp-json\/wp\/v2\/posts\/29039","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kinsta.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kinsta.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kinsta.com\/fr\/wp-json\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/kinsta.com\/fr\/wp-json\/wp\/v2\/comments?post=29039"}],"version-history":[{"count":3,"href":"https:\/\/kinsta.com\/fr\/wp-json\/wp\/v2\/posts\/29039\/revisions"}],"predecessor-version":[{"id":29080,"href":"https:\/\/kinsta.com\/fr\/wp-json\/wp\/v2\/posts\/29039\/revisions\/29080"}],"alternate":[{"embeddable":true,"hreflang":"es","title":"Spanish","href":"https:\/\/kinsta.com\/fr\/wp-json\/kinsta\/v1\/posts\/29039\/translations\/es"},{"embeddable":true,"hreflang":"en","title":"English","href":"https:\/\/kinsta.com\/fr\/wp-json\/kinsta\/v1\/posts\/29039\/translations\/en"},{"embeddable":true,"hreflang":"it","title":"Italian","href":"https:\/\/kinsta.com\/fr\/wp-json\/kinsta\/v1\/posts\/29039\/translations\/it"},{"embeddable":true,"hreflang":"pt","title":"Portuguese","href":"https:\/\/kinsta.com\/fr\/wp-json\/kinsta\/v1\/posts\/29039\/translations\/pt"},{"embeddable":true,"hreflang":"de","title":"German","href":"https:\/\/kinsta.com\/fr\/wp-json\/kinsta\/v1\/posts\/29039\/translations\/de"},{"embeddable":true,"hreflang":"fr","title":"French","href":"https:\/\/kinsta.com\/fr\/wp-json\/kinsta\/v1\/posts\/29039\/translations\/fr"},{"embeddable":true,"hreflang":"da","title":"Danish","href":"https:\/\/kinsta.com\/fr\/wp-json\/kinsta\/v1\/posts\/29039\/translations\/dk"},{"embeddable":true,"hreflang":"sv","title":"Swedish","href":"https:\/\/kinsta.com\/fr\/wp-json\/kinsta\/v1\/posts\/29039\/translations\/se"},{"embeddable":true,"hreflang":"ja","title":"Japanese","href":"https:\/\/kinsta.com\/fr\/wp-json\/kinsta\/v1\/posts\/29039\/translations\/jp"},{"embeddable":true,"hreflang":"nl","title":"Dutch","href":"https:\/\/kinsta.com\/fr\/wp-json\/kinsta\/v1\/posts\/29039\/translations\/nl"},{"href":"https:\/\/kinsta.com\/fr\/wp-json\/kinsta\/v1\/posts\/29039\/tree"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kinsta.com\/fr\/wp-json\/wp\/v2\/media\/29043"}],"wp:attachment":[{"href":"https:\/\/kinsta.com\/fr\/wp-json\/wp\/v2\/media?parent=29039"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kinsta.com\/fr\/wp-json\/wp\/v2\/tags?post=29039"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/kinsta.com\/fr\/wp-json\/wp\/v2\/topic?post=29039"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}