• MySQL知识库 :: performance
  • What are the MySQL Enterprise Monitor Advisors?

  • Discussion

    The MySQL Enterprise Monitor Advisor Rules are a set of MySQL supplied best practices that allow DBAs to implement new MySQL servers with confidence and to proactively manage the dynamic nature of all of their MySQL servers over time. The MySQL Advisor Rules do this by monitoring all MySQL servers for adherence to MySQL recommended configuration and server settings and notifying the DBA with specific instructions to address located exceptions and align them with MySQL best practices. To this end, the Enterprise Monitor employs over 100 MySQL Advisor Rules that monitor over 600 MySQL and OS specific variables and metrics that track and report on the overall health, security, availability and performance of each MySQL server.

    The Enterprise Monitor ships with the following set of MySQL Advisors:

    • Administration Advisor
      Monitors and advises on problems relating to general database administration, recoverability and performance configuration settings.
    • Upgrade Advisor
      Monitors and advises on specific bugs that can potentially impact versions of MySQL Enterprise Server deployed within an environment. Advises on specific upgrade path to version of MySQL that provides fix for identified bugs.
    • Performance Advisor
      Monitors and advises on deviations from MySQL performance best-practice rules.
    • Schema Advisor
      Monitors and advises on unexpected changes to database schema and objects.
    • Memory Usage Advisor
      Monitors and advises on the optimal use of memory and cache settings for specific MySQL implementations.
    • Security Advisor
      Monitors and advises on security vulnerabilities in a MySQL Server.
    • Replication Advisor
      Monitors and advises on issues relating to replication setup, synchronization or performance problems.
    • Custom Advisor
      Allows a DBA to define best practices to fit their organization's specific needs.

    Each of the Advisors is designed to cover specific DBA areas of concern and is comprised of a set of Advisor Rules that help DBAs proactively find problems and tuning opportunities they may not have the time or expertise to find themselves. For new servers, added as part of a scale-out strategy, there are specific Advisor Rules that monitor configuration variables and settings for optimal recoverability, performance, and security. From a security standpoint, the Security Advisor Rules monitor for the presence of security loopholes that leave a new MySQL server vulnerable to malicious attack. For existing MySQL servers, there are specific Memory Usage, Performance, Security, Schema, and Replication Advisor Rules that track and alert on dynamic metrics, so that DBAs can proactively address things like security violations, poor cache hit ratios, poorly utilized indexes, or replication synch issues before they impact application performance and ultimately the end user.

    For DBAs with advanced monitoring needs, the MySQL Advisors can be extended to include custom Advisor Rules that monitor existing metrics or that the DBA opts to collect from the MySQL server. DBAs can easily copy and edit the MySQL provided Advisor Rules to better meet their organizations' specific needs. They can also create Rules and evaluated expressions from scratch using the MySQL provided template and the MySQL and OS variables and counters collected by the Enterprise Monitor.