MySQL Enterprise Monitor Glossary

These terms are commonly used in information about MySQL Enterprise Monitor.

A

access control

MySQL Enterprise Monitor Access Control enables you to manage asset visibility, application administration, data access, roles, and users.

For more information, see Chapter 23, Access Control.

See Also role.

advisor

Advisors filter and evaluate the information collected by the Monitoring Agents and present it to the Events page when defined thresholds are breached. Advisors can be in one or more Categories.

The MySQL Enterprise Monitor product comes with a number of default advisors. Based on your organization's particular needs, you may create or adapt custom advisors.

See Also custom, notification, schedule, standard.

advisor category

A set of Advisors that are designed to enforce MySQL best practices for that specific category. For example, there are predefined advisor categories such as Administration, Availability, Cluster, Replication and Security.

See Also advisor.

Agent

The MySQL Enterprise Monitor component that actively collects data from a host and its MySQL server instances. The data is transmitted to the Service Manager.

See Also instance, Service Manager.

Apache

The web server that runs the Tomcat servlet container that powers the UI. The MySQL Enterprise Monitor Service Manager installation includes the Apache web server.

See Also Service Manager, Tomcat.

asset

A component that the MySQL Enterprise Monitor product monitors, such as a MySQL server instance, or a CPU or file system within a server machine. Contrast with metric, which is a property within the component that is measured.

See Also instance, metric.

Asset Selector

The Groups shown in the Asset Selector are the ones you create and manage (on the MySQL Instances Dashboard, or during Agent installation) and those that are discovered automatically from monitoring replication topologies. It is on the left side of many UI pages that controls content in the main-body of the page.

See Also asset, graph.

autodiscovery

The mechanism that detects the set of master, slave, and master/slave servers in a replication configuration, and displays the topology in the Server tree.

See Also Asset Selector, master, replication, slave, topology.

B

backlog

The agent backlog is a caching mechanism which stores monitoring data in the event the agent cannot communicate with the MySQL Enterprise Service Manager. The backlog can store 10MB of monitored data in active RAM.

See Also Agent.

blackout period

A function of Event Notification, it is a time period where events do not trigger notifications via the Event Handler, in that information is not reported from a MySQL Server. Typically, this is during a maintenance period when the database might go through an unusual workload that does not require raising any notifications.

See Also Agent, instance, notification.

bottleneck

An aspect or component of a system whose capacity imposes a limit on performance. In MySQL Enterprise Monitor, you identify bottlenecks in areas such as I/O or memory usage using graphs, and use advisors to automatically raise events when problems occur.

See Also advisor, event, graph.

bundled

The “bundled MySQL server” refers to the MySQL server delivered with the MySQL Enterprise Monitor product, to serve as the repository for the collected data.

See Also repository.

C

C

The C programming language.

canonical query

A synonym for normalized query.

See Also normalized query.

chain replication

In replication, a kind of topology where each server acts as a source/replica server, connected to at most two other servers.

See Also circular replication, master/slave, replication, topology.

circular replication

In a replication configuration, a topology where every server is both a source and a replica, connected to two other servers, forming a ring structure. Forms a ring structure.

See Also replication, ring replication, topology.

credentials

The MySQL Enterprise Monitor product interfaces with many different databases and other kinds of servers. Each of these components can have its own login and security credentials. MySQL Enterprise Monitor pulls performance data from the MySQL servers that you monitor, stores the resulting data in a repository that is also a MySQL server, and sends alerts by communicating through other kinds of servers such as SMTP for e-mail alerts and NMS for SNMP traps. It pulls support-related data from the My Oracle Support site. You view the results in the UI, which is protected by its own login and optionally by LDAP authentication.

See Also LDAP, NMS, repository, SMTP, SNMP.

Critical

A high severity level for alarms. Within a rule, you can designate the threshold values that specify whether an alarm triggers a Critical, Warning, or notice alert.

See Also advisor, event, Notice, threshold, Warning.

custom

User-created rules and graphs. Contrast with standard.

See Also graph, standard.

D

data collection item

Data values derived from server status variables, operating system status information, and MySQL table information. You can reference these items using mnemonic names in expressions when you create or edit rules.

See Also expression.

diagnostic report

The diagnostic report includes detailed information about your server (or multiple servers if you selected a server group), including configuration, hardware, MySQL options/variables and historical graphs.

If you intend to communicate with MySQL Enterprise Monitor support, it is strongly recommended you provide this report with your support request.

See Also My Oracle Support, service request, support issue.

E

event

The highest severity level for an advisor. Within an Advisor, you can designate the threshold values that specify whether an event triggers an Emergency, Critical, Warning, or notice event.

See Also advisor, Critical, event, Notice, Warning.

event

Events are displayed if an Advisor Threshold is crossed, and are used to inform you of errors or potential problems with your implementation. Monitor events using the Events page, and define how events are handled by configuring Event Handling.

See Also Critical, Events, Notice, notification, Warning.

event handler

Event handlers are conditions associated with notifications. If the condition is met, the notification is sent.

See Also Critical, event, Events, Notice, notification, Warning.

Events

A page within the UI, for monitoring events. See Section 26.1, “Events”.

See Also event.

EXPLAIN plan

A textual report showing the internal mechanisms used by a query, and estimates for the “cost”, such as amount of data to process, involved in each step. Performance monitoring involves checking whether queries that are slow or frequently run could be sped up or made less resource-intensive, by examining the EXPLAIN plan to check if the MySQL optimizer has chosen the most efficient ways to process indexes, order join clauses, and so on. The MySQL Enterprise Monitor product includes a number of features for visualizing EXPLAIN plans.

See Also query.

expression

The part of an Advisor that tests a metric against a threshold value.

See Also advisor, metric, threshold.

F

firewall

Additional considerations apply when the server you are monitoring is separated from the Service Manager by a firewall.

See Also remote, Service Manager, SSL.

full table scan

An aspect of a SELECT query that often indicates a performance or scalability issue. The query scans every row in a table, rather than using an index to look up a subset of rows. It can be a non-issue for small tables that are cached in memory. It can be unavoidable when querying large tables to prepare reports. Performance issues are most likely when the table being scanned is involved in a join operation, when the query is run frequently, or when the result set only references a small fraction of the rows in the table.

To diagnose possible issues due to full table scans, choose a time period of heavy SQL activity from one of the graphs, use the Query Analyzer to locate queries that process large numbers of rows, and examine the explain plan for the queries. The notation in the explain plan that indicates a full table scan is Type=ALL.

See Also EXPLAIN plan, graph, query, Query Analyzer.

G

graph

A visual representation of server activity, resources, or other metric over time. You view graphs using the Metrics view.

See Also metric.

H

heartbeat

An implementation detail from MySQL Enterprise Monitor 2.x that is no longer present. A heartbeat signal that is sent from an Agent to the Service Manager was defined as the heartbeat, and was present in the connecting URL.

See Also Agent, Service Manager.

host

A computer running one or more instances of MySQL server. Typically each host is monitored by a MySQL Enterprise Monitor Agent.

See Also instance, MySQL server.

I

instance

A mysqld daemon running on a MySQL server. There might be multiple instances running on the same server machine. An instance is one of the asset MySQL Enterprise Monitor can monitor.

The Instances view manages the instances, and the MySQL Process Discovery advisor discovers local instances on the host that the Agent is installed on.

See Also asset.

instrument

A persisted instance of a run-time metric evaluation. These may store the raw metric data, or the result of an expression or function against a metric. Instruments are generally stored for things that are displayed in the GUI, such as graph data.

See Also graph, metric.

inventory

Core information about a host or MySQL server instance. This data is collected by the Agent. The inventory includes details such as the MySQL server version number, supported storage engines and replication configuration. The data in the inventory helps to determine what other kinds of data can be collected from the hosts and MySQL servers.

See Also Agent, instance, replication.

J

Java

The MySQL Enterprise Monitor product is partly built on Java technology, using the Tomcat servlet container for the web-based GUI. It uses a JRE on the machine that runs the Service Manager, its performance is affected by the Tomcat configuration parameters, the Agent is written in Java, and during troubleshooting you might use diagnostic information from the Java environment.

See Also JDBC, Query Analyzer, Tomcat.

JDBC

The underlying database API used by many Java applications.

See Also Java.

JET

Oracle JavaScript Extension Toolkit (JET) is a collection of open source JavaScript libraries along with a set of Oracle contributed JavaScript libraries used to build applications that consume and interact with Oracle products and services.

See Also UI.

L

LDAP

An authentication mechanism that can control access to the UI. On Linux, Unix, and macOS systems, you might have a separate LDAP server where each user has their own credentials. On Windows systems, the LDAP protocol is used to connect to an Active Directory server for the same authentication purposes. Typically, you map LDAP roles to corresponding MySQL Enterprise Monitor roles, to enable groups of users to have basic or administrative access to the Dashboard without configuring each user individually, or giving them a new user ID and password, or requiring extra work to revoke access when they leave the organization.

See Also credentials, role.

log file

MySQL Enterprise Monitor manages log files for the Tomcat, repository, agentand Service Manager components, as well as a configuration report pertaining to the initial installation.

See Also repository, Service Manager, Tomcat.

Lua

A programming language that is used for parts of the Service Manager. Although you do not need to know this language to operate MySQL Enterprise Monitor, you may need to specify options containing file paths related to Lua scripts or libraries.

See Also Agent, Query Analyzer, Service Manager.

M

master

In a replication configuration, a database server that sends updates to a set of slave servers. It typically dedicates most of its resources to write operations, leaving user queries to the slaves. In complex topologies, a server can be both a master and a slave, known as a master/slave.

See Also master/slave, replica, replication, slave, source, topology.

master/slave

In replication, a server that acts as a slave to receive updates from another server, and also acts as a master to propagate changes to another set of slave servers. Keeps the top-level master from having to service too many slaves, and allows certain kinds of changes to be propagated to a subset of slaves. This topology is represented as a tree, with all the intermediate nodes being master/slave servers.

See Also master, replication, slave, topology, tree.

metric

Any property that is measured using a numeric value. Within MySQL Enterprise Monitor, such measurements can be displayed over time as a graph, or an alert can be sent when a threshold value is reached. Each metric is collected from an asset. For example, how much time is taken by a database query, or how full is the file system on a server machine.

See Also asset, graph, threshold.

mixed replication

In a replication configuration, a kind of topology consisting of different combinations of master, slave, and dual-purpose master/slave servers.

See Also chain replication, circular replication, master, master/slave, replication, slave, topology, tree.

monitor

To view information about the state, health, activity, and history of a resource such as a MySQL server instance. Monitoring can help to diagnose problems, spot worrisome trends before they turn into problems, reassure when systems are operating normally, and notify when an operator needs to take corrective action. With MySQL Enterprise Monitor, the component you interact with during monitoring is the UI.

See Also instance.

My Oracle Support

The website for filing bugs and service requests with Oracle Support. (Commercial customers such as MySQL Enterprise Monitor users now use the official Oracle support channel rather than the MySQL bug database.) In MySQL Enterprise Monitor, you interact with the support site through the What's New tab.

See Also service request, What's New tab.

MySQL server

The MySQL database instance running on a host computer. More than one MySQL instance can run on the same computer, either as separate mysqld processes or through virtualization.

See Also instance.

N

.NET

A programming framework used by many Windows applications.

NMS

Acronym for Network Management System, a type of monitoring system that is separate from the MySQL Enterprise Monitor product. If your network has this kind of monitoring capability, MySQL Enterprise Monitor can notify the NMS of network issues by translating events into SNMP traps.

See Also event, SNMP.

normalized query

A condensed form of the query text used to treat similar queries as if they were identical, for monitoring performance. When MySQL Enterprise Monitor normalizes queries, it disregards differences in keyword capitalization, whitespace, and most comments. It replaces literal values with placeholders and transforms multi-row insert statements and IN clauses, to group similar statements with different parameters when measuring how much time is consumed by a particular type of query.

See Also canonical query, query.

Notice

A low severity level for events. Within an advisor, you can designate the threshold values that specify the severity level that is triggered.

See Also advisor, Critical, event, threshold, Warning.

notification

The e-mail or other form of communication triggered by an alarm. Notifications are defined using Event Handlers.

See Also event.

notification group

A collection of users who receive a notification when advisor alerts occur. These users might have login credentials for the UI, but this is not a requirement.

See Also event, event handler, notification.

P

PHP

A scripting language typically embedded within web pages.

Q

QRTi

QRTi stands for "Query Response Time index". It is a "quality of service" measurement for each query, and it uses the Apdex formula for that calculation. For more information about Apdex, see: Apdex on Wikipedia.

See Also Query Analyzer.

QuAn

An abbreviation for Query Analyzer used in some keyword names.

See Also Query Analyzer.

query

In the MySQL Enterprise Monitor context, any SQL statement whose performance might be monitored. Includes not just SQL SELECT queries, but also DML statements such as INSERT, UPDATE, and DELETE, and DDL statements such as CREATE TABLE and TRUNCATE TABLE.

See Also normalized query, slow query log.

Query Analyzer

The MySQL Enterprise Monitor component that tracks data about MySQL queries and summarizes that data using graphs and tables. You interact with it (for example, filtering the displayed queries or selecting a specific time period) using the Query Analyzer tab in the UI.

See Also graph, query, Query Analyzer view.

Query Analyzer view

A page within the UI that displays output and controls the options for the Query Analyzer component. See Chapter 32, Query Analyzer View for more information.

See Also Query Analyzer.

R

remote

Additional considerations apply when the server you are monitoring is separated from the Service Manager, for example by a wide-area network or by a firewall.

See Also firewall, remote monitoring, SSL.

remote monitoring

An Agent on one host that monitors different hosts, and MySQL instances on different hosts.

Remote monitoring has limitations, versus local monitoring. Remote monitoring does not provide Operating System level data, such as CPU, file, and network utilization information.

See Also Agent, remote.

replica

Synonym for slave in replication topologies.

In a replication configuration, a database server that receives updates from a source server. Typically used to service user queries, to minimize the query load on the master. In complex topologies, a server can be both a source and a replica, known as a source/replica.

See Also master, master/slave, replication, topology.

replication

A set of database features that mirrors the same data across a set of servers. Used for reliability in case of server failure, and to speed up queries by dividing the work across servers. Because replication involves so many aspects of reliability and performance, it is an important aspect to monitor and has a dedicated Replication view in the UI.

See Also topology.

Replication view

A view within the UI that monitors aspects of replication. See Chapter 28, Replication Dashboard.

See Also replication.

repository

The database that stores the monitoring data collected by the MySQL Enterprise Monitor product. It can be a separate database instance that is part of the MySQL Enterprise Monitor installation (the bundled MySQL server), or you can use an existing database of your own. The bundled MySQL server is a level of MySQL database that is fully tested with the MySQL Enterprise Monitor product, and can be kept separate from your other databases to avoid any extra load on them. You might use an existing server that has spare capacity, fast storage devices, tuned configuration parameters, a backup system, or other conveniences that can benefit the MySQL Enterprise Monitor data storage as well.

See Also bundled, instance.

ring replication

See circular replication.

role

A level of access privilege for the UI. One of manager (highest privilege), dba, read-only, or agent (specialized privilege for sending data). Each user account registered with the Dashboard must have one of these roles. Components such as the Agent and the use the agent role. To simplify the process of granting credentials for large numbers of users, you can map LDAP roles to these MySQL Enterprise Monitor roles.

See Also Agent, credentials, LDAP.

S

schedule

Determines how often each advisor is evaluated.

See Also advisor.

scope

A dynamic filter against an asset class.

See Also asset.

Service Manager

The core MySQL Enterprise Monitor component that receives the monitoring data from the Agent and Query Analyzer components. It displays this information through the GUI web-interface, and manages the Advisors, Events, and Event Handlers, as well as access to Reporting, Graphing, and Query Analysis.

See Also advisor, Agent, event, Query Analyzer.

service request

Generic term for a bug that you have filed or a support request that you have opened, on the My Oracle Support site. Formerly, we referred to these as support issues.

See Also My Oracle Support, support issue.

Settings

A page in the UI for viewing or editing configuration settings of the Service Manager.

See Also Service Manager.

severity

A measure of the seriousness of an Event. Event Handling policies can take into account the severity level in determining the appropriate course of Notification action.

See Also event handler.

slave

In a replication configuration, a database server that receives updates from a master server. Typically used to service user queries, to minimize the query load on the master. In complex topologies, a server can be both a master and a slave, known as a master/slave.

See Also master, master/slave, replica, replication, source, topology.

slow query log

A MySQL Server facility for tracking queries that consume considerable time and resources. MySQL Enterprise Monitor provides more information about query performance than the slow query log, and does not currently use the slow query log itself.

See Also query.

SMTP

The e-mail protocol for sending alerts as e-mail messages. To send alerts this way, you configure e-mail settings similar to those in an e-mail client.

SNMP

A protocol for sending event notifications (“SNMP traps”) to an NMS. The MySQL Enterprise Monitor product can turn notifications for selected rules into SNMP traps. In contrast to typical alerts that are only raised when some issue occurs, SNMP traps are broadcast for all state changes, so that corrective action can be cancelled when an issue is cleared.

See Also NMS, notification.

source

Synonym for master in replication topologies.

In a replication configuration, a database server that sends updates to a set of replica servers. It typically dedicates most of its resources to write operations, leaving user queries to the replicas. In complex topologies, a server can be both a source and a replica, known as a source/replica.

See Also master/slave, replica, replication, slave, topology.

source/replica

In replication, a server that acts as a replica to receive updates from another server, and also acts as a source to propagate changes to another set of replica servers. Keeps the top-level source from having to service too many replicas, and allows certain kinds of changes to be propagated to a subset of replicas. This topology is represented as a tree, with all the intermediate nodes being source/replica servers.

See Also replica, replication, source, topology, tree.

SSL

For MySQL Enterprise Monitor, the default port used for SSL connections is 18443. If you are connecting using SSL, the built-in MySQL Enterprise Monitor certificate is self-signed and may be highlighted as “unsafe” within the browser on initial connection. To prevent problems accessing the site, add an exception for the certificate to your browser for this server.

standard

The predefined advisors and graphs supplied as part of MySQL Enterprise Monitor. Contrast with custom.

See Also custom, graph.

Status Summary

The Status Summary widget is displayed on top of every page, updates dynamically, and shows current status counters for Hosts monitored, MySQL Instances monitored, MySQL Instances with invalid connection configurations, Unmonitored MySQL Instances, and Emergency Events. The counters are live links for displaying details or resolving the issues they are reporting.

support issue

Former term for bugs and service requests. In the My Oracle Support system, now known as a service request, which is the preferred term.

See Also service request.

T

table scan

See full table scan.

threshold

Thresholds are the predefined limits for Advisors. If the monitored value breaches the defined threshold, an event is generated and displayed on the Events page for the asset. Advisor thresholds use a variety of different value types, depending on the monitored value. Some use percentages, such as percentage of maximum number of connections. Others use timed durations, such as the average statement execution time. It is also possible to check if specific configuration elements are present or correct.

See Also Critical, event, expression, Notice, Warning.

Tomcat

Apache Tomcat is a component of the Service Manager. It is the servlet engine that powers the UI.

See Also Apache, Java, Service Manager.

topology

In a replication configuration, the way in which the different source, replica, and dual-purpose source/replica servers are connected. In MySQL Enterprise Monitor, the configurations are classified in the Replication view as one of TREE, RING, or MIXED.

See Also master, master/slave, replication, Replication view, slave.

topology view

A graphical representation of the replication topology displayed in a dedicated Topology view.

See Also replica, replication, Replication view, source.

tree

A data structure often used to represent relationships between MySQL servers. In the UI, servers are displayed in the Server Tree sidebar. In a replication configuration, setting up some machines as dual-purpose master/slave servers produces a nesting relationship that is represented in the Server Tree.

See Also Asset Selector, master/slave, replication.

trending

Predicting when a problem may occur. For example, predicting that a disk is expected to run out of disk space 30 days in the future.

U

UI

The UI is a web-based interface to the MySQL Enterprise Service Manager. The back end is a Java application powered by the Tomcat server.

UUID

A unique identifier used to distinguish each MySQL instance, host machine, and agent. Because there is so much flexibility in spreading components across multiple systems or running multiple instances and agents on the same system, the combination of these different UUIDs identifies where information came from and the source of any issues. Always generate a new UUID for any one of these components, rather than copying or reusing an existing UUID value.

In MySQL 5.5, or earlier, the UUID for the server is stored in the table mysql.inventory. When a component such as the Agent connects to that MySQL server, the applicable MySQL user must have privileges to read this table.

See Also Agent, instance.

W

Warning

A medium severity level for alarms. Within a rule, you can designate the threshold values that specify for each severity level.

See Also advisor, Critical, event, Notice, notification, threshold.

What's New tab

A page within the UI that provides updates and news related to MySQL Enterprise Monitor and your My Oracle Support account.

See Also My Oracle Support.

Index

A  | B  | C  | D  | E  | F  | G  | H  | I  | J  | L  | M  | N  | O  | P  | Q  | R  | S  | T  | U  | V  | W

A

[index top]

access control, MySQL Enterprise Monitor Glossary

Administration Advisors, Administration Advisors

32-Bit Binary Running on 64-Bit AMD Or Intel System, 32-Bit Binary Running on 64-Bit AMD Or Intel System

Binary Log Debug Information Disabled, Binary Log Debug Information Disabled

Binary Logging Is Limited, Binary Logging Is Limited

Binary Logging Not Enabled, Binary Logging Not Enabled

Binary Logging Not Synchronized To Disk At Each Write, Binary Logging Not Synchronized To Disk At Each Write

Binary Logs Automatically Removed Too Quickly, Binary Logs Automatically Removed Too Quickly

Database May Not Be Portable Due To Identifier Case Sensitivity, Database May Not Be Portable Due To Identifier Case Sensitivity

Event Scheduler Disabled, Event Scheduler Disabled

General Query Log Enabled, General Query Log Enabled

Host Cache Size Not Sufficient, Host Cache Size Not Sufficient

In-Memory Temporary Table Size Limited By Maximum Heap Table Size, In-Memory Temporary Table Size Limited By Maximum Heap Table Size

InnoDB Status Truncation Detected, InnoDB Status Truncation Detected

InnoDB Strict Mode Is Off, InnoDB Strict Mode Is Off

InnoDB Tablespace Cannot Automatically Expand, InnoDB Tablespace Cannot Automatically Expand

InnoDB Transaction Logs Not Sized Correctly, InnoDB Transaction Logs Not Sized Correctly

Multiple Threads Used When Repairing MyISAM Tables, Multiple Threads Used When Repairing MyISAM Tables

MySQL Server No Longer Eligible For Oracle Premier Support, MySQL Server No Longer Eligible For Oracle Premier Support

Next-Key Locking Disabled For InnoDB But Binary Logging Enabled, Next-Key Locking Disabled For InnoDB But Binary Logging Enabled

