Shulou(Shulou.com)05/31 Report--

This article mainly explains "how many kinds of logs are there in MySQL database". The content of the explanation in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how many kinds of logs are there in MySQL database"?

What kinds of logs are there in MySQL database

Select log

Slowselect log

Change log

Binary change log (binlog)

Alarm log

Error log.

Can be configured in my.cnf

Parameters.

Description

Log

What kinds of logs are there in MySQL database

Text select log, write down all MySQL command operations

Log-update

Text change log

Log-bin

I know all this. It is necessary 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

Critical error log

Log-warnings

Warning level log, lower than error

Long_query_time

The number of seconds is a slow query statement.

Log-queries-not-using-indexes

Logs that are not queried using an index

Log-slow-queri

Slow query, this will be optimized as soon as it is too much.

Thank you for your reading, the above is the content of "how many kinds of logs are there in the MySQL database". After the study of this article, I believe you have a deeper understanding of the question of how many kinds of logs there are in the MySQL database. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.