Monday, 17 June 2013

MySql Storage Engine Types


A storage engine is a software module that a database management system uses to create, read, update data from a database. There are two types of storage engines in MySQL. Transactional and non-transactional.

The default storage engine for MySQL prior to version 5.5 was MyISAM. For MySQL 5.5 and later, the default storage engine is InnoDB. Choosing the right storage engine is an important strategic decision, which will impact future development.


List of MySQL supported storage engines:


1.) MyISAM

2.) InnoDB

3.) Memory

4.) CSV

5.) Merge

6.) Archive

7.) Blackhole

8.) Federated

9.) Example



1.) MyISAM:- The default MySQL storage engine and the one that is used the most in Web, data warehousing, and other application environments.It is a fast storage engine. It does not support transactions. MyISAM provides table-level locking.

2.) InnoDB:- A transaction-safe (ACID compliant) storage engine for MySQL that has commit, rollback, and crash-recovery capabilities to protect user data. InnoDB row-level locking (without escalation to coarser granularity locks) and Oracle-style consistent nonlocking reads increase multi-user concurrency and performance. InnoDB stores user data in clustered indexes to reduce I/O for common queries based on primary keys. To maintain data integrity, InnoDB also supports FOREIGN KEY referential-integrity constraints.

3.) Memory:- Stores all data in RAM for extremely fast access in environments that require quick lookups of reference and other like data. This engine was formerly known as the HEAP engine.

4.) CSV:- The CSV storage engine stores data in text files using comma-separated values format. You can use the CSV engine to easily exchange data between other software and applications that can import and export in CSV format.

5.) Merge:- Merge operates on underlying MyISAM tables. Merge tables help manage large volumes of data more easily. It logically groups a series of identical MyISAM tables, and references them as one object. Good for data warehousing environments.

6.) Archive:- Archive storage engine is optimized for high speed inserting. It compresses data as it is inserted. It does not support transactions. It is ideal for storing, retrieving large amounts of seldom referenced historical, archived data.

7.) Blackhole:- The Blackhole storage engine accepts but does not store data. Retrievals always return an empty set. The functionality can be used in distributed database design where data is automatically replicated, but not stored locally. This storage engine can be used to perform performance tests or other testing.

8.) Federated:- Federated storage engine offers the ability to separate MySQL servers to create one logical database from many physical servers. Queries on the local server are automatically executed on the remote (federated) tables. No data is stored on the local tables. It is good for distributed environments.

9.) Example:- The Example storage engine is “stub” engine that does nothing. You can create tables with this engine, but no data can be stored in them or retrieved from them. The purpose of this engine is to serve as an example in the MySQL source code that illustrates how to begin writing new storage engines. As such, it is primarily of interest to developers.

