r 06, 2004 11:13 PM
To: [EMAIL PROTECTED]
Subject: show processlist state value 'statistics'
Does anyone know what is the meaning of value 'statistics' in state
column of show processlist?
It is displaying this state during a SELECT query.
I noticed lot of them in DB while our
Does anyone know what is the meaning of value 'statistics' in state column of show
processlist?
It is displaying this state during a SELECT query.
I noticed lot of them in DB while our application is being run in a stress mode.
This is not documented in Mysql documentation for show p
Hello,
I have wrote a small program which's main purpose is to do "change master
to", "slave start" and after a transfer of data - "slave stop".
But after "slave start" i need to know when the transfer ends - to do this
I could parse the mysql_list_processes() output for a string "Has read all
re
Hi,
Currently, I have a situation where an app makes connections (via JDBC)
to a mysql server, 50 connections at once, and everything just becomes
super-slow. For instance, a SELECT that should take 0.01 sec takes
several minutes. SHOW PROCESSLIST says that these threads that are
connections
>Description:
When I do 'SHOW PROCESSLIST' on my server currently, the line for 'system user' is
as follows:
++-+--+-+-++---+--+
| Id | User| Host | d
All:
I recently discovered the Show Processlist statement which is great. My
question is this...
One the process completes it falls off this list. Is there another
command that will show me the run time of the processes that have
completed?
Is this info in a log? If so, which one?
Thanks
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?
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
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.
Hi Jeremy,
> On Wed, Feb 18, 2004 at 04:26:21PM +0100, Martijn Tonies wrote:
> > Hi,
> >
> > Does anyone know what the possible values for column
> > "Command" are when doing a SHOW PROCESSLIST?
>
> A table in Chapter 1 of High Performance MySQL
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
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,
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?
Thank´s,
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMA
On Wed, Feb 18, 2004 at 04:26:21PM +0100, Martijn Tonies wrote:
> Hi,
>
> Does anyone know what the possible values for column
> "Command" are when doing a SHOW PROCESSLIST?
A table in Chapter 1 of High Performance MySQL[*]
Binlog Dump
Change user
Connect
Conne
My confusion, I thought that was what you were asking for.
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 2/18/04, 10:01:24 AM, Martijn Tonies <[EMAIL PROTECTED]> wrote
se are ones that I know of.
>
> >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
>
> On 2/18/04, 9:26:21 AM, Martijn Tonies <[EMAIL PROTECTED]> wrote
> regardin
<<<<<<<<<<<<<<<<<
On 2/18/04, 9:26:21 AM, Martijn Tonies <[EMAIL PROTECTED]> wrote
regarding Possible values in "COMMAND" for SHOW PROCESSLIST:
> Hi,
> Does anyone know what the possible values for column
> "Command"
Hi,
Does anyone know what the possible values for column
"Command" are when doing a SHOW PROCESSLIST?
All I'm getting so far, is "Query", "Killed" and "Sleep".
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebir
d things to see
which index to use, if any, when looking up rows in a table.
Now we both know. ;-) Hope that helps.
Matt
- Original Message -
From: "Andrius Jakas"
Sent: Thursday, December 18, 2003 6:08 AM
Subject: show processlist
> Hi,
>
> show processlist display
Hi,
show processlist displays processes with state "statistics", what does this
status means.
Documentation doesn't say much
A.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I would like to know (if possible, there is no explanation in the documentation) the
exact meanning of the column "time" in the "show processlist" command.
Why is it sometime so hight ?
When is it reinitialize (and why) ?
Is there any correlation between the time column and
On Tue, Aug 12, 2003 at 11:43:50AM +0200, Mechain Marc wrote:
>
> I would like to know (if possible, there is no explanation in the
> documentation) the exact meanning of the column "time" in the "show
> processlist" command.
It's the amount of time that
On Wed, Aug 13, 2003 at 03:26:24PM +0200, Mechain Marc wrote:
> First of all, thank you Jeremy for your answer.
>
> You said:
>
> >> It's the amount of time that thread has been in its current state.
>
> Is it the current state column value (which is in fact nothing or
> the text of the running
Jeremy Zawodny wrote:
>
>> What happens to the thread if the value of time is greater than
>> interactive timeout or wait timeout ?
>
>The client will be disconnected and thread closed.
That's what I thought was supposed to happen, but we constantly wind up
with sleeping connections longer than t
Thanks very much.
Marc.
-Message d'origine-
De : Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 13 août 2003 17:01
À : Mechain Marc
Cc : [EMAIL PROTECTED]
Objet : Re: Meaning of Column time in Show Processlist
On Wed, Aug 13, 2003 at 03:26:24PM +0200, Mechain Marc
First of all, thank you Jeremy for your answer.
You said:
>> It's the amount of time that thread has been in its current state.
Is it the current state column value (which is in fact nothing or the text of the
running SQL request)
or the current command column value (sleeping, opening table, cl
PAUL MENARD <[EMAIL PROTECTED]> wrote:
>
> I'm having an intermittent problem with a MySQL server that I have running on a
> Windows 2000 Advance server systems. This issue occurs every few days depending on
> the load of the system.
>
> Here are the details.
>
> MySQL version 3.23.42-nt (I k
Hello All,
I'm having an intermittent problem with a MySQL server that I have running on a
Windows 2000 Advance server systems. This issue occurs every few days depending on the
load of the system.
Here are the details.
MySQL version 3.23.42-nt (I know I need to upgrade. Soon).
Machine:
Wi
<[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
<[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
IL PROTECTED]>
Sent: Tuesday, June 17, 2003 12:24 PM
Subject: SHOW PROCESSLIST
Hi, we've got a linux server (version 4.0.12) and we seem to be having a
strange issue.whenever we view the processlist, it ALWAYS shows
connections coming from the localhost instead of the remote mach
; To: [EMAIL PROTECTED]
> Subject: SHOW PROCESSLIST
>
>
> Hi, we've got a linux server (version 4.0.12) and we seem to
> be having a
> strange issue.whenever we view the processlist, it ALWAYS shows
> connections coming from the localhost instead of the rem
Hi
Im running mysql 4.0.12-embedded, a simple query - 'show proceslist'; returns an
empty set ? Is this a bug ?
thx
G
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Josh Smith wrote:
> Hello, all.
>
> I have noticed over the last few days that when I do a SHOW
PROCESSLIST on my MySQL server the host field always reports the same
host IP address or name regardless of who is making the connection.
Here is
"Josh Smith" <[EMAIL PROTECTED]> wrote:
>
> I have noticed over the last few days that when I do a SHOW PROCESSLIST on my MySQL
> server the host field always reports the same host IP address or name regardless of
> who is making the connection. Here is a run
Hello, all.
I have noticed over the last few days that when I do a SHOW PROCESSLIST on my MySQL
server the host field always reports the same host IP address or name regardless of
who is making the connection. Here is a run of the command on my machine:
mysql> show processl
March 25, 2003 5:37 PM
Subject: Trouble with MySQL4, host field in show processlist
> Hi,
>
> My first post here l;)
>
> Ok, here it goes.
> I recently installed MySQL4 and transfered all my databases there.
> Now, it all works great, but the host field, in show processlist
Sasa,
> Now, it all works great, but the host field, in show processlist
> command, don't work correctly.
> It don't display correct info from where the query has came.
> Example:
my
Hi,
My first post here l;)
Ok, here it goes.
I recently installed MySQL4 and transfered all my databases there.
Now, it all works great, but the host field, in show processlist
command, don't work correctly.
It don't display correct info from where the query has came.
Example:
m
Has anybody seen something like this when using show processlist?
Note how they have been killed, their status is null and the have been
running for 171316 seconds. I killed them yesterday.
mysql> show processl
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:
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
Hi,
I am developing a web-based application using java + tomcat + mysql in Win
2000.
When the application is running,I try to view the processlist in MS-DOS
using the commad "show processlist".
mysql> sho
On Tue, Jul 30, 2002 at 12:31:32PM -0400, Chris Friedline wrote:
> hello everyone,
>
> i'm a newbie so please excuse the probably dumb question.
>
> i'm using monitoring software to record the number of processes at a current
> time. currently, i'm just
hello everyone,
i'm a newbie so please excuse the probably dumb question.
i'm using monitoring software to record the number of processes at a current
time. currently, i'm just sending a show processlist and my monitoring
software returns something like this:
"0.06 sec,
random and minor problem, it is
very stable. I also can't repeat the problem, as it just happens unexpectedly
(not on every call to "show processlist").
-Hank
__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
htt
EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Henry Hank" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 27, 2002 4:13 AM
Subject: Signal 11 on SHOW PROCESSLIST query
>
> Hello All,
>
> I have mysql 3.23.41 running on a Del
no symbols"
HH> error.
HH> The good news is that mysql restarted itself and there seems to be no table
HH> corruption (whew!), but I'd still like to figure out why the server crashed on
HH> the "SHOW PROCESSLIST" command (which does run once a minute in a cron job
p/mysqld.sym" I get a "nm: libexec/mysqld: no symbols"
> error.
same problem with my server too ... every two weeks restarts ... with same cron job
"show processlist" every minutes
i hope mysql will improve this soon on next stable version please !!!
becaus
d there seems to be no table
corruption (whew!), but I'd still like to figure out why the server crashed on
the "SHOW PROCESSLIST" command (which does run once a minute in a cron job).
Any pointers or help would be greatly appreciated! Thanks,
-Hank Es
> > PMFJI, but has anyone done any testing to see if persistent
> > connections with MySQL and PHP is actually faster in practice?
>
> Without testing, I suspect that it is faster but that the gains are
> very small. If this was Oracle, it'd be a whole different story. The
> connection
At 10:24 PM 3/4/2002 , you wrote:
>On Mon, Mar 04, 2002 at 01:47:42PM -0600, BD wrote:
> >
> > Jeremy,
> >
> > PMFJI, but has anyone done any testing to see if persistent
> > connections with MySQL and PHP is actually faster in practice?
>
>What's PMFJU?
"Pardon me for jumping in"
>Wit
On Mon, Mar 04, 2002 at 01:47:42PM -0600, BD wrote:
>
> Jeremy,
>
> PMFJI, but has anyone done any testing to see if persistent
> connections with MySQL and PHP is actually faster in practice?
What's PMFJU?
Without testing, I suspect that it is faster but that the gains are
very small.
we couldn't log in because mysql sent back a 'too many
> > open connection!' (or someting like that) error message. If I use
> > the command SHOW PROCESSLIST than I can see many 'Sleep' processes.
> > If I try to kill some processes by KILL than new
oo many
> open connection!' (or someting like that) error message. If I use
> the command SHOW PROCESSLIST than I can see many 'Sleep' processes.
> If I try to kill some processes by KILL than newer
> processes appear in the list.
Sounds like you need to decrease the amo
Hi,
We use mysql 1.23.47 as a database for our
PHP based accounting system.
We use mysql_pconnect() to get a
connection to the DB.
This morning we couldn't log in because
mysql sent back a 'too many open connection!'
(or someting like that) error message.
If I use the command S
Personally I feel that I have a pretty good understanding on MySQL locking,
however I am confused by the output I've received from "SHOW PROCESSLIST" at
seemingly random times.
At the end of this message is the output from "SHOW FULL PROCESSLIST." ALL
queries from ou
Hi,
>
> Hallo,
>
> Im writing an Visual Basic 6 application, using MDAC 2.1 and MySql ODBC
> 2.50.38.
>
> In some part of this application I like to know the processes that are
> running on MySql. I'm using "SHOW PROCESSLIST" expecting a recordset back
Hallo,
Im writing an Visual Basic 6 application, using MDAC 2.1 and MySql ODBC
2.50.38.
In some part of this application I like to know the processes that are
running on MySql. I'm using "SHOW PROCESSLIST" expecting a recordset back
like in "SHOW STATUS". I
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,
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
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
How do I show processlist from a specific computer, not everything ?
Thanks.
>> What privileges should I give my user so that I can do the
>> SHOW PROCESSLIST on all databases ?
> Process_priv
Should I then do :
GRANT PROCESS ON mysql.* to shark@'123.123.123.123' ide
Jacob Friis Larsen writes:
> What privileges should I give my user so that I can do the SHOW PROCESSLIST
> on all databases ?
>
> Please also reply to my E-mail address.
>
> :) Jacob
Process_priv
Regards,
- Jani
For technical support contracts, visit https
Jacob Friis Larsen writes:
> What privileges should I give my user so that I can do the SHOW PROCESSLIST
> on all databases ?
PROCESS, I think, although it's somewhat of a guess.
I wish someone with more knowledge about these things
could add a clarification to that section of
What privileges should I give my user so that I can do the SHOW PROCESSLIST
on all databases ?
Please also reply to my E-mail address.
:) Jacob
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
quot; & strDBName )
set rs = conn.execute("show tables")
no problem. However I was surprised when this didn't work (that is, it
didn't return a recordset)
set rs = conn.execute("show processlist")
rs is empty, which is odd, because I thought I would
68 matches
Mail list logo