All pages
Powered by GitBook
1 of 1

Loading...

mysql_refresh

mysql_refresh flushes server-side caches and state using a bitmask of options such as REFRESH_GRANT, REFRESH_LOG, REFRESH_TABLES, and REFRESH_HOSTS.

Syntax

int mysql_refresh(MYSQL * mysql,
  unsigned int options);

Parameters

  • 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 combination of the following:

Option
Description

Returns zero on success, otherwise nonzero.

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_GRANT

Refresh grant tables.

REFRESH_LOG

Flush logs.

REFRESH_TABLES

Flush table cache.

Return Value

  • To combine different values in the options parameter, use the OR operator '|'.

  • The function mysql_reload() is an alias for mysql_refresh().

REFRESH_HOSTS

spinner