73 comments:

  1. I can tell you how I spend my free time come here plummy online casino slot games I am here and have fun and take out the money and you are also lucky

    ReplyDelete
  2. Thanks for sharing is so amazing and helpful to us.
    Buy Hydrocodone online

    ReplyDelete
  3. eBook Promotion Packages
    Promote your ebooks through our kindle eBook Promotion and marketing Services. We will help you promote your eBook and help you with marketing it to your potential users.

    ReplyDelete

  4. Best Article buy Pain Pills online Excellent post. I appreciate this site. Stick with it! Because the admin of this web page is working, no doubt very quickly it will be well-known, due to its quality contents.This website was how do you say it? Relevant!! Finally, I’ve found something that helped me.
    Best Article buy Roxicodone online Excellent post
    buy Xanax online
    buy Oxycodone online

    Best Article buy Pain Medications online Excellent post. I appreciate this site. Stick with it! Because the admin of this web page is working, no doubt very quickly it will be well-known, due to its quality contents.This website was how do you say it? Relevant!! Finally, I’ve found something that helped me.

    buy Research Chemicals online

    buy Roxicodone online

    buy Cbd Isolate online

    ReplyDelete
  5. Onsite HIPAA Training with instructors is best if you would like to provide your employees with HIPAA training that is customized to your organizational need.

    ReplyDelete
  6. Roofing contractors in Calgary can be found on almost any corner these days. Since your home is likely the most expensive investment you’ve made and own, and you want to take care of it.

    ReplyDelete

  7. Click here Happy New Year 2k20 Offers grab Opportunity with 25% Off ALL Products

    Order Now>> Buy Online Medicine free Shipping in US TO US 3 To 4 days Delivery

    Buy Tramadol Online
    Buy Xanax Online
    Buy Ambien Online
    Buy hydrocodone online
    Buy Adderall Online
    Buy Phentermine Online
    Buy Valium Online

    ReplyDelete
  8. I am happy with your blog. You shared the information is really awesome and very useful. Great blog. Thanks for sharing. If you want discount on all of this medicines please visit - North Mart Pharmacy


    Here is our other medicines for buy online 24/7

    Buy tramadol online
    Buy Valium Online
    Buy Soma Online
    Buy ambien 10 mg
    Buy Adderall Online
    Buy Xanax Online

    ReplyDelete
  9. Mr Sanjay Baghela focus to reflects as the best leader of SEO in the world, and his dedication and expertise in SEO field make him enable as the owner of the best  BEST SEO Expert India. You can connect with him anytime and you can see his knowledge about SEO itself. Drop your request and dial his number now! best seo expert in india

    ReplyDelete
  10. With Sanjay Baghela, your business Website is in safe hands. He and his team are the best SEO Expert in India the leading digital marketing field.
    Best SEO Expert In India
    Best Seo Company in India

    ReplyDelete
  11. You have provided an nice article, Thank you very much for this one. And I hope this will be useful for many people.. and I am waiting for your next post keep on updating these kinds of knowledgeable things… If you want to buy online medicines please visit - Online Pain Pills

    And other medicines are also her plese check and buy 24/7

    Buy Adderall Online

    Buy Adderall XR online

    Buy Ambien Online

    Buy Codeine Online

    Buy Diazepam Online

    ReplyDelete
  12. Our online pharmacy that provides information about diseases and their symptoms ranging from physical to psychological and what kind of medicines can cure them, based on their dosage, the type of disease it is being taken for, the kind of person taking the drug, etc. When you buy a drug from our website, we provide you with a prescription so that you can take the drug properly.

    Buy Codeine Online
    Buy Hydrocodone Online
    Buy Methadone Online
    buy Ambien Online
    Ambien for Sale

    ReplyDelete

  13. We are Providing Generic Drugs Online at very cheapest price. When you buy a drug from our website, we provide you with a prescription so that you can take the drug properly.

    Buy Soma Online
    Buy Darvon Online
    Buy Vicodin Online

    ReplyDelete
  14. Our online pharmacy that provides information about diseases and their symptoms ranging from physical to psychological and what kind of medicines can cure them, based on their dosage, the type of disease it is being taken for, the kind of person taking the drug, etc. When you buy a drug from our website, we provide you with a prescription so that you can take the drug properly.

    Buy Tramadol Online
    Buy Soma Online
    Buy Xanax Online
    buy Ambien Online
    Ambien for Sale

    ReplyDelete
  15. thanks!
    Diazepam belongs to the “benzodiazepines” family of drugs and used for the following:
    Used for the treatment of anxiety
    Used for Alcohol withdrawal
    Also Used to relieve the patient from Muscle spasms
    Cure Seizures (these are abnormal electrical activities that occur inside the brain)
    Diazepam is also used as a sedative for conducting medical procedures.https://wayrightmeds.com/

    buy diazepam online
    Buy Subutex Online

    ReplyDelete
  16. Order without prescription, overnight delivery via FedEx at a discounted price in the United States. Top-quality Medicines

    Buy Adderall Online
    Buy Roxicodone Online
    Buy Hydrocodone Online

    ReplyDelete
  17. This is a great post. I like this topic. This site has lots of advantage. I found many interesting things from this site. It helps me in many ways. Thanks for posting this again

    buy cheap zopiclone tablets USA
    buy tramadol overnight USA
    buy Xanax overnight USA

    ReplyDelete
  18. Rite Aid USA
    * No Prescription Required (NO RX)
    * Buy Direct and Save Time with Cryptocurrency
    * Reshipment is offered if the package does not get to location or refunds
    * High-Quality Pharmacy Grade Medicines.
    * Best and Affordable prices

    Buy Hydrocodone Online
    Can i Buy Hydrocodone Online
    Buy Adderall Online
    Buy Alprazolam Online
    Buy Ambien Online
    Buy Ativan online
    Buy Carisoprodol Online
    Buy Codeine Online
    Buy Diazepam Online
    Buy Dilaudid Online
    Buy Fioricet online

    ReplyDelete
  19. Buy Generic medicines Online without prescription. Licensed Online Healthcare. ONLY HERE The Best QUALITY and LOW PRICES! High Quality Medications!

    Buy Percocet Online
    Buy Norco Online
    Buy Percocet Online

    Buy Anxiety Medicines Online

    Buy Xanax Online

    ReplyDelete
  20. One of the medications which are highly prescribed for weight loss by a health expert is Adipex and you can buy it online from wayrightmeds.com

    Buy Adipex 375mg Online
    Buy Phentermine 15mg Online
    Buy Phentermine 30mg Online

    ReplyDelete
  21. Gets 20%off on every buying Buy Tramadol 100MG Online
    Tramadol is taken as a pain medication by the patients suffering from mild to severe pain. This drug is also considered as a narcotic drug that helps in giving relief from pain. This tablet is also available in the immediate and extended-release form. However, it shall not be taken without taking proper consideration from a health expert.

    ReplyDelete
  22. Pretty nice post. I just stumbled upon your blog and wished to say that I have really enjoyed surfing around your blog posts.
    After all I will be subscribing to your rss feed and I hope you write again soon! tramadol online overnight usa

    ReplyDelete
  23. Buy Sleeping tablets to treat your sleeping disorders in quick and effective way. Now you can easily buy sleeping pills online without moving out of your home.

    buy sleeping tablets online uk

    buy sleeping pills uk

    best sleeping pills uk

    buy sleeping pills

    ReplyDelete
  24. You are just one step away to buy valium (Diazepam) 10mg online by a simple mouse click on tramadoldrugstore.com and get 100% satisfied medicine with expire date for more info call now on +1-3852640405 and visit here: https://www.tramadoldrugstore.com/valium-10mg

    ReplyDelete
  25. If you are suffering from anxiety disorder and looking to buy online Ativan (lorazepam) 2mg online at the best price then just click cureusnow.com and get 100% satisfied medicine with expire date for more details call on +1-660-236-1626 or visit here: https://www.cureusnow.com/product/ativan-2mg/

    ReplyDelete
  26. This comment has been removed by the author.

    ReplyDelete
  27. This comment has been removed by the author.

    ReplyDelete
  28. What a great content we have here buy painkillers online as we browse we also see this blog too and is pretty good buy Percocet online we also realize that blog are good for business we also bring buy vyvanse online best blog to visit

    ReplyDelete
  29. Valium comes under the generic name of Diazepam, it's belong to the same class of drugs known as Benzodiazepines. So before you buy valium 10mg online beware some website are fake order medicine genuine website like https://www.cureusnow.com/product/valium-10mg/

    ReplyDelete
  30. If you wish to consume tramadol to cure your pain, you need a doctor's prescription to get the same. Also, If you want to get buy tramadol100mg pills online without prescription then visit here: https://www.everydaydrugs.org/product/buy-tramadol-100mg-online/

    ReplyDelete
  31. Decide to Buy Cialis 40mg online for benefits. Cialis (tadalafil) increase increases blood flow to a certain area of the body and is used to treat erectile dysfunction (impotence).

    ReplyDelete
  32. Thanks for sharing such great information. It is really helpful to me. I always search to read quality content and finally I found this in your post. keep it up!

    ReplyDelete
  33. It’s difficult to find well-informed people on this topic, but you seem to know what you’re talking about! Thanks

    ReplyDelete
  34. Good blog! I love how it is easy on my eyes and the data are well written. I’m wondering how I might be notified when a new post has been made. I’ve subscribed to your RSS which must do the trick! Have a great day!

    ReplyDelete