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 after
- Original Message -
> From: "Claudio Nanni"
>
> 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, iirc.
--
Unhappin
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
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-d
> documentation should say more than it does.
>
>> -Original Message-
>> From: Róbert Kohányi [mailto:kohanyi.rob...@gmail.com]
>> Sent: Tuesday, July 24, 2012 10:52 AM
>> To: mysql@lists.mysql.com
>> Subject: mysqlimport --use-threads / mysqladmin processlist
>&
0: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
> the database schema, the second one contain
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
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 i
I found some tools to capture the MySQL processlist, log errors, etc.
MySQLReport <http://hackmysql.com/mysqlreport> and
mytop<http://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
In infinite wisdom James Corteciano wrote:
> [1 ]
> 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://poormansprofiler.org/>
--
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
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:
>
>
> -----
tion is "sleeping", nothing 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 r
on I've run into the " show full
> processlist\G" command. In my case I've got an output similar to this:
>
> --
> -------
>
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:
--
el Vogel <[EMAIL PROTECTED]> wrote:
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 "Open
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
When
ever i type "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 dykm
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
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
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 sl
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
unds
unlikely.
Batara Kesuma <[EMAIL PROTECTED]> wrote:
> 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?
&g
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
To
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
hared 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
+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 proce
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
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
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 Lis
when 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
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 reg
Matt
- Original Message -
From: "Tom 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 th
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
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 t
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]
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
> se
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 displaye
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
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.
ugust 2003 22:55
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 continue to have problems with the CPU usage with MySQL and PHP
> under IIS 5 (Win2000). I recently rewrote
, etc.)
> -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,
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
> 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
--
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 th
cho. Does
Windows have 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
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 on
as reading advice from "MySQL 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
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
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
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 processl
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
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.
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?
t
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 IR
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
-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 foll
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 s
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 s
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 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 whe
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:
<>
+-+-+--+--+
| Id | User| Host | db
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
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> sho
On Wed, Jul 31, 2002 at 10:54:54AM +0200, mr wrote:
>
> 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 rec
1 - 100 of 143 matches
Mail list logo
