Talking about the log file system of MySQL

Like most relational databases, log files areMySQLimportant part of the database. MySQLThere are several different log files, usually including error log files, binary logs, general logs, slow query logs , and so on. These logs can help us locatemysqldinternal events, database performance failures, record data changes history, user recovery database, etc.

composition of the MySQL log file system

A, error log: Records The issue that occurs when you start, run, or stop mysqld.

b. General log: Records the established client connections and executed statements.

c, update log: The statement that records the change data. The log is no longer used in MySQL 5.1.

d, binary log: A statement that records all changes to the data. Also used for replication.

e, slow query log: Records all queries that have been executed for more than long_query_time seconds, or queries that do not use indexes.

F,Innodb logs:Innodb redo Log

You can force mysqld to close and reopen the log file (or, in some cases, switch to a new log) by refreshing the log.

when you perform a When you FLUSH the LOGS statement or perform mysqladminflush-logs or mysqladmin refresh , the log is aged.

Talking about the log file system of MySQL