PDA

View Full Version : MySQL Innodb or Myisam



VistaBoy
21-09-2009, 08:28 AM
Hello,

Iam to to sure on what to use for my storage engine. i found many sites where some people say its good and some do not so i am not to sure.

The site i am making will be very user used. so most likely have a lot of read and writing query's.

I need something fast-ish but #1 has to be stable and reliable.

So what one is the best.?
Innodb or Myisam

LMS16
21-09-2009, 08:30 AM
Myisam is pretty reliable, i use that.

VistaBoy
21-09-2009, 08:34 AM
Maybe but i did read some where that the innodb it has a better recovery rate if the system has a power failure or something. and it has row locking and not table locking and that could be a plus but not to sure.


(i think wordpress uses innodb now)

Want to hide these adverts? Register an account for free!