How to query SIG system of database log?
Mysql database log path: / var/lib/Mysql/ServerName. Err.
Through check log can view mysal common operation conditions, such as:
1, whether mysql process anomaly or have been restarted
Common: due to insufficient memory problems lead to the mysql process exception. Mysql exception will lead to relevant SAS service data can't write into the database, SAS will connect database recurrently, in the related service in SAS log can view the information, which can also first sentence whether mysql is anomaly.
2, if there is damage whether the table is damaged.
through the log checking specific list whether the table is damaged, need repaired, and combined with whether there is abnormal restart, can sentence the cause of the damage of the table. Usually after a table damaged, when the page inquires the relevant table, page layout will always inquiry status (table is very big, inquires the situation very slowly with the some alike, need to differentiate).