MySQL load

[liteonit]

Some days ago, MySQL is using sometimes more then 50% load.
Same thing for the apache server.

I've been looking a whole day for the mysql logfile, but I couldn't find it.

Versions i'm using:
Apache 2.2.8
DirectAdmin 1.31.5
Exim 4.67
MySQL 5.0.51a
Named 9.3.3rc2
ProFTPd 1.3.1
sshd
vm-Pop3d 1.1.7f-DA-2


Does anyone know why MySQL doens't log.


I'm using the my.cnf for large databases (1-2GB ram)

My hardware:
SUN X2100
AMD Opteron 146
2GB DDR
2x 500GB RAID1


Anybody with some idea's for this weird situation?

 

[nobaloney]

MySQL doesn't log unless you tell it to; you can add a line to my.cnf to log slow connections.

Jeff

 

[sde]

You would use something like this in my.cnf like Jeff said:

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

then there are parsers out there which will read that log and report the problem queries clearly. here's one: http://www.retards.org/projects/mysql/