Oracle MySQL 5.7 Database Administrator — Question 6

Which two methods accurately monitor the size of your total database size over time? (Choose two.)

Answer options

• A. monitoring the Innodb_rows_inserted status variable
• B. monitoring the innodb_redo_log_size variable
• C. monitoring the information_schema.TABLES table
• D. monitoring datadir size in the operating system
• E. monitoring cumulative Innodb_page_size increase
• F. monitoring the performance_schema_hosts_size variable

Correct answer: C, F

Explanation

The correct answers, C and F, are effective methods for monitoring database size. C provides a detailed view of table sizes within the database, while F allows for tracking specific performance metrics related to the schema size. The other options do not effectively measure the total database size over time or are not relevant to this specific monitoring task.