Question: 1
Consider these global status variables:
Which two conclusions can be made from the output?
Question: 2
You inherited a busy InnoDB OLTP Instance with 100 schemas and 100 active users per schem
a.
Total dataset size is 200G with an average schema size of 2G.
The data is transient and is not backed up and can be repopulated easily.
Performance and responsiveness of the DB is paramount.
The query pattern for the DB instance is split 90/10 read/write.
DB host is dedicated server with 256G RAM and 64 cores.
One of your colleagues made some recent changes to the system and users are now complaining of
performance impacts.
Which four configuration file edits might your colleague have performed to cause the negative DB
performance?
Question: 3
You have the following in your my.cnf configuration file:
[mysqld]
default_authentication_plugin=sha256_password
You want to create a new user who will be connecting from the IP address 192.0.2.10, and you want to use the authentication plug-in that implements SHA-256 hashing for user account passwords.
Which two statements would create a user named webdesign for this IP address with the password of imbatman using a SHA_256 password hash?
Question: 4
A MySQL database uses all InnoDB tables and is configured as follows;
You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.
Which two arguments will you pass to mysqldump to achieve this?
Question: 5
What two statements are true regarding FLUSH TABLES FOR EXPORT?