MyISAM vs. InnoDB vs. others...?
On a very limited environment (slow CPU, little RAM, but a lot of disk space), what would be the advantages of using different storage engine than MyISAM assuming an optim开发者_如何学Cized php script (w/ using cache) daily performs a lot of read queries (SELECT) and almost no writes (m/b 5% - UPDATE queries)?
At what point does MySQL INNODB fine tuning become a requirement?
This was addressed in a post I made a while back
In the post I reference other tuning articles
Please read this in its entirety
精彩评论