Which is best for server load, Myisam or innob?

[DoctorX]

Hello,
Which type of database is best for less server load, Myisam or innob?
And is there a better type?

Thanks

DoctorX Reviewed by DoctorX on 20th Jul 2011. Which is best for server load, Myisam or innob? Hello, Which type of database is best for less server load, Myisam or innob? And is there a better type? Thanks Rating: 5

[bubawuba]

If you have alot of memory then InnoDB if you dont then MyISAM. For scalability, Innodb is the best way to go. It can handle large volumes of traffic.

[DoctorX]

Do you mean that InnoDB takes more ram but less CPU?

[bubawuba]

It depends on the site. Innodb uses more cpu the more traffic you get mostly because of the way it locks rows, but your site will be alot faster for your visitors with innodb. If your site is small i'd stick with myisam.

[DoctorX]

Ok, the picture is clear now.
thank you bubawuba