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).
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.

PLEASE HELP ME (or give me a new job :-])

Klaus



Topaktuelle Consumer-Adressen anmieten www.consumeradressen.de 


Diese Mail ist von:
Deutsche Post Direkt GmbH
Beleglese Center Mannheim

Klaus Franz     
Manager Abgleichsysteme 

Willy-Brandt-Platz 13   Tel. 06 21.129 56 436
68161 Mannheim          


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to