MySQLd hogging CPU

[rbreck]

[SOLVED]

Mysqld is hogging the CPU on one of my new NE installs (fluctuates between 40-80% and keeps the machine's overall load average quite high).

We just rolled this server out and there's only one active mailbox on it. It's a bit of a doozy, a client who had a 13GB PST that had to be imported. Not only does he have a lot of mail, but he's a OCD sorted, so there are 2178 subfolders in his inbox. Most have only 2-3 emails in them.

His account is currently be accessed by his Laptop (IMAP), iPAD (as an exchange account) and Blackberry (with ZBC).

I'm assuming that the incredulous number of folders he has and the fact that he's hitting them 3x over might have something to do with the server running hot?

If so, any tuning suggestions for someone with so many folders? We're hoping to get hundreds of more accounts on this server in the next few weeks, but I'm worried it's going to end up having to be dedicated to a single account :P

[rbreck]

I ended up tweaking /etc/my.cnf and got it all to calm down..

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
skip-locking
old_passwords=1
key_buffer = 384M
max_allowed_packet = 8M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache = 4
#thread_concurrency = 2
thread_concurrency = 8
query_cache_size = 128M
query_cache_limit = 4M
max_connections = 1500
log_slow_queries
long_query_time=1

init_connect='SET collation_connection = utf8_general_ci'
init_connect='SET NAMES utf8'
default-character-set=utf8
character-set-server = utf8
collation-server = utf8_general_ci



[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid