Re: CPU Usage and MySQL...
On Sun, Aug 31, 2003 at 12:02:20AM -0400, K Old wrote: 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. Glad you like it! Maybe I should add some testimonials to the mytop web site... :-) Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 31 days, processed 1,353,656,389 queries (497/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: CPU Usage and MySQL...
On Sun, Aug 31, 2003 at 07:14:12AM -0400, Albert wrote: Can this tool be used on Windows and if so what version do I need to DL and does it need anything else besides the software (e.g. Perl - which I see listed for the nix versions. When I last had a Windows box at work, mytop worked with ActivePerl (from ActiveState). Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 31 days, processed 1,353,657,492 queries (497/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]
RE: CPU Usage and MySQL...
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]
Re: CPU Usage and MySQL...
Can this tool be used on Windows and if so what version do I need to DL and does it need anything else besides the software (e.g. Perl - which I see listed for the nix versions. Thanks Albert - Original Message - From: K Old [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, August 31, 2003 12:02 AM 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]
Re: CPU usage running mysql
Randy, I did not receive any replies so any suggestions would be useful!. We are using mysql with PHP and the problem may stem from PHP hogging the database, but I cannot be sure. Thanks, David Randy Johnson wrote: Dave Did you get any replies?? I am having the same problem as you and it is driving me crazy... thanks randy -Original Message- From: David Allen [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 8:59 AM To: [EMAIL PROTECTED] Subject: CPU usage running mysql Hi, We run mysql V3.22.32 (solaris 2.5.1 version ) on a Solaris 2.6 box. The top command shows the mysqld running at 98.3% of cpu time when the system is idling. On a Solaris 7 box runnning Solaris 7 running mysql-3.22.32 (solaris 7 version) but also idle, the top command shows 0.5% for the mysqld. Any ideas which is correct, how I can rectify the situation and could this explain why the 2.6 box has started to run slow? Stopping and restarting the mysqld has no effect on the cpu time used Thanks, David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: CPU usage running mysql
I wish it was! See my note below, the 7 box runs at about 0.5% but the 2.6 box runs at 99%! David Simon Green wrote: Is that not 98% idle and mysqld using 5% of the total CPU use! i.e. you are looking at vary different things? Simon -Original Message- From: David Allen [mailto:[EMAIL PROTECTED]] Sent: 21 May 2001 12:42 To: Randy Johnson; [EMAIL PROTECTED] Subject: Re: CPU usage running mysql Randy, I did not receive any replies so any suggestions would be useful!. We are using mysql with PHP and the problem may stem from PHP hogging the database, but I cannot be sure. Thanks, David Randy Johnson wrote: Dave Did you get any replies?? I am having the same problem as you and it is driving me crazy... thanks randy -Original Message- From: David Allen [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 8:59 AM To: [EMAIL PROTECTED] Subject: CPU usage running mysql Hi, We run mysql V3.22.32 (solaris 2.5.1 version ) on a Solaris 2.6 box. The top command shows the mysqld running at 98.3% of cpu time when the system is idling. On a Solaris 7 box runnning Solaris 7 running mysql-3.22.32 (solaris 7 version) but also idle, the top command shows 0.5% for the mysqld. Any ideas which is correct, how I can rectify the situation and could this explain why the 2.6 box has started to run slow? Stopping and restarting the mysqld has no effect on the cpu time used Thanks, David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: CPU usage running mysql
Hello again! Do you know if there is any way I can see what the mysqld is doing? If it is taking up 99% of the processor time, it is very busy doing something! I installed the binary version and consequently only have the tools available which came with that distribution. Thanks, David Simon Green wrote: Is that not 98% idle and mysqld using 5% of the total CPU use! i.e. you are looking at vary different things? Simon -Original Message- From: David Allen [mailto:[EMAIL PROTECTED]] Sent: 21 May 2001 12:42 To: Randy Johnson; [EMAIL PROTECTED] Subject: Re: CPU usage running mysql Randy, I did not receive any replies so any suggestions would be useful!. We are using mysql with PHP and the problem may stem from PHP hogging the database, but I cannot be sure. Thanks, David Randy Johnson wrote: Dave Did you get any replies?? I am having the same problem as you and it is driving me crazy... thanks randy -Original Message- From: David Allen [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 8:59 AM To: [EMAIL PROTECTED] Subject: CPU usage running mysql Hi, We run mysql V3.22.32 (solaris 2.5.1 version ) on a Solaris 2.6 box. The top command shows the mysqld running at 98.3% of cpu time when the system is idling. On a Solaris 7 box runnning Solaris 7 running mysql-3.22.32 (solaris 7 version) but also idle, the top command shows 0.5% for the mysqld. Any ideas which is correct, how I can rectify the situation and could this explain why the 2.6 box has started to run slow? Stopping and restarting the mysqld has no effect on the cpu time used Thanks, David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: CPU usage running mysql
-Original Message- From: David Allen [mailto:[EMAIL PROTECTED]] Sent: lunes, 21 de mayo de 2001 14:36 To: Simon Green; [EMAIL PROTECTED] Subject: Re: CPU usage running mysql Hello again! Do you know if there is any way I can see what the mysqld is doing? If it is taking up 99% of the processor time, it is very busy doing something! I installed the binary version and consequently only have the tools available which came with that distribution. First of all, compare with supported tools such as vmstat or ps to ensure that top is correct. vmstat will not show the process itself but just total usertime, systemtime and idletime. You can also use Symbel ( www.setoolkit.com ), but I've experienced a bug in this too related to cpu/process info on Solaris 6, 7 and possible also 8. This is in all recent releases (3.0 - 3.2) and is present in toptool.se, aw.se and infotool.se. Tools in Symbel that will work and give you some info about mysqld is /opt/RICHPse/examples/pea.se this however tends to loop if you pipe the output to awk or another program. That's another bug ;-) For default debugging tools shipped with a standard Solaris go to /usr/proc/bin : # ls -al /usr/proc/bin total 30 drwxr-xr-x 2 root bin 512 Dec 31 20:25 . drwxr-xr-x 3 root bin 512 Dec 31 20:25 .. lrwxrwxrwx 1 root root 15 Dec 31 20:25 pcred - ../../bin/pcred lrwxrwxrwx 1 root root 16 Dec 31 20:25 pfiles - ../../bin/pfiles lrwxrwxrwx 1 root root 16 Dec 31 20:25 pflags - ../../bin/pflags lrwxrwxrwx 1 root root 14 Dec 31 20:25 pldd - ../../bin/pldd lrwxrwxrwx 1 root root 14 Dec 31 20:25 pmap - ../../bin/pmap lrwxrwxrwx 1 root root 14 Dec 31 20:25 prun - ../../bin/prun lrwxrwxrwx 1 root root 14 Dec 31 20:25 psig - ../../bin/psig lrwxrwxrwx 1 root root 16 Dec 31 20:25 pstack - ../../bin/pstack lrwxrwxrwx 1 root root 15 Dec 31 20:25 pstop - ../../bin/pstop lrwxrwxrwx 1 root root 15 Dec 31 20:25 ptime - ../../bin/ptime lrwxrwxrwx 1 root root 15 Dec 31 20:25 ptree - ../../bin/ptree lrwxrwxrwx 1 root root 15 Dec 31 20:25 pwait - ../../bin/pwait lrwxrwxrwx 1 root root 14 Dec 31 20:25 pwdx - ../../bin/pwdx There are man pages for all of them. They all give useful information about what a given process is doing. You can also use truss. ...ofcourse you can also get some info from MySQL itself with show processlist -- Un saludo / Venlig hilsen / Regards Jesper Frank Nemholt Unix System Manager Compaq Computer Corporation Phone : +34 699 419 171 E-Mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php