MySQL Enterprise Monitor is available as part of the MySQL Enterprise subscription, learn more at http://www.mysql.com/products/.
MySQL Enterprise Advisors gather information from your MySQL Instances via the Agent, analyze that information, and then offer advice, create Events, and provide Graphs and Reports when necessary.
This section is available at the top and at the bottom of the page. It contains seven buttons that let you:
The search filter icon ( ) opens up a search, with filters for Advisor, Group, and Asset.
Edit Selected Advisors: Edit the configuration for one or more selected Advisors.
Disable Selected Advisors: Disable one or more selected Advisors.
Create Advisor: Create a new Advisor.
Import/Export: Import/export custom Advisor rules and Graph data.
Only custom advisors and graphs can be imported/exported.
Select All: Select all visible Advisors, which only includes advisors of expanded categories.
Expand All: Expand all Advisor categories.
Collapse All: Collapse all Advisor categories.
The MySQL Enterprise Advisors are classified under the following categories:
Administration: Suggests improvements for smoother operations and better database management.
Agent: Checks the status of each MySQL Enterprise Monitor Agent.
Availability: Advisors related specifically to MySQL process and connection availability.
Backup: Checks whether backup jobs succeed or fail, required resources, and information about MySQL Enterprise Backup specific tasks.
Cluster: MySQL Cluster related Advisors.
Graphing: Advisors that provide data for the graphs.
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.
Monitoring and Support Services: Advisors related to the MySQL Enterprise Monitoring services itself.
Operating System: Advisors about Host (rather than MySQL Instance) Operating System performance.
Performance: Identifies potential performance bottlenecks, and suggests optimizations.
Query Analysis: Advisors related to Queries and Query Analysis.
Replication: Identifies replication bottlenecks, and suggests replication design improvements.
Schema: Identifies schema changes.
Security: Protects MySQL Servers and discovers security loopholes.
Advisor Category groups a set of Advisors that
are designed to enforce MySQL best practices for that specific
Each Advisor Category panel contains a table listing of Advisors in that category. This table is a "tree-table", showing the hierarchy of Monitoring Assets. The row containing the Advisor itself represents a "global" scope: the Advisor being evaluated for every appropriate type of Asset in your entire monitored infrastructure. If you expand the "global" scope, underneath are all defined Groups. Expanding each Group displays the appropriate type of Monitored Assets in that Group (MySQL Instances, Hosts, Agents, etc.). Advisors can be configured against nodes in this hierarchy to represent overrides.
For example, while all Advisors are scheduled "globally" by default, you might want to have different Advisor thresholds for MySQL Instances in hypothetical "Dev" and "Production" Groups. Furthermore, if you had an MySQL Instance in the "Dev" group that had exceptional demands due to, say, a load test, you could then configure the Advisor to have different thresholds just for that one Instance. As well, Advisors can be Disabled for any node or sub-tree in the hierarchy.
The table is divided by six columns:
Item: Displays the Advisor name, Group name, or Asset name.
Clicking the [+] (plus) button next to a specific Advisor shows the Groups that this Advisor is available on, and clicking [+] on a group shows the assets. Advisors can be configured at any level.
Clicking the checkbox besides a column header or each Advisor/Group/Asset name and selects them.
Clicking the (drop-down) icon besides a specific Advisor/Group/Asset shows the menu.
Info: Displays a help (help) icon on each Advisor column. For a more complete description of an Advisor, click the tooltip icon.
Coverage: Displays the Assets coverage percentage on an Advisor row.
Displays "(Covered)" if the Group/Asset is covered with the Advisors/Group configuration.
Displays an empty string if the Group/Asset redefines the Advisor/Group configuration.
Schedule: Displays the evaluation schedule of an Advisor. The Advisor may display:
Not Configured if the Advisor is not configured.
Disabled if the Advisor is disabled.
Every time the Advisor is a Group/Asset override, the Advisor/Group configuration appears in bold text.
Event Handling: Displays the (close) icon followed by the number of auto-close event handlers configured. Hovevering over this icon lists the matching event handlers, and if that states "Default Auto-close Policy", it means that the Advisor in-focus has a default auto-close policy. The icon followed by the number of SMTP event handlers configured, the icon followed by the number of SNMP Event handlers configured. Hovering the mouse over an icon displays additional information, including the names of configured event handlers.
These icons become saturated (colored) when there are related Event Handlers. For more information, see Chapter 16, Event Handling.
Parameters: Displays the Advisor configuration parameter values: thresholds and other Advisor evaluation parameters.
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.
When the MySQL Enterprise Monitor User Interface is first installed, all Advisors are enabled by default.
To edit a single Advisor, click the Advisor schedule drop-down icon to the left of the Advisor/Group/Asset title, and choose Edit Advisor Configuration or Override Advisor Configuration. Or if you are editing multiple Advisors, select them and click the Edit Selected Advisors button on the top left of the page. It will then display a dialog box similar to:
Advisors can have multiple types of parameters.
The most common pattern for Parameters are the thresholds. The four levels of Thresholds, which are Notice, Warning, and Critical, and Emergency, indicate increasing levels of severity. Events can be created by the Advisor evaluation result being equal to a certain value, greater than a certain value, or less than a certain value.
For instructions on setting up notification groups, see Chapter 16, Event Handling. Once you have set the Advisor parameters, click Save.
The Schedule dialog box lets you configure several fields, as described below.
Schedule Type: The type of schedule to use to collect data for this Advisor to evaluate.
Fixed Rate: Collect data for this Advisor on the schedule defined specifically. For example, if the schedule is set to 1 minute, and data collection executes at 12:00:00, it will execute the next data collection at 12:01:00, no matter how long the initial collection takes.
Fixed Delay: Collect data for this Advisor on the schedule, but will reset when it will next run only on completion of the last collection. For example, if it is set to 1 minute, and data collection executes at 12:00:00, taking 10 seconds to run, it will execute the next data collection at 12:01:10.
Disabled: Disables the Advisor.
Interval: Is defined after you choose your Schedule Type, and behaves accordingly. It dictates how often the Advisor evaluates. The Default value for different Advisors varies, but an Advisor can be set to run at any interval desired.
Some Advisors are "On Demand", such as the expensive Advisor that populates the InnoDB Buffer Pool graph, and they are not listed on the Advisors page.
When upgrading MySQL Enterprise Service Manager 3.x to 3.x, new Advisors are auto-scheduled.
To remove an Advisor configuration override, use the menu to the left of the Advisor, Group or Asset name, depending on what level of override you would like to remove. If you remove a configuration override, the selected node and its children will inherit the Advisor configuration of their parent.
It will then display a confirmation dialog similar to:
To Disable and Advisor, click on the Advisor menu drop-down icon ( ) to the left of the Advisor, Group or Asset title, and choose "Disable Advisor". If you're disabling multiple Advisors, select them and click the Disable Selected Advisors button at the top of the page. It will then display a dialog box similar to:
Graphs that depend on a disabled Advisor will automatically be removed.