Linux - Mysql - Bin log
2021/6/13 2:21:03
本文主要是介绍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
这篇关于Linux - Mysql - Bin log的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-04-26MySQL查出时间比实际晚8小时的解决方案
- 2024-04-01JPA不识别MySQL的枚举类型
- 2024-03-30mysql数据库表卡死解决方法
- 2024-03-15MySQL多数据源笔记5-ShardingJDBC实战
- 2024-03-11natural join mysql
- 2024-03-11关于VS2017,VS2015 中利用 EF使用Mysql 不显示数据源问题解决方案
- 2024-02-26mysql 阿里云xb后缀备份文件恢复-icode9专业技术文章分享
- 2024-02-22docker mysql 5.7
- 2024-02-18从 20 多套 MySQL 到 1 套 TiDB丨骏伯网络综合运营管理平台应用实践
- 2024-02-07mysql 外键索引入门介绍,为什么工作中很少有人使用?