总之,FLUSH NO_WRITE_TO_BINLOG BINARY LOGS是一个高级管理命令,主要用于在不影响复制的前提下,执行特定的维护或管理操作。
执行flush命令会默认写入二进制日志,以便能够把该操作的状态同步到Slave,如果不想写入二进制日志,则加上NO_WRITE_TO_BINLOG或其别名LOCAL参数。 注:FLUSH LOGS、FLUSH TABLES WITH READ LOCK (withor without a table list)、FLUSH TABLES tbl_name ... FOREXPORT在任何情况下都不会写入到二进制日志,因为如果这...
FLUSH [NO_WRITE_TO_BINLOG | LOCAL] { flush_option [, flush_option] ... } flush_option: { BINARY LOGS | DES_KEY_FILE | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | HOSTS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | QUERY CACHE | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | STATUS...
FLUSH[NO_WRITE_TO_BINLOG|LOCAL]{flush_option[,flush_option]...|tables_option}flush_option: {BINARYLOGS|ENGINELOGS|ERRORLOGS|GENERALLOGS|HOSTS|LOGS|PRIVILEGES|OPTIMIZER_COSTS|RELAYLOGS[FORCHANNELchannel]|SLOWLOGS|STATUS|USER_RESOURCES}tables_option: {table_synonym|table_synonymtbl_name[,tbl_name]...
FLUSH [NO_WRITE_TO_BINLOG | LOCAL] flush_option [, flush_option] ... 执行flush命令会默认写入二进制日志,以便能够把该操作的状态同步到Slave,如果不想写入二进制日志,则加上NO_WRITE_TO_BINLOG或其别名LOCAL参数。 注:FLUSH LOGS、FLUSH TABLES WITH READ LOCK (with or without a table list)、FLUSH...
。Local(或NO_WRITE_TO_BINLOG)表示不写入Binlog,即不会同步到slave节点。 向服务器发送SIGNUP指令会触发某些flush操作。 reset语句类似于flush。 FLUSH BINARY LOGS 关闭并且重新打开正在写的binlog。在binlog开启的情况下,这个命令会让binlog文件增加一个 ...
FLUSH [NO_WRITE_TO_BINLOG |LOCAL] flush_option [, flush_option] ... ……… The RESET statementissimilartoFLUSH. See [HELP RESET],for information about using the RESET statementwithreplication. URL: http://dev.mysql.com/doc/refman/5.5/en/flush.html 从...
FLUSH[NO_WRITE_TO_BINLOG|LOCAL]{flush_option[,flush_option]...|tables_option}flush_option: {BINARYLOGS|DES_KEY_FILE|ENGINELOGS|ERRORLOGS|GENERALLOGS|HOSTS|LOGS|PRIVILEGES|OPTIMIZER_COSTS|QUERYCACHE|RELAYLOGS[FORCHANNELchannel]|SLOWLOGS|STATUS|USER_RESOURCES}tables_option: {table_synonym|table_syno...
By default,FLUSHstatements are written to thebinary logand will bereplicated. TheNO_WRITE_TO_BINLOGkeyword (LOCALis an alias) will ensure the statement is not written to the binary log. The different flush options are: OptionDescription
NO_WRITE_TO_BINLOGLOCAL FlushOption PRIVILEGESSTATUSTIDBPLUGINSPluginNameListHOSTSLogTypeOptLOGSTableOrTablesTableNameListOptWithReadLockOpt LogTypeOpt BINARYENGINEERRORGENERALSLOW TableOrTables TABLETABLES TableNameListOpt TableNameList WithReadLockOpt ...