是否啟用了日誌mysql>show variables like "log_%";怎樣知道當前的日誌mysql> show master status;顯示二進位制日誌數目mysql> show master logs;看二進位制日誌檔案用mysqlbinlogshell>mysqlbinlog mail-bin.000001或者shell>mysqlbinlog mail-bin.000001 | tail在配置檔案中指定log的輸出位置.Linux 的配置檔案為 my.cnf ，一般在 /etc 下。在linux下：Sql程式碼# 在[mysqld] 中輸入#loglog-error=/usr/local/mysql/log/error.loglog=/usr/local/mysql/log/mysql.loglong_query_time=2log-slow-queries= /usr/local/mysql/log/slowquery.log# 在[mysqld] 中輸入 #loglog-error=/usr/local/mysql/log/error.loglog=/usr/local/mysql/log/mysql.loglong_query_time=2log-slow-queries= /usr/local/mysql/log/slowquery.log