RE: mysqld shows high cpu usage over extended time, restart = normal

2003-07-09 Thread Dave [Hawk-Systems]
>> Is there a known issue (running on FreeBSD 4.8, MySQL 3.23.55 MyISAM)? >> Is there something I should check when next I notice the high CPU usage? >> > >I used to see the same kind of behavior a while back with a MySQL >installation I did for a client. It turned out that what was happening >was

RE: mysqld shows high cpu usage over extended time, restart = normal

2003-07-09 Thread Dave [Hawk-Systems]
>> load). Is there a known issue (running on FreeBSD 4.8, >> MySQL 3.23.55 MyISAM)? > >its been a known issue for quite a long time >use linuxthreaded version and it should work fine. > >although much of work has been done on threads implementation, >there are still such problems with mysql. it ha

mysqld shows high cpu usage over extended time, restart = normal

2003-07-09 Thread Dave [Hawk-Systems]
Occasionally in checking one of the servers, I noticed that mysql shows 85% + of cpu usage essentially leaving the server at 0% idle. After monitoring it for a few hours, the status did not change. After a stop and start of mysql, things progessed normally. Checking back a few days later I notic