{"id":9856475,"date":"2026-11-18T15:27:17","date_gmt":"2026-11-18T14:27:17","guid":{"rendered":"https:\/\/wp-rocket.me\/docs\/optimisations-base-de-donnees\/"},"modified":"2026-11-18T15:27:17","modified_gmt":"2026-11-18T14:27:17","slug":"optimisations-base-de-donnees","status":"publish","type":"docs_hub","link":"https:\/\/wp-rocket.me\/fr\/docs\/optimisations-base-de-donnees\/","title":{"rendered":"Optimisations de la base de donn\u00e9es"},"content":{"rendered":"<p>\n\t Cet article contient des informations sur les fonctionnalit\u00e9s d&rsquo;optimisation de l&rsquo;onglet Base de donn\u00e9es.<\/p>\n<p class=\"callout-yellow\">\n\t<strong> Attention !<\/strong><strong> Sauvegardez votre base de donn\u00e9es avant d&rsquo;ex\u00e9cuter un nettoyage !<\/p>\n<p>\t<\/strong>Dans la plupart des cas, il ne devrait y avoir aucun probl\u00e8me, mais une fois qu&rsquo;une optimisation de la base de donn\u00e9es a \u00e9t\u00e9 effectu\u00e9e, il n&rsquo;y a aucun moyen de l&rsquo;annuler. Vous pouvez voir comment <a href=\"https:\/\/wpformation.com\/sauvegardez-votre-site-wordpress-avec-updraftplus\/\" target=\"_blank\" rel=\"noopener\">sauvegarder votre base de donn\u00e9es ici<\/a>.<\/p>\n<h2>Conditions requises<\/h2>\n<p>\n\t Pour que ces optimisations fonctionnent correctement, <a href=\"https:\/\/developer.wordpress.org\/plugins\/cron\/\" target=\"_blank\" rel=\"noopener\">WP-Cron<\/a> ou un cron job c\u00f4t\u00e9 serveur devrait fonctionner, conform\u00e9ment \u00e0 <a href=\"https:\/\/wp-rocket.me\/fr\/docs\/cron-et-wp-rocket\/\">notre article ici<\/a>.<\/p>\n<p>\n\t En outre, l&rsquo;option <em>Optimiser les tables<\/em> n&rsquo;optimisera pas les tables si elles utilisent le moteur InnoDB.<\/p>\n<h2>Comment \u00e7a marche<\/h2>\n<p>\n\t WP Rocket v\u00e9rifiera les \u00e9l\u00e9ments de la base de donn\u00e9es qui peuvent \u00eatre optimis\u00e9s, puis enverra des requ\u00eates \u00e0 la base de donn\u00e9es en utilisant un ensemble de fonctions WordPress et de d\u00e9clarations MySQL comme suit :<\/p>\n<h3>Nettoyage des Articles<\/h3>\n<ul>\n<li><strong>R\u00e9visions : <\/strong>utilise la fonction <a href=\"https:\/\/developer.wordpress.org\/reference\/functions\/wp_delete_post_revision\/\" target=\"_blank\" rel=\"noopener\">wp_delete_post_revision<\/a> sur les posts avec <a href=\"https:\/\/wordpress.org\/support\/article\/post-types\/\" target=\"_blank\" rel=\"noopener\">post_type<\/a> r\u00e9gl\u00e9 sur&nbsp;<code>revision<\/code>.<\/li>\n<li><strong>Brouillons Automatiques : <\/strong>utilise la fonction <a href=\"https:\/\/developer.wordpress.org\/reference\/functions\/wp_delete_post\/\" target=\"_blank\" rel=\"noopener\">wp_delete_post<\/a> sur les posts avec <a href=\"https:\/\/wordpress.org\/support\/article\/post-status\/\" target=\"_blank\" rel=\"noopener\">status<\/a> r\u00e9gl\u00e9 sur <code>auto-draft<\/code>.<\/li>\n<li><strong>Articles supprim\u00e9s :<\/strong> utilise la fonction <a href=\"https:\/\/developer.wordpress.org\/reference\/functions\/wp_delete_post\/\" target=\"_blank\" rel=\"noopener\">wp_delete_post<\/a> sur les posts avec le statut r\u00e9gl\u00e9 sur <code>trash<\/code>.<\/li>\n<\/ul>\n<h3>Nettoyage des&nbsp;Commentaires<\/h3>\n<ul>\n<li><strong>Commentaires Spams : <\/strong>les<strong>&nbsp;<\/strong>commentaires avec la valeur&nbsp;<code>spam<\/code> dans la colonne&nbsp;<code>comment_approved<\/code> seront supprim\u00e9s gr\u00e2ce \u00e0 la fonction <a href=\"https:\/\/developer.wordpress.org\/reference\/functions\/wp_delete_comment\/\" target=\"_blank\" rel=\"noopener\">wp_delete_comment<\/a> function.<\/li>\n<li><strong>Commentaires&nbsp;supprim\u00e9s&nbsp;: <\/strong>les commentaires avec la valeur <code>trash<\/code> ou&nbsp;<code>post-trashed<\/code> dans la colonne <code>comment_approved<\/code> seront supprim\u00e9s gr\u00e2ce \u00e0 la fonction <a href=\"https:\/\/developer.wordpress.org\/reference\/functions\/wp_delete_comment\/\" target=\"_blank\" rel=\"noopener\">wp_delete_comment<\/a>.<\/li>\n<\/ul>\n<h3>Nettoyage des&nbsp;Transients<\/h3>\n<ul>\n<li><strong>Tous les transients :<\/strong> utilisera les fonctions <a href=\"https:\/\/developer.wordpress.org\/reference\/functions\/delete_transient\/\" target=\"_blank\" rel=\"noopener\">delete_transient()<\/a> et <a href=\"https:\/\/developer.wordpress.org\/reference\/functions\/delete_site_transient\/\" target=\"_blank\" rel=\"noopener\">delete_site_transient()<\/a>.<\/li>\n<\/ul>\n<h3>Nettoyage de la Base de donn\u00e9es<\/h3>\n<ul>\n<li><strong>Optimisation des Tables : <\/strong>Optimisera les tables gr\u00e2ce \u00e0 la d\u00e9claration <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/optimize-table.html\" target=\"_blank\" rel=\"noopener\">OPTIMIZE TABLE<\/a>.<\/li>\n<\/ul>\n<h3>Nettoyage Automatique<\/h3>\n<ul>\n<li><strong>Planifier un nettoyage automatique&nbsp;:&nbsp;<\/strong>&nbsp;utilisera une t\u00e2che cron pour ex\u00e9cuter les options d&rsquo;optimisation de base de donn\u00e9es s\u00e9lectionn\u00e9es, en fonction de l&rsquo;intervalle sp\u00e9cifique choisi.\u2028&nbsp;Les fr\u00e9quences de nettoyage disponibles sont quotidiennes, hebdomadaires et mensuelles.\n\t<\/li>\n<\/ul>\n<h2>R\u00e9solution de probl\u00e8me<\/h2>\n<h4><strong> Page des r\u00e9glages lente<\/strong><\/h4>\n<p>\n\t Afin de compter et d&rsquo;afficher le nombre d&rsquo;\u00e9l\u00e9ments de base de donn\u00e9es \u00e0 optimiser, WP Rocket utilise quelques requ\u00eates MySQL, si le nombre d&rsquo;\u00e9l\u00e9ments de base de donn\u00e9es est trop important ou si le serveur ne peut pas g\u00e9rer le traitement, la page de configuration de WP Rocket peut devenir plus lente.<\/p>\n<h4>Les optimisations de la base de donn\u00e9es ne fonctionnent pas<\/h4>\n<p>Veuillez vous r\u00e9f\u00e9rer \u00e0 cette documentation: <a href=\"https:\/\/wp-rocket.me\/fr\/docs\/les-optimisations-de-la-base-de-donnees-ne-fonctionne-pas\/\" style=\"font-size: 14px;\">Les optimisations de la base de donn\u00e9es ne fonctionne pas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cet article contient des informations sur les fonctionnalit\u00e9s d&rsquo;optimisation de l&rsquo;onglet Base de donn\u00e9es. Attention ! Sauvegardez votre base de donn\u00e9es avant d&rsquo;ex\u00e9cuter un nettoyage ! Dans la plupart des cas, il ne devrait y avoir aucun probl\u00e8me, mais une&hellip;<\/p>\n","protected":false},"template":"","docs_hub_category":[238],"docs_hub_tag":[345],"class_list":["post-9856475","docs_hub","type-docs_hub","status-publish","hentry","docs_hub_category-fonctionnalites-optimisation","docs_hub_tag-optimisation-de-la-base-de-donnees"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Optimisations de la base de donn\u00e9es - WP Rocket<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/wp-rocket.me\/fr\/docs\/optimisations-base-de-donnees\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Optimisations de la base de donn\u00e9es - WP Rocket\" \/>\n<meta property=\"og:description\" content=\"Cet article contient des informations sur les fonctionnalit\u00e9s d&#039;optimisation de l&#039;onglet Base de donn\u00e9es. Attention ! Sauvegardez votre base de donn\u00e9es avant d&#039;ex\u00e9cuter un nettoyage ! Dans la plupart des cas, il ne devrait y avoir aucun probl\u00e8me, mais une&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wp-rocket.me\/fr\/docs\/optimisations-base-de-donnees\/\" \/>\n<meta property=\"og:site_name\" content=\"WP Rocket\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/pages\/WP-Rocket\/631942253526829\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wp-rocket.me\/wp-content\/uploads\/2024\/10\/1200x800-Featured-Image.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2048\" \/>\n\t<meta property=\"og:image:height\" content=\"1365\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@wp_rocket\" \/>\n<meta name=\"twitter:label1\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/wp-rocket.me\\\/fr\\\/docs\\\/optimisations-base-de-donnees\\\/\",\"url\":\"https:\\\/\\\/wp-rocket.me\\\/fr\\\/docs\\\/optimisations-base-de-donnees\\\/\",\"name\":\"Optimisations de la base de donn\u00e9es - WP Rocket\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wp-rocket.me\\\/#website\"},\"datePublished\":\"2026-11-18T14:27:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/wp-rocket.me\\\/fr\\\/docs\\\/optimisations-base-de-donnees\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/wp-rocket.me\\\/fr\\\/docs\\\/optimisations-base-de-donnees\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/wp-rocket.me\\\/fr\\\/docs\\\/optimisations-base-de-donnees\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/wp-rocket.me\\\/fr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Documentation\",\"item\":\"https:\\\/\\\/wp-rocket.me\\\/docs\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Optimisations de la base de donn\u00e9es\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/wp-rocket.me\\\/#website\",\"url\":\"https:\\\/\\\/wp-rocket.me\\\/\",\"name\":\"WP Rocket\",\"description\":\"Plugin d&#039;optimisation de sites WordPress\",\"publisher\":{\"@id\":\"https:\\\/\\\/wp-rocket.me\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/wp-rocket.me\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/wp-rocket.me\\\/#organization\",\"name\":\"WP Rocket\",\"url\":\"https:\\\/\\\/wp-rocket.me\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/wp-rocket.me\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/wp-rocket.me\\\/wp-content\\\/uploads\\\/1\\\/logo-wp-rocket-paypal-2.png\",\"contentUrl\":\"https:\\\/\\\/wp-rocket.me\\\/wp-content\\\/uploads\\\/1\\\/logo-wp-rocket-paypal-2.png\",\"width\":150,\"height\":41,\"caption\":\"WP Rocket\"},\"image\":{\"@id\":\"https:\\\/\\\/wp-rocket.me\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/pages\\\/WP-Rocket\\\/631942253526829\",\"https:\\\/\\\/x.com\\\/wp_rocket\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UC1ozThXHd1IWIZ5wkshgp_Q\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Optimisations de la base de donn\u00e9es - WP Rocket","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:\/\/wp-rocket.me\/fr\/docs\/optimisations-base-de-donnees\/","og_locale":"fr_FR","og_type":"article","og_title":"Optimisations de la base de donn\u00e9es - WP Rocket","og_description":"Cet article contient des informations sur les fonctionnalit\u00e9s d'optimisation de l'onglet Base de donn\u00e9es. Attention ! Sauvegardez votre base de donn\u00e9es avant d'ex\u00e9cuter un nettoyage ! Dans la plupart des cas, il ne devrait y avoir aucun probl\u00e8me, mais une&hellip;","og_url":"https:\/\/wp-rocket.me\/fr\/docs\/optimisations-base-de-donnees\/","og_site_name":"WP Rocket","article_publisher":"https:\/\/www.facebook.com\/pages\/WP-Rocket\/631942253526829","og_image":[{"width":2048,"height":1365,"url":"https:\/\/wp-rocket.me\/wp-content\/uploads\/2024\/10\/1200x800-Featured-Image.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@wp_rocket","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/wp-rocket.me\/fr\/docs\/optimisations-base-de-donnees\/","url":"https:\/\/wp-rocket.me\/fr\/docs\/optimisations-base-de-donnees\/","name":"Optimisations de la base de donn\u00e9es - WP Rocket","isPartOf":{"@id":"https:\/\/wp-rocket.me\/#website"},"datePublished":"2026-11-18T14:27:17+00:00","breadcrumb":{"@id":"https:\/\/wp-rocket.me\/fr\/docs\/optimisations-base-de-donnees\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wp-rocket.me\/fr\/docs\/optimisations-base-de-donnees\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/wp-rocket.me\/fr\/docs\/optimisations-base-de-donnees\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/wp-rocket.me\/fr\/"},{"@type":"ListItem","position":2,"name":"Documentation","item":"https:\/\/wp-rocket.me\/docs\/"},{"@type":"ListItem","position":3,"name":"Optimisations de la base de donn\u00e9es"}]},{"@type":"WebSite","@id":"https:\/\/wp-rocket.me\/#website","url":"https:\/\/wp-rocket.me\/","name":"WP Rocket","description":"Plugin d&#039;optimisation de sites WordPress","publisher":{"@id":"https:\/\/wp-rocket.me\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wp-rocket.me\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/wp-rocket.me\/#organization","name":"WP Rocket","url":"https:\/\/wp-rocket.me\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/wp-rocket.me\/#\/schema\/logo\/image\/","url":"https:\/\/wp-rocket.me\/wp-content\/uploads\/1\/logo-wp-rocket-paypal-2.png","contentUrl":"https:\/\/wp-rocket.me\/wp-content\/uploads\/1\/logo-wp-rocket-paypal-2.png","width":150,"height":41,"caption":"WP Rocket"},"image":{"@id":"https:\/\/wp-rocket.me\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/pages\/WP-Rocket\/631942253526829","https:\/\/x.com\/wp_rocket","https:\/\/www.youtube.com\/channel\/UC1ozThXHd1IWIZ5wkshgp_Q"]}]}},"_links":{"self":[{"href":"https:\/\/wp-rocket.me\/fr\/wp-json\/wp\/v2\/docs_hub\/9856475","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp-rocket.me\/fr\/wp-json\/wp\/v2\/docs_hub"}],"about":[{"href":"https:\/\/wp-rocket.me\/fr\/wp-json\/wp\/v2\/types\/docs_hub"}],"version-history":[{"count":0,"href":"https:\/\/wp-rocket.me\/fr\/wp-json\/wp\/v2\/docs_hub\/9856475\/revisions"}],"wp:attachment":[{"href":"https:\/\/wp-rocket.me\/fr\/wp-json\/wp\/v2\/media?parent=9856475"}],"wp:term":[{"taxonomy":"docs_hub_category","embeddable":true,"href":"https:\/\/wp-rocket.me\/fr\/wp-json\/wp\/v2\/docs_hub_category?post=9856475"},{"taxonomy":"docs_hub_tag","embeddable":true,"href":"https:\/\/wp-rocket.me\/fr\/wp-json\/wp\/v2\/docs_hub_tag?post=9856475"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}