Comments - MONyog Monitoring
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.
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 firstname.lastname@example.org if you have any queries in MONyog. Sibin (Webyog)