默认情况下，如果日志没有配置，则只记录错误日志，记录到syslog，配置文件 /etc/mysql/conf.d/mysqld_safe_syslog.cnf （ubuntu下）
[mysqld_safe]
syslog
移除 /etc/mysql/conf.d/mysqld_safe_syslog.cnf ，然后在 /etc/mysql/my.cnf 添加相关配置
MySQL有多种类型的日志：Error Log、General Query Log、Binary Log 、Slow Query Log、Relay log（slave server）还有undo log/redo log 来实现事务
查看服务器中有哪些日志
[root@dev ~]# lsof -nc mysqld | grep -vE '(.so(..*)?$|.frm|.MY?|.ibd|ib_logfile|ibdata|TCP)'mysqld_sa 25638 root cwd DIR 8,2 4096 2 /mysqld_sa 25638 root rtd DIR 8,2 4096 2 /mysqld_sa 25638 root txt REG 8,2 941720 3145826 /bin/bashmysqld_sa 25638 root mem REG 8,2 99158576 4198587 /usr/lib/locale/locale-archivemysqld_sa 25638 root mem REG 8,2 26060 4197707 /usr/lib64/gconv/gconv-modules.cachemysqld_sa 25638 root 0r CHR 1,3 0t0 3857 /dev/nullmysqld_sa 25638 root 1w CHR 1,3 0t0 3857 /dev/nullmysqld_sa 25638 root 2w CHR 1,3 0t0 3857 /dev/nullmysqld_sa 25638 root 255r REG 8,2 24632 4210700 /usr/bin/mysqld_safemysqld 26379 mysql cwd DIR 8,2 4096 3932444 /var/lib/mysqlmysqld 26379 mysql rtd DIR 8,2 4096 2 /mysqld 26379 mysql txt REG 8,2 10438848 4207116 /usr/libexec/mysqldmysqld 26379 mysql 0r CHR 1,3 0t0 3857 /dev/nullmysqld 26379 mysql 1w REG 8,2 10234 937095 /data/logs/mysql/mysql_error.logmysqld 26379 mysql 2w REG 8,2 10234 937095 /data/logs/mysql/mysql_error.logmysqld 26379 mysql 3u REG 8,2 132 937139 /data/logs/mysql/binarylog/mysql_bin.indexmysqld 26379 mysql 6u REG 8,2 0 1048581 /tmp/ibzlBDfl (deleted)mysqld 26379 mysql 7u REG 8,2 0 1048582 /tmp/ib48cnZp (deleted)mysqld 26379 mysql 8u REG 8,2 0 1048583 /tmp/ibidAZvz (deleted)mysqld 26379 mysql 11w REG 8,2 2618 937140 /data/logs/mysql/slow_query.logmysqld 26379 mysql 12u REG 8,2 0 1048584 /tmp/ibpL9bkE (deleted)mysqld 26379 mysql 13w REG 8,2 8059 937141 /data/logs/mysql/general_log.logmysqld 26379 mysql 15w REG 8,2 425 937145 /data/logs/mysql/binarylog/mysql_bin.000003通过PID来查看[root@dev ~]# sudo lsof -p 26379 | grep -vE '(.so(..*)?$)'COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAMEmysqld 26379 mysql cwd DIR 8,2 4096 3932444 /var/lib/mysqlmysqld 26379 mysql rtd DIR 8,2 4096 2 /mysqld 26379 mysql txt REG 8,2 10438848 4207116 /usr/libexec/mysqldmysqld 26379 mysql 0r CHR 1,3 0t0 3857 /dev/nullmysqld 26379 mysql 1w REG 8,2 10234 937095 /data/logs/mysql/mysql_error.logmysqld 26379 mysql 2w REG 8,2 10234 937095 /data/logs/mysql/mysql_error.logmysqld 26379 mysql 3u REG 8,2 132 937139 /data/logs/mysql/binarylog/mysql_bin.indexmysqld 26379 mysql 4uW REG 8,2 446693376 3933686 /var/lib/mysql/ibdata1mysqld 26379 mysql 5u REG 8,2 0 1048580 /tmp/ibM08Tvg (deleted)mysqld 26379 mysql 6u REG 8,2 0 1048581 /tmp/ibzlBDfl (deleted)mysqld 26379 mysql 7u REG 8,2 0 1048582 /tmp/ib48cnZp (deleted)mysqld 26379 mysql 8u REG 8,2 0 1048583 /tmp/ibidAZvz (deleted)m<strong style="color:transparent">来源gaodai#ma#com搞@代~码$网</strong>ysqld 26379 mysql 9uW REG 8,2 67108864 3933687 /var/lib/mysql/ib_logfile0mysqld 26379 mysql 10uW REG 8,2 67108864 3933688 /var/lib/mysql/ib_logfile1mysqld 26379 mysql 11w REG 8,2 2618 937140 /data/logs/mysql/slow_query.logmysqld 26379 mysql 12u REG 8,2 0 1048584 /tmp/ibpL9bkE (deleted)mysqld 26379 mysql 13w REG 8,2 8059 937141 /data/logs/mysql/general_log.logmysqld 26379 mysql 14u IPv4 373448 0t0 TCP *:mysql (LISTEN)mysqld 26379 mysql 15w REG 8,2 425 937145 /data/logs/mysql/binarylog/mysql_bin.000003mysqld 26379 mysql 17u REG 8,2 2048 3933369 /var/lib/mysql/mysql/host.MYImysqld 26379 mysql 18u REG 8,2 0 3933385 /var/lib/mysql/mysql/host.MYDmysqld 26379 mysql 19u REG 8,2 2048 3933388 /var/lib/mysql/mysql/user.MYImysqld 26379 mysql 20u REG 8,2 828 3933421 /var/lib/mysql/mysql/user.MYDmysqld 26379 mysql 21u REG 8,2 5120 3932436 /var/lib/mysql/mysql/db.MYImysqld 26379 mysql 22u REG 8,2 2640 3932437 /var/lib/mysql/mysql/db.MYDmysqld 26379 mysql 23u REG 8,2 5120 3933682 /var/lib/mysql/mysql/proxies_priv.MYImysqld 26379 mysql 24u REG 8,2 1386 3933683 /var/lib/mysql/mysql/proxies_priv.MYDmysqld 26379 mysql 25u REG 8,2 4096 3933612 /var/lib/mysql/mysql/tables_priv.MYImysqld 26379 mysql 26u REG 8,2 0 3933613 /var/lib/mysql/mysql/tables_priv.MYDmysqld 26379 mysql 27u REG 8,2 4096 3933615 /var/lib/mysql/mysql/columns_priv.MYImysqld 26379 mysql 28u REG 8,2 0 3933616 /var/lib/mysql/mysql/columns_priv.MYDmysqld 26379 mysql 29u REG 8,2 4096 3933648 /var/lib/mysql/mysql/procs_priv.MYImysqld 26379 mysql 30u REG 8,2 0 3933649 /var/lib/mysql/mysql/procs_priv.MYDmysqld 26379 mysql 31u REG 8,2 1024 3933609 /var/lib/mysql/mysql/servers.MYImysqld 26379 mysql 32u REG 8,2 0 3933610 /var/lib/mysql/mysql/servers.MYDmysqld 26379 mysql 33u REG 8,2 4096 3933657 /var/lib/mysql/mysql/event.MYImysqld 26379 mysql 34u REG 8,2 168 3933658 /var/lib/mysql/mysql/event.MYDmysqld 26379 mysql 35u IPv4 374008 0t0 TCP localhost:mysql->localhost:51908 (ESTABLISHED)mysqld 26379 mysql 44u IPv4 374010 0t0 TCP localhost:mysql->localhost:51913 (ESTABLISHED)mysqld 26379 mysql 45u IPv4 374011 0t0 TCP localhost:mysql->localhost:51918 (ESTABLISHED)mysqld 26379 mysql 46u IPv4 374014 0t0 TCP localhost:mysql->localhost:51920 (ESTABLISHED)mysqld 26379 mysql 47u IPv4 374062 0t0 TCP localhost:mysql->localhost:54839 (ESTABLISHED)mysqld 26379 mysql 50u REG 8,2 4096 3933645 /var/lib/mysql/mysql/proc.MYImysqld 26379 mysql 51u REG 8,2 212 3933646 /var/lib/mysql/mysql/proc.MYD
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：mysql中的日志（一）_MySQL
转载请注明原文链接：mysql中的日志（一）_MySQL
