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
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).
After
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. PostDirekt MA
Cc: [EMAIL PROTECTED]
Betreff: Re: Pending results blocking mysql-server
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
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 Stefan,
thanks for your fast reply !
Would it be possible
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
The problem is, that i can't prevent queries like
SELECT * FROM TABLE WHERE COLUMN 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
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