You enable binary logging on MySQL Server with the configuration:
binlog-format=STATEMENT
log-bin
Which database updates are logged on the master server to the binary log by default?
A. all updates except to the TEMPDB database
B. all updates except to the PERFORMANCE_SCHEMA database
C. all updates not involving temporary tables
D. all updates to the default database, except temporary tables
E. all updates to all databases
Answer: E
你启用了基于STATEMENT的binlog,下面哪些操作默认会写入binlog?
A.除了TEMPDB数据库以外的所有updates
B.除了PERFORMANCE_SCHEMA数据库以外的所有updates
C.不涉及临时表的所有updates
D.针对default database的所有updates,不包含临时表
E.所有updates
日志文件包含所有报表所做的任何更改,因此可以用来审计数据库https://www.cndba.cn/hbhe0316/article/22798https://www.cndba.cn/hbhe0316/article/22798
版权声明:本文为博主原创文章,未经博主允许不得转载。
MYSQL