Six Types of MySQL logs

MySQLThe six types of logs in the database are required to monitor the database system, which is also very practical. The following section describes the six types of logs for MySQL, I hope this will help you.

Select log

Slow select log

Change log

Binary change log (binlog)

Alarm log

Error Log.

You can configure it in my. cnf.

Parameters

Description

Log

Write down all MySQL command operations in the select log,

Log-update

Text change log

Log-bin

This is a must-have for database replication.

Binlog_cache_size

The buffer length of the SQL statement that temporarily stores a transaction

Max_binlog_cache_szie

Maximum binary Cache log buffer size

Max_binlog_size

Maximum binary log size

Log-error

Severe Error Log

Log-warnings

Warning Level log, lower than error

Long_query_time

A slow query statement is generated when the number of seconds is exceeded.

Log-queries-not-using-indexes

No logs are queried using indexes,

Log-slow-queri

Slow query, which requires Optimization
 

This article describes the basic knowledge of the six types of logs in the MySQL database. Do not miss it for beginners who are just getting started. Finally, I hope you can gain some benefits from the content mentioned above.