mysqli::refresh

Name:mysqli::refresh

Category:MySQLi

Programming Language:php

One-line Description:Refresh/empty table or cache, or reset replication server information.

Definition and usage

refresh() / mysqli_refresh() function refreshes/clears table or cache, or resets the replication server information.

 $mysqli -> refresh ( options )

 mysqli_refresh ( connection , options )

parameter	describe
connection	Required. Specify the MySQL connection to use
options	Options to refresh. It can be one or more of the following (separated by OR): MYSQLI_REFRESH_GRANT - Refresh the authorization table MYSQLI_REFRESH_LOG - Clear logs MYSQLI_REFRESH_TABLES - Clear table cache MYSQLI_REFRESH_HOSTS - Clear host cache MYSQLI_REFRESH_STATUS - Reset status variables MYSQLI_REFRESH_THREADS - Clear thread cache MYSQLI_REFRESH_SLAVE - Reset the master server information and restart the slave server MYSQLI_REFRESH_MASTER - Delete binary log files in binary log index and truncate index file

parameter

describe

connection

Required. Specify the MySQL connection to use

options

Options to refresh. It can be one or more of the following (separated by OR):

MYSQLI_REFRESH_GRANT - Refresh the authorization table
MYSQLI_REFRESH_LOG - Clear logs
MYSQLI_REFRESH_TABLES - Clear table cache
MYSQLI_REFRESH_HOSTS - Clear host cache
MYSQLI_REFRESH_STATUS - Reset status variables
MYSQLI_REFRESH_THREADS - Clear thread cache
MYSQLI_REFRESH_SLAVE - Reset the master server information and restart the slave server
MYSQLI_REFRESH_MASTER - Delete binary log files in binary log index and truncate index file