No Value Set For MyISAM Recover Options, No Value Set For MyISAM Recover Options

Table Cache Set Too Low For Startup, Table Cache Set Too Low For Startup

Time Zone Data Not Loaded, Time Zone Data Not Loaded

Warnings Not Being Logged, Warnings Not Being Logged

--adminpassword option, MySQL Enterprise Service Manager Options

--adminuser option, MySQL Enterprise Service Manager Options

advisor, MySQL Enterprise Monitor Glossary

advisor category, MySQL Enterprise Monitor Glossary

Advisors, GUI-Based Advisor Reference

32-Bit Binary Running on 64-Bit AMD Or Intel System, 32-Bit Binary Running on 64-Bit AMD Or Intel System

Account Has An Overly Broad Host Specifier, MySQL User Account

Account Has Global Privileges, MySQL User Account

Account Has Old Insecure Password Hash, Account Has Old Insecure Password Hash

Account Requires Unavailable Authentication Plug-ins, Account Requires Unavailable Authentication Plug-ins

Agent Health Advisor, Agent Health Advisor

Attempted Connections To The Server Have Failed, Attempted Connections To The Server Have Failed

AUTO_INCREMENT Field Limit Nearly Reached, AUTO_INCREMENT Field Limit Nearly Reached

Average Statement Execution Time Advisor, Average Statement Execution Time Advisor

Binary Log Checksums Disabled, Binary Log Checksums Disabled

Binary Log Debug Information Disabled, Binary Log Debug Information Disabled

Binary Log File Count Exceeds Specified Limit, Binary Log File Count Exceeds Specified Limit

Binary Log Row Based Images Excessive, Binary Log Row Based Images Excessive

Binary Log Space Exceeds Specified Limit, Binary Log Space Exceeds Specified Limit

Binary Log Usage Exceeding Disk Cache Memory Limits, Binary Log Usage Exceeding Disk Cache Memory Limits

Binary Logging Is Limited, Binary Logging Is Limited

Binary Logging Not Enabled, Binary Logging Not Enabled

Binary Logging Not Synchronized To Disk At Each Write, Binary Logging Not Synchronized To Disk At Each Write

Binary Logs Automatically Removed Too Quickly, Binary Logs Automatically Removed Too Quickly

Cluster Data Node Redo Buffer Space Getting Low, Cluster Data Node Redo Buffer Space Getting Low

Cluster Data Node Redo Log Space Getting Low, Cluster Data Node Redo Log Space Getting Low

Cluster Data Node Undo Buffer Space Getting Low, Cluster Data Node Undo Buffer Space Getting Low

Cluster Data Node Undo Log Space Getting Low, Cluster Data Node Undo Log Space Getting Low

Cluster DiskPageBuffer Hit Ratio Is Low, Cluster DiskPageBuffer Hit Ratio Is Low

CPU Utilization Advisor, CPU Utilization Advisor

Database May Not Be Portable Due To Identifier Case Sensitivity, Database May Not Be Portable Due To Identifier Case Sensitivity

Database-level Privileges on All Databases, MySQL User Account

Duplicate Host Identity, Duplicate Host Identity

Duplicate MySQL Server UUID, Duplicate MySQL Server UUID

Event Scheduler Disabled, Event Scheduler Disabled

Excessive Disk Temporary Table Usage Detected, Excessive Disk Temporary Table Usage Detected

Excessive Number of Locked Processes, Excessive Number of Locked Processes

Excessive Number of Long Running Processes, Excessive Number of Long Running Processes

Excessive Number of Long Running Processes Locked, Excessive Number of Long Running Processes Locked

Excessive Percentage Of Attempted Connections To The Server Have Failed, Excessive Percentage Of Attempted Connections To The Server Have Failed

Filesystem Free Space Advisor, Filesystem Free Space Advisor

Flush Time Set To Non-Zero Value, Flush Time Set To Non-Zero Value

General Query Log Enabled, General Query Log Enabled

Group Replication, Group Replication Advisors

Group Replication Configuration, Group Replication Configuration Advisor

Group Replication Status, Group Replication Status Advisor

Host Cache Size Not Sufficient, Host Cache Size Not Sufficient

HTTP Server Performance, HTTP Server Performance

In-Memory Temporary Table Size Limited By Maximum Heap Table Size, In-Memory Temporary Table Size Limited By Maximum Heap Table Size

Indexes Not Being Used Efficiently, Indexes Not Being Used Efficiently

InnoDB Buffer Cache Has Sub-Optimal Hit Rate, InnoDB Buffer Cache Has Sub-Optimal Hit Rate

InnoDB Buffer Pool Writes May Be Performance Bottleneck, InnoDB Buffer Pool Writes May Be Performance Bottleneck

InnoDB Flush Method May Not Be Optimal, InnoDB Flush Method May Not Be Optimal

InnoDB Log Buffer Flushed To Disk After Each Transaction, InnoDB Log Buffer Flushed To Disk After Each Transaction

InnoDB Log Waits May Be Performance Bottleneck, InnoDB Log Waits May Be Performance Bottleneck

InnoDB Not Using Newest File Format, InnoDB Not Using Newest File Format

InnoDB Status Truncation Detected, InnoDB Status Truncation Detected

InnoDB Strict Mode Is Off, InnoDB Strict Mode Is Off

InnoDB Tablespace Cannot Automatically Expand, InnoDB Tablespace Cannot Automatically Expand

InnoDB Transaction Logs Not Sized Correctly, InnoDB Transaction Logs Not Sized Correctly

Insecure Password Authentication Option Is Enabled, Insecure Password Authentication Option Is Enabled

Insecure Password Generation Option Is Enabled, Insecure Password Generation Option Is Enabled

Key Buffer Size May Not Be Optimal For Key Cache, Key Buffer Size May Not Be Optimal For Key Cache

LOCAL Option Of LOAD DATA Statement Is Enabled, LOCAL Option Of LOAD DATA Statement Is Enabled

Master Not Verifying Checksums When Reading From Binary Log, Master Not Verifying Checksums When Reading From Binary Log

Maximum Connection Limit Nearing Or Reached, Maximum Connection Limit Nearing Or Reached

Multiple Threads Used When Repairing MyISAM Tables, Multiple Threads Used When Repairing MyISAM Tables

MyISAM Concurrent Insert Setting May Not Be Optimal, MyISAM Concurrent Insert Setting May Not Be Optimal

MyISAM Indexes Found with No Statistics, MyISAM Indexes Found with No Statistics

MySQL Agent Memory Usage Excessive, MySQL Agent Memory Usage Excessive

MySQL Agent Not Reachable, MySQL Agent Not Reachable

MySQL Availability, MySQL Availability

MySQL Enterprise Backup Health Advisor, MySQL Enterprise Backup Health Advisor

MySQL Process Discovery Advisor, MySQL Process Discovery Advisor

MySQL Server Has Been Restarted, MySQL Server Has Been Restarted

MySQL Server No Longer Eligible For Oracle Premier Support, MySQL Server No Longer Eligible For Oracle Premier Support

MySQL User Account, MySQL User Account

Next-Key Locking Disabled For InnoDB But Binary Logging Enabled, Next-Key Locking Disabled For InnoDB But Binary Logging Enabled

No Value Set For MyISAM Recover Options, No Value Set For MyISAM Recover Options

Object Changed: Database Has Been Altered, Object Changed: Database Has Been Altered

Object Changed: Database Has Been Created, Object Changed: Database Has Been Created

Object Changed: Database Has Been Dropped, Object Changed: Database Has Been Dropped

Object Changed: Function Has Been Created, Object Changed: Function Has Been Created

Object Changed: Function Has Been Dropped, Object Changed: Function Has Been Dropped

Object Changed: Index Has Been Created, Object Changed: Index Has Been Created

