Klaus,
>>in this case, I suspect, is that the disconnect happens in the
>> pre-data-sending stage, which is possibly quite lengthy.
> Exactly ! It takes hours till these results are erased and i even don't know
> where the period when they are erased come from.
> I still hope this is set in a ser
The problem is, that i can't prevent queries like
SELECT * FROM WHERE LIKE 'a%'
where an index will not help on a Table > 100.000.000 records.
It's not that we have to answer hese queries (therefore the timeout), but
it's impossible to prevent dumm users.
Run EXPLAIN on the untrusted queries f
With lot of queries, it even happens, that a connection to the mysql-server is blocked.
i think it would be the best to get rid of hte pending results on the server, that are
not
fetched after let's say 20 seconds.
Which variable do i need to set to achieve this (if possible).
The program use
Klaus
Ursprüngliche Nachricht-
Von: Sasha Pachev [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 17. Februar 2004 14:19
An: Franz, Fa. PostDirekt MA
Cc: Stefan Hinz; [EMAIL PROTECTED]
Betreff: Re: AW: Pending results blocking mysql-server
Franz, Fa. PostDirekt MA wrote:
> Hi Stef
Franz, Fa. PostDirekt MA wrote:
Hi Stefan,
thanks for your fast reply !
Would it be possible to call mysql_free_result() from your
application? You might be able to set a "timer" in your app, calling
that function after, for example, 20 seconds.
I am not the of developer this programm ...
But
lt() from your
>>application? You might be able to set a "timer" in your app, calling
>>that function after, for example, 20 seconds.
-Ursprüngliche Nachricht-
Von: Stefan Hinz [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 17. Februar 2004 12:15
An: Franz, Fa. Pos
but the threads for them are kept a very long
> time.
> With lot of queries, it even happens, that a connection to the mysql-server is
> blocked.
> i think it would be the best to get rid of hte pending results on the server, that
> are not
> fetched after let's say 20 sec
ng time.
With lot of queries, it even happens, that a connection to the mysql-server is blocked.
i think it would be the best to get rid of hte pending results on the server, that are
not
fetched after let's say 20 seconds.
Which variable do i need to set to achieve this (if possible).
The pr
Im having trouble with 'to many pending results' in MySQL.
Any ideas?
-
amund
