You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-type is set to DATABASE.

Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output?

What three are correct statements about MySQL backups? (Choose three.)

After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is:

What are the two most likely reasons for the slowness given this output?

You have been tasked with creating a QA MySQL instance on a DB host, which already has one large instance in /var/lib/mysql/running as the mysqluser. The MySQL configuration file for the existing instance includes:

The default instance was installed using the OS package manager. The latest binaries for both client and server are already in ENV PATH.
The new instance will run as a different user from the existing instance for security purposes.
You create the new data directory successfully and move on to initialize the new DATADIR.
You verify the output to confirm the operation's success:
[mysqlQA@linux /var/lib/]$ mysqld --initialize --datadir=/var/lib/mysql_QA 2>&1 | tail -n3
2018-05-03T12:16:10.928809Z 0 [ERROR] Could not open file '/var/log/mysqld.log' for error logging:
Permission denied
2018-05-03T12:16:10.928841Z 0 [ERROR] Aborting
[mysqlQA@linux /var/lib/]$
The initialization of the instance has failed.
What would you do to enable the initialization to succeed?

Consider that local disk files are accessible via MySQL with commands such as:
mysql> LOAD DATA LOCAL INFILE `/etc/passwd' INTO TABLE mypasswords; What change could be made to stop any breach via this insecurity?