mysql eats all the CPU power

Hi there, I am having serious problems with a mysql 4.0.18 production server. Mysql takes away sometimes almost 100% of the cpu. The system works fine for days, but then suddenly load average climbes up and up and up till about 17. This is wat top says: top - 12:06:47 up 9:50, 2 users, load

Mysql eats all the cpu power

Hi there, I am having serious problems with a mysql 4.0.18 production server. Mysql takes away sometimes almost 100% of the cpu. The system works fine for days, but then suddenly load average climbes up and up and up till about 17. This is wat top says: top - 12:06:47 up 9:50, 2 users,