mysql 300% cpu usage :s

Flexup

Verified User
Joined
Feb 26, 2012
Messages
40
hello

mysql use 150% 300% cpu charge.

my load average is ~3

it's normal ?
 
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
 
Back
Top