Chapter 17 Events

Table of Contents

17.1 Closing an Event
17.2 Notification of Events
Note

MySQL Enterprise Monitor is available as part of the MySQL Enterprise subscription, learn more at http://www.mysql.com/products/.

Once an advisor is enabled, it runs at set intervals. If it finds nothing of interest, it does not create events, which also means that notifications are not generated.

Events are defined using a number of different levels according to the severity of the alert. The eight levels are:

For convenience, the event states are also represented by icons, as defined in the following table. The table also shows the relative level of the alert from the highest (Emergency) to the lowest (Unknown). The order represented here is used when identifying when an event has transitioned between levels (for example, from Success to Critical), hence triggering a notification, and when sorting events based on their current state.

IconDescription
A red and orange flames icon indicates an emergency alert.
An round red icon indicates a critical alert.
A triangular yellow icon indicates a warning.
An blue octagon with the letter "i" indicates an informational alert.
A green check beside an event indicates that the Advisor has run successfully and no alert created.
A skull icon indicates that the status of the Advisor is unknown.

When events are triggered, they appear on the Events screen. Emergency and Critical events also appear on the Overview screen. The notification group or groups associated with a specific advisor receive a notification when an alert is triggered. For more information about creating notification groups, see Chapter 18, Event Handling.

To view open events, click the Events tab. The tree-view on the left determines which server or server group these events belong to. Open events are shown in tabular format.

Figure 17.1 MySQL Enterprise Monitor User Interface: Events Screen with Search enabled

MySQL Enterprise Monitor User Interface: Events screen with search enabled

The event table has the following columns:

By default, all events are shown but the list of events can be filtered using the form displayed above the event list. The options include filtering by:

Choose the options and click the Filter button to refresh the display. To limit the number of items that appear on a page, choose a different value from the Show entries dropdown list box.

The dropdown list box showing severity status has the options: Any, All Alerts, Emergency, Critical, >=Critical, Warning, >=WarningNotice, Warning, Success, and Unknown. The default option (any) shows all events, and also those advisors that have run successfully.

A 'successful' Event is one that currently evaluates past the level of the "Success" threshold, and is indicated by a green tick icon.

The All Alerts shows only those advisors that have been violated.

Some columns can be sorted by clicking the individual column headings. The alerts shown in Figure 17.1, “MySQL Enterprise Monitor User Interface: Events Screen with Search enabled”.

The server shown in Figure 17.1, “MySQL Enterprise Monitor User Interface: Events Screen with Search enabled”, is filtered for Any. Typically, when filtering by severity you choose All Alerts and, if you see an Emergency Critical, Warning, or Notice alert, use the All Alerts filter to see when the rule last ran successfully. Narrowing down the time frame can help determine the cause of the alert.

Besides filtering for severity, you can filter for a specific time period using the Time Range dropdown. You can also filter by specific rules or categories of rules. The State dropdown list box lets you choose Open or Closed events. To avoid excessive scrolling, you can also limit the number of events shown on a specific page.

For more information about an alert, click anywhere on the row with the rule name. A slider window appears, showing a description of the alert and the exact time of occurrence. This slider provides links to useful resources and advice for resolution.

For expression-based advisors, where possible, the results of the expression are listed in the Evaluated Expression section of the Details frame.