Today i found a blog on MySQL performance.
I manage many big MySQL databases, some are over 20 GB in size. But i have not yet done much MySQL optimizations. For me, it is good CPU and enough RAM will handle with out much problem.
Most MySQL optimizations are finding slow MySQL query and optimize the SQL query. If you are using standard programs like vbulletin, phpBB, SQL commands are already optimized for good performance and there is no much can be done on SQL side.
I have to go through these documentations to see if i can do some thing to improve the performance.