出錯日志
出錯日志主要包括啟動、關閉信息和運行中出現的關鍵錯誤。如果服務器出現死機並自動重起、MySQL注意到某表需要自動檢查或修復,那麼錯誤日志將對此進行記錄。下面的內容為一份出錯日志的樣本。
061221 13:08:25 [Note] MySQL: ready for connections.
Version: '5.0.24a-community-nt-log' socket: '' port: 3306 MySQL Community Edition (GPL)
061221 13:09:58 [Note] MySQL: Normal shutdown
061221 13:09:58 [Note] MySQL: Shutdown complete
061221 13:10:35 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL Server acts as a master and has his hostname changed!! Please use '--log-bin=mrkj-bin' to avoid this problem.
061221 13:10:35 [Note] MySQL: ready for connections.
Version: '5.0.24a-community-nt-log' socket: '' port: 3306 MySQL Community Edition (GPL)
061221 13:11:22 [Note] MySQL: Normal shutdown
……
根據上面的樣本就可以對MySQL的啟動、關閉、重啟及出現的錯誤進行直觀的把握,從而使用戶能夠快速准確地處理MySQL數據庫可能發生的錯誤。