mysql_refresh
You are viewing an old version of this article. View
the current version here.
Syntax
int mysql_refresh(MYSQL * mysql, unsigned int options);
mysql- a mysql handle, which was previously allocated by mysql_init() or mysql_real_connect().options- a bit masked composed integer. See below.
Description
Flushes different types of information stored on the server. The bit-masked parameter options specify which kind of information will be flushed. options can be any combinationation of the following:
| 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. |
| REFRESH_READ_LOCK | |
| REFRESH_FAST |
Returns zero on success, otherwise non zero.
To combine different values in the options parameter use the OR operator '|'. The function mysql_reload() is an alias for mysql_refresh().
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
