Mysql Conf File Help

[akintemel]

Hi
i want to know mysql conf file is ok because i mysqld use %100 cpu. first i give my hardware configuration .
Cpu : E5620 2.4 Ghz 4 Core
Ram : 8 Gb Total
Hdd : 1 tb scsi ( raid 5 )


and here is my mysql conf file ;


[mysqld]

basedir = /opt/zimbra/mysql
datadir = /opt/zimbra/db/data
socket = /opt/zimbra/db/mysql.sock
pid-file = /opt/zimbra/db/mysql.pid
bind-address = localhost
port = 7306
user = zimbra
tmpdir = /opt/zimbra/data/tmp

external-locking

log-slow-queries = /opt/zimbra/log/myslow.log
long-query-time = 1
log-long-format
log-queries-not-using-indexes

thread_cache_size = 110
max_connections = 110

# We do a lot of writes, query cache turns out to be not useful.
query_cache_type = 0

sort_buffer_size = 1048576
read_buffer_size = 1048576

# (Num mailbox groups * Num tables in each group) + padding
table_cache = 1200

innodb_buffer_pool_size = 3435973840
innodb_log_file_size = 104857600
innodb_log_buffer_size = 8388608
innodb_file_per_table

# Value is: 200 + max_connections + 2 * table_cache
innodb_open_files = 2710

innodb_max_dirty_pages_pct = 10
innodb_flush_method = O_DIRECT
innodb_flush_log_at_trx_commit = 0

[mysqld_safe]

err-log = /opt/zimbra/log/mysqld.log
pid-file = /opt/zimbra/db/mysql.pid



i have ~500 account and ~80 distrubiton list.

and here is my Top out :


top - 11:43:17 up 2:44, 1 user, load average: 1.67, 1.76, 1.75
Tasks: 182 total, 1 running, 181 sleeping, 0 stopped, 0 zombie
Cpu0 : 44.1%us, 0.0%sy, 0.0%ni, 55.9%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 32.3%us, 0.3%sy, 0.0%ni, 67.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 19.7%us, 0.3%sy, 0.0%ni, 74.9%id, 1.7%wa, 3.3%hi, 0.0%si, 0.0%st
Cpu3 : 12.6%us, 1.0%sy, 0.0%ni, 85.4%id, 0.0%wa, 0.7%hi, 0.3%si, 0.0%st
Mem: 8186084k total, 6605788k used, 1580296k free, 217588k buffers
Swap: 9438176k total, 0k used, 9438176k free, 2420812k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
4361 zimbra 15 0 4020m 964m 4732 S 99.5 12.1 156:52.09 mysqld
7546 zimbra 15 0 215m 101m 3784 S 9.3 1.3 0:00.88 amavisd
1918 root 15 0 5908 604 488 S 0.3 0.0 0:00.85 syslogd
2048 named 25 0 245m 7672 2072 S 0.3 0.1 0:10.08 named
6569 zimbra 18 0 3800m 1.7g 13m S 0.3 22.1 8:03.55 java
6779 zimbra 15 0 443m 303m 2504 S 0.3 3.8 0:54.18 clamd
1 root 18 0 10348 688 580 S 0.0 0.0 0:01.16 init
2 root RT -5 0 0 0 S 0.0 0.0 0:00.25 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/0
5 root RT -5 0 0 0 S 0.0 0.0 0:00.25 migration/1
6 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
7 root RT -5 0 0 0 S 0.0 0.0 0:00.00


wiht color red you see mysqld demaon is %100 use cpus ..

Thanks for your help.