MySQL - Managing MySQL Performance Logs MCQ

MySQL – Managing MySQL Performance Logs MCQ

1 / 26

1. What is the primary purpose of the MySQL error log?

To log slow queries

To store binary log data

To record general SQL queries

To capture critical errors and warnings

2 / 26

2. Which MySQL log records all SQL statements sent to the server?

Slow Query Log

Error Log

Binary Log

General Query Log

3 / 26

3. What is the primary use of the slow query log in MySQL?

To store binary log data

To capture critical errors and warnings

To log queries that exceed a time threshold

To record all SQL statements

4 / 26

4. What can be a potential drawback of enabling the general query log in a production MySQL environment?

Increased disk space usage

Reduced query execution time

Increased server performance

Improved query optimization

5 / 26

5. What MySQL log contains records of changes to the database, such as INSERT, UPDATE, DELETE, and DDL statements?

Slow Query Log

Error Log

Binary Log

General Query Log

6 / 26

6. How can you configure log rotation for MySQL performance logs?

Configure rotation settings in my.cnf

It is not possible to configure log rotation

Use third-party tools

Manually delete old log files

7 / 26

7. Which log is used to identify and optimize poorly performing queries in MySQL?

Slow Query Log

Binary Log

Error Log

General Query Log

8 / 26

8. What SQL variable controls the threshold time for queries to be logged in the slow query log?

long_query_time

query_threshold_time

slow_query_threshold

log_slow_queries_threshold

9 / 26

9. Which log should be protected to prevent unauthorized access due to potentially sensitive information?

Binary Log

General Query Log

Slow Query Log

Error Log

10 / 26

10. What should you consider when enabling the general query log in MySQL?

It requires server downtime to enable

It has no impact on performance

It only logs errors and warnings

It may consume significant disk space

11 / 26

11. Which log can be used for point-in-time recovery and replication in MySQL?

Binary Log

General Query Log

Error Log

Slow Query Log

12 / 26

12. What is log retention policy in the context of MySQL performance logs?

A policy to prevent log rotation

A policy to retain log records indefinitely

A policy to define the log verbosity level

A policy to archive log files

13 / 26

13. Which log contains records of all changes to the database and is essential for replication and auditing?

Slow Query Log

Binary Log

General Query Log

Error Log

14 / 26

14. What action can help prevent MySQL performance log files from consuming excessive disk space?

Implementing log rotation

Increasing the log verbosity level

Disabling log recording altogether

Setting long_query_time to 0

15 / 26

15. Which log should you review to identify queries that take longer than a predefined threshold to execute?

General Query Log

Error Log

Binary Log

Slow Query Log

16 / 26

16. What is the primary disadvantage of enabling the general query log in a production MySQL environment?

Reduced server performance

Improved query optimization

Enhanced query execution time

Increased disk space usage

17 / 26

17. What can you achieve by analyzing the slow query log in MySQL?

Monitor server uptime

Record critical errors and warnings

Optimize poorly performing queries

Identify unauthorized access attempts

18 / 26

18. What should you do to protect sensitive information in MySQL performance logs?

Restrict access to authorized personnel

Store logs in plaintext format

Disable log rotation

Share log files with external parties

19 / 26

19. What log can be used to diagnose and resolve critical errors and warnings in MySQL?

General Query Log

Error Log

Binary Log

Slow Query Log

20 / 26

20. How can you prevent the binary log from growing indefinitely in MySQL?

Disable binary logging

Decrease the log verbosity level

Enable the log rotation feature

Manually delete log files

21 / 26

21. Which MySQL log is best suited for capturing unauthorized access attempts or security-related events?

Slow Query Log

Error Log

General Query Log

Binary Log

22 / 26

22. What is the primary benefit of log rotation in MySQL?

It improves query performance

It enhances server security

It reduces disk space usage

It prevents log files from growing too large

23 / 26

23. What action should you take if a MySQL performance log file becomes too large?

Rename the log file to a shorter name

Increase the log verbosity level

Manually delete or archive old log files

Disable log rotation

24 / 26

24. Which MySQL log records all SQL statements sent to the server, including those that may affect performance?

Binary Log

Slow Query Log

Error Log

General Query Log

25 / 26

25. How can you automate the analysis of MySQL performance logs for anomalies and critical issues?

Implement log rotation

Disable log recording

Manually review logs

Use automated log analysis tools

26 / 26

26. What is the purpose of log files retention policies in MySQL?

To define the threshold for slow queries

To manage the lifespan of log files

To increase log verbosity

To archive log files

Your score is