ZBLOG

mysql FLUSH NO_WRITE_TO_BINLOG tables;

The FLUSH NO_WRITE_TO_BINLOG tables command is used to flush all tables from the query cache and prevent any further writes to the binary log. This command does not delete or truncate any data from the tables.

When executed, this command will ensure that all queries run on the server after it has been executed will not be written to the binary log. This can be useful in situations where you want to perform administrative tasks or maintenance on a database without logging these actions in the binary log.

It’s important to note that executing this command may result in loss of data if there are any ongoing transactions that are not yet committed to the database. Therefore, it should be used with caution and only when necessary.

本站部分文章来源于网络,版权归原作者所有,如有侵权请联系站长删除。
转载请注明出处:https://golang.0voice.com/?id=5137

分享:
扫描分享到社交APP
上一篇
下一篇
发表列表
游客 游客
此处应有掌声~
评论列表

还没有评论,快来说点什么吧~

联系我们

在线咨询: 点击这里给我发消息

微信号:3007537140

上班时间: 10:30-22:30

关注我们
x

注册

已经有帐号?