int mysql_ping(MYSQL *mysql)
Description
Checks whether the connection to the server is working. If the
connection has gone down, an automatic reconnection is
attempted.
This function can be used by clients that remain idle for a
long while, to check whether the server has closed the
connection and reconnect if necessary.
Return Values
Zero if the connection to the server is alive. Non-zero if an
error occurred. A non-zero return does not indicate whether
the MySQL server itself is down; the connection might be
broken for other reasons such as network problems.
Errors
-
CR_COMMANDS_OUT_OF_SYNC
Commands were executed in an improper order.
-
CR_SERVER_GONE_ERROR
The MySQL server has gone away.
-
CR_UNKNOWN_ERROR
An unknown error occurred.