I have coded my own client that uses mysql_real_connect(). The client code runs on another machine and there can be up to 120 clients connecting to the database. Each client connects and then disconnects sucessfully for anything up to 5 minutes before the clients start to receive 2003 host connection errors. The machine that runs the clients uses SuSE 7.1 (with the latest Mysql client patches from the SuSE site). The server machine runs SuSE 7.0 and the version of Mysql is Ver 11.15 Distrib 3.23.39. To solve the problem I make the clients loop round the mysql_real_connect() call until the 2003 error goes away, but this is a waste of resources. Does the client throw this kind of error when the server is overloaded or is there a TCP/IP issue that needs fixing with Mysql or my Linux distributon? Aidan --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
