Skip to content

Instantly share code, notes, and snippets.

@ojimac

ojimac/gist:2834148

Created May 30, 2012 06:50
Show Gist options
  • Save ojimac/2834148 to your computer and use it in GitHub Desktop.
Save ojimac/2834148 to your computer and use it in GitHub Desktop.
Download ZIP
mysql5.0.xでのエラーログ、スロークエリーログ設定
Raw
gistfile1.txt
# 5.0系と5.1系で違っていつも調べなおすのでメモ
# エラー
log-warnings = 2 # 警告も出す
log-error=/var/lib/mysql/{LOG_FILE_NAME}
# スロークエリ
log_slow_queries=mysql-slow.log
long_query_time={n} # n秒以上かかったクエリをログに出力
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment