Shulou(Shulou.com)06/01 Report--

The following mainly brings you the specific methods of using Navicat to view MySQL logs. I hope these contents can bring you practical use, which is also the main purpose of this article that I edit the specific methods of using Navicat to view MySQL logs. All right, don't talk too much nonsense, let's just read the following.

Download the latest version of Navicat for MySQL

Navicat for MySQL is an ideal solution for managing and developing MySQL or MariaDB. Using Navicat for MySQL, you can connect to both MySQL and MariaDB. Navicat for MySQL provides powerful front-end functions and provides an intuitive graphical interface for database management, development and maintenance. For novices and professionals alike, Navicat for MySQL is a powerful tool for managing and developing MySQL or MariaDB.

Use MySQL Log

In software applications, log files record the actions performed in the system and the people who performed them. Log files can be the administrator's best friend in the event of an unexpected situation, whether it's a security vulnerability, a system crash, or poor performance. MySQL has several different log files that can help you find out what's going on inside the MySQL CVM. This article is about getting started with MySQL logging.

Log type

MySQL can support multiple log types, but keep in mind that by default, no logging is enabled except for error logs on Windows. This is a list of types:

The most important of these are error logs, regular query logs, binary logs, and slow logs. This article will cover the first two, and the latter two will be covered in the next one.

Error log

The first resource when solving CVM problems is the error log. MySQL CVM uses error logs to record information related to any problems that prevent the CVM from starting. You will find the error log in the data directory specified in the my.ini file. The default data directory location in Windows is "C:\ Program Files\ MySQL\ MySQL Server 5.7\ data" or "C:\ ProgramData\ Mysql". Note that the "C:\ ProgramData" directory is hidden by default, so you may need to change the folder options to see the directory and its contents.

Figure 1-MySQL error Log in Windows

For other platforms, it may be helpful to reference the log_error configuration variable. If you use Navicat to manage the database, you can use the CVM Monitor tool to find system variables. It can be accessed through the Tools main menu command.

In Server Monitor, click the middle "Variables" tab, and then scroll down to log_error in the list:

Figure 2-log_error CVM variables in the Navicat Server Monitor tool

General query log

As the name implies, the generic query log provides a general record of what MySQL is doing. When a client connects or disconnects, the cloud server writes information to this log and every SQL statement received from the client. The generic query log is useful when you suspect that there are errors in the client application and want to know exactly what the client sends to the database.

By default, regular query logs are disabled. To enable it, set the general_log variable to 1 (or ON in Navicat). Not assigning any value to general_log also enables it. Setting it back to 0 (or turning it off in Navicat) disables logging. To specify the log file name, assign it to the general_log_file variable. To specify log output to a file, use the log_output system variable to assign a file name. MySQL can also send the output to the slow_ log table in the mysql system database. In fact, you can choose file output, table output, or both. We will discuss this in more detail in the next blog post.

Figure 3-general_log and general_log_file CVM variables in the Navicat Server Monitor tool

For the above about the specific methods of using Navicat to view MySQL logs, we do not think it is very helpful. If you need to know more, please continue to follow our industry information. I'm sure you'll like it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.