FreeBSD manual
download PDF document: mysql_ping.3.pdf
mysql_ping(3) MariaDB Connector/C mysql_ping(3)
Name
mysql_ping - checks if the connection between client and server is
working
Synopsis
#include <mysql.h>
int mysql_ping(MYSQL * mysql);
Description
Checks whether the connection to the server is working. If it has gone
down, and global option reconnect is enabled 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.
Parameters
o mysql - a mysql handle, which was previously allocated by
mysql_init(3) and connected by mysql_real_connect(3). ### Notes
o If a reconnect occurred the thread_id will change. Also resources
bundled to the connection (prepared statements, locks, temporary
tables, ...) will be released.
Return value
Returns zero on success, nonzero if an error occured.
See also
o mysql_optionsv(3)
o mysql_kill(3)
Version 3.3.1 mysql_ping(3)