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/bash
mysqld_sa 25638 root mem REG 8,2 99158576 4198587 /usr/lib/locale/locale-archive
mysqld_sa 25638 root mem REG 8,2 26060 4197707 /usr/lib64/gconv/gconv-modules.cache
mysqld_sa 25638 root 0r CHR 1,3 0t0 3857 /dev/null
mysqld_sa 25638 root 1w CHR 1,3 0t0 3857 /dev/null
mysqld_sa 25638 root 2w CHR 1,3 0t0 3857 /dev/null
mysqld_sa 25638 root 255r REG 8,2 24632 4210700 /usr/bin/mysqld_safe
mysqld 26379 mysql cwd DIR 8,2 4096 3932444 /var/lib/mysql
mysqld 26379 mysql rtd DIR 8,2 4096 2 /
mysqld 26379 mysql txt REG 8,2 10438848 4207116 /usr/libexec/mysqld
mysqld 26379 mysql 0r CHR 1,3 0t0 3857 /dev/null
mysqld 26379 mysql 1w REG 8,2 10234 937095 /data/logs/mysql/mysql_error.log
mysqld 26379 mysql 2w REG 8,2 10234 937095 /data/logs/mysql/mysql_error.log
mysqld 26379 mysql 3u REG 8,2 132 937139 /data/logs/mysql/binarylog/mysql_bin.index
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)
mysqld 26379 mysql 11w REG 8,2 2618 937140 /data/logs/mysql/slow_query.log
mysqld 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.log
mysqld 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 NAME
mysqld 26379 mysql cwd DIR 8,2 4096 3932444 /var/lib/mysql
mysqld 26379 mysql rtd DIR 8,2 4096 2 /
mysqld 26379 mysql txt REG 8,2 10438848 4207116 /usr/libexec/mysqld
mysqld 26379 mysql 0r CHR 1,3 0t0 3857 /dev/null
mysqld 26379 mysql 1w REG 8,2 10234 937095 /data/logs/mysql/mysql_error.log
mysqld 26379 mysql 2w REG 8,2 10234 937095 /data/logs/mysql/mysql_error.log
mysqld 26379 mysql 3u REG 8,2 132 937139 /data/logs/mysql/binarylog/mysql_bin.index
mysqld 26379 mysql 4uW REG 8,2 446693376 3933686 /var/lib/mysql/ibdata1
mysqld 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)
mysqld 26379 mysql 9uW REG 8,2 67108864 3933687 /var/lib/mysql/ib_logfile0
mysqld 26379 mysql 10uW REG 8,2 67108864 3933688 /var/lib/mysql/ib_logfile1
mysqld 26379 mysql 11w REG 8,2 2618 937140 /data/logs/mysql/slow_query.log
mysqld 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.log
mysqld 26379 mysql 14u IPv4 373448 0t0 TCP *:mysql (LISTEN)
mysqld 26379 mysql 15w REG 8,2 425 937145 /data/logs/mysql/binarylog/mysql_bin.000003
mysqld 26379 mys