FLUSH Statements
Explore commands to clear internal caches. Learn to use FLUSH to reload privileges, clear the query cache, or close open tables.
Last updated
Was this helpful?
Explore commands to clear internal caches. Learn to use FLUSH to reload privileges, clear the query cache, or close open tables.
Complete FLUSH statement reference: NO_WRITE_TO_BINLOG/LOCAL syntax, FLUSH TABLES WITH READ LOCK/FOR EXPORT, FLUSH STATUS, and SSL/TLS certificate reload.
Defragment the query cache to optimize memory usage. This command reorganizes the cache to eliminate fragmentation without removing existing cached queries.
Prepare individual tables for binary backup. This command flushes changes to disk and locks tables, allowing safe copying of .ibd files while the server runs.
Last updated
Was this helpful?
Was this helpful?