4個MySQL 資料庫基本除錯技巧 1. 資料庫日誌error.log /var/log/mysql / error.log /var/ lib/mysql / error.log [pastacode lang=”markup” manual=”120714%2015%3A35%3A26%20%5BNote%5D%20Plugin%20’FEDERATED’%20is%20disabled.%0A120714%2015%3A35%3A26%20InnoDB%3A%20Initializing%20buffer%20pool%2C%20size%20%3D%208.0M%0A120714%2015%3A35%3A26%20InnoDB%3A%20Completed%20initialization%20of%20buffer%20pool%0A120714%2015%3A35%3A26%20InnoDB%3A%20Started%3B%20log%20sequence%20number%200%2067138180%0A120714%2015%3A35%3A27%20%5BNote%5D%20Event%20Scheduler%3A%20Loaded%200%20events%0A120714%2015%3A35%3A27%20%5BNote%5D%20%2Fusr%2Fsbin%2Fmysqld%3A%20ready%20for%20connections.%0AVersion%3A%20’5.1.63-0ubuntu0.10.04.1-log’%20socket%3A%20’%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock’%20port%3A%203306%0A%C3%8A(Ubuntu)” message=”” highlight=”” provider=”manual”/] 2. 資料庫執行狀態 …