Main differences between INNODB and MYISAM

Good Morning to all…. 🙂
In MYSQL, the MyISAM and InnoDB are the most commonly used storage engine. Both these storage enginee have advantages and disadvantages depending on the specific application.

The main and important difference between InnoDB and MYISAM is : the MyISAM does not support the advanced transaction process, and InnoDB support advanced transaction process.

MyISAM does not support the advanced transaction process

MYISAM InnoDB
MyISAM does not support the advanced transaction process InnoDB support the advanced transaction process
It’s very easy to use InnoDB is very difficult to use
MyISAM can do only a table-level lock. InnoDB implements row-level.
FULLTEXT Search is supported. FULLTEXT Search indexes doesn’t support until v5.6.
The main mechanism used is the key cache. It only caches index pages from .MYI files. Implemented transactions, foreign keys and relationship constraints.
ACID( Automicity, Consistency, Isolation and Durability) properties is not supported. ACID Properties is supported.
Supported high level table compression. It has Buffer Pool to cache data and index pages.
To take backup of MYISAM table the mysqldump helps to this process. You can take backup of InnoDB tables using just a snapshot of the filesystem.
MyISAM data and indexes are separate. The index is compressed the memory usage on the corresponding increase a lot. InnoDB have index and data are closely tied but do not use compression because of it InnoDB is huge
MYISAM doesn’t support transaction processing and foreign keys InnoDB support transaction processing and foreign keys
MyISAM can set up join index and other fields together. In the part of index, the InnoDB table have AUTO_INCREMENT field.
MYISAM depends upon file system block cache for storing reads in rows and indexes. InnoDB does caching inside the enginee, merging the row caches along with the index caches.
Indexes are stored in one file and datas are stored in another file. Both data and indexes are stored in a single file
COUNT(*) performance is very fast. COUNT(*) performance is very slow
It requires less system resources It requires more system resources like RAM.
MYISAM is generally rapid due to its simple construction and hence cost less in terms of server sources. The InnoDB is generally slower than MYISAM.

If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

52 thoughts on “Main differences between INNODB and MYISAM

  1. lifme

    generic clomiphene walmart cheap clomid prices where to buy cheap clomiphene no prescription says: generic clomiphene online can i buy generic clomid price can i purchase generic clomid online cost of cheap clomiphene without insurance

  2. Jennifer Scott

    Bali Hotels Or Bali Villas Dear Reader,One says that traveling is not an exact science, to combine between their cultures, traditions, countries and different languages sometimes are not easy. Trust an expert, contact your repu [read more..]

  3. Daniel Perez

    You got to sell it Its important for both parties to know that when goods are sold, what are the price of the item and the timing of the payment. Its also good to know what are the stipulations if any that apply to the [read more..]

  4. David Walker

    What Are Bonds Bonds are completely different than stocks. Stock is a certificate thatt proves ownership of a piece of a business. A bond is a debt security. This means that a bond is like an I.O.U.. Bonds are purch [read more..]

  5. Joseph Thomas

    Abs are a huge deal You can take your pick from an abundance of abdominal exercise machines on the fitness market today. Who doesn't have a bright idea for some new and improved ab invention? It's kind of funny [read more..]

  6. Ryan Green

    Limousine Service Advice Limousines years ago were just a plain car that had been stretched. Thats it. Plain. Simple. Limousines have changed so much over the past years. They now come in all different shapes and sizes. A lim [read more..]

  7. Donna Mitchell

    What Do “They” Know Are you like me? I was always asking myself… what do successful people know that I don't?What are their secrets to success?What can they teach me?How is it that, some people seem to have the su [read more..]

  8. Emily Rivera

    Aromatherapy Certification When dealing with aromatherapy certification or diploma, it is somehow necessary to bear in mind that the aromatherapy certification in the is actually meaningless. It is meaningless in the sense th [read more..]

  9. Laura King

    True Credit Secrets Figuring out exactly how credit scores work is problematic. Like nuclear fission, learning Chinese and setting the clock on your DVD player, credit scoring is not something that most people can easily [read more..]

  10. Susan Adams

    Is ADD A Learning Disability Attention Deficit Disorder, in itself, is not a learning disability. The term learning disability typically refers to a perceptual disability, such as an auditory or visual processing disorder, like a [read more..]

  11. Carol Ramirez

    Panama City, Florida OverviewLocated along the United States Highway 98 in Bay County, Panama City, Florida is the biggest metropolis between Pensacola and Tallahassee. According to the 2000 census, its population had gro [read more..]

  12. Kathleen Lopez

    Calcium Ascorbate Calcium ascorbate is a well-known type of vitamin C which plays an important role in collagen formation, hormone synthesis, amino acid metabolism, and utilization of a lot of nutrients like iron and f [read more..]

  13. Barbara Jackson

    The Meaning of Friendship Even if your life is perfect and everything is running like clock work, one day you still may get into trouble or there will be a problem that you will not be able to solve yourself. What you do is ca [read more..]

  14. Susan Hernandez

    Words: Weak or Powerful Choosing your words and how you say them will have an impact on:how others perceive you as a leader of changehow persuasive and convincing your coaching ishow much your team understands what youre try [read more..]

  15. Situs Iklan Properti

    Tulisan Anda adalah contoh nyata dari keunggulan intelektual. Kedalaman analisis dan kelancaran bahasa yang Anda gunakan membuat artikel ini sangat berharga. Saya merasa lebih berpengetahuan setelah membaca ini. Terima kasih atas kontribusi luar biasa ini. Hormat kami, Pasang Iklan Properti Gratis

Leave a Reply

Your email address will not be published.