Q81.The replication for master ad slave MySQL Server is up and running .The disk space occupied by the binary log files continues to grow.
Which two methods mange this issue?
A)Execute the FLUSH LOGS statement.
B)Delete all binary log files manually a=on the file system to release storage space.
C)Execute the PURGE BINARY LOGS statement.
D)On the master server,disable binary logging by removing the --log-bin option
E)Set the binlog_expire_logs_seconds variable.
Answer:CE
Q82.Examine this list of MySQL data directory binary logs:
Binlog.000001
Binlog.000002
........
Binlog.000289
Binlog.000300
Binlog.000301
Binlog.index
Now examine this command, which executes successfully:
Mysqldump --delete-master-logs--all-databases>/backup/db_backup.sql
Which two are true?
A)All databases are backed up to the output file.(不会备份sys、information_schema、performace_schema)
B)All details regarding deleted logs and master metadata are captured i