MaxGauge is performance management too designed to support an effective performance management and fault management of each component which make up the computer system including the database, system, applications, and etc. In respect of a system administrator who oversees the system operation, the three tasks shown in the diagram below are essential to performance management, and each task must be carried out on the basis of a mutual interworking relationship.
MaxGauge supports system administrators or database and application administrators who oversee the performance management and fault management, to be effective in real-time monitoring, diagnosis, and analysis. And through the real-time monitoring feature, it allows the administrator to easily and quickly identify in which database or server the error occurred or the performance degradation occurred, among the many servers and databases. In the event of an error or performance degradation, it easily identifies exactly in which part by what factors the problem occurred through a diagnosis process, ensuring a real-time resolution as much as possible, and it further investigates the root cause of the error or performance degradation through a post-analysis so that appropriate troubleshooting actions may be taken.
Let us explain about the functions which MaxGague provides for the performance management of MySQL database. The functions can be largely divided into real-time monitoring and diagnosis section and the post-anlysis section. We will briefly explain the functions provided by each section. MaxGauge provides functions which checks the current performance status of MySQL database, monitors if any indicator has exceeded the predefined threshold values, and tracks down the root cause of the problem in the event of performance issues. These functions allow the MySQL DBA or performance administrators to recognize potential performance issues and make corrections to prevent problems before they occur. And the activities which occur during the database operation are logged in detail and made available by date and time as a resource for identifying the problems.
Integrated Monitoring Function
By monitoring multiple MySQL databases on a single screen, you can easily identify and resolve the MySQL performance issues scattered across the system network. You can also monitor by comparing the data of several databases in respect of one particular indicator.
Session Monitoring Function
By monitoring the current wait information and SQL information of a particular session from a single screen organically, you can identify the current performance status of a session in real-time.
REPLICATION Environment Monitoring Function
You can monitor replication delays and replication fails of a database configured with replication in real-time.
Session Query Function
You can search for several sessions connected to a single database by conditions and simultaneously monitor the aggregates of sessions which meet the conditions. You can query a session’s ID, Thread ID, User Name, Host Name, and the SQL Text currently executing.
LOCK Tracing Function
You can trace the wait relationships of locks generated in MySQL database in real-time. You can analyze the the session holding the lock and the waiting sessions organically through a tree format, and monitor dead locks in real-time.
Cloudwatch metrics monitoring feature
By providing information provided in Cloudwatch such as the server’s CPU Utilization, Freeable Memory, etc., it allows the user to effectively monitor even more performance metrics.
Wait Indicator Logging Function
Provides logging data of all the wait indicators generated in MySQL for the user’s convenience in analysis.
Active Thread Logging Function
According to the logging cycle defined by the user, it provides the details of all the active threads executed during the period and the currently executing SQL Text.
Lock Logging Function
According to the logging cycle defined by the user, it provides the logging data through which you can analyzethe lock and the lock holders generated during the period in a tree structure.
Parameter Logging Function
Logs parameters once a day and is provided to the user.
Deadlock Logging Function
Logs InnoDB’s deadlock information taken every minute.
Innodb Status Logging Function
Logs InnoDB’s status information taken every 5 minutes.
Threshold Values Alarm Function
Besides the collected indicators, it also provides alarms for the monitoring server’s Disk Free Size and the Replication information.