Hi guys,
I'm trying to use pt-query-digest on one of our Prod servers.
The problem our slow log is disabled, no tcpdump is installed and I
decided to use --processlist parameter which I never tried before.
pt-query-digest version 2.2.2
I run to connect to remote node:
pt-query-digest
Hi Claudio,
Thanks for reply. Great. I was sure you can't enable slow log
dynamically on 5.0 and 5.1.
That solves my issue for 5.1 at least.
Many thanks,
Igor
On 06/06/13 13:06, Claudio Nanni wrote:
Hi,
First of all I discourage you to use --processlist, I don't think it
is enough
- Original Message -
From: Claudio Nanni claudio.na...@gmail.com
You can dynamically enable the Slow Query Log with long_query_time=0
Except when you have persistent connections on a stock mysqld. The recent
Percona ones do have a way to change the settings of existing connections,
Hi,
First of all I discourage you to use --processlist, I don't think it is
enough an accurate method to analyse queries.
You can dynamically enable the Slow Query Log with long_query_time=0 and
get a way better data.
Check the syntax for SET GLOBAL variables.
Remember to disable it afterwards
Subject: mysqlimport --use-threads / mysqladmin processlist
I'm in the middle of migrating an InnoDB database to an NDBCluster. I
use mysqldump to first create two dumps, the first one contains only
the database schema, the second one contains only tab delimited data
(via mysqldump --tab). I
[mailto:kohanyi.rob...@gmail.com]
Sent: Tuesday, July 24, 2012 10:52 AM
To: mysql@lists.mysql.com
Subject: mysqlimport --use-threads / mysqladmin processlist
I'm in the middle of migrating an InnoDB database to an NDBCluster. I
use mysqldump to first create two dumps, the first one contains only
this:
mysqladmin --sleep=1 processlist
this is what I see: http://pastebin.com/raw.php?i=M23fWVjc
Only a single process seems to be loading my data. Is this what I
*should* see, or, in my case using 4 threads, should I see four
processes? I'm not asking which one will be faster, I'm just simply
confused
I found some tools to capture the MySQL processlist, log errors, etc.
MySQLReport http://hackmysql.com/mysqlreport and
mytophttp://jeremy.zawodny.com/mysql/mytop/apps. My goal is to grab
the logs of mysql including the processlist to help
me assist in diagnosis of faults.
What tool/apps do you
If your mysql server is hung, crashed or otherwise unreacheable (as you
first posted), you can't connect to it and request it's status and
processlist - it's threaded and thus all inline.
You could use GDB or something similar to go look in the execution stack, as
Raj said, and if you have full
In infinite wisdom James Corteciano ja...@linux-source.org wrote:
[1 text/plain; ISO-8859-1 (7bit)]
Hi All,
What is the other way to get the *processlist* and *status* of mysql server
on event that the mysql server cannot be able to reach due to hung or
crashed?
GDB http
Hi All,
What is the other way to get the *processlist* and *status* of mysql server
on event that the mysql server cannot be able to reach due to hung or
crashed?
Cheers,
James
is being executed at the
moment, therefore info is NULL
Olaf
On 10/6/08 11:38 AM, MaBa.listas [EMAIL PROTECTED] wrote:
Hello,
reading the MySQL documentation I've run into the show full
processlist\G command. In my case I've got an output similar
documentation I've run into the show full
processlist\G command. In my case I've got an output similar to this:
-
mysql show full processlist\G
*** 1
Hello,
reading the MySQL documentation I've run into the show full
processlist\G command. In my case I've got an output similar to this:
-
mysql show full processlist\G
processlist\G command. In my case I've got an output similar to this:
--
---
mysql show full processlist\G
*** 1. row ***
Id: 30127
MySQL on a high traffic Server with approximately 10k
databases. Since some time MySQL is has become very sluggish.
When I look at my processlist it shows more than 25 processes (sometimes
of the same table) with status Opening tables. Some processes also
show closing tables.
Since I am running I
Hey guys,
I do run MySQL on a high traffic Server with approximately 10k
databases. Since some time MySQL is has become very sluggish.
When I look at my processlist it shows more than 25 processes (sometimes
of the same table) with status Opening tables. Some processes also
show closing
Hi All,
I have some doudts in db connections. Please clarify if u know.
I am using MySQL 5 version, while my program(Java Program with threads) is
running, some times i won't get DB connection with in expected time. When
ever i type show processlist on mysql prompt, it is showing 180
show processlist on mysql prompt, it is showing 180+
connections estableshed but almost all are in sleep stage only. Is these
many opened connections are delaying a new connection? if yes is there any
process to close these sleeping connections?
--
- michael dykman
- [EMAIL PROTECTED]
- All
Hi,
I want to get a full list of all queries being run at a specific moment...
If I look at mytop output, I'm hitting 500 queries per second.
If I do show full processlist though, I only see 1 query as output -
it's 'show full processlist' itself! And a few sleeping queries
sometimes.
How does
Peter, SHOW PROCESSLIST is a moment-in-time snapshot of connections and
their activities. It shows you what all is going on at the instant you
issue the command; it does not show you recent commands (even those
that happened a second ago).
Many of your queries are very likely so fast
Hi
I didn´t find it in the documentation
I would like to know if the collumn time in the command show full processlist
show the seconds the query is taking to execute!?
Thank´s in advance
-
Yahoo! Acesso Grátis - Internet rápida e grátis
Hi,
I noticed that the number of id when I do show processlist is getting
bigger and bigger. Now it is about 444,466,168. What is the maximum
number, and what will happen if it runs out of number?
--bk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
:
Hi,
I noticed that the number of id when I do show processlist is getting
bigger and bigger. Now it is about 444,466,168. What is the maximum
number, and what will happen if it runs out of number?
--bk
--
For technical support contracts, goto https://order.mysql.com/?ref
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
user-login for a web-based application to
my mysql database - is there a way of including some information at
connect time or during processing that would show up when issuing
`show processlist'?
Only if you prefixed each query with a comment:
/* foo #3 */ SELECTL * FROM world ORDER
On Thu, Aug 05, 2004 at 12:36:55PM +0100, Naran Hirani wrote:
Hi,
I'm using a single shared user-login for a web-based application to
my mysql database - is there a way of including some information at
connect time or during processing that would show up when issuing
`show processlist
a single shared user-login for a web-based application to
my mysql database - is there a way of including some information at
connect time or during processing that would show up when issuing
`show processlist'?
Only if you prefixed each query with a comment:
/* foo #3 */ SELECTL * FROM
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
Occasionally, when looking at the processlist using MySQLAdmin, I see
entries
'unauthenticated user' 'reading from net'
Would some kind person tell me what this means, and if I'm in danger of
having data compromised?
Thanks
Terry Riley
--
MySQL General Mailing List
For list archives: http
the query is on the mysql command line (a SELECT query about 81000 lines).
The command SHOW PROCESSLIST shows that the state of that command is Writing to net ! I don't see what that means and how I can find a solution ?
Anybody can help me ?
Try
$sth-{mysql_use_result} = 1;
before
$sth
is on the mysql command line (a SELECT query about 81000 lines).
The command SHOW PROCESSLIST shows that the state of that command is Writing to net
! I don't see what that means and how I can find a solution ?
Anybody can help me ?
best regards,
Rekin's
hi listers
how would i determine the association between the id from mysqladmin processlist to a
pid?
what i'm after is that i notice some of the mysql threads have a high cpu utilization.
i see this using top (on a linux box). i would like to know which user/program is
responsible for tuning
filter: select, mysql
Solaris 3.23.40 connections using perl, jdbc, odbc.
Yesterday, we experienced a rare mysqld failure where all connections
where in the state=Opening table. Normally our 200+ connections
are in state=sleep. The Time field from command
show processlist
showed each
Roos
Sent: Tuesday, March 09, 2004 6:05 AM
Subject: mysqladmin processlist and pid
hi listers
how would i determine the association between the id from mysqladmin
processlist to a pid?
what i'm after is that i notice some of the mysql threads have a high
cpu utilization. i see this using top
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
Hi All,
Is there a possibility that a certain query that is executing in mysql
by application is not visible by a show processlist command. As
happened in my database a query was taking number of CPU cycles but when
seen through the show processlist command nothing was displayed.
shasan
Sohail Hasan [EMAIL PROTECTED] wrote:
Is there a possibility that a certain query that is executing in mysql
by application is not visible by a show processlist command. As
happened in my database a query was taking number of CPU cycles but when
seen through the show processlist command
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
Second Edition by Paul Dubois. I just
wonder if this is a problem that is unable to be solved?!
-Original Message-
From: Adam Nelson [mailto:[EMAIL PROTECTED]
Sent: 08 August 2003 17:16
To: 'Gary Broughton'; [EMAIL PROTECTED]
Subject: RE: Mysql processlist sleep time
I think I see
Hi all
I continue to have problems with the CPU usage with MySQL and PHP under
IIS 5 (Win2000). I recently rewrote our messageboards in PHP (from
ASP). I now have both online separately, and if I look at the
processlist, the times on the ASP version rarely hit double figures, but
those
a way to start a process (mysql) in low priority?
-Original Message-
From: Gary Broughton [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08, 2003 4:20 AM
To: [EMAIL PROTECTED]
Subject: RE: Mysql processlist sleep time
The PHP one is indeed used less, probably by about 10
On Thu, Aug 07, 2003 at 07:54:24PM +0100, Gary Broughton wrote:
Hi all
I continue to have problems with the CPU usage with MySQL and PHP
under IIS 5 (Win2000). I recently rewrote our messageboards in PHP
(from ASP). I now have both online separately, and if I look at the
processlist
does anyone know what it means when it says state = NULL doing the show
processlist?
The client is connected but not doing anything. It could be
either preparing to send a query, between queries, or finished
with its last query and hasn't disconnected yet.
-M
--
MySQL General Mailing List
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
.)
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 07, 2003 5:55 PM
To: Gary Broughton
Cc: [EMAIL PROTECTED]
Subject: Re: Mysql processlist sleep time
On Thu, Aug 07, 2003 at 07:54:24PM +0100, Gary Broughton wrote:
Hi all
I
Broughton
Cc: [EMAIL PROTECTED]
Subject: Re: Mysql processlist sleep time
On Thu, Aug 07, 2003 at 07:54:24PM +0100, Gary Broughton wrote:
Hi all
I continue to have problems with the CPU usage with MySQL and PHP
under IIS 5 (Win2000). I recently rewrote our messageboards in PHP
(from ASP). I now
On Thu, Aug 07, 2003 at 05:42:12PM -0400, Bernd Jagla wrote:
Dear list,
does anyone know what it means when it says state = NULL doing the show
processlist?
Usually you see this when the 'command' is sleep. That means the
thread is idle.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux
Dear list,
does anyone know what it means when it says state = NULL doing the show processlist?
Thanks
Bernd
=
Please note that this e-mail and any files transmitted with it may be
privileged
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
On Sun, Jun 15, 2003 at 03:01:18PM +0800, Ares Liu wrote:
MySQL 4.0.12 max on AIX 4.3.2 HA. When I use show full processlist
on localhost, all Hosts show as localhost. but when I use show full
processlist from remote, all Hosts show as remote IP. as follow:
Known bug fixed in 4.0.13
MySQL 4.0.12 max on AIX 4.3.2 HA. When I use show full processlist on localhost, all
Hosts show as localhost. but when I use show full processlist from remote, all Hosts
show as remote IP.
as follow:
mysql show full processlist
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
Hello all at mysql list,
can anyone tell me, please, what kind of format is Time in PROCESSLIST?
thanks
--
Martin Hudec
--
:@: [EMAIL PROTECTED]
:w: http://www.corwin.sk
:m: +421.907.303.393
In google non est, ergo non est.
- unknown IRC operator
seconds
- Original Message -
From: Martin Hudec [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 3:55 PM
Subject: processlist
Hello all at mysql list,
can anyone tell me, please, what kind of format is Time in PROCESSLIST?
thanks
--
Martin Hudec
On Tuesday 01 April 2003 10:55, Martin Hudec wrote:
can anyone tell me, please, what kind of format is Time in PROCESSLIST?
In seconds.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 18 Mar 2003, Andrew Braithwaite wrote:
Anyone know why mysqladmin processlist is not showing the host that is
connected, but instead is showing the following in v4.0.12:
truncated excerpt
Hi all,
Anyone know why mysqladmin processlist is not showing the host that is
connected, but instead is showing the following in v4.0.12:
truncated excerpt
+-+-+--+--+
| Id | User| Host | db | Command
The change log for 4.012 mentions (Lenz Grimmer just posted this a couple of
messages ago):
Functionality added or changed:
* `SHOW PROCESSLIST' will now include the client TCP port after the
hostname to make it easier to know from which client the request
originated.
I guess whenever
It says in the change log that it added the port to make it easier to see
where the connection is coming from. 146.101.143.72:48753 gives you a lot
more information than host1
From the release announcement --
* `SHOW PROCESSLIST' will now include the client TCP port after the
hostname
Hi,
I do understand what you're saying and I did read the 4.0.12 changelog and
appreciate the addition of the TCP port in that display, but all the
hostnames in the processlist are displaying as the localhost of the mysql
server that they are connecting to instead of the hostnames of the server
Anyone else notice this, or is it just me?
Andrew
-Original Message-
From: Andrew Braithwaite
Sent: Tuesday 18 March 2003 23:05
To: 'R. Hannes Niedner'; MySQL Mailinglist
Subject: RE: mysqladmin processlist = weird in version 4.0.12
Hi,
I do understand what you're saying and I did
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
with an upgraded binary from MySQL.
RH, Linux 2.2.16-22enterprise, harmless load averages
until a few respectable queries are issued and we get
crippled.
Never seen a processlist like this though. It happens
within 30 seconds of the server getting throttled.
Thanks,
| 17546 | root| localhost | NULL
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
Hello everybody
I'd like to know what does that means: Writing to net in the state row of
processlist.
I have to launch a perl script which do traitement on a mysql table with
1.750.000 records.
The request blocks during a long time everytime on the select of the hole
table and i can see
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
1 - 100 of 140 matches
Mail list logo