Object Changed: Index Has Been Dropped, Object Changed: Index Has Been Dropped

Object Changed: Table Has Been Altered, Object Changed: Table Has Been Altered

Object Changed: Table Has Been Created, Object Changed: Table Has Been Created

Object Changed: Table Has Been Dropped, Object Changed: Table Has Been Dropped

Object Changed: User Has Been Dropped, Object Changed: User Has Been Dropped

Object Changes Detected, Object Changes Detected

Policy-Based Password Validation Does Not Perform Dictionary Checks, Policy-Based Password Validation Does Not Perform Dictionary Checks

Policy-Based Password Validation Is Weak, Policy-Based Password Validation Is Weak

Policy-Based Password Validation Not Enabled, Policy-Based Password Validation Not Enabled

Prepared Statements Not Being Closed, Prepared Statements Not Being Closed

Prepared Statements Not Being Used Effectively, Prepared Statements Not Being Used Effectively

Privilege Alterations Detected: Privileges Granted, Privilege Alterations Detected: Privileges Granted

Privilege Alterations Detected: Privileges Revoked, Privilege Alterations Detected: Privileges Revoked

Privilege Alterations Have Been Detected, Privilege Alterations Have Been Detected

Query Analysis Reporting, Query Analysis Reporting

Query Cache Has Sub-Optimal Hit Rate, Query Cache Has Sub-Optimal Hit Rate

Query Cache Is Excessively Fragmented, Query Cache Is Excessively Fragmented

Query Cache Potentially Undersized, Query Cache Potentially Undersized

Query Pileup Advisor, Query Pileup Advisor, Query Analysis Reporting

Replica Execution Position Too Far Behind, Replica Execution Position Too Far Behind

Replication Configuration Advisor, Replication Configuration Advisor

Replication Status Advisor, Replication Status Advisor

Replication Too Far Behind, Replication Too Far Behind

Root Account Can Login Remotely, Root Account Can Login Remotely

Root Account Without Password, Root Account Without Password

Server Contains Default "test" Database, Server Contains Default "test" Database

Server Has Accounts Without A Password, Server Has Accounts Without A Password

Server Has Anonymous Accounts Not Being Used As Proxies, Server Has Anonymous Accounts Not Being Used As Proxies

Server Has No Locally Authenticated Root User, Server Has No Locally Authenticated Root User

Server Includes A Root User Account, Server Includes A Root User Account

Server-Enforced Data Integrity Checking Disabled, Server-Enforced Data Integrity Checking Disabled

Server-Enforced Data Integrity Checking Not Strict, Server-Enforced Data Integrity Checking Not Strict

SHA-256 Password Authentication Not Enabled, SHA-256 Password Authentication Not Enabled

Slave Detection Of Network Outages Too High, Slave Detection Of Network Outages Too High

Slave Has Login Accounts With Inappropriate Privileges, Slave Has Login Accounts With Inappropriate Privileges

Slave Not Configured As Read Only, Slave Not Configured As Read Only

Slave Not Verifying Checksums When Reading From Relay Log, Slave Not Verifying Checksums When Reading From Relay Log

Slave Relay Log Space Is Very Large, Relay Log Space Is Very Large, Slave Relay Logs Not Automatically Purged

Slave SQL Processing Not Multi-Threaded, Slave SQL Processing Not Multi-Threaded

Slave Without REPLICATION SLAVE Accounts, Slave Without REPLICATION SLAVE Accounts

SQL Statement Generates Warnings or Errors, SQL Statement Generates Warnings or Errors

Support Diagnostics, Support Diagnostics

Symlinks Are Enabled, Symlinks Are Enabled

sys Schema Install Advisor, sys Schema Install Advisor

Table Cache Not Optimal, Table Cache Not Optimal

Table Cache Set Too Low For Startup, Table Cache Set Too Low For Startup

Table Lock Contention Excessive, Table Lock Contention Excessive

Tables Found with No Primary or Unique Keys, Tables Found with No Primary or Unique Keys

Thread Cache Not Enabled, Thread Cache Not Enabled

Thread Cache Size May Not Be Optimal, Thread Cache Size May Not Be Optimal

Thread Pool Stall Limit Too Low, Thread Pool Stall Limit Too Low

Thread Pooling Not Enabled, Thread Pooling Not Enabled

Time Zone Data Not Loaded, Time Zone Data Not Loaded

Too Many Concurrent Queries Running, Too Many Concurrent Queries Running

Unsupported Agent Version, Unsupported Agent Version Advisor

User Has Rights To Database That Does Not Exist, User Has Rights To Database That Does Not Exist

User Has Rights To Table That Does Not Exist, User Has Rights To Table That Does Not Exist

Users Can View All Databases On MySQL Server, Users Can View All Databases On MySQL Server

Warnings Not Being Logged, Warnings Not Being Logged

advisors

creating, Creating Advisors and Rules, Creating a New Advisor: An Example

agent

configuration utilities, Agent Configuration Utility

installation, Monitor Agent Installation

troubleshooting, Troubleshooting the Agent

Agent, MySQL Enterprise Monitor Glossary

Managing agents, Agents View

Agent Advisors, Agent Advisors

Agent Health Advisor, Agent Health Advisor

MySQL Agent Memory Usage Excessive, MySQL Agent Memory Usage Excessive

MySQL Agent Not Reachable, MySQL Agent Not Reachable

--agent_autocreate option, MySQL Enterprise Monitor Agent Options

--agent_installtype option, MySQL Enterprise Monitor Agent Options

--agentpassword option, MySQL Enterprise Monitor Agent Options

--agentservicename option, MySQL Enterprise Monitor Agent Options

--agentuser option, MySQL Enterprise Monitor Agent Options

Apache, MySQL Enterprise Monitor Glossary

Apple OS X, Starting/Stopping the Agent on macOS, macOS Platforms, MySQL Enterprise Service Manager Log Files

architecture, MySQL Enterprise Monitor Introduction and Architecture

asset, MySQL Enterprise Monitor Glossary

Asset management

inventory, Asset Management

Asset Selector, MySQL Enterprise Monitor Glossary

Assets

Deleting Assets, Deleting Assets

management, Asset Management

autodiscovery, MySQL Enterprise Monitor Glossary

Availability Advisors, Availability Advisors

Attempted Connections To The Server Have Failed, Attempted Connections To The Server Have Failed

Excessive Percentage Of Attempted Connections To The Server Have Failed, Excessive Percentage Of Attempted Connections To The Server Have Failed

Maximum Connection Limit Nearing Or Reached, Maximum Connection Limit Nearing Or Reached

MySQL Availability, MySQL Availability

MySQL Server Has Been Restarted, MySQL Server Has Been Restarted

B

[index top]

backlog, MySQL Enterprise Monitor Glossary

backup

restore, Restoring from Backup

Backup Advisors

MySQL Enterprise Backup Health Advisor, MySQL Enterprise Backup Health Advisor

Backup Dashboard

Backup Details, Backup Details

filter, Overview Filter

Group Overview, Backup Overview

History, Backup History

Instance Overview, Backup Overview

Backup Details

Backup Command, Backup Command

Backup Configuration, Backup Configuration

Backup Status, Backup Status

InnoDB Configuration, InnoDB Configuration

Progress Log, Progress Log

--backupdir option, MySQL Enterprise Service Manager Options

backups, Backup the Repository

blackout

blackout period, Event Notification Blackout Periods

blackout scripting, Scripting Blackouts

command line, Scripting Blackouts

curl, Scripting Blackouts

blackout period, MySQL Enterprise Monitor Glossary

bottleneck, MySQL Enterprise Monitor Glossary

browsers, Supported Browsers

bundled, MySQL Enterprise Monitor Glossary

C

[index top]

C, MySQL Enterprise Monitor Glossary

