Question 1

You have a MySQL instance with the following variables in the /etc/my.cnf file:

You issue these statements:
USE prices;
UPDATE sales.january SET amount=amount+1000;
An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.
Which statement is true? (Choose two.)
  • Question 2

    A single InnoDB table has been dropped by accident. You are unable to use an additional intermediate MySQL instance to restore the table. Which two backup methods can be used to restore the single table without stopping the MySQL instance? (Choose two.)
  • Question 3

    Recently, users on mostly-write MySQL database have been complaining of slowdowns or stalls in their applications.
    Which option is most likely to have a positive effect on the server's health and performance?
  • Question 4

    The MySQL error log shows:
    InnoDB: Warning: a long semaphore wait:
    The relevant parts of the InnoDB monitor output shows:

    Which two options would help avoid the long wait in the future?
  • Question 5

    Which three statements correctly describe MySQL InnoDB Cluster?