{"id":4824,"date":"2021-08-17T04:09:06","date_gmt":"2021-08-17T04:09:06","guid":{"rendered":"https:\/\/studysection.com\/blog\/?p=4824"},"modified":"2021-08-17T04:42:52","modified_gmt":"2021-08-17T04:42:52","slug":"database-engines-in-mysql","status":"publish","type":"post","link":"https:\/\/studysection.com\/blog\/database-engines-in-mysql\/","title":{"rendered":"DataBase Engines In MySQL"},"content":{"rendered":"<p>Storage engines are components of MySQL that manage many SQL operations and Queries.<br \/>\nBy Default <strong>InnoDB<\/strong> is the most generally used storage engine.<\/p>\n<p>To determine which storage engines are supported by your server, use the SHOW ENGINES statement as shown below.<br \/>\n<img decoding=\"async\" src=\"https:\/\/studysection.com\/blog\/wp-content\/uploads\/2021\/08\/cmd.png\" alt=\"MySQL\"\/><\/p>\n<p><strong>These are the type of database engines:<\/strong><\/p>\n<ol>\n<li>CSV<\/li>\n<li>MRG_MyISAM<\/li>\n<li>MEMORY<\/li>\n<li>Aria<\/li>\n<li>MyISAM<\/li>\n<li>SEQUENCE<\/li>\n<li>InnoDB<\/li>\n<li>PERFORMANCE_SCHEMA<\/li>\n<\/ol>\n<p><code>MariaDB [(none)]> SHOW ENGINES\\G;<\/code><\/p>\n<ul>\n<li><strong>CSV:<\/strong> In this storage engine, Data is stored in Comma Separated Value Format in a Text File.<br \/>\n<code>Info from MySQL :<br \/>\n******************************************************<br \/>\nEngine: CSV<br \/>\nSupport: YES<br \/>\nTransactions: NO<br \/>\nXA: NO<br \/>\nSavepoints: NO<br \/>\n******************************************************<\/code>\n<\/li>\n<li><strong>MERGE (MRG_MyISAM):<\/strong> This engine combines one or more MyISAM tables to be treated as a single table. It can handle non-transactional tables by default.<br \/>\n<code>Info from MySQL :<br \/>\n******************************************************<br \/>\nEngine: MRG_MyISAM<br \/>\nSupport: YES<br \/>\nTransactions: NO<br \/>\nXA: NO<br \/>\nSavepoints: NO<br \/>\n******************************************************<\/code>\n<\/li>\n<li><strong>MEMORY:<\/strong> It provides in-memory tables. It is formerly known as HEAP. This storage engine stores data in RAM, So that the data can be accessed faster, as compared to storing data on disk. This is useful for quick looks up of reference and other identifying data. It is a hash-based system.<br \/>\n<code>Info from MySQL :<br \/>\n******************************************************<br \/>\nEngine: MEMORY<br \/>\nSupport: YES<br \/>\nTransactions: NO<br \/>\nXA: NO<br \/>\nSavepoints: NO<br \/>\n******************************************************<\/code>\n<\/li>\n<li><strong>ARIA:<\/strong> Aria is a storage engine for MariaDB and MySQL.It is also known as the relational <a href=\"https:\/\/studysection.com\/blog\/sqlite-database-in-react-native-android\/\">database<\/a> management system. The main goal of this system is to make a Crash-Safe system. It is used for internal temporary tables in MariaDB. Aria is not shipped with MySQL.<br \/>\n<code>Info from MySQL :<br \/>\n******************************************************<br \/>\nEngine: Aria<br \/>\nSupport: YES<br \/>\nTransactions: NO<br \/>\nXA: NO<br \/>\nSavepoints: NO<br \/>\n******************************************************<\/code>\n<\/li>\n<li><strong>MyISAM:<\/strong> This storage engine, manages non-transactional tables, provides high-speed storage and retrieval, supports full-text searching.It is a Non-transactional engine with good performance and a small data footprint<br \/>\n<code>Info from MySQL :<br \/>\n******************************************************<br \/>\nEngine: MyISAM<br \/>\nSupport: YES<br \/>\nTransactions: NO<br \/>\nXA: NO<br \/>\nSavepoints: NO<br \/>\n******************************************************<\/code>\n<\/li>\n<li><strong>SEQUENCE:<\/strong> In this Storage engine records are created in ascending or descending sequence of numbers, with a given starting value, ending value, and increment.<br \/>\n<code>Info from MySQL :<br \/>\n******************************************************<br \/>\nEngine: SEQUENCE<br \/>\nSupport: YES<br \/>\nTransactions: YES<br \/>\nXA: NO<br \/>\nSavepoints: YES<br \/>\n******************************************************<\/code>\n<\/li>\n<li><strong>InnoDB:<\/strong> This is the default, mostly used storage engine which is used for MySQL 5.5 or higher. It supports FOREIGN KEY referential-integrity constraints, commit, rollback, and crash recovery capabilities to protect data. Apart from that it also supports row-level locking. It stores data in clustered indexes which reduces I\/O for queries based on primary keys so that the Overall performance of this database is very good.<br \/>\n<code>Info from MySQL :<br \/>\n******************************************************<br \/>\nEngine: InnoDB<br \/>\nSupport: DEFAULT<br \/>\nTransactions: YES<br \/>\nXA: YES<br \/>\nSavepoints: YES<br \/>\n******************************************************<\/code><\/li>\n<li><strong>PERFORMANCE_SCHEMA:<\/strong> It provides a way to examine the internal execution of the server at runtime. It primarily focuses on performance Data. This differs from INFORMATION_SCHEMA, which serves for inspection of metadata.<br \/>\n<code>Info from MySQL :<br \/>\n******************************************************<br \/>\nEngine: PERFORMANCE_SCHEMA<br \/>\nSupport: YES<br \/>\nTransactions: NO<br \/>\nXA: NO<br \/>\nSavepoints: NO<br \/>\n******************************************************<\/code><\/li>\n<\/ul>\n<p><small><em>Get certification for your knowledge in the fundamentals of Computer functioning by clearing the <a href=\"https:\/\/www.studysection.com\/computer-applications-diploma-advanced\">Computer Certification Exam<\/a> conducted by StudySection. After going through this Computer Certification exam, you will be able to evaluate your basic knowledge of computers.<\/em><\/small><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Storage engines are components of MySQL that manage many SQL operations and Queries. By Default InnoDB is the most generally<\/p>\n","protected":false},"author":1,"featured_media":4826,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[149,507],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>DataBase Engines Used In MySQL - StudySection Blog<\/title>\n<meta name=\"description\" content=\"Storage engines are components of MySQL that manage many operations and Queries. By Default InnoDB is the most generally used storage engine.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/studysection.com\/blog\/database-engines-in-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DataBase Engines Used In MySQL - StudySection Blog\" \/>\n<meta property=\"og:description\" content=\"Storage engines are components of MySQL that manage many operations and Queries. By Default InnoDB is the most generally used storage engine.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/studysection.com\/blog\/database-engines-in-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog Posts on famous people, innovations and educational topics\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/studysection\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-17T04:09:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-17T04:42:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/studysection.com\/blog\/wp-content\/uploads\/2021\/08\/MySQL.png\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin-studysection-blog\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@studysection\" \/>\n<meta name=\"twitter:site\" content=\"@studysection\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin-studysection-blog\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\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\":\"Article\",\"@id\":\"https:\/\/studysection.com\/blog\/database-engines-in-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/studysection.com\/blog\/database-engines-in-mysql\/\"},\"author\":{\"name\":\"admin-studysection-blog\",\"@id\":\"https:\/\/studysection.com\/blog\/#\/schema\/person\/db367e2c29a12d1808fb1979edb3d402\"},\"headline\":\"DataBase Engines In MySQL\",\"datePublished\":\"2021-08-17T04:09:06+00:00\",\"dateModified\":\"2021-08-17T04:42:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/studysection.com\/blog\/database-engines-in-mysql\/\"},\"wordCount\":391,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/studysection.com\/blog\/#organization\"},\"keywords\":[\"database\",\"MySQL\"],\"articleSection\":[\"Learn and Grow\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/studysection.com\/blog\/database-engines-in-mysql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/studysection.com\/blog\/database-engines-in-mysql\/\",\"url\":\"https:\/\/studysection.com\/blog\/database-engines-in-mysql\/\",\"name\":\"DataBase Engines Used In MySQL - StudySection Blog\",\"isPartOf\":{\"@id\":\"https:\/\/studysection.com\/blog\/#website\"},\"datePublished\":\"2021-08-17T04:09:06+00:00\",\"dateModified\":\"2021-08-17T04:42:52+00:00\",\"description\":\"Storage engines are components of MySQL that manage many operations and Queries. By Default InnoDB is the most generally used storage engine.\",\"breadcrumb\":{\"@id\":\"https:\/\/studysection.com\/blog\/database-engines-in-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/studysection.com\/blog\/database-engines-in-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/studysection.com\/blog\/database-engines-in-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/studysection.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DataBase Engines In MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/studysection.com\/blog\/#website\",\"url\":\"https:\/\/studysection.com\/blog\/\",\"name\":\"Blog Posts on famous people, innovations and educational topics\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/studysection.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/studysection.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/studysection.com\/blog\/#organization\",\"name\":\"StudySection\",\"url\":\"https:\/\/studysection.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/studysection.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/studysection.com\/blog\/wp-content\/uploads\/2021\/10\/studySection-logo.png\",\"contentUrl\":\"https:\/\/studysection.com\/blog\/wp-content\/uploads\/2021\/10\/studySection-logo.png\",\"width\":920,\"height\":440,\"caption\":\"StudySection\"},\"image\":{\"@id\":\"https:\/\/studysection.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/studysection\",\"https:\/\/twitter.com\/studysection\",\"https:\/\/www.instagram.com\/study.section\/\",\"https:\/\/www.linkedin.com\/company\/studysection\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/studysection.com\/blog\/#\/schema\/person\/db367e2c29a12d1808fb1979edb3d402\",\"name\":\"admin-studysection-blog\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/studysection.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/054ac87a6874df1932004239cd8eab36?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/054ac87a6874df1932004239cd8eab36?s=96&d=mm&r=g\",\"caption\":\"admin-studysection-blog\"},\"url\":\"https:\/\/studysection.com\/blog\/author\/admin-studysection-blog\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DataBase Engines Used In MySQL - StudySection Blog","description":"Storage engines are components of MySQL that manage many operations and Queries. By Default InnoDB is the most generally used storage engine.","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:\/\/studysection.com\/blog\/database-engines-in-mysql\/","og_locale":"en_US","og_type":"article","og_title":"DataBase Engines Used In MySQL - StudySection Blog","og_description":"Storage engines are components of MySQL that manage many operations and Queries. By Default InnoDB is the most generally used storage engine.","og_url":"https:\/\/studysection.com\/blog\/database-engines-in-mysql\/","og_site_name":"Blog Posts on famous people, innovations and educational topics","article_publisher":"https:\/\/www.facebook.com\/studysection","article_published_time":"2021-08-17T04:09:06+00:00","article_modified_time":"2021-08-17T04:42:52+00:00","og_image":[{"width":300,"height":200,"url":"https:\/\/studysection.com\/blog\/wp-content\/uploads\/2021\/08\/MySQL.png","type":"image\/png"}],"author":"admin-studysection-blog","twitter_card":"summary_large_image","twitter_creator":"@studysection","twitter_site":"@studysection","twitter_misc":{"Written by":"admin-studysection-blog","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/studysection.com\/blog\/database-engines-in-mysql\/#article","isPartOf":{"@id":"https:\/\/studysection.com\/blog\/database-engines-in-mysql\/"},"author":{"name":"admin-studysection-blog","@id":"https:\/\/studysection.com\/blog\/#\/schema\/person\/db367e2c29a12d1808fb1979edb3d402"},"headline":"DataBase Engines In MySQL","datePublished":"2021-08-17T04:09:06+00:00","dateModified":"2021-08-17T04:42:52+00:00","mainEntityOfPage":{"@id":"https:\/\/studysection.com\/blog\/database-engines-in-mysql\/"},"wordCount":391,"commentCount":0,"publisher":{"@id":"https:\/\/studysection.com\/blog\/#organization"},"keywords":["database","MySQL"],"articleSection":["Learn and Grow"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/studysection.com\/blog\/database-engines-in-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/studysection.com\/blog\/database-engines-in-mysql\/","url":"https:\/\/studysection.com\/blog\/database-engines-in-mysql\/","name":"DataBase Engines Used In MySQL - StudySection Blog","isPartOf":{"@id":"https:\/\/studysection.com\/blog\/#website"},"datePublished":"2021-08-17T04:09:06+00:00","dateModified":"2021-08-17T04:42:52+00:00","description":"Storage engines are components of MySQL that manage many operations and Queries. By Default InnoDB is the most generally used storage engine.","breadcrumb":{"@id":"https:\/\/studysection.com\/blog\/database-engines-in-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/studysection.com\/blog\/database-engines-in-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/studysection.com\/blog\/database-engines-in-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/studysection.com\/blog\/"},{"@type":"ListItem","position":2,"name":"DataBase Engines In MySQL"}]},{"@type":"WebSite","@id":"https:\/\/studysection.com\/blog\/#website","url":"https:\/\/studysection.com\/blog\/","name":"Blog Posts on famous people, innovations and educational topics","description":"","publisher":{"@id":"https:\/\/studysection.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/studysection.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/studysection.com\/blog\/#organization","name":"StudySection","url":"https:\/\/studysection.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/studysection.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/studysection.com\/blog\/wp-content\/uploads\/2021\/10\/studySection-logo.png","contentUrl":"https:\/\/studysection.com\/blog\/wp-content\/uploads\/2021\/10\/studySection-logo.png","width":920,"height":440,"caption":"StudySection"},"image":{"@id":"https:\/\/studysection.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/studysection","https:\/\/twitter.com\/studysection","https:\/\/www.instagram.com\/study.section\/","https:\/\/www.linkedin.com\/company\/studysection"]},{"@type":"Person","@id":"https:\/\/studysection.com\/blog\/#\/schema\/person\/db367e2c29a12d1808fb1979edb3d402","name":"admin-studysection-blog","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/studysection.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/054ac87a6874df1932004239cd8eab36?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/054ac87a6874df1932004239cd8eab36?s=96&d=mm&r=g","caption":"admin-studysection-blog"},"url":"https:\/\/studysection.com\/blog\/author\/admin-studysection-blog\/"}]}},"views":553,"_links":{"self":[{"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/posts\/4824"}],"collection":[{"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/comments?post=4824"}],"version-history":[{"count":5,"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/posts\/4824\/revisions"}],"predecessor-version":[{"id":4831,"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/posts\/4824\/revisions\/4831"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/media\/4826"}],"wp:attachment":[{"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/media?parent=4824"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/categories?post=4824"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/tags?post=4824"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}