Navicat Blog

Jan 8, 2019 by Robert Gravelle

Navicat Monitor for MySQL/MariaDB's starting screen is the Overview Dashboard. It's a one-stop shop of the real-time analytics for the health and performance of all your instances. Since the introduction of Compact View in version 1.7, you can now monitor hundreds of instances at a glance! In today's blog, we'll learn how to build a customized dashboard for your server metrics to get a global view of each instance, as well as apply instance grouping.

Dec 31, 2018 by Robert Gravelle

The Query Analyzer Section

Navicat Monitor for MySQL/MariaDB's Query Analyzer tool provides a graphical representation of the query logs that makes interpreting their contents much easier. In addition, the Query Analyzer tool enables you to monitor and optimize query performance, visualize query activity statistics, analyze SQL statements, as well as quickly identify and resolve long running queries. Last week's blog provided an overview of this useful feature and described how to take full advantage of the Latest Deadlock Query and Process List screen sections. In this 2nd and final installment, we will learn all about the Query Analyzer screen section.

Dec 24, 2018 by Robert Gravelle

Overview, Latest Deadlock Query and Process List screens

As touched upon in the last blog series on the MySQL/MariaDB logs, one of the primary complaints levied by database administrators (DBAs) about the General and Slow Query logs is that their contents are difficult to read. The solution? Monitor your logs using Navicat Monitor for MySQL/MariaDB! Its Query Analyzer tool provides a graphical representation for the query logs that enables you to monitor and optimize query performance, visualize query activity statistics, analyze SQL statements, as well as quickly identify and resolve long running queries. Today's blog will provide an overview of this useful feature as well as describe how to take full advantage of the Latest Deadlock Query and Process List screens. Part 2 will be devoted to the Query Analyzer screen section.

Dec 18, 2018 by Robert Gravelle

One of the main roles of database monitoring is to catch potential issues before they develop into real problems. To that end, Navicat Monitor for MySQL/MariaDB offers advanced root cause analysis that enables you to find in-depth information when an issue occurs. This functionality is part of the Alerts feature.

Dec 11, 2018 by Robert Gravelle

Welcome back to this blog series on MySQL logging. We'll be referencing these first three installments later on when we talk about monitoring in Navicat Monitor for MySQL/MariaDB. Part I provided an overview of the different log types on MySQL, highlighted the most important of these, and covered the first two in the list. Part II presented the binary log in more detail. The Slow Log will be the topic of today's blog.

Navicat Blogs
Feed Entries
Share
Blog Archives