{"id":175,"date":"2012-06-12T09:46:14","date_gmt":"2012-06-12T08:46:14","guid":{"rendered":"http:\/\/www.bocciolesi.fr\/tutoriels-et-cours\/?p=175"},"modified":"2017-02-24T14:25:52","modified_gmt":"2017-02-24T13:25:52","slug":"les-differents-moteurs-de-stockage-mysql","status":"publish","type":"post","link":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/les-differents-moteurs-de-stockage-mysql\/","title":{"rendered":"Les diff\u00e9rents moteurs de stockage MySql"},"content":{"rendered":"
\"image_pdf\"Enregistrer en PDF<\/span><\/a><\/a><\/div>

I\u25ba Nous allons voir les diff\u00e9rents moteurs de stockage Mysql :<\/strong><\/span><\/p>\n

MyIsam :<\/span><\/strong><\/h2>\n

MyIsam \u00e9tait le moteur de stockage par d\u00e9faut pour toute sles versions de MySql inf\u00e9rieures \u00e0 MySql 5.5.<\/p>\n

\ud83d\ude41<\/p>\n

    \n
  • Il ne g\u00e8re ni les relations ni les transactions SQL.<\/span><\/li>\n
  • Il bloque les tables<\/span> automatiquement lors d’insertion, de modification ou de suppression de donn\u00e9es.<\/span><\/li>\n<\/ul>\n

    \ud83d\ude42<\/p>\n

      \n
    • Il permet l’indexation des champs et est capable de’optimiser au maximum ses recherhces textes avec l’index FULLTEXT (bien plus rapide qu’une clause LIKE %…)<\/span><\/li>\n
    • Il est\u00a0extr\u00eamement<\/span>\u00a0rapide en lecture.<\/span><\/li>\n<\/ul>\n

      \u00a0InnoDB :<\/span><\/strong><\/h2>\n

      InnoDB est un moteur transactionnel et relationnel.
      \nIl\u00a0s\u2019assure\u00a0de la coh\u00e9rence des enregistrements connexes lors d’op\u00e9rations sur les tables.<\/p>\n

      Le verrouillage des donn\u00e9es s’effectue\u00a0uniquement\u00a0au niveau de la ligne<\/span> concern\u00e9e et non de la table (MyIsam)
      \nIl est plus lent que MyIsam mais plus s\u00e9curis\u00e9 (gr\u00e2ce aux relations). Ceci tend \u00e0 devenir faux depuis la version 5.5…<\/p>\n

      \u00a0Memory(heap) :<\/span><\/strong><\/h2>\n

      Memory est un moteur de stockage qui cr\u00e9e les tables directement en RAM.
      \nIl est le plus rapide des moteurs mais extr\u00eament dangereux en cas de plantage du syst\u00e8me (les donn\u00e9es sont d\u00e9finitivement perdues).
      \nIl est utilis\u00e9 en d\u00e9veloppement Web pour stocker des informations relatives \u00e0 la session (Panier, compte client , mail …)<\/p>\n

      \u00a0Merge :<\/span><\/strong><\/h2>\n

      Merge est un moteur qui permet de r\u00e9unir plusieurs tables de donn\u00e9es ind\u00e9pendantes en une seule m\u00eame table.
      \nLes tables fusionn\u00e9es peuvent appartenir \u00e0 plusieurs bases de donn\u00e9es mais celles-ci doivent \u00eatre physiquement pr\u00e9sentes sur le m\u00eame serveur.
      \nLes colonnes et les types doivent \u00eatre strictement identiques.<\/p>\n

      On peut cr\u00e9er une table par mois et fusionner le tout en une table\u00a0annuelle.
      \nOn peut bien s\u00fbr travailler\u00a0ind\u00e9pendamment\u00a0sur chaque mois (table) et requ\u00eater sur\u00a0l\u2019ann\u00e9e\u00a0enti\u00e8re ou en cours de construction.<\/p>\n

      BlackHole :<\/span><\/h2>\n
      Le trou noir ( -> \/dev\/null ) est un moteur qui permet de faire des simulations car tout ce qui est \u00e9crit est d\u00e9truit au final, ce qui \u00e9vite de supprimer (drop) les tables au final.<\/div>\n
      <\/div>\n

      Archive :<\/span><\/h2>\n

      Archive est un moteur de stocj=kage qui permet de stocker d’\u00e9normes quantit\u00e9 de donn\u00e9es. en effet, les donn\u00e9es sont compress\u00e9es \u00e0 leur insertion.
      \nNi les relations, ni les transactions, ni les index ne sont autoris\u00e9es. on ne peut faire que des requ\u00eates d’insert et de select !<\/span><\/p>\n

      CSV :<\/span><\/h2>\n

      Les donn\u00e9es sont stock\u00e9es dans des fichiers textes s\u00e9par\u00e9es par une virgule; il permet une grande compatibilit\u00e9 avec les tableurs.<\/p>\n

       <\/p>\n","protected":false},"excerpt":{"rendered":"

      I\u25ba Nous allons voir les diff\u00e9rents moteurs de stockage Mysql : MyIsam : MyIsam \u00e9tait le moteur de stockage par d\u00e9faut pour toute sles versions de MySql inf\u00e9rieures …<\/p>\n","protected":false},"author":1,"featured_media":1547,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37,5,39],"tags":[24],"class_list":["post-175","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mariadb","category-mysql","category-tutoriels","tag-moteurs-mysql"],"yoast_head":"\nLes diff\u00e9rents moteurs de stockage MySql - Tutoriels et Cours<\/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:\/\/bocciolesi.fr\/tutoriels-et-cours\/les-differents-moteurs-de-stockage-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Les diff\u00e9rents moteurs de stockage MySql - Tutoriels et Cours\" \/>\n<meta property=\"og:description\" content=\"I\u25ba Nous allons voir les diff\u00e9rents moteurs de stockage Mysql : MyIsam : MyIsam \u00e9tait le moteur de stockage par d\u00e9faut pour toute sles versions de MySql inf\u00e9rieures ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/les-differents-moteurs-de-stockage-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels et Cours\" \/>\n<meta property=\"article:published_time\" content=\"2012-06-12T08:46:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-02-24T13:25:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"424\" \/>\n\t<meta property=\"og:image:height\" content=\"283\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Michel BOCCIOLESI\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Michel BOCCIOLESI\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/les-differents-moteurs-de-stockage-mysql\/\",\"url\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/les-differents-moteurs-de-stockage-mysql\/\",\"name\":\"Les diff\u00e9rents moteurs de stockage MySql - Tutoriels et Cours\",\"isPartOf\":{\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/les-differents-moteurs-de-stockage-mysql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/les-differents-moteurs-de-stockage-mysql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg\",\"datePublished\":\"2012-06-12T08:46:14+00:00\",\"dateModified\":\"2017-02-24T13:25:52+00:00\",\"author\":{\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#\/schema\/person\/6bdfe0a1263b803645c69e3d5748dabe\"},\"breadcrumb\":{\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/les-differents-moteurs-de-stockage-mysql\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/les-differents-moteurs-de-stockage-mysql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/les-differents-moteurs-de-stockage-mysql\/#primaryimage\",\"url\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg\",\"contentUrl\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg\",\"width\":424,\"height\":283,\"caption\":\"Cours et tutoriels MySQL et Maria DB\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/les-differents-moteurs-de-stockage-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Les diff\u00e9rents moteurs de stockage MySql\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#website\",\"url\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/\",\"name\":\"Tutoriels et Cours\",\"description\":\"Michel Bocciolesi | Formateur Consultant en Informatique\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#\/schema\/person\/6bdfe0a1263b803645c69e3d5748dabe\",\"name\":\"Michel BOCCIOLESI\",\"description\":\"Michel Bocciolesi est consultant et formateur sp\u00e9cialis\u00e9 en Informatique.\",\"sameAs\":[\"https:\/\/www.mb-creation-web.fr\"],\"url\":\"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/author\/michel\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Les diff\u00e9rents moteurs de stockage MySql - Tutoriels et Cours","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:\/\/bocciolesi.fr\/tutoriels-et-cours\/les-differents-moteurs-de-stockage-mysql\/","og_locale":"fr_FR","og_type":"article","og_title":"Les diff\u00e9rents moteurs de stockage MySql - Tutoriels et Cours","og_description":"I\u25ba Nous allons voir les diff\u00e9rents moteurs de stockage Mysql : MyIsam : MyIsam \u00e9tait le moteur de stockage par d\u00e9faut pour toute sles versions de MySql inf\u00e9rieures ...","og_url":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/les-differents-moteurs-de-stockage-mysql\/","og_site_name":"Tutoriels et Cours","article_published_time":"2012-06-12T08:46:14+00:00","article_modified_time":"2017-02-24T13:25:52+00:00","og_image":[{"width":424,"height":283,"url":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg","type":"image\/jpeg"}],"author":"Michel BOCCIOLESI","twitter_misc":{"\u00c9crit par":"Michel BOCCIOLESI","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/les-differents-moteurs-de-stockage-mysql\/","url":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/les-differents-moteurs-de-stockage-mysql\/","name":"Les diff\u00e9rents moteurs de stockage MySql - Tutoriels et Cours","isPartOf":{"@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/les-differents-moteurs-de-stockage-mysql\/#primaryimage"},"image":{"@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/les-differents-moteurs-de-stockage-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg","datePublished":"2012-06-12T08:46:14+00:00","dateModified":"2017-02-24T13:25:52+00:00","author":{"@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#\/schema\/person\/6bdfe0a1263b803645c69e3d5748dabe"},"breadcrumb":{"@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/les-differents-moteurs-de-stockage-mysql\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bocciolesi.fr\/tutoriels-et-cours\/les-differents-moteurs-de-stockage-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/les-differents-moteurs-de-stockage-mysql\/#primaryimage","url":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg","contentUrl":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-content\/uploads\/2013\/08\/bases-de-donnees.jpg","width":424,"height":283,"caption":"Cours et tutoriels MySQL et Maria DB"},{"@type":"BreadcrumbList","@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/les-differents-moteurs-de-stockage-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/"},{"@type":"ListItem","position":2,"name":"Les diff\u00e9rents moteurs de stockage MySql"}]},{"@type":"WebSite","@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#website","url":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/","name":"Tutoriels et Cours","description":"Michel Bocciolesi | Formateur Consultant en Informatique","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/#\/schema\/person\/6bdfe0a1263b803645c69e3d5748dabe","name":"Michel BOCCIOLESI","description":"Michel Bocciolesi est consultant et formateur sp\u00e9cialis\u00e9 en Informatique.","sameAs":["https:\/\/www.mb-creation-web.fr"],"url":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/author\/michel\/"}]}},"_links":{"self":[{"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/posts\/175","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/comments?post=175"}],"version-history":[{"count":15,"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/posts\/175\/revisions"}],"predecessor-version":[{"id":1636,"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/posts\/175\/revisions\/1636"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/media\/1547"}],"wp:attachment":[{"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/media?parent=175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/categories?post=175"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bocciolesi.fr\/tutoriels-et-cours\/wp-json\/wp\/v2\/tags?post=175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}