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

Like most relational databases, log files are an important part of MySQL databases. MySQL has several different log files, usually including error log files, binary logs, generic logs, slow query logs, and so on. These logs can help us to locate internal events in mysqld, database performance failures, record the change history of data, users to restore the database and so on.

The composition of the MySQL journal file system

Error log: record problems that occur when starting, running, or stopping mysqld.

B, general log: record the client connection established and the statement executed.

C. Update log: a statement that records change data. This log is no longer in use in MySQL 5.1.

D, binary log: a statement that records all change data. It is also used for replication.

E, slow query log: record all queries with execution time longer than long_query_time seconds or queries that do not use indexes.

F, Innodb log: 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 execute a FLUSH LOGS statement or execute mysqladminflush-logs or mysqladmin refresh, the log is aging.

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.