mysql_refresh3
Name
mysql_refresh - flushes information on the server
Synopsis
-
#include <mysql.h> int mysql_refresh(MYSQL * mysql, unsigned int options);
Description
Flushes different types of information stored on the server. The bit-masked parameter options specify which kind of information will be flushed.
Parameters
- •
-
mysql- a mysql handle, which was previously allocated bymysql_init(3)and connected bymysql_real_connect(3).
- •
-
options- a bit masked composed integer. See below.
options can be any combination of the following flags:
| Option | Description |
REFRESH_GRANT | Refresh grant tables. |
REFRESH_LOG | Flush logs. |
REFRESH_TABLES | Flush table cache. |
REFRESH_HOSTS | Flush host cache. |
REFRESH_STATUS | Reset status variables. |
REFRESH_THREADS | Flush thread cache. |
REFRESH_SLAVE | Reset master server information and restart slaves. |
REFRESH_MASTER | Remove binary log files. |
Notes
•
|
To combine different values in the options parameter use the OR operator `|'. |
|---|---|
•
|
|
Return value
Returns zero on success, otherwise non zero.
Releases
3 releases since Debian 12 (Bookworm); the text changed 1 time.