关于MYSQL flush table的作用
关于MYSQL flush table的作用 水平有限,还待学习。如有错误,请指正。 先给出官方文档: ? FLUSH TABLES Closes all open tables, forces all tables in use to be closed, and flushes the query cache. FLUSH TABLES also removes all query results from the query cache, like the RESET QUERY CACHE statement. In MySQL 5.6, FLUSH TABLES is not permitted when there is an active LOCK TABLES ... READ. To flush and lock tables, use FLUSH TABLES tbl_name... WITH READ LOCK instead. ? FLUSH TABLES tbl_name[, tbl_name] ... With a list of one or more c...