MySQL 8.0 Database Administrator — Question 35

Your MySQL installation is running low on space due to binary logs. You need to reduce your log space usage urgently.
Which two sets of actions when completed will accomplish this? (Choose two.)

Answer options

• A. Use SET GLOBAL binlog_expire_logs_seconds=<value> and restart the server.
• B. Set binlog_expire_logs_seconds in my.cnf.
• C. Set binlog_expire_logs_seconds = 0 in my.cnf and restart the server.
• D. Use SET PERSIST binlog_expire_logs_seconds=<value>.
• E. Use PURGE BINARY LOGS to <binlog_name>.
• F. Use SET GLOBAL binlog_expire_logs_seconds=<value> and run the FLUSH BINARY LOGS command.

Correct answer: A, D

Explanation

The correct answer includes A and D. Option A helps set the expiration for binary logs immediately, while D sets the expiration persistently. Options B and C do not provide immediate relief without a restart or require a configuration file change. Option E is not relevant for reducing log space usage directly, and F does not effectively manage log expiration.