Re: CPU Usage and MySQL...

2003-09-02 Thread Jeremy Zawodny
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

Re: CPU Usage and MySQL...

2003-09-02 Thread Jeremy Zawodny
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

CPU Usage and MySQL...

2003-08-31 Thread jkelty
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

Re: CPU Usage and MySQL...

2003-08-31 Thread K Old
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

RE: CPU Usage and MySQL...

2003-08-31 Thread electroteque
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

Re: CPU Usage and MySQL...

2003-08-31 Thread Albert
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

Re: how to limit the cpu usage in MySql

2002-07-11 Thread Alexander Barkov
Probably execution with nice will help. Edwin Wang wrote: I want to find a way to limit how much of a system processor (cpu) the mysql server will use, so that I don't run the risk again of having googlebot or other web robots interrupt my other server operations in my computer. Thank you

how to limit the cpu usage in MySql

2002-07-05 Thread Edwin Wang
I want to find a way to limit how much of a system processor (cpu) the mysql server will use, so that I don't run the risk again of having googlebot or other web robots interrupt my other server operations in my computer. Thank you Edwin

RE: how to limit the cpu usage in MySql

2002-07-05 Thread Alain Fontaine
Hello, If your main concern is spider-bots, why not use a (possibly dynamic!) robots.txt file? -Message d'origine- De : Edwin Wang [mailto:[EMAIL PROTECTED]] Envoyé : mardi 4 juin 2002 17:53 À : [EMAIL PROTECTED] Objet : how to limit the cpu usage in MySql I want to find a way

Re: how to limit the cpu usage in MySql

2002-07-05 Thread Ralf Narozny
Hello! If you are using Unix/Linux you might want to 'nice' the mysqld processes or raise the priority of your more important services. Greetings Ralf Edwin Wang wrote: I want to find a way to limit how much of a system processor (cpu) the mysql server will use, so that I don't run the risk

busy site w/ high cpu usage on mysql

2001-10-29 Thread alexus
Hello I have a very busy site (www site) w/ a lot of hits my site is very heavily integrated w/ mysql and when i do top it shows me like over 80% of cpu even though i have dual p3 850mhz w/ 1.5 gig of ram any ideas what to do about it so it'll drop down? thank you in advance

Re: busy site w/ high cpu usage on mysql

2001-10-29 Thread Bill Adams
alexus wrote: Hello I have a very busy site (www site) w/ a lot of hits my site is very heavily integrated w/ mysql and when i do top it shows me like over 80% of cpu even though i have dual p3 850mhz w/ 1.5 gig of ram any ideas what to do about it so it'll drop down? Have you

Re: CPU usage running mysql

2001-05-21 Thread David Allen
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

Re: CPU usage running mysql

2001-05-21 Thread David Allen
:[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

Re: CPU usage running mysql

2001-05-21 Thread David Allen
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

RE: CPU usage running mysql

2001-05-21 Thread Nemholt, Jesper Frank
-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

CPU usage running mysql

2001-05-18 Thread David Allen
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