MySQL

The Technical Specifications below provide details on metrics collected by the MySQL application, how those metrics are evaluated by Longitude, and the available preconfigured reports. For additional details on the Longitude SQL Server application, see the MySQL Application User Guide or contact Heroix Support.

Events

Longitude Events are generated when collected performance and availability metrics are evaluated by Longitude’s rule engine and a potential problem is detected.

The rules use best-practice thresholds, displayed below, which can be customized as needed.

Reports

Longitude reports display performance and availability metrics over time. Summary reports display average metrics across multiple devices, while detail reports drill down and present a more granular view of metrics for a selected device.

 

Process
Metrics Events
Process id
User name
Host name
Database name
Command
Time
State
Information
Locked Processes: State = LOCKED
Status
Metrics Events
Key Write Requests
Threads Connected
Threads Running
Aborted Clients
Questions
Uptime
Opened Tables
Select Full Join
Select Scan
Slow Queries
Key Read Requests
Key Reads
Key Writes
Low Read Cache: (Key Read Requests – Key Reads)/(Key Read Requests) < 90%
Low Write Cache: (Key Write Requests – Key Writes)/(Key Write Requests) < 90%
High Table Open Rate: (Opened Tables)/(Collection Interval) > 2 tables/sec
Too Many Joins Without Indexes: Select Full Join > 0
Too Many Slow Queries: (Slow Queries)/(Questions) > 5%
Too Many Threads Connected: Threads Connected > 200
Too Many Threads Running: Threads Running > 20
Unusual Number of Requests: Questions +/- 35% of decayed average number of questions
Reports
Summary Key Read Cache % over multiple MySQL instances
Detail Detailed Key Read Cache % per MySQL instance
Summary Key Write Cache % over multiple MySQL instances
Detail Detailed Key Write Cache % per MySQL instance
Summary Opened Table Rate over multiple MySQL instances
Detail Detailed Opened Table Rate per MySQL instance
Summary Slow and Non-slow Query Rates over multiple MySQL instances
Detail Detailed Slow and Non-slow Query Rates per MySQL instance
Summary Threads Connected and Threads Running over multiple MySQL instances
Detail Detailed Threads Connected and Threads Running per MySQL instance
TableSpace
Metrics Events
Table name
Engine
Average Row Length
Data Length
Max Data Length
Data Free
Tablespace free space KB
TableSpace Full: Tablespace free space KB < 256 KB
Reports
Summary TableSpace Free over multiple MySQL instances
Detail Detailed TableSpace Free per MySQL instance

Top
Insight Manager Netflow