MySQL Engines: MyISAM vs. InnoDB | Tag1 Consulting

I am nobody's puppet.

Disclaimer: My blogs are not a reflection of my employer's opinions, but are my own, and often unfiltered. Also, some links on this site may be part of an Amazon Associates program, so by clicking on them you help me pay for my independence.

[[{"type":"media","view_mode":"media_preview","fid":"25","link_text":null,"attributes":{"alt":"Acquia Certified Developer","title":"I am an Acquia Certified Developer","height":147,"width":147,"style":"width: 60px; height: 60px;","class":"media-image media-element file-media-preview"}}]] [[{"type":"media","view_mode":"media_preview","fid":"15","link_text":null,"attributes":{"height":180,"width":180,"style":"width: 60px; height: 60px;","class":"media-image media-element file-media-preview"}}]] [[{"type":"media","view_mode":"media_original","fid":"13","link_text":null,"attributes":{"height":68,"width":310,"style":"width: 190px; height: 42px;","class":"media-image media-element file-media-original"}}]]

Thanks again, Steve. I hope
14 years 1 month ago
Hi - bit late responding here
14 years 1 month ago
Should have added...
14 years 2 months ago
Hi Ryan,
14 years 2 months ago
Ryan,
14 years 2 months ago
It is happening and you are
14 years 5 months ago
In close future I want to
14 years 8 months ago
the article has been
14 years 9 months ago
I think it's a great coup for
14 years 9 months ago
My hardware box acts as an
14 years 10 months ago

By rprice , 28 December 2011

Link

http://tag1consulting.com/MySQL_Engines_MyISAM_vs_InnoDB

In most cases, InnoDB is the correct choice for a Drupal site. It provides increased concurrency, enhanced performance and much more data integrity than MyISAM ever can. However, the pluggable nature of MySQL engines allows the user to "mix and match" table engines inside a single database. This allows us to consider tables whose workloads fit MyISAM more so than InnoDB. The main candidates for MyISAM in a mostly InnoDB-centric database are the search tables. A database layout with most tables being InnoDB (for performance and data security) and the search tables being MyISAM (for performance on that particular workload and acknowledging the fact that, if that data was corrupted, it could be easily rebuilt) is an excellent fit.