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 if it helps :0)
I read about mysql_free_result() already, but i thought it would
clear the local buffer for an already fetched result.
Are you sure it erases a pending result on the server?
mfg
Klaus
>>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.
-----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
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 a while, there is very big load on the MySQL-server (up to 90) and 'show
> processlist' shows very
> many connections with queries that are in 'sending data'-state. But after they are
> timed out,
> this results will never be fetched, 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 seconds.
> Which variable do i need to set to achieve this (if possible).
> The program uses the C-API. The serve is 4.017 with MyISAM-Tables on SUSE-LINUX SLES
> 8.0,
> Ext3-filesystem, a 3Ghz xeleron, 1.5G MEM.
> Please help me, after i convienced my boss to use MySQL for this duty (which took
> about 18 month),
> this might be very dangerous for my carreer.
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.
http://www.mysql.com/doc/en/mysql_free_result.html
Regards,
--
Stefan Hinz <[EMAIL PROTECTED]>
iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
