The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

MONyog Monitoring

Is MONyog capable of monitoring INNODB table locks and mutex locks?? Also can it monitor binary logs of MariaDB database.??

Answer Answered by Sibin AS in this comment.

You can monitor the locks on queries, locks on tables and deadlocks using MONyog.

If a transaction in InnoDB has acquired a lock on a row or table then the query which has acquired the lock is called Locking query . MONyog gathers the information about locked queries, locking queries and locked tables from various innodb tables in information_schema like innodb_trx, innodb_locks, innodb_lock_waits ( these values are only related to InnoDB transactions).

To get the value for locking queries you have to start the Real-Time feature of MONyog, there you can see the time information of locked queries, locked tables and locking queries.

You can enable deadlock monitoring, by just selecting "Yes" for the option "Enable deadlock monitoring?" (Edit server -> Advanced settings -> Deadlock) and MONyog will start tracing deadlocks. Once you have enabled, you can get the information from the group "InnoDB Deadlocks" having counters "New deadlock detected" and "Latest detected deadlock". "New deadlock detected" tells if a new deadlock was reported by "SHOW ENGINE INNODB STATUS" between the last two data retrievals and "last deadlock detected" shows information about the last deadlock detected (if any). These two counters are alertable by default, you just need to enable mail alerts and you will be notified in the occurrence of such events.

You can monitor the error logs, general log and slow_query log file in MONyog and you can also refer our documentation for the same, here >> http://monyogkb.webyog.com/article/29-advanced-settings and http://monyogkb.webyog.com/article/60-different-types-of-logs-supported

It is currently not possible to monitor the binary logs in MONyog.

You may write to support@webyog.com if you have any queries in MONyog. Sibin (Webyog)

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.