>> 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 a poorly designed client/server app was touching off this really >huge query (lots of rows and lots of columns across multiple tables) and >then disconnecting before the result could be returned. > >They fixed their app and the problem went away. Drove me nuts >troubleshooting it. > >Anyway. Make sure you don't have something similar going on.
Will check again next time it occurs, but I don't recall seeing any other processes running at the time via "mysqladmin -u root -p processlist" After reading terry's post, I did come across the following resource though; http://jeremy.zawodny.com/blog/archives/000203.html thanks Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
