mysql 300% cpu usage :s

[Flexup]

hello

mysql use 150% 300% cpu charge.

my load average is ~3

it's normal ?

 

[scsi]

http://help.directadmin.com/item.php?id=352

 

[unihostbrasil]

You can also:

1) View the queries in realtime (as root):

$ watch -n1 mysqladmin proc stat

2) Use the STATUS tab options from phpMyAdmin (as root)

3) Log the slow queries (config options from /etc/my.cnf):

slow_query_log=1
slow_query_log_file=/var/log/mysqld.slow.log
long_query_time=10