Re: Query status

2003-10-23 Thread jlord
10/23/03 02:15 PM cc Subject

Re: Query status

2003-10-23 Thread Filip Rachunek
Are you sure you don't have any errors in your SQL? Maybe your query returns a karthesian product - and this might kill your J2EE application. Check out your slow-log - the query is probably there. -- Per Andreas Buer Thanks for your response Per. Yes, the query is at my slow-log, I already know

Re: Query status

2003-10-23 Thread Per Andreas Buer
"Filip Rachunek" <[EMAIL PROTECTED]> writes: > Hello, > can somebody tell me what the status "Writing to net" returned by "show > processlist" exactly mean? I've tried to find it in MySQL documentation but > either it's not there or I missed it. > I am asking because this status is usually shown w

Query status

2003-10-22 Thread Filip Rachunek
Hello, can somebody tell me what the status "Writing to net" returned by "show processlist" exactly mean? I've tried to find it in MySQL documentation but either it's not there or I missed it. I am asking because this status is usually shown when my J2EE application [using Connector/J 3.0.9] starts

Re: long query status info

2002-02-13 Thread Gerald Clark
I can't read your structures or query from here. [EMAIL PROTECTED] wrote: >hi, > >i'm running a big query across a table containing more than 137 million rows >comparing them to another one with about 4000 rows and i'm wondering how long it will >still take... > >is there a way to see how many

long query status info

2002-02-12 Thread nils
hi, i'm running a big query across a table containing more than 137 million rows comparing them to another one with about 4000 rows and i'm wondering how long it will still take... is there a way to see how many operations have been made and how many are left? as you can see it already took

Re: long query status info

2002-02-07 Thread Gerald Clark
I can't read your structures or query from here. [EMAIL PROTECTED] wrote: >hi, > >i'm running a big query across a table containing more than 137 million rows >comparing them to another one with about 4000 rows and i'm wondering how long it will >still take... > >is there a way to see how many

long query status info

2002-02-07 Thread nils
hi, i'm running a big query across a table containing more than 137 million rows comparing them to another one with about 4000 rows and i'm wondering how long it will still take... is there a way to see how many operations have been made and how many are left? as you can see it already took