折腾:
【未解决】Ubuntu中mysql有时候会突然挂掉
期间,此处Ubuntu中可以用service管理mysql:
1 | service mysql status |
其中能看到service文件:
Loaded: loaded (/lib/systemd/system/mysql.service; bad; vendor preset: enabled)
而为了解决mysql偶尔挂掉,需要搞清楚log日志文件在哪。好去找挂掉原因。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | root@VM - 158 - 80 - ubuntu:~ / xxx # cat /lib/systemd/system/mysql.service # MySQL systemd service file [Unit] Description = MySQL Community Server After = network.target [Install] WantedBy = multi - user.target [Service] User = mysql Group = mysql PermissionsStartOnly = true ExecStartPre = / usr / share / mysql / mysql - systemd - start pre ExecStart = / usr / sbin / mysqld ExecStartPost = / usr / share / mysql / mysql - systemd - start post TimeoutSec = 600 Restart = on - failure RuntimeDirectory = mysqld RuntimeDirectoryMode = 755 |
没找到log文件目录
ubuntu mysql log location
去
/var/log中看看
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | root@VM-158-80-ubuntu:~ # ll /var/lo local / lock/ log/ root@VM-158-80-ubuntu:~ # ll /var/log/mysql mysql/ mysql.err mysql.log mysql.log.1 mysql.log.8.gz root@VM-158-80-ubuntu:~ # ll /var/log/mysql* -rw-r----- 1 mysql adm 0 Feb 6 2017 /var/log/mysql .err -rw-r----- 1 mysql adm 0 Jun 7 06:25 /var/log/mysql .log -rw-r----- 1 mysql adm 0 Jun 6 06:25 /var/log/mysql .log.1 -rw-r----- 1 mysql adm 20 Aug 20 2018 /var/log/mysql .log.8.gz /var/log/mysql : total 36 drwxr-s--- 2 mysql adm 4096 Jun 7 21:23 ./ drwxrwxr-x 13 root syslog 4096 Jun 7 06:25 ../ -rw-r----- 1 mysql adm 12476 Jun 7 13:39 mariadb-bin.000392 -rw-r----- 1 mysql adm 154 Jun 7 21:23 mariadb-bin.000393 -rw-r----- 1 mysql adm 68 Jun 7 21:23 mariadb-bin.index -rw-rw---- 1 mysql adm 11 Aug 20 2018 mariadb-bin.state |
很明显
1 2 3 4 5 | root@VM-158-80-ubuntu: /var/log # ll mysql* -rw-r----- 1 mysql adm 0 Feb 6 2017 mysql.err -rw-r----- 1 mysql adm 0 Jun 7 06:25 mysql.log -rw-r----- 1 mysql adm 0 Jun 6 06:25 mysql.log.1 -rw-r----- 1 mysql adm 20 Aug 20 2018 mysql.log.8.gz |
都是空的,无效的log。
真正有效的是,至少看起来有内容的是:
/var/log/mysql
中的:
mariadb-bin.000392
mariadb-bin.000393
mariadb-bin.index
mariadb-bin.state
【总结】
此处,是从,相对比较通用的路径:
1 | /var/log/mysql |
找到mysql的log文件的。
不过不是熟悉的.log,而是bin文件。
所以后续去:
【已解决】如何查看mysql或mariadb的bin二进制的log文件内容
【后记】
后来从mysql的配置文件:
/etc/mysql/my.cnf
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 | root@VM - 158 - 80 - ubuntu: / var / log / mysql # cd /etc/mysql/ root@VM - 158 - 80 - ubuntu: / etc / mysql # ll total 36 drwxr - xr - x 4 root root 4096 Aug 20 2018 . / drwxr - xr - x 112 root root 4096 Jan 9 09 : 54 .. / drwxr - xr - x 2 root root 4096 Aug 20 2018 conf.d / - rw - - - - - - - 1 root root 333 Feb 6 2017 debian.cnf - rwxr - xr - x 1 root root 120 Jul 28 2018 debian - start * - rw - r - - r - - 1 root root 5231 Aug 20 2018 my.cnf - rw - r - - r - - 1 root root 682 Feb 4 2017 mysql.cnf drwxr - xr - x 2 root root 4096 Aug 20 2018 mysql.conf.d / root@VM - 158 - 80 - ubuntu: / etc / mysql # cat my.cnf ... socket = / var / run / mysqld / mysqld.sock ... socket = / var / run / mysqld / mysqld.sock ... [mysqld] # # * Basic Settings # user = mysql pid - file = / var / run / mysqld / mysqld.pid socket = / var / run / mysqld / mysqld.sock port = 3306 basedir = / usr datadir = / var / lib / mysql tmpdir = / tmp lc_messages_dir = / usr / share / mysql ... slow_query_log_file = / var / log / mysql / mariadb - slow.log ... log_bin = / var / log / mysql / mariadb - bin log_bin_index = / var / log / mysql / mariadb - bin .index |
中看到了,的确是bin的log,路径就是前面我们看到的:
/var/log/mysql/mariadb-bin
/var/log/mysql/mariadb-bin.index
转载请注明:在路上 » 【已解决】Ubuntu中mysql的log日志文件在哪