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 processlist
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 application is being run
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
relay log;
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 | db | Command | Time
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,
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, Firebird, MySQL MS SQL
Server.
Upscene Productions
http
Possible values in COMMAND for SHOW PROCESSLIST:
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, Firebird
Possible values in COMMAND for SHOW PROCESSLIST:
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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
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
regarding Re: Possible values in COMMAND for SHOW PROCESSLIST:
Hi,
Are you sure about this? According to
http://www.mysql.com/doc/en
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
Connect Out
Create DB
Debug
Delayed_insert
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/[EMAIL
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, Linux
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 so many threads get
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[*]
Thanks!
With regards,
Martijn Tonies
Database Workbench
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.
Shouldn´t the queries
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 some kind of
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?
Does this mean some
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]
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 displays processes with state statistics, what
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,
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 wrote
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 these
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 SQL
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 thread has been in its currnet state.
--
Jeremy D
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 the variables wait
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 know I
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:
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 remote machine's
name/ip. Is there any particular reason
, 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 machine's
name/ip. Is there any particular
[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.vbmysql.com
-Original
[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.vbmysql.com
-Original
Hi
Im running mysql 4.0.12-embedded, a simple query - 'show proceslist'; returns an
empty set ? Is this a bug ?
thx
G
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 processlist
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 of the command on my machine:
mysql
-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 a run
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:
mysql show
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:
mysql show processlist
: 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
command, don't work correctly.
It don't display correct
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 processlist
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, Linux
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 show processlist
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 sending a show processlist and my monitoring
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, 4 rows, 1629, [user
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).
HH Any pointers or help would be greatly appreciated! Thanks,
Henry, can you repeat
]
[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 Dell Poweredge 2550 on standard install
of
Red Hat 7.2 (2.4.9
(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 Eskin
Here is the error log of the last crash
/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 !!!
because i really need this show processlist for monitoring activity.
--
Let's
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
Without testing, I
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
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 SHOW PROCESSLIST
!' (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 processnumber than newer
processes appear in the list.
Sounds like you need to decrease the amount of time that idle
connections stay around
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 processnumber than newer
processes appear in the list.
Sounds like you need to decrease the amount
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. If
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 output are shown. ALL WHERE clauses
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'm getting an runtime-error -2147467259
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
like in SHOW STATUS. I'm getting an runtime
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 does the status
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 does
How do I show processlist from a specific computer, not everything ?
Thanks.
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
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
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 the manual,
seeing
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://order.mysql.com
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' identified by
'sharkpassword';
-
Before
rDBName )
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 at least see my own
p
66 matches
Mail list logo
