2008年12月8日 星期一

MySQL Server Logs

MySQL 5.0 Reference Manual :: 5 MySQL Server Administration :: 5.2 MySQL Server Logs

MySQL has several different logs that can help you find out what is going on inside mysqld:

Log Type Information Written to Log
The error log Problems encountered starting, running, or stopping mysqld
The general query log Established client connections and statements received from clients
The binary log All statements that change data (also used for replication)
The slow query log All queries that took more than long_query_time seconds to execute or didn't use indexes
By default, all log files are created in the mysqld data directory.


Tsueng'blog - MySQL 設定 記錄執行過的 SQL 語法

SQL - MySQL Server 日常維護: Log 分析(mysqlsla)

沒有留言: