mysql_ping(3)

💖 NAME 💖

okay so bestie, this is mysql_ping(3) from MariaDB Connector/C — the function that 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 the 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 🎀

• mysql — a mysql handle, which was previously allocated by mysql_init(3) and connected by mysql_real_connect(3). 🦋

🫶 NOTES 🫶

• If a reconnect occurred the thread_id will change. Also resources bundled to the connection (prepared statements, locks, temporary tables, ...) will be released. 😭

⚠️ Important: if a reconnect occurred, the thread_id will change, and resources bundled to the connection (prepared statements, locks, temporary tables, ...) will be released. 💀

🌈 RETURN VALUE 🌈

Returns zero on success, nonzero if an error occurred. ✅❌

👑 SEE ALSO 👑

• mysql_optionsv(3)
• mysql_kill(3)

Source: MariaDB Connector/C — Version 3.4. That's the footer energy, bestie. No cap. 💅✨