Definition and Usage
The refresh() / mysqli_refresh() function refreshes/flushes tables or caches, or resets the replication server information.
Syntax
Object oriented style:
text
$mysqli -> refresh(options)
Procedural style:
text
mysqli_refresh(connection, options)
Parameter Values
| Parameter | Description |
|---|---|
| connection | Required. Specifies the MySQL connection to use |
| options | The options to refresh. Can be one of more of the following (separated by OR): MYSQLI_REFRESH_GRANT - Refreshes the grant tables MYSQLI_REFRESH_LOG - Flushes the logs MYSQLI_REFRESH_TABLES - Flushes the table cache MYSQLI_REFRESH_HOSTS - Flushes the host cache MYSQLI_REFRESH_STATUS - Resets the status variables MYSQLI_REFRESH_THREADS - Flushes the thread cache MYSQLI_REFRESH_SLAVE - Resets the master server info, and restarts the slave MYSQLI_REFRESH_MASTER - Removes the binary log files in the binary log index, and truncates the index file |
Technical Details
| Return Value: | TRUE on success. FALSE on failure |
|---|---|
| PHP Version: | 5.3+ |