[Architecture] MySQL Log File-Error Log

[Architecture] MySQL Log File-Error Log (I) What is it? Record detailed information about MySQL Server startup and shutdown, and serious warnings and error messages during running [SQL] mysql> show variables like 'Log _ error '; + --------------- + response + | Variable_name | Value | + ----------------- + ------------------------------- + | log_error |/home/mysql/log/alert. log | + --------------- + ------------------------------- + 1 row in set (0.01 sec) for ease of maintenance, and sometimes want to back up the content in the error log and record it again, you can: [plain] shell> Mv host_name.err host_name.err-old shell> mysqladmin flush-logs shell> mv host_name.err-old backup-directory (ii) What is the role? When a problem occurs, MySQL DBA should first check the file. when MySQL Server cannot be started normally, the first important object to be tortured should be the error log file in MySQL, in fact, the function is very similar to alert in Oracle, but the name also shows that MySQL is still a bit tender. The error logs is not all error information, and not all errors are logged, this name is a bit out of the name, or the Oracle Gaoming-alert, is to remind you to pay attention, understanding is not faulty