Thanks for the reply. It helped alot, since I did not know where to look.
I read the documentation regarding the issue and some more pages google
turned up for me.
I did increase my table cache to 16k and my open files are at 30k. I do
run debian etch 32-bit. How would I determine what reasona
the problem is not on the MySQL side.. the problem is in the
connection management of your Java application... Are you using
connection pooling? Nothing on the server is going to close those
connections for you (although they will go stal eventually), that is
up to your client application.
-
rekin's janky wrote:
Hi listers,
Using MySQL 4.0.15-max-debug on Windows 2000, I am working with perlscripts.
When one of my program runs, I have an unexpected long time for one query which take at least 10 min (in the best case, but it stayed blocked most of the time) instead of 10 sec when t
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,
> 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 Li
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/
__ ___ ___
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
---
ECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, June 06, 2002 6:52 AM
Subject: Re: processlist
> Hi,
> Is this mysqld.log file created automatically or we need to do some
> settings in my.cnf to enable this logging of mysqld?
>
> Thanx in advance..
---
ECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, June 06, 2002 6:52 AM
Subject: Re: processlist
> Hi,
> Is this mysqld.log file created automatically or we need to do some
> settings in my.cnf to enable this log
Hi,
Is this mysqld.log file created automatically or we need to do some
settings in my.cnf to enable this logging of mysqld?
Thanx in advance..
Ritu
On Wed, 5 Jun 2002, Eivind A. Sivertsen wrote:
> You can also tail -f the logfile of mysqld...
>
> >> tail -f /var/log/mysqld.log
>
> ...or so
You can also tail -f the logfile of mysqld...
>> tail -f /var/log/mysqld.log
...or something like that...
Eivind
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://list
s : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Sergey S. Kostyliov" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 2:33 PM
Subject: Re: processlist
> thanks Sergey,
> but
EMAIL PROTECTED]>
To: "Sergey S. Kostyliov" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 1:33 PM
Subject: Re: processlist
> thanks Sergey,
> but that command line only shows the total processlist, it doesn't show
> exactlly witch queri
thanks Sergey,
but that command line only shows the total processlist, it doesn't show
exactlly witch queries are happening on my tables besids my one that says 'show
full processlist'.The others are sleep , but if they are really, why is my
mysql server running severls processes with 11.5 Mgs or
thanks David,
i have allready seen that but what is exactlly them command line to do so?
EX: the select queries or the update ones in all databases or in just in one.
regards
tsa
On 04-Jun-2002 David BORDAS wrote:
> Hi,
>
> Just connect to mysql and use this query :
> show processlit;
> http:
Hi,
Just connect to mysql and use this query :
show processlit;
http://www.mysql.com/doc/S/H/SHOW_PROCESSLIST.html
You can also use slow query logs.
http://www.mysql.com/doc/S/l/Slow_query_log.html
David
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesda
On Tuesday 04 June 2002 15:07, [EMAIL PROTECTED] wrote:
> Hello all,
>
> Please can any one tell me how do i see all the queries in my mysql
> server in real-time?
> this is for checking witch ones are longer.
`mysqladmin -v proc`
Or (in mysql client)
mysql> SHOW PROCESSLIST;
> regards
> tsa
-
On Thursday 24 January 2002 11:44 am, Sinisa Milivojevic wrote:
> >?(2) Can someone give me an idea what these correspond to:
> >?
> >? ? ?Connect Out
Slave connecting to master.
--
MySQL Development Team
For technical support contracts, visit https://order.mysql.com/
__ ___ ___
On Wed, 23 Jan 2002 16:53:47 -0800
Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> In sql/sql_parse.cc:72 (roughly), a list of command names is defined:
>
> const char *command_name[]={
> "Sleep", "Quit", "Init DB", "Query", "Field List", "Create DB",
> "Drop DB", "Refresh", "Shutdown", "S
On Thu, Feb 22, 2001 at 05:54:42PM -0800, Steven Roussey wrote:
>
> Hi, I searched all over, but I can not find out what the state
> 'reschedule' means in the PROCESSLIST.
I could hazard a guess based on the source from sql/sql_insert.cc:
---snip---
/* Let READ clients do something once in
20 matches
Mail list logo
