{"id":219,"date":"2012-11-28T15:42:51","date_gmt":"2012-11-28T20:42:51","guid":{"rendered":"https:\/\/jeremystein.com\/journal\/?p=219"},"modified":"2016-01-11T11:03:55","modified_gmt":"2016-01-11T16:03:55","slug":"innodb-versus-myisam-no-comparison","status":"publish","type":"post","link":"https:\/\/jeremystein.com\/journal\/innodb-versus-myisam-no-comparison\/","title":{"rendered":"InnoDB versus MyISAM: no comparison"},"content":{"rendered":"<p>There was a question on <a href=\"http:\/\/dba.stackexchange.com\/\">DBA.SE<\/a> about <a href=\"http:\/\/dba.stackexchange.com\/questions\/1\/what-are-the-main-differences-between-innodb-and-myisam\">InnoDB versus MyISAM<\/a>.  For some perspective, I took a screen capture of the page (on the left) and demonstrated what it would look like if this was TimepieceBuyers.SE (on the right):<\/p>\n<p><a href=\"https:\/\/jeremystein.com\/journal\/wp-content\/uploads\/2012\/11\/comparison.png\">(click to view)<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/jeremystein.com\/journal\/wp-content\/uploads\/2012\/11\/comparison-300x172.png\" width=\"300\" height=\"172\" \/><\/a><\/p>\n<p>Reading the answers on that page, I feel like I&#8217;m the straight man in some kind of Monty Python skit.  I asked for a timepiece and John Cleese is trying to sell me a bracelet:<\/p>\n<blockquote><p><strong>Cleese:<\/strong> Now this is a fine model, sir.  It&#8217;s durable, fashionable, and fits nicely on your wrist.<\/p>\n<p><strong>Me:<\/strong> My, that is a nice timepiece.  Now, how do I tell the time?<\/p>\n<p><strong>Cleese:<\/strong> You find the nearest clock and look at it.  This goes well with your jacket.  I think you&#8217;ll be quite happy with it.<\/p>\n<p><strong>Me:<\/strong> But wait, this doesn&#8217;t tell time?  I need a timepiece!<\/p>\n<p><strong>Cleese:<\/strong> Time display is a feature on some of our models, but this is much lighter and more versatile.  Would you like me to wrap it for you?<\/p><\/blockquote>\n<p>Why do you need a database engine?  Referential integrity and transaction support.  There are other niceties, but that&#8217;s the core of what I learned in DB Theory 101.  MyISAM is a file system that understands SQL.  There&#8217;s no comparison.  If you want a database engine with MySQL, use InnoDB.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There was a question on DBA.SE about InnoDB versus MyISAM. For some perspective, I took a screen capture of the page (on the left) and demonstrated what it would look like if this was TimepieceBuyers.SE (on the right): (click to view) Reading the answers on that page, I feel like I&#8217;m the straight man in [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-219","post","type-post","status-publish","format-standard","hentry","category-geek"],"_links":{"self":[{"href":"https:\/\/jeremystein.com\/journal\/wp-json\/wp\/v2\/posts\/219","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jeremystein.com\/journal\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jeremystein.com\/journal\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jeremystein.com\/journal\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jeremystein.com\/journal\/wp-json\/wp\/v2\/comments?post=219"}],"version-history":[{"count":9,"href":"https:\/\/jeremystein.com\/journal\/wp-json\/wp\/v2\/posts\/219\/revisions"}],"predecessor-version":[{"id":370,"href":"https:\/\/jeremystein.com\/journal\/wp-json\/wp\/v2\/posts\/219\/revisions\/370"}],"wp:attachment":[{"href":"https:\/\/jeremystein.com\/journal\/wp-json\/wp\/v2\/media?parent=219"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jeremystein.com\/journal\/wp-json\/wp\/v2\/categories?post=219"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jeremystein.com\/journal\/wp-json\/wp\/v2\/tags?post=219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}