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

Reply via email to