canonical query, MySQL Enterprise Monitor Glossary

chain replication, MySQL Enterprise Monitor Glossary

--checkmysqlhost option, MySQL Enterprise Monitor Agent Options

circular replication, MySQL Enterprise Monitor Glossary

Cluster

Managing clusters, NDB Clusters View

Cluster Advisors

Cluster Data Node Redo Buffer Space Getting Low, Cluster Data Node Redo Buffer Space Getting Low

Cluster Data Node Redo Log Space Getting Low, Cluster Data Node Redo Log Space Getting Low

Cluster Data Node Undo Buffer Space Getting Low, Cluster Data Node Undo Buffer Space Getting Low

Cluster Data Node Undo Log Space Getting Low, Cluster Data Node Undo Log Space Getting Low

Cluster DiskPageBuffer Hit Ratio Is Low, Cluster DiskPageBuffer Hit Ratio Is Low

config.properties file, The config.properties file

Configuration, Configuring MySQL Enterprise Service Manager

configuration files, MySQL Enterprise Service Manager Log Files

configuration utilities

agent, Agent Configuration Utility

agent.bat, Agent Configuration Utility

agent.sh, Agent Configuration Utility

config.bat, Configuration Utilities

config.sh, Configuration Utilities

service manager, Configuration Utilities

Configuration View

Configuration Filters, Configuration Views

--createBackup option, MySQL Enterprise Monitor Agent Options

--createDataBackup option, MySQL Enterprise Service Manager Options

credentials, MySQL Enterprise Monitor Glossary

Critical, MySQL Enterprise Monitor Glossary

custom, MySQL Enterprise Monitor Glossary

custom data collection

customizing advisors, Custom Data Collection

D

[index top]

data collection item, MySQL Enterprise Monitor Glossary

--dbhost option, MySQL Enterprise Service Manager Options

--dbname option, MySQL Enterprise Service Manager Options

dbpool.default.initialSize option, Usage

dbpool.default.maxActive option, Usage

dbpool.default.maxIdle option, Usage

dbpool.default.maxWaitMillis option, Usage

dbpool.default.minEvictableIdleTimeMillis option, Usage

dbpool.default.minIdle option, Usage

dbpool.default.timeBetweenEvictionRunsMillis option, Usage

dbpool.ui.initialSize option, Usage

dbpool.ui.maxActive option, Usage

dbpool.ui.maxIdle option, Usage

dbpool.ui.maxWaitMillis option, Usage

dbpool.ui.minEvictableIdleTimeMillis option, Usage

dbpool.ui.minIdle option, Usage

dbpool.ui.timeBetweenEvictionRunsMillis option, Usage

--dbport option, MySQL Enterprise Service Manager Options

--debuglevel option, MySQL Enterprise Service Manager Options, MySQL Enterprise Monitor Agent Options

--debugtrace option, MySQL Enterprise Service Manager Options, MySQL Enterprise Monitor Agent Options

Deleting Assets, Deleting Assets

diagnostic report, MySQL Enterprise Monitor Support, MySQL Enterprise Monitor Glossary

Diagnostics Report, Diagnostics Report

E

[index top]

event, MySQL Enterprise Monitor Glossary

event handler, MySQL Enterprise Monitor Glossary

Events, Events, MySQL Enterprise Monitor Glossary

EXPLAIN plan, MySQL Enterprise Monitor Glossary

expression, MySQL Enterprise Monitor Glossary

expressions, Thresholds

F

[index top]

FAQs, MySQL Enterprise Monitor Frequently Asked Questions

Filtering

Named Filters, System and User-defined Filters

firewall, MySQL Enterprise Monitor Glossary

firewall issues, Monitoring Outside the Firewall with an SSH Tunnel

--forceRestart option, MySQL Enterprise Service Manager Options

full table scan, MySQL Enterprise Monitor Glossary

G

[index top]

--generalpassword option, MySQL Enterprise Monitor Agent Options

--generaluser option, MySQL Enterprise Monitor Agent Options

graph, MySQL Enterprise Monitor Glossary

graphs

creating, Creating Advisors and Rules, Creating a New Graph: An Example

Group Replication Advisors

Group Replication Configuration, Group Replication Configuration Advisor

Group Replication Status, Group Replication Status Advisor

H

[index top]

heartbeat, MySQL Enterprise Monitor Glossary

--help option, MySQL Enterprise Service Manager Options, MySQL Enterprise Monitor Agent Options

host, MySQL Enterprise Monitor Glossary

Hosts

Managing hosts, Hosts View

I

[index top]

InnoDB Buffer Pool Usage Report, InnoDB Buffer Pool Usage

installation

agent, Monitor Agent Installation

backup, Restoring from Backup

post-install tasks, Post-installation Considerations

service manager, Service Manager Installation

unattended, Unattended Installation

uninstalling, Uninstalling MySQL Enterprise Monitor

--installdir option, MySQL Enterprise Service Manager Options, MySQL Enterprise Monitor Agent Options

--installer option, MySQL Enterprise Service Manager Options

--installer-language option, MySQL Enterprise Monitor Agent Options

instance, MySQL Enterprise Monitor Glossary

Instance Status

Status Summary, Status Summary

instrument, MySQL Enterprise Monitor Glossary

Inventory

Deleting Assets, Deleting Assets

inventory, MySQL Enterprise Monitor Glossary

Inventory management

assets, Asset Management

J

[index top]

Java, MySQL Enterprise Monitor Glossary

Java VM

installation, Service Manager Installation

JDBC, MySQL Enterprise Monitor Glossary

JET, MySQL Enterprise Monitor Glossary

L

[index top]

LDAP, MySQL Enterprise Monitor Glossary

--limitedpassword option, MySQL Enterprise Monitor Agent Options

--limiteduser option, MySQL Enterprise Monitor Agent Options

Linux, Starting/Stopping the Agent on Unix, MySQL Enterprise Service Manager Log Files

locale, Setting the Timezone and Locale

log file, MySQL Enterprise Monitor Glossary

MySQL Enterprise Service Manager, MySQL Enterprise Service Manager Log Files

Logout

User Menu, User Menu

Lua, MySQL Enterprise Monitor Glossary

M

[index top]

Mac OS X, Starting/Stopping the Agent on macOS, macOS Platforms, MySQL Enterprise Service Manager Log Files

macOS, Starting/Stopping the Agent on macOS, macOS Platforms, MySQL Enterprise Service Manager Log Files

--managerhost option, MySQL Enterprise Monitor Agent Options

--managerport option, MySQL Enterprise Monitor Agent Options

master, MySQL Enterprise Monitor Glossary

master/slave, MySQL Enterprise Monitor Glossary

Memory Usage Advisors, Memory Usage Advisors

InnoDB Buffer Cache Has Sub-Optimal Hit Rate, InnoDB Buffer Cache Has Sub-Optimal Hit Rate

Key Buffer Size May Not Be Optimal For Key Cache, Key Buffer Size May Not Be Optimal For Key Cache

Query Cache Has Sub-Optimal Hit Rate, Query Cache Has Sub-Optimal Hit Rate

Query Cache Potentially Undersized, Query Cache Potentially Undersized

Table Cache Not Optimal, Table Cache Not Optimal

Thread Cache Size May Not Be Optimal, Thread Cache Size May Not Be Optimal

Memory Usage Report, Memory Usage Report

Menus

Metrics, Metrics

metric, MySQL Enterprise Monitor Glossary

MIB file, The Management Information Base (MIB) File

mixed replication, MySQL Enterprise Monitor Glossary

--mode option, MySQL Enterprise Service Manager Options, MySQL Enterprise Monitor Agent Options

monitor, MySQL Enterprise Monitor Glossary

installation, Service Manager Installation

Monitoring and Support Advisors

