Mysql log File [Reading Notes 1]

Mysql log File [Reading Notes 1] 1. Error log File: Error. log www.2cto.com records all serious warnings or error messages during Mysql Server running, as well as detailed information about Mysql Server startup and shutdown, by default,-log-error = [= file-name] (Binary Log & Binary Log Index, that is, binlog-log-bin = [= file_name]) is disabled: mysql records all query statements that modify Database Data in binary format to a file, including 1. execution time of each statement, 2. consumed resource 3, and related transaction information 4, binlog is an additional binlog parameter for transaction security -- binlog_max_size sets the maximum storage limit for binlog -- binlog-bin-db = dbname indicates a table record binlog -- binlog-ignore-db = dbname ignores a table note: dbname indicates the database where the query is executed, not the database where the query operation is executed. 3. update log: The update log is similar to the binlog, In the text format. 4, slow query log; as the name suggests, slow query log records query statements that have been executed for a long time. -- log-slow-quries [= file-name] enables 1, and the text format is 2, statement execution time 3, statement consumption time 4, execution user, linked host and other related information 5, dedicated analysis of slow query tools: mysqlslowdump five innodb online redo log innodb Transaction Security storage engine: this mainly ensures transaction security through online redo logs and undo information recorded in the table. innodb_log_group_home_dir sets the storage location innodb_log_files_in_group and sets the number of logs.