[client] port=3306 socket=/tmp/mysql.sock [mysqld] port=3306 socket=/tmp/mysql.sock key_buffer_size=16M max_allowed_packet=8M pid-file = /usr/local/var/mysql/MacOSX.local.pid #エラーログの確認 log-error=/var/log/mysql/error.log #クエリログを表示 general_log=1 general_log_file=/var/log/mysql/query.log # バイナリログを残す日数 expire_logs_days = 2 # basic datadir = /usr/local/var/mysql tmpdir = /tmp character-set-server = utf8 default-storage-engine = InnoDB innodb_buffer_pool_size = 128M [mysqldump] quick
クエリログのドキュメント