You can view previous deadlocks by clicking the View All button. You'll find the Latest Deadlocked Query in the top portion of the screen: The Query Analyzer screen shows the summary information of all executing queries and helps you identify problematic queries, such as top queries with cumulative execution time count, slow queries, and deadlocks caused by two or more queries blocking each other.

Save the most recent configuration and restore whenever you like.

Restrict login or role access by IP Address.

User integration for OpenLDAP or Active Directory.

Detect MySQL/MariaDB hacking activities.

Improve MySQL/MariaDB security by sending you alerts.

Control of access to your monitoring assets and features.

Send alerts when any replication problems are detected.

Replication error history for replication trouble shooting.

Displays your Replication Topologies and enable you to quickly see the status of each replication.

Store a history to diagnose deadlock problems.

Find out queries having the biggest impact on your system.

Analysing Slow Query Log and General Query Log.

Use SMTP, SMS, SNMP Trap and Slack with customizable thresholds.

Get helpful advice on how to improve server performances.

Come preconfigured with over 40 fully-customizable alert policies.

Generate reports for server performance metrics.

Monitor the live MySQL/MariaDB metrics, CPU, memory and swap usage on host machines.

View all registered MySQL/MariaDB instances and availability groups on one central web-based interface.

Moreover, Navicat Monitor is accessible from anywhere via a web browser, thus providing you unhampered access to easily and seamlessly track your servers from anywhere in the world, at any time of day or night. The term 'agentless' is key because it describes a server-based architecture that does not require any software installation on the servers being monitored. Navicat Monitor is an agentless remote server monitoring tool for MySQL/MariaDB that is packed with features to make monitoring your database (DB) instances as effective and easy as possible. In today's follow-up will present a different approach to bottlenecks and deadlock investigation using Navicat Monitor. In last week's How the MySQL 8 Performance Schema Helps Diagnose Query Deadlocks blog, we had a crash course on Mutexes and Threads, learned about the MySQL Performance Schema, and applied a few queries against it for investigating performance bottlenecks.

Navicat 8 for mysql