Drupal and Wordpress do it for historical purposes, and also because most cheap hosting providers (aka $10 per month) only offer MyISAM. You can configure these open source products to use InnoDB if you have your own environment. Mediawiki for example gives you a choice at install and other products will follow suit in time. FYI - Drupal for example can now by Mongo, not MySQL as well.
If your reason is to stick with MyISAM is based on two popular open source LAMP products, that a poor and unwise reason. Ronald On Wed, Jan 5, 2011 at 3:37 PM, David Mintz <[email protected]> wrote: > > > On Wed, Jan 5, 2011 at 2:58 PM, Ronald Bradford <[email protected] > > wrote: > >> InnoDB can even perform better then MyISAM in high read environment if you >> have a good ratio of data in memory (i.e. innodb_buffer_pool_size). >> >> <snip> >> >> >> On Wed, Jan 5, 2011 at 2:48 PM, Hans Zaunere <[email protected]> wrote: >> >>> > If you have 20 data tables with a lot of relationships among them, do >>> > you think that is reason enough to choose InnoDB -- with its support >>> for >>> > transactions and foreign keys -- over MyIsam? >>> >>> If you need transactions and foreign keys, then yes. >>> >>> > I'm working on an app and taking great pains to preserve integrity at >>> > the application level and coming to realize that it's even harder than >>> I >>> >>> Don't - it's not really possible, and if you truly need that type of >>> thing, >>> it has to be done in the database anyway. >>> >> <snip> > > > Oh. Er, um, apology for posting withdrawn. Guess I'll change my mind again, > independent thinker that I am. Or call it flexible, open-minded... anyway: > one ad hominem line of reasoning that has influenced me is that giants like > Drupal and Wordpress seem to favor myisam and if it's good enough for > them... Why do you suppose they go for myisam? Performance performance > performance? > > -- > David Mintz > http://davidmintz.org/ > It ain't over: > http://www.healthcare-now.org/ > > > > _______________________________________________ > New York PHP Community MySQL SIG > http://lists.nyphp.org/mailman/listinfo/mysql > > NYPHPCon 2006 Presentations Online > http://www.nyphpcon.com > > Show Your Participation in New York PHP > http://www.nyphp.org/show_participation.php >
_______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
