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
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
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 i'm sure I can convince him
