The 'applicationdb' is using InnoDB and consuming a large amount of file system space. You have a /backup partition available on NFS where backups are stored.
You investigate and gather this information:
* The table data_current has 1,000,000 rows.
* The table data_reports has 1,500,000 rows.
* The table data_archive has 4,500,000 rows.

Three tables are stored in the InnoDB shared tablespace and the details are as follows:

You attempt to free space from ibdata1 by taking a mysqldump of the data_archive table 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?

An admin attempts to enforce stronger security by using these commands:

The admin then leaves the system running with the specified changes. What are two remaining security concerns?

Consider the two partial outputs of the SHOW GLOBAL VARIABLEScommand from a master and slave server:
Master:

Slave:

There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?

Host slave1 has ip address 192.0.2.10.
Host slave2 has ip address 203.0.113.50
Examine these commands:

Why did this error occur?

Consider these global status variables:

Which two conclusions can be made from the output?