mysql high load

[crea]

Hello,

I transfered two sites to new server which is use directadmin panel
My local time is 10:30,that is to say sites are not get too hit in this time
Databases are not big but it use lots of cpu

I put a screen of usage, i think there is problem how can fix it




System info

Sun x2100
Processor Name AMD Opteron(tm) Processor 146
Vendor ID AuthenticAMD
Processor Speed (MHz) 2000.000
Total Memory 1034832 kB
Free Memory 463548 kB
Total Swap Memory 2031608 kB
Free Swap Memory 2031608 kB
System Uptime 0 Days, 8 Hours and 16 Minutes
Apache 1.3.37 Running
DirectAdmin 1.29.2 Running
Exim 4.61 Running
MySQL 4.1.22 Running
Named 9.3.2 Running
ProFTPd 1.3.0a Running
sshd Running
vm-Pop3d 1.1.7f-DA-2 Running

 

[jackc]

enable slow queries logging in my.cnf

log-slow-queries=/var/log/mysql-slow.log
long_query_time=10

you will see which mysql query cause this problem.

 

[crea]

enable slow queries logging in my.cnf

log-slow-queries=/var/log/mysql-slow.log
long_query_time=10

you will see which mysql query cause this problem.

hi

i enable slow queries now but how can i look which queries cause this problem

 

[smtalk]

tail -n [I]number_of_lines[/I] /var/log/mysql-slow.log

 

[digi]

enable slow queries logging in my.cnf

log-slow-queries=/var/log/mysql-slow.log
long_query_time=10

you will see which mysql query cause this problem.

when I enable this mysqld-error.log says the file won't exist, even when I make the file manualy.
Whit's mistake do I make??