Atlas ITSI Content Pack for MySQL
Overview
Details
The ITSI Content Pack for MySQL contains service definitions and KPIs ready to import to ITSI. The KPI Thresholds and importance values are set to defaults so that they can be tuned manually for your use case. After configuration, this content pack provides a comprehensive monitoring solution for MySQL databases, ensuring optimal performance and reliability.
Presidio Splunk Solutions ITSI Content Pack Blog
For more information about Presidio Splunk Solutions' Products, visit our website
Services
MySQL monitoring encompasses several specialized services, each targeting specific aspects of database performance:
- Database
- Description: Core MySQL database service responsible for data storage and retrieval.
- Connections
- Description: Manages client connections to the MySQL database.
- Storage
- Description: Manages the storage and retrieval of data within the MySQL database.
- Performance
- Description: Monitors and optimizes the performance of the MySQL database.
- Replication
- Description: Manages data replication between MySQL instances.
KPIs
Each service utilizes specific KPIs to measure its effectiveness:
- Conn Count
- Description: Number of active connections.
- Aborted Conns
- Description: Number of aborted connections.
- Threads Running
- Description: Number of running threads.
- Threads Connected
- Description: Number of connected threads.
- Disk IO
- Description: Disk input/output operations.
- Buffer Hit Rate
- Description: Rate of buffer pool hits.
- Open Files
- Description: Number of open files.
- Open Tables
- Description: Number of open tables.
- CPU Pct
- Description: CPU usage percentage.
- Mem Usage
- Description: Memory usage.
- Query Time
- Description: Average query execution time.
- Slow Queries
- Description: Number of slow queries.
- Repl Lag
- Description: Replication lag time.
- Repl Errors
- Description: Number of replication errors.
- Repl Events
- Description: Number of replication events.
Relationships
Dependencies:
Services are interconnected; for instance, the Database service is the central component of MySQL, upon which other services like connections, storage, performance, and replication depend.
Hierarchical Structure:
Some services form a hierarchy, such as the Database service being the core, with other services like Connections, Storage, Performance, and Replication building upon it, illustrating a layered approach to performance monitoring where base metrics support broader performance indicators.
Release Notes
Version 1.0.0
Documentation Update
Version 0.0.1
Initial Release