From: Perrin Harkins (perrinelem.com)
Date: Wed Apr 21 2010 - 10:26:17 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On Wed, Apr 21, 2010 at 11:14 AM, shamubrogmail.com <shamubrogmail.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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]