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

You may also like...

Leave a Reply

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