Exhibit:

What does the possible_keys column in this output denote?

You have a MySQL instance running in a single cpu (1vCPU) VM in a shared infrastructure environment.
Your users are complaining that MySQL is sporadically slow and you have a suspicion that the VM infrastructure host is at fault due to resource contention.
You review the output of your scripts that monitor the database VM operating system during an extended period of slowdown.
What are the two most common indicators of the VM infrastructure host being at fault due to resource contention? (Choose two.)

Which MySQL utility copies the master instance to a slave instance on the same host?

Consider the key buffer in a MySQL server. Which two statements are true about this feature?

The 'applicationdb' is using InnoDB and consuming a large amount of file system space. You have a / backuppartition available on NFS where backups are stored.
You investigate and gather this information:

Three tables are stored in the InnoDB shared tablespace and the details are as follows:
* The table data_currenthas 1,000,000 rows.
* The table data_reports has 1,500,000 rows.
* The table data_archivehas 4,500,000 rows.

You attempt to free space from ibdata1by taking a mysqldump of the data_archivetable and storing it on your backup partition.

Unfortunately, this action does not free any actual disk space back to the file system and the server disk space is running out.
Which set of actions will allow you to free disk space back to the file system?