| mysql_refresh(3) | MariaDB Connector/C | mysql_refresh(3) |
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 by mysql_init(3) and connected by mysql_real_connect(3).
- •
- options - a bit masked composed integer. See below.
options can be any combinationation 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 `|'.
- •
- mysql_reload() is an alias for mysql_refresh().
Return value
Returns zero on success, otherwise non zero.
| Version 3.3.1 |