+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: MySQL storage engines (/showthread.php?tid=26404)
MySQL storage engines - El Forum - 01-12-2010
[eluser]frist44[/eluser]
I'm creating an application that will have multi-users and ideally, a lot of traffic. I don't have great experience with MySQL, mostly SQL server. I've noticed the benefits of the InnoDB storage engine of transaction-safe and row-level locking. There was also some mention of better integrity upon failures.
Does anyone have any opinion about InnoDB vs. MyISAM? Are the benefits of InnoDB worth it? Is InnoDB slower? If so, enough to warrant not using the additional benefits?
Thanks!
MySQL storage engines - El Forum - 01-13-2010
[eluser]bretticus[/eluser]
From google search...
Is your table is going to be inserted, deleted, and updated much much more than it is going to be selected? InnoDB
If you need full-text search MyISAM
If you prefer/require relational database design InnoDB
Is disk-space or ram an issue? MyISAM
In Doubt? MyISAM
MySQL storage engines - El Forum - 01-13-2010
[eluser]n0xie[/eluser]
To add to bretticus list
MySQL storage engines - El Forum - 01-13-2010
[eluser]frist44[/eluser]
yeah i found all those articles too. I was more hoping someone could provide a first-hand account of their experience with the decision and opinions of the outcome.