Part IV Using MySQL Enterprise Monitor

Table of Contents

25 Overview

25.1 Overview Sparkline Graphs

25.2 Database Availability

25.3 General Database Statistics

26 Events

26.1 Events

27 Enterprise Backup Dashboard

27.1 Backup Overview

27.2 Backup Details

28 Replication Dashboard

28.1 Replication Overview

28.2 Replication Dashboard Tabs

28.3 Replication Logging

29 Topology

30 Reports and Graphs

30.1 All Timeseries Graphs

30.1.1 Graph Controls

30.1.2 Graph Types

30.1.3 Timeseries Data Aggregation

30.2 Database File I/O and Lock Waits

30.2.1 sys Schema

30.2.2 Database File I/O Graphs and Reports

30.2.3 Lock Waits Report

30.3 Processes Report

30.4 Table Statistics

30.5 User Statistics

30.6 Memory Usage Report

30.7 InnoDB Buffer Pool Usage

30.8 NDB Cluster Memory Usage

31 Customizing MySQL Enterprise Monitor

31.1 Creating Advisors and Rules

31.1.1 Creating Advisors

31.1.2 Overview of Graph Creation

31.1.3 Overview of Advisor Creation

31.1.4 Variables

31.1.5 Thresholds

31.1.6 Using Strings

31.1.7 Wiki Format

31.1.8 Creating a New Advisor: An Example

31.1.9 Creating a New Graph: An Example

31.2 Custom Data Collection

31.2.1 Custom.xml

31.2.2 Queries

31.2.3 Data Collection Attributes

31.3 Event Notification Blackout Periods

31.3.1 Scripting Blackouts