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
I am interested to help, you can email me the call graph or source.
I nearly have nothing much to do ( no client, teching guiter now!!! ha
ha). I am using the C API 100% flawlessly in my
http://www.DhakaStockExchangeGame.com/
Still using it
--
Aftab Jahan Subedar
CEO/Software Engineer
Su
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
tDirekt MA
Cc: [EMAIL PROTECTED]
Betreff: Re: Pending results blocking mysql-server
Klaus,
> we are porting an application from ORACLE to MySQL.
> The application does lot of queries and has and times out a query, if no result is
> back
> after 10 seconds.
> It handles queries parrallel
Klaus,
> we are porting an application from ORACLE to MySQL.
> The application does lot of queries and has and times out a query, if no result is
> back
> after 10 seconds.
> It handles queries parrallel and rasies or lowers the amount of connection variable
> (the programm is a server itself).
>
Dear Sirs and Ladies,
we are porting an application from ORACLE to MySQL.
The application does lot of queries and has and times out a query, if no result is back
after 10 seconds.
It handles queries parrallel and rasies or lowers the amount of connection variable
(the programm is a server itself).
