yes mytop is very wicked it helps monitor the queries and gives you benchmarks
-----Original Message----- From: K Old [mailto:[EMAIL PROTECTED] Sent: Sunday, August 31, 2003 2:02 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: CPU Usage and MySQL... On Sat, 2003-08-30 at 23:18, [EMAIL PROTECTED] wrote: > Hello, > > I have a strange problem with my mysql server. The mysql process seems to be > using between 60 and 70 percent of the CPU at all times. Even when it is > seemingly idle (not active queries). I'm not sure what to look for to see what > it is doing other than truss'ing the process (I'm running it on Sparc Solaris > 9 Ultra III procs). I have included the status and variables out put just > incase something obvious pop's up there. Thanks alot! Hello, I ran across this tool the other day and it is awesome. Basically it is like the top utility for *nix, but it's for mysql. It basically gives you a live look into the database and what queries it's processing, etc in real time. Give it a try.... http://jeremy.zawodny.com/mysql/mytop/ Kevin -- K Old <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]