开云手机站登录入口官方网站

3年前 (2023-06-19)
Foreword

For IT practitioners, the log is very important information in the process of daily development and troubleshooting. You can learn a lot of useful information through the log, and many strange and difficult to locate problems can often be found by analyzing the log.. 同题参见

In mysql, various types of logs are also provided, and different types of logs have different functions. This article will provide an in-depth understanding of various logs of mysql and the use of various logs. 对照阅读

mysql log classification

Divided according to categories, mysql logs are mainly divided into the following categories: 相关阅读

  • Binary log;
  • Error log;
  • General query log;
  • Slow query log;

The above are the four well-known logs. After mysql8, added two moreLogs, relay logs and data definition statement logs, it can be said that with these logs, everything that happens inside mysql can be traced back. The specific functions of several logs are as follows:

  • Slow query log: records all execution time exceeding long_query_timeAll queries are convenient for us to optimize the query (default is not enabled);
  • General query log: records the start time and termination time of the mysql service connection, and all instructions sent to the database server (DML and DDL), for recovery

你可能想看：

标签:logmysql

继续阅读

若需了解「开云手机站登录入口官方网站」的上下文，可结合站内栏目与相关篇目交叉阅读。

栏目用于追新，文内链接用于对照细节。两者配合可减少漏读与重复检索。

继续浏览时优先选择同栏目或相近主题，避免被站外镜像带偏。

站点导览

wiki · 科技 · 文化 · 主页

页面按栏目组织。可先看导读，再进入相关篇目或返回列表。