Which two preventative actions should you take if your number of monitored MySQL instances has changed?
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?(innodb_buffer_pool_size).Reference: https://dev.mysql.com/doc/refman/5.6/en/innodb-buffer-pool.html
Question:
Which two preventative actions should you take if your number of monitored MySQL instances has changed?
Options:
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
Correct Answer
The Correct Answer for this Question is
Increase the disk space with at least 10% of the database size.
Tune the InnoDB Buffer Pool of the MySQL Enterprise Monitor Repository database. This can have a significant impact on performance