sys Schema Install Advisor, sys Schema Install Advisor

Monitoring and Support Services Advisors, Monitoring and Support Services Advisors

Duplicate Host Identity, Duplicate Host Identity

Duplicate MySQL Server UUID, Duplicate MySQL Server UUID

HTTP Server Performance, HTTP Server Performance

MySQL Process Discovery Advisor, MySQL Process Discovery Advisor

Support Diagnostics, Support Diagnostics

Unsupported Agent Version, Unsupported Agent Version Advisor

My Oracle Support, MySQL Enterprise Monitor Glossary

MySQL Enterprise Backup, Backup the Repository

MySQL Server

installation, Service Manager Installation

MySQL server, MySQL Enterprise Monitor Glossary

mysql-monitor-agent.log file, Agent Log Files

--mysqlconnectiongroup option, MySQL Enterprise Monitor Agent Options

--mysqlconnmethod option, MySQL Enterprise Monitor Agent Options

mysqldump, Backup the Repository

--mysqlhost option, MySQL Enterprise Monitor Agent Options

--mysql-identity-source option, MySQL Enterprise Service Manager Options

--mysqlpassword option, MySQL Enterprise Monitor Agent Options

--mysqlport option, MySQL Enterprise Monitor Agent Options

--mysqlsocket option, MySQL Enterprise Monitor Agent Options

--mysqluser option, MySQL Enterprise Monitor Agent Options

--mysql_installation_type option, MySQL Enterprise Service Manager Options

N

[index top]

Named Filters

Creating Filters, System and User-defined Filters

NDB Cluster Advisors, NDB Cluster Advisors

NDB Cluster Memory Usage Report

NDB Cluster, NDB Cluster Memory Usage

.NET, MySQL Enterprise Monitor Glossary

NMS, MySQL Enterprise Monitor Glossary

normalized query, MySQL Enterprise Monitor Glossary

Notice, MySQL Enterprise Monitor Glossary

notification, MySQL Enterprise Monitor Glossary

notification group, MySQL Enterprise Monitor Glossary

O

[index top]

Operating System Advisors, Operating System Advisors

CPU Utilization Advisor, CPU Utilization Advisor

Filesystem Free Space Advisor, Filesystem Free Space Advisor

--optionfile option, MySQL Enterprise Service Manager Options, MySQL Enterprise Monitor Agent Options

OS X, Starting/Stopping the Agent on macOS, macOS Platforms, MySQL Enterprise Service Manager Log Files

overview, MySQL Enterprise Monitor Introduction and Architecture

Overview, Overview

P

[index top]

Performance Advisors, Performance Advisors

Binary Log Usage Exceeding Disk Cache Memory Limits, Binary Log Usage Exceeding Disk Cache Memory Limits

Excessive Disk Temporary Table Usage Detected, Excessive Disk Temporary Table Usage Detected

Excessive Number of Locked Processes, Excessive Number of Locked Processes

Excessive Number of Long Running Processes, Excessive Number of Long Running Processes

Excessive Number of Long Running Processes Locked, Excessive Number of Long Running Processes Locked

Flush Time Set To Non-Zero Value, Flush Time Set To Non-Zero Value

Indexes Not Being Used Efficiently, Indexes Not Being Used Efficiently

InnoDB Buffer Pool Writes May Be Performance Bottleneck, InnoDB Buffer Pool Writes May Be Performance Bottleneck

InnoDB Flush Method May Not Be Optimal, InnoDB Flush Method May Not Be Optimal

InnoDB Log Buffer Flushed To Disk After Each Transaction, InnoDB Log Buffer Flushed To Disk After Each Transaction

InnoDB Log Waits May Be Performance Bottleneck, InnoDB Log Waits May Be Performance Bottleneck

InnoDB Not Using Newest File Format, InnoDB Not Using Newest File Format

MyISAM Concurrent Insert Setting May Not Be Optimal, MyISAM Concurrent Insert Setting May Not Be Optimal

Prepared Statements Not Being Closed, Prepared Statements Not Being Closed

Prepared Statements Not Being Used Effectively, Prepared Statements Not Being Used Effectively

Query Cache Is Excessively Fragmented, Query Cache Is Excessively Fragmented

Table Lock Contention Excessive, Table Lock Contention Excessive

Thread Cache Not Enabled, Thread Cache Not Enabled

Thread Pool Stall Limit Too Low, Thread Pool Stall Limit Too Low

Thread Pooling Not Enabled, Thread Pooling Not Enabled

Too Many Concurrent Queries Running, Too Many Concurrent Queries Running

performance schema, Using the MySQL Performance Schema

performance tuning, Performance Tuning MySQL Enterprise Monitor

PHP, MySQL Enterprise Monitor Glossary

ports

MySQL server for monitoring, MySQL Enterprise Monitor Agent Options

MySQL server for repository, MySQL Enterprise Service Manager Options

service manager, MySQL Enterprise Service Manager Options, MySQL Enterprise Monitor Agent Options

Tomcat, MySQL Enterprise Service Manager Options

Tomcat SSL, MySQL Enterprise Service Manager Options

post-install tasks, Post-installation Considerations

Q

[index top]

QRTi, MySQL Enterprise Monitor Glossary

QuAn, MySQL Enterprise Monitor Glossary

query, MySQL Enterprise Monitor Glossary

Query Analysis Advisors, Query Analysis Advisors

Average Statement Execution Time Advisor, Average Statement Execution Time Advisor

Query Analysis Reporting, Query Analysis Reporting

Query Pileup Advisor, Query Pileup Advisor, Query Analysis Reporting

SQL Statement Generates Warnings or Errors, SQL Statement Generates Warnings or Errors

Query Analyzer, Statements, Query Analyzer View, MySQL Enterprise Monitor Glossary

Query Details, Detailed Query Information

supplying query data, Providing Query Analyzer Data

Query Analyzer view, MySQL Enterprise Monitor Glossary

R

[index top]

remote, MySQL Enterprise Monitor Glossary

remote monitoring, MySQL Enterprise Monitor Glossary

replica, MySQL Enterprise Monitor Glossary

Replication, Replication Dashboard

replication, MySQL Enterprise Monitor Glossary

Replication Advisors, Replication Advisors

Binary Log Checksums Disabled, Binary Log Checksums Disabled

Binary Log File Count Exceeds Specified Limit, Binary Log File Count Exceeds Specified Limit

Binary Log Row Based Images Excessive, Binary Log Row Based Images Excessive

Binary Log Space Exceeds Specified Limit, Binary Log Space Exceeds Specified Limit

Master Not Verifying Checksums When Reading From Binary Log, Master Not Verifying Checksums When Reading From Binary Log

Replica Execution Position Too Far Behind, Replica Execution Position Too Far Behind

Replication Configuration Advisor, Replication Configuration Advisor

Replication Status Advisor, Replication Status Advisor

Replication Too Far Behind, Replication Too Far Behind

Slave Detection Of Network Outages Too High, Slave Detection Of Network Outages Too High

Slave Has Login Accounts With Inappropriate Privileges, Slave Has Login Accounts With Inappropriate Privileges

Slave Not Configured As Read Only, Slave Not Configured As Read Only

Slave Not Verifying Checksums When Reading From Relay Log, Slave Not Verifying Checksums When Reading From Relay Log

Slave Relay Log Space Is Very Large, Relay Log Space Is Very Large, Slave Relay Logs Not Automatically Purged

Slave SQL Processing Not Multi-Threaded, Slave SQL Processing Not Multi-Threaded

Slave Without REPLICATION SLAVE Accounts, Slave Without REPLICATION SLAVE Accounts

Replication view, MySQL Enterprise Monitor Glossary

repository, MySQL Enterprise Monitor Glossary

database name, MySQL Enterprise Service Manager Options

