RE: show processlist state value 'statistics'

2004-10-06 Thread Amit_Wadhwa
I have seen a similar option in PHPMyAdmin which says 'Enable Statistics' I suppose when the status shows statistics, mysql is just updating the statistics in there for the query just run? -Original Message- From: Ananth Reddy [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004

Re: SHOW PROCESSLIST

2004-02-18 Thread Martijn Tonies
Hi Ronan, > > > > 21 threads are idle. > > > > > > But, what could make so many threads get idle? > > > > Connecting, but don't doing anything. > > > > > Shouldn´t the queries just be executed, return the results and > > > be closed? > > > > If you don't close your connection, what do you expect?

Re: SHOW PROCESSLIST

2004-02-18 Thread Ronan Lucio
Martijn, > > > 21 threads are idle. > > > > But, what could make so many threads get idle? > > Connecting, but don't doing anything. > > > Shouldn´t the queries just be executed, return the results and > > be closed? > > If you don't close your connection, what do you expect? > > > Does this mean

Re: SHOW PROCESSLIST

2004-02-18 Thread Martijn Tonies
Hi, > > > I executed a SHOW PROCCESSLIST command and > > > it returned me 39 rows which 21 of than show "Sleep" > > > in the column "Command". > > > > > > What does this tell me? > > > > 21 threads are idle. > > But, what could make so many threads get idle? Connecting, but don't doing anything.

Re: SHOW PROCESSLIST

2004-02-18 Thread Ronan Lucio
Jeremy, > On Wed, Feb 18, 2004 at 04:01:57PM -0300, Ronan Lucio wrote: > > Hi All, > > > > I executed a SHOW PROCCESSLIST command and > > it returned me 39 rows which 21 of than show "Sleep" > > in the column "Command". > > > > What does this tell me? > > 21 threads are idle. But, what could make

Re: SHOW PROCESSLIST

2004-02-18 Thread Jeremy Zawodny
On Wed, Feb 18, 2004 at 04:01:57PM -0300, Ronan Lucio wrote: > Hi All, > > I executed a SHOW PROCCESSLIST command and > it returned me 39 rows which 21 of than show "Sleep" > in the column "Command". > > What does this tell me? 21 threads are idle. -- Jeremy D. Zawodny | Perl, Web, MySQL,

Re: show processlist

2003-12-18 Thread Matt W
Hi Andrius, Yes, I've wondered about this before too, but wasn't exactly sure what it meant either. :-) So I just decided to see where this state is set in the code, and it's when the make_join_statistics() function is called. I think that function checks key distribution and things to see which

Re: RE: SHOW PROCESSLIST

2003-06-17 Thread Shane Kirk
<[EMAIL PROTECTED]> Sent: 06/17/03 02:37 PM To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: SHOW PROCESSLIST > > This is a know bug that has been addressed in version 4.0.13, you will need to upgrade. See http://bugs.mysql.com/bug.php?id=164 Regards, Mike Hillyer www

Re: RE: SHOW PROCESSLIST

2003-06-17 Thread Shane Kirk
<[EMAIL PROTECTED]> Sent: 06/17/03 02:37 PM To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: SHOW PROCESSLIST > > This is a know bug that has been addressed in version 4.0.13, you will need to upgrade. See http://bugs.mysql.com/bug.php?id=164 Regards, Mike Hillyer www

Re: SHOW PROCESSLIST

2003-06-17 Thread Shane Bryldt
Are you running AIX? This problem was just addressed, and is fixed in 4.0.13 I thought it was a name resolution problem, sorry for the misdirection on whoever had this problem earlier. -Shane - Original Message - From: "Shane Kirk" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tu

RE: SHOW PROCESSLIST

2003-06-17 Thread Mike Hillyer
This is a know bug that has been addressed in version 4.0.13, you will need to upgrade. See http://bugs.mysql.com/bug.php?id=164 Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Shane Kirk [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 17, 2003 12:25 PM > To: [EMAIL P

Re: show processlist ? - sleep .

2002-10-21 Thread cristian ditoiu
f the script ends, unless it's closed earlier by explicitly calling mysql_close(). ) - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "cristian ditoiu" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, October 22, 2002 12:

Re: show processlist ?

2002-10-21 Thread Jeremy Zawodny
On Mon, Oct 21, 2002 at 02:51:14PM +0200, cristian ditoiu wrote: > Hi . > Using Mysql3.23.49 on RH 7.3 + PHP + Apache . > When issuing 'show processlist' i get a lot of these : > > What exactly means 'sleep' ? The thread (connection) is idle. -- Jeremy D. Zawodny | Perl, Web, MySQL, L

Re: show processlist: status

2001-11-12 Thread Heikki Tuuri
Hi! >I'm trying to understand what the status field of the "SHOW PROCESSLIST" >command means. When I execute a query - "SELECT count(*) as count from >table1 where col1 like "name%";", the query takes a long time to execute. >The table has over 47,000,000 records and is indexed on col1. > >What

Re: show processlist

2001-11-09 Thread Bill Adams
Stuart Scamman wrote: > How do I show processlist from a specific computer, not everything ? > Thanks. mysqladmin processlist |grep 'the.host.you.care.about' -- Bill Adams TriQuint Semiconductor - Before posting, please