Linux - Mysql - Bin log

when you set the bin log , you may cause below problems;

1> PID not found;
for this problem , you could edit my.cnf file to add a new line
server-id=12121
(12121 is a random number, you can assume any)

2> still failed. maybe you could check your mysql data folder which is for mysql user.

[01:17:55 root@centos7 data]#ll
total 20
drwxr-xr-x  9 mysql mysql 4096 Jun 13 01:13 mysql

[01:16:53 root@centos7 mysql]#ll
total 123160
-rw-r----- 1 mysql mysql       56 Jun  2 22:00 auto.cnf
drwxr-xr-x 2 mysql mysql       77 Jun 12 14:07 backup
-rw------- 1 mysql mysql     1680 Jun  2 22:00 ca-key.pem
-rw-r--r-- 1 mysql mysql     1112 Jun  2 22:00 ca.pem
-rw-r----- 1 mysql mysql     1058 Jun 12 21:31 centos7.log
-rw-r--r-- 1 mysql mysql     1112 Jun  2 22:00 client-cert.pem
-rw------- 1 mysql mysql     1680 Jun  2 22:00 client-key.pem
drwxr-x--- 2 mysql mysql      286 Jun  9 22:26 hellodb
-rw-r----- 1 mysql mysql      324 Jun 13 01:12 ib_buffer_pool
-rw-r----- 1 mysql mysql 12582912 Jun 13 01:13 ibdata1
-rw-r----- 1 mysql mysql 50331648 Jun 13 01:13 ib_logfile0
-rw-r----- 1 mysql mysql 50331648 Jun  2 22:00 ib_logfile1
-rw-r----- 1 mysql mysql 12582912 Jun 13 01:13 ibtmp1
drwxr-xr-x 2 mysql mysql       86 Jun 13 01:13 logbin
drwxr-x--- 2 mysql mysql     4096 Jun 13 00:05 mysql
-rw-r----- 1 mysql mysql   202194 Jun 13 01:13 mysql.log
-rw-r----- 1 mysql mysql        5 Jun 13 01:13 mysql.pid
srwxrwxrwx 1 mysql mysql        0 Jun 13 01:13 mysql.sock
-rw------- 1 mysql mysql        5 Jun 13 01:13 mysql.sock.lock
drwxr-x--- 2 mysql mysql     8192 Jun  2 22:00 performance_schema
-rw------- 1 mysql mysql     1680 Jun  2 22:00 private_key.pem
-rw-r--r-- 1 mysql mysql      452 Jun  2 22:00 public_key.pem
-rw-r--r-- 1 mysql mysql     1112 Jun  2 22:00 server-cert.pem
-rw------- 1 mysql mysql     1680 Jun  2 22:00 server-key.pem
drwxr-x--- 2 mysql mysql     8192 Jun  2 22:00 sys
drwxr-x--- 2 mysql mysql       58 Jun  9 21:19 test1


then you can find the true;

01:13:46(root@localhost) [(none)]> 
01:13:47(root@localhost) [(none)]> show variables like "%log_bin%"
    -> ;
+---------------------------------+---------------------------------------+
| Variable_name                   | Value                                 |
+---------------------------------+---------------------------------------+
| log_bin                         | ON                                    |
| log_bin_basename                | /data/mysql/logbin/mysql-binlog       |
| log_bin_index                   | /data/mysql/logbin/mysql-binlog.index |
| log_bin_trust_function_creators | OFF                                   |
| log_bin_use_v1_row_events       | OFF                                   |
| sql_log_bin                     | ON                                    |
+---------------------------------+---------------------------------------+

[01:17:56 root@centos7 data]#ll mysql/logbin/
total 12
-rw-r----- 1 mysql mysql 177 Jun 13 01:12 mysql-binlog.000001
-rw-r----- 1 mysql mysql 154 Jun 13 01:13 mysql-binlog.000002
-rw-r----- 1 mysql mysql 78 Jun 13 01:13 mysql-binlog.index

 

上一篇:mysql释放大表空间的正确之道


下一篇:关于docker启动失败问题处理