On Wed, Apr 21, 2010 at 11:14 AM, shamu...@gmail.com <shamu...@gmail.com> wrote: > This is my current my.cnf setttings. Could anyone take a quick peek and tell > me if I set anything awfully wrong?
If your tables are MyISAM (not InnoDB), then 128MB is much too small for your key_buffer. You should look at the sample my.cnf files that come in the mysql documentation. Those will give you a better starting point. And to answer your original question, in general, RAM is more useful than anything else for a database. Whatever is using your CPU might be work that could be pushed off to your web layer, but the data access can't be. - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org