Chapter 13 User Interface
Prev |  | Next

## Chapter 13 User Interface

This chapter provides an overview of the MySQL Enterprise Monitor user interface.

## 13.1 Initial Log-In

If this is the first time logging in to the dashboard, the following page is displayed:

Figure 13.1 Initial setup for the MySQL Enterprise Monitor User Interface

You must perform the following tasks:

- Create a user name and password for the Manager User. The manager user is used for the initial session, configuring the systems, and the access control list.

- Create a user name and password for the MySQL Enterprise Monitor Agent. The Agent user credentials are used by every monitoring agent to connect to MySQL Enterprise Service Manager.

  Note

  It is possible to configure additional Agent users should your system require it. For more information, see Chapter 23, Access Control.

- Configure your Data Purging Behavior preferences.

  Although these settings control the amount of disk space used, changing them later to lower values may not reclaim disk space automatically, as you would have to dump-and-reload the table, and InnoDB tables never shrink.

- Configure your preferences for Online Updates. If your organisation uses a HTTP proxy, you must check the Use HTTP Proxy field, and complete the fields displayed when this is enabled.

In the Create Manager User section of this screen, enter credentials for the Monitor UI administrator. This creates the Manager user described in Section 3.3.3, “Users Created on First Log-in”. Record the user name and password, as these credentials are required for any future login.

In the Create Agent User section of this screen, enter the credentials for the agent. This is the user described in Section 3.3.3, “Users Created on First Log-in”. The agent must log in to report its findings. Record the agent's credentials; this information is required when installing the agent.

After specifying all settings, click the Complete Setup button. When you log in, a message reports that the Advisors are now scheduled.

## 13.2 Setting the Timezone and Locale

If this is the first time that you have launched the MySQL Enterprise Monitor User Interface, you are asked to set your time zone and locale. Choose the appropriate values from the drop-down list boxes. Setting the time zone ensures that you have an accurate time reference for any notifications from the MySQL Enterprise Advisors.

Warning

Make sure to set the time zone (and the system clock) correctly because this setting affects the way the graphs display.

The locale chosen determines the default language displayed when logging in to the Monitor UI. This overrides the default browser settings whenever this specific user logs in.

After specifying your time zone and locale, the Monitor UI opens on the What's New page.

At this point the MySQL Enterprise Service Manager Repository is being monitored, and the built-in Agent is attempting to auto-discover additional MySQL instances on the host.

## 13.3 Menus and Toolbars

This chapter describes the menus and toolbars of the MySQL Enterprise Monitor user interface.

### 13.3.1 Main Menus

This section describes the main menus of the user interface.

#### Dashboards

- Overview: opens the Overview dashboard. This dashboard provides a high-level view of the current state of your monitored assets. For more information, see Chapter 14, Overview. This is the first page displayed after the initial setup steps are completed.

- Replication: opens the Replication dashboard. This dashboard provides a detailed view of the current state of your monitored replication servers. For more information, see Chapter 17, Replication Dashboard.

- MySQL Instances: opens the MySQL Instances dashboard. This dashboard provides a detailed view of the current state of your monitored instances. It also permits the addition, removal, or editing of connections to MySQL instances. For more information, see Chapter 15, MySQL Instances Dashboard.

#### Events

The Events page lists all the events for the monitored assets to which you have access. See Figure 20.1, “Events Page with Filter” for more information.

#### Query Analyzer

Opens the Query Analyzer page. See Chapter 27, Using the Query Analyzer for more information.

#### Reports and Graphs

The reports and Graphs menu contains the following links:

- All Timeseries: opens the All Timeseries graphs page. See Section 18.1, “All Timeseries Graphs” for more information.

- Database File I/O: opens the Database File I/O page. This page displays details and graphs of latency statistics taken from Performance Schema I/O event data.

  This page utilises the `sys` schema and is only supported on MySQL versions 5.6 and 5.7.

- InnoDB Buffer Pool Usage: opens the InnoDB Buffer Pool Usage block graph. This graph displays a graphical overview of the data stored in the InnoDB Buffer Pool.

  See Section 18.3, “InnoDB Buffer Pool Usage” for more information.

#### Refresh

Sets the page to refresh automatically according to a schedule. It is also possible to pause the page refresh using the pause button adjacent to the Refresh drop-down list.

Note

The pause is temporary. If the page is manually refreshed, the pause is cancelled and the defined refresh behavior resumes.

To resume the defined page refresh, click the button again.

#### User

This section describes the contents of the User menu.

- User Preferences: opens the User Preferences page, enabling the user to change their username, full name, password, timezone, and locale.

- Logout: ends the current user's session.

#### Global Settings (Gear)

The Global Settings menu contains links to the following configuration pages:

- Groups: opens the Manage Groups page.

- Advisors: opens the Advisors page. See Chapter 19, Advisors for more information.

- Event Handling: opens the Event Handling page. See Chapter 20, Events and Event Handling for more information.

- Settings: opens the Settings page. See Chapter 25, Global Settings for more information.

- Roles: opens the Roles page. See Chapter 23, Access Control for more information.

- Users: opens the Users page. See Chapter 23, Access Control for more information.

- Diagnostic Report: generates and downloads the user diagnostic file. This file contains information on the application, property files, stack traces, and all log files.

  This file is intended for MySQL Support, to assist them in diagnosing any issues you may have with your installation.

  For more information, see Section D.1, “Diagnostics Report”.

### 13.3.2 Status Summary

The Status Summary bar displays the current status of the monitored hosts and instances. Each icon, and its adjacent number, link to pages which provide more detail.

Figure 13.2 Status Summary

The icons, from left to right, represent the following:

- Hosts Monitored: the number of successfully monitored hosts. Links to the MySQL Instances dashboard.

  Note

  An agent must be installed on a host to monitor that host. It is not possible to monitor a host without a local agent installed on it. Only MySQL instances can be monitored remotely.

- MySQL Instances Monitored: the number of successfully monitored MySQL instances. Links to the MySQL Instances dashboard.

- MySQL Instances with Bad Connection Configurations: the number of incorrectly configured instance connections.

- MySQL Instances Unmonitored: the number of running MySQL instances which are not currently monitored. Links to the Unmonitored MySQL Instances list on the MySQL Instances dashboard.

  See Unmonitored MySQL Instances for more information.

- Emergency Events: the number of current emergency events. Links to the Events page and sets the filter to the status Emergency and state Open.

Note

The hosts and instances represented in the Status Summary depend on the permissions defined for the user. If the user is assigned to a specific group, only the issues originating from the servers in that group are displayed in the system status bar. For example, the Hosts Monitored icon only displays the total number of hosts in the group assigned to the user's role.

Prev | Up | Next
Part III Using MySQL Enterprise Monitor | Home | Chapter 14 Overview