--restartImmediately option, MySQL Enterprise Monitor Agent Options

restore

backup, Restoring from Backup

restoring

backup, Restoring from Backup

role, MySQL Enterprise Monitor Glossary

rules

blackout periods, Event Notification Blackout Periods

creating, Creating Advisors and Rules

variable substitution, Variables

S

[index top]

schedule, MySQL Enterprise Monitor Glossary

Schema Advisors, Schema Advisors

AUTO_INCREMENT Field Limit Nearly Reached, AUTO_INCREMENT Field Limit Nearly Reached

MyISAM Indexes Found with No Statistics, MyISAM Indexes Found with No Statistics

Object Changed: Database Has Been Altered, Object Changed: Database Has Been Altered

Object Changed: Database Has Been Created, Object Changed: Database Has Been Created

Object Changed: Database Has Been Dropped, Object Changed: Database Has Been Dropped

Object Changed: Function Has Been Created, Object Changed: Function Has Been Created

Object Changed: Function Has Been Dropped, Object Changed: Function Has Been Dropped

Object Changed: Index Has Been Created, Object Changed: Index Has Been Created

Object Changed: Index Has Been Dropped, Object Changed: Index Has Been Dropped

Object Changed: Table Has Been Altered, Object Changed: Table Has Been Altered

Object Changed: Table Has Been Created, Object Changed: Table Has Been Created

Object Changed: Table Has Been Dropped, Object Changed: Table Has Been Dropped

Object Changed: User Has Been Dropped, Object Changed: User Has Been Dropped

Object Changes Detected, Object Changes Detected

Server-Enforced Data Integrity Checking Disabled, Server-Enforced Data Integrity Checking Disabled

Server-Enforced Data Integrity Checking Not Strict, Server-Enforced Data Integrity Checking Not Strict

Tables Found with No Primary or Unique Keys, Tables Found with No Primary or Unique Keys

scope, MySQL Enterprise Monitor Glossary

Security Advisors, Security Advisors, Security Advisors

Account Has Old Insecure Password Hash, Account Has Old Insecure Password Hash

Account Requires Unavailable Authentication Plug-ins, Account Requires Unavailable Authentication Plug-ins

Insecure Password Authentication Option Is Enabled, Insecure Password Authentication Option Is Enabled

Insecure Password Generation Option Is Enabled, Insecure Password Generation Option Is Enabled

LOCAL Option Of LOAD DATA Statement Is Enabled, LOCAL Option Of LOAD DATA Statement Is Enabled

MySQL Enterprise Audit Plugin, MySQL Enterprise Audit Plugin

MySQL User Account, MySQL User Account

Policy-Based Password Validation Does Not Perform Dictionary Checks, Policy-Based Password Validation Does Not Perform Dictionary Checks

Policy-Based Password Validation Is Weak, Policy-Based Password Validation Is Weak

Policy-Based Password Validation Not Enabled, Policy-Based Password Validation Not Enabled

Privilege Alterations Detected: Privileges Granted, Privilege Alterations Detected: Privileges Granted

Privilege Alterations Detected: Privileges Revoked, Privilege Alterations Detected: Privileges Revoked

Privilege Alterations Have Been Detected, Privilege Alterations Have Been Detected

Root Account Can Login Remotely, Root Account Can Login Remotely

Root Account Without Password, Root Account Without Password

Server Contains Default "test" Database, Server Contains Default "test" Database

Server Has Accounts Without A Password, Server Has Accounts Without A Password

Server Has Anonymous Accounts Not Being Used As Proxies, Server Has Anonymous Accounts Not Being Used As Proxies

Server Has No Locally Authenticated Root User, Server Has No Locally Authenticated Root User

Server Includes A Root User Account, Server Includes A Root User Account

SHA-256 Password Authentication Not Enabled, SHA-256 Password Authentication Not Enabled

Symlinks Are Enabled, Symlinks Are Enabled

User Has Rights To Database That Does Not Exist, User Has Rights To Database That Does Not Exist

User Has Rights To Table That Does Not Exist, User Has Rights To Table That Does Not Exist

Users Can View All Databases On MySQL Server, Users Can View All Databases On MySQL Server

service manager

configuration utility, Service Manager Configuration Utilities

database name, MySQL Enterprise Service Manager Options

installation, Service Manager Installation

Service Manager, MySQL Enterprise Monitor Glossary

service request, MySQL Enterprise Monitor Glossary

services

starting and stopping, Starting/Stopping MySQL Enterprise Monitor Services

Settings, MySQL Enterprise Monitor Glossary

severity, MySQL Enterprise Monitor Glossary

slave, MySQL Enterprise Monitor Glossary

slow query log, MySQL Enterprise Monitor Glossary

SMTP, MySQL Enterprise Monitor Glossary

SNMP, MySQL Enterprise Monitor Glossary

SNMP traps, The Management Information Base (MIB) File

source, MySQL Enterprise Monitor Glossary

source/replica, MySQL Enterprise Monitor Glossary

sql_mode, sql_mode

SSH tunneling, Monitoring Outside the Firewall with an SSH Tunnel

SSL, MySQL Enterprise Service Manager Options, MySQL Enterprise Monitor Glossary

standard, MySQL Enterprise Monitor Glossary

starting

MySQL Enterprise Monitor service, Starting/Stopping MySQL Enterprise Monitor Services on Windows

MySQL Enterprise Monitor services, Starting/Stopping MySQL Enterprise Monitor Services

Status Summary, MySQL Enterprise Monitor Glossary

Instance Status, Status Summary

stopping

MySQL Enterprise Monitor service, Starting/Stopping MySQL Enterprise Monitor Services on Windows

MySQL Enterprise Monitor services, Starting/Stopping MySQL Enterprise Monitor Services

support files

diagnostic report, MySQL Enterprise Monitor Support

support issue, MySQL Enterprise Monitor Glossary

--system-size option, MySQL Enterprise Service Manager Options

T

[index top]

Table Statistics Report, Table Statistics

threshold, MySQL Enterprise Monitor Glossary

thresholds, Thresholds

timezone, Setting the Timezone and Locale

Tomcat, MySQL Enterprise Monitor Glossary

installation, Service Manager Installation

starting and stopping, Starting/Stopping MySQL Enterprise Monitor Services on Windows

--tomcatport option, MySQL Enterprise Service Manager Options

--tomcatsslport option, MySQL Enterprise Service Manager Options

topology, MySQL Enterprise Monitor Glossary

topology view, MySQL Enterprise Monitor Glossary

tree, MySQL Enterprise Monitor Glossary

trending, MySQL Enterprise Monitor Glossary

troubleshooting, Troubleshooting the Agent

tuning, Performance Tuning MySQL Enterprise Monitor

U

[index top]

UI, MySQL Enterprise Monitor Glossary

unattended installation, Unattended Installation

--unattendedmodeui option, MySQL Enterprise Service Manager Options, MySQL Enterprise Monitor Agent Options

uninstalling, Uninstalling MySQL Enterprise Monitor

Unix, Starting/Stopping the Agent on Unix, MySQL Enterprise Service Manager Log Files

User Menu

Logout, User Menu

User Preferences, User Menu

User Preferences

User Menu, User Menu

User Statistics Report, User Statistics

UUID, MySQL Enterprise Monitor Glossary

V

[index top]

variable substitution, Variables

--version option, MySQL Enterprise Service Manager Options, MySQL Enterprise Monitor Agent Options

W

[index top]

Warning, MySQL Enterprise Monitor Glossary

Web browsers, Supported Browsers

What's New tab, MySQL Enterprise Monitor Glossary

Wiki markup, Wiki Format

Windows, Starting/Stopping MySQL Enterprise Monitor Services on Windows, Starting/Stopping the Agent on Windows, Windows Platforms, MySQL Enterprise Service Manager Log Files