Slow Queries
My MySQL-Server seems to be getting very many slow-queries at some points. What could be causing this and how can I solve it?
The slow-query slow is always empty though. I am using /root/slowlog -> owned by mysql.mysql and chmod 777.
MySQL Log containing number of slow-queries:
http://www.fctwente.net/stats/mysql-status.txt
Server
Intel Pentium (4) 2.4ghz
1024mb memory
2x80gb hdd
Software
Red Hat Linux 9.0
PHP 4.3.6
MySQL 4.0.18
My.txt is /etc/my.cnf of course
