<< Prev Question Next Question >>

Question 13/30

The data in this instance is transient; no backup or replication will be required. It is currently under performing.
The database size is static and including indexes is 19G.
Total system memory is 32G.
After profiling the system, you highlight these MySQL status and global variables:

The OS metrics indicate that disk is a bottleneck. Other variables retain their default values.
Which three changes will provide the most benefit to the instance? (Choose three.)

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (30q)
Question 1: Which two statements are true about using backups of the bin...
Question 2: An existing asynchronous replication setup is running MySQL ...
1 commentQuestion 3: You plan to install MySQL Server by using the RPM download. ...
Question 4: Examine this command, which executes successfull mysqlbackup...
Question 5: Examine this command and output: (Exhibit) Which two stateme...
Question 6: Which step or set of steps can be used to rotate the error l...
Question 7: Which two statements are true about InnoDB data-at-rest encr...
Question 8: Which two are use cases of MySQL asynchronous replication? (...
Question 9: A colleague complains about slow response time on your websi...
Question 10: You wish to store the username and password for a client con...
1 commentQuestion 11: Examine this SQL statement: mysql&gt; GRANT r_read@localhost...
Question 12: Which two statements are true about the mysql_config_editor ...
Question 13: The data in this instance is transient; no backup or replica...
Question 14: A user wants to connect without entering his or her username...
Question 15: Examine these statements, which execute successfully: CREATE...
Question 16: What does the binlog dump thread do?...
Question 17: Which two are characteristics of snapshot-based backups? (Ch...
Question 18: Which two queries are examples of successful SQL injection a...
Question 19: Examine this command and output: (Exhibit) Which two options...
Question 20: You want to log only the changes made to the database object...
Question 21: Consider this shell output and executed commands: [root@oel7...
Question 22: Examine this MySQL client command to connect to a remote dat...
Question 23: Which three settings control global buffers shared by all th...
2 commentQuestion 24: A MySQL server is monitored using MySQL Enterprise Monitor's...
Question 25: Examine these statements and output: (Exhibit) Which stateme...
Question 26: You wish to protect your MySQL database against SQL injectio...
Question 27: Which statement is true about InnoDB persistent index statis...
Question 28: Examine these entries from the general query log: (Exhibit) ...
Question 29: You encountered an insufficient privilege error in the middl...
Question 30: Examine these statements, which execute successfully: TRUNCA...