MySQL Monitoring and Performance Management

• Continuously monitor the availability and responsiveness of MySQL instances
• Track connection traffic to each MySQL instance and identify whether there are any denial-of-service attacks happening
• Identify whether specific users or applications are causing connection leaks on the MySQL server, leading to slowness for other users and applications
• Identify long running queries; provide query execution plans to identify whether longer execution time is due to table scans or bad design of the queries
• Monitor all user processes and their active/inactive states, so that if and when slowness is detected, this can be correlated back to a specific user's activity
• By looking at percentage rollbacks, it helps to detect inefficient application design

• Monitor the size of each database; be alerted to any databases that are rapidly growing in size
• Monitor large tables by size and records for capacity issues and binary log size growth to make sure there is sufficient space available for MySQL's archive log
• Monitor InnoDB, the main storage engine of each MySQL instance. Track throughput, IOPS, pending log writes, and data file pending reads and writes to identify bottlenecks in the database engine
• Track InnoDB memory usage and receive alerts when memory usage is nearing maximum capacity
• Identify whether there are an excessive number of locks or lock waits in the InnoDB

• Monitor the cluster members and receive alerts if any unavailability or slowness is detected
• Monitor the state changes of any of the nodes in the cluster
• Monitor all the KPIs per node in the cluster
• Monitor the workload on each node and identify situations where one node is more heavily loaded than the other
• Monitor whether the replication works fine and detect any back lag as per RTO objective and help to take preventive action

eG Enterprise application performance monitoring allows database performance to be monitored in the context of the applications using MySQL database servers.

• Without requiring any agents on the database servers, eG Enterprise APM traces all application accesses and reports on slow queries and exceptions during database processing.
• When a specific web page or URL is slow, you don't have to spend hours figuring out what is causing the slowdown. eG Enterprise APM gives you the answers at your fingertips.
• Eliminates finger-pointing between application development, application operations, and database admin teams by finding the root cause and not the symptoms.