Question 3
You use MySQL Enterprise Monitor for a group of MySQL servers. In recent weeks, the MySQL Enterprise Monitor has slowed down significantly.
Which two preventative actions should you take if your number of monitored MySQL instances has changed?
Increase the disk space with at least 10% of the database size.
Increase the necessary operating system swap space (Linux): mkswap /dev/sdx; swapon/dev/sdx, /etc/fstab.
Increase the amount of RAM available to the JVM installed with Tomcat. The JVM memory settings are defined by the JAVA_OPTS line of the setenv file, which sets the environment variables for Tomcat (--JvmMs/-Xms and –JvmMx/-Xmx).
Tune the InnoDB Buffer Pool of the MySQL Enterprise Monitor Repository database. This can have a significant impact on performance (innodb_buffer_pool_size).
Correct answer: AD
Explanation:
Reference: https://dev.mysql.com/doc/refman/5.6/en/innodb-buffer-pool.html
Reference: https://dev.mysql.com/doc/refman/5.6/en/innodb-buffer-pool.html