Documentation Home
MySQL Enterprise Monitor 2.3 Manual
Related Documentation Download this Manual
PDF (US Ltr) - 4.0Mb
PDF (A4) - 4.0Mb
EPUB - 3.2Mb
HTML Download (TGZ) - 3.1Mb
HTML Download (Zip) - 3.1Mb

2.3 The Advisors Tab


MySQL Enterprise subscription, MySQL Enterprise Monitor, MySQL Replication Monitor, and MySQL Query Analyzer are only available to commercial customers. To learn more, see:

MySQL Enterprise Advisors are a series of scripts that gather information from your MySQL servers via the Service Manager and the Monitor Agents, analyze that information based on custom rules included as part of MySQL Enterprise Monitor, and then offer alerts and advice when necessary. As new rules are introduced, the MySQL Enterprise Advisors can be updated over the Web.

The MySQL Enterprise Advisors are classified under the following categories (advisor groups):

  • Administration:

    • Better manage databases.

    • Suggest improvements for smoother operation.

  • Backup:

    • Confirm whether backup jobs succeed or fail.

    • Check how long various stages of backup jobs take.

    • Works with MySQL Enterprise Backup 3.5.3 and up. Relies on the logging feature described in the MySQL Enterprise Backup documentation at Using the MySQL Enterprise Backup Logs.

  • Cluster:

    • Shows the up/down status of MySQL Cluster data nodes.

    • Alert you when data node and index node memory runs low.

    • Alert you when Redo and Undo buffer and log space runs low.

  • Heat Chart:

    • Drive the status indicators in the Heat Chart.

    • Identify up/down status and performance issues.

  • Memory Usage:

    • Indicate how efficiently you are using various memory caches, such as the InnoDB buffer pool, MyISAM key cache, query cache, table cache, and thread cache.

  • Performance:

    • Identify potential performance bottlenecks.

    • Make suggestions for improved database speed.

  • Replication:

    • Identify replication bottlenecks.

    • Improve replication design.

  • Schema:

    • Identify schema changes.

    • Find security loopholes.

  • Security:

    • Protect MySQL servers.

    • Find security loopholes.

  • Upgrade:

    • Checks if your current MySQL version has critical issues and requires an update.

An advisor category provides a set of rules designed to enforce MySQL best practices for that specific category. Rules can be targeted to run at the individual server or group level and, upon rule violation, provide alerts and expert advice on how to address and correct a problem before it becomes a costly outage.

The file items-mysql-monitor.xml contains supplementary information used to construct rules. On Windows, this file is in the C:\Program Files\mySQL\Enterprise\Agent\share\mysql-monitor-agent directory and on Unix, in the /opt/mysql/enterprise/agent/share/mysql-monitor-agent directory. For example, the following rule detects a root account with no password.

    <![CDATA[SELECT COUNT(*) AS no_password FROM mysql.user WHERE user='root' AND password='']]>

Any MySQL Enterprise Monitor customer can use any of the available rules.

When the Dashboard is first installed, the only rules that are scheduled are those that belong to the Heat Chart group.

Go to the Advisors screen by logging in to the Dashboard and choosing the Advisors tab.

Download this Manual
PDF (US Ltr) - 4.0Mb
PDF (A4) - 4.0Mb
EPUB - 3.2Mb
HTML Download (TGZ) - 3.1Mb
HTML Download (Zip) - 3.1Mb
User Comments
Sign Up Login You must be logged in to post a comment.