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]