Welcome Guest, Not a member yet? Register   Sign In
MySQL storage engines
#1

[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!
#2

[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
#3

[eluser]n0xie[/eluser]
To add to bretticus list
#4

[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.




Theme © iAndrew 2016 - Forum software by © MyBB