Query Analyzer. Query Analyzer collects information about query statements by the following methods. For MySQL / MariaDB instances, Navicat Monitor • retrieves the General Query Log from the server and analyze the information. • retrieves the Slow Query Log from the server and analyze the information. • queries the performance_schema database and analyze specific performance information. Note: Performance Schema is supported in MySQL Server 5.5.3 or later. Query statements are normalized and the maximum length is 1024 bytes. Similar queries with different literal values are combined. Quoted values and numbers are replaced by "?". For SQL Server instances, Navicat Monitor • queries execution related dynamic management views and analyze specific performance information.
Query Analyzer. Query Analyzer collects information about query statements by the following methods. Retrieve the General Query Log from the server and analyze the information. Retrieve the Slow Query Log from the server and analyze the information. Query the performance_schema database and analyze specific performance information. Note: Performance Schema is supported in MySQL Server 5.5.3 or later. Query statements are normalized and the maximum length is 1024 bytes. Similar queries with different literal values are combined. Quoted values and numbers are replaced by "?".
