I'm using MySQL 3.23.43 running on Linux with a 2.2.16 kernel. My software does around 50,000 inserts a day and from some of those inserts they result in:
Lost connection to MySQL server during query The software is developed in C, using the mysql C api to talk to the database. Problem is.. once I get this error I'd assume I have lost connection to the database and that I would need to reconnect and try to insert the query again. For this instance I DO NOT reconnect to the database and the application continues to make more queries to the database but they work fine even after I get the above result from the queries I had made before. Does the MySQL C API automatically reconnect when a connection is lost? If so does it try to execute the query again once it has reconnected to the database? If it doesn't automatically reconnect then why am I getting this error when the application really has not lost connection with the database. Considering it can succesfully insert queries after the above result.. Any help would be appreciated. Regards, Benjamin Charles Tehan --------------------------------------------------------------------- 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