量的日志文件在/usr/local/mysql/var/下面，一般产生的日志文件都类似如下：
-rw-rw---- 1 mysql mysql 2.0M Sep 28 17:08 mysql-bin.000001-rw-...
原创
2023-05-16 16:01:59
486阅读
公司的业务系统数据库登录不了，第一反应是数据库空间满了，使用命令查看：#df -h使用命令依次查看哪个目录占用的空间#du -sh *进入目录查看，发现很多mysql-bin.000001类型的文件，并且每个文件大小为1G左右，如图：mysql-bin是数据库的操作日志文件，如果不做主从复制的话，基本上是没用的。例如UPDATE一个表，或者DELETE一些数据，即使该语句没有匹配的数据，这个命
原创
精选
2021-12-10 19:48:14
5199阅读
如果数据库频繁读写，我们发现data目录下会产生mysql-bin.00000X类似的文件，会占用很大的磁盘容量。这个文件是数据库操作日志记录文件，可以先停止数据库服务，直接删除，但删除之前我们建议将数据库做一下备份。删除这个文件如果数据库无法正常启动，还需要编辑data目录下的mysql-bin.index文件，将刚才删除的文件的文件名删掉，保存后重启mysql服务
转载
2021-05-04 15:19:44
821阅读
MySQL学习系列 bin 目录在 MysQL 的安装目录下有一个特别特别重要的 bin 目录， 这个目录下存放着许多可执行文件。其他系统中的可执行文件与此的类似。 这些可执行文件都是与服务器程序和客户端程序相关的。如果不知道对应的目录，比如在docker容器当中，可以通过查找mysqldump的方式查找目录。root@a5f0ba6ab874:/usr/sbin# whereis mysqldu
转载
2023-07-04 18:15:20
538阅读
NO： Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of
原创
2022-04-19 15:50:50
108阅读
NO： Walter Savage Landor:strove with none,for none was
原创
2022-04-19 16:53:27
77阅读
NO： Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of
原创
2022-04-20 14:54:43
21阅读
NO： Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of
原创
2022-04-20 17:20:45
84阅读
NO： Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of
原创
2022-04-21 09:36:02
130阅读
NO： Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of
原创
2022-04-21 09:51:24
95阅读
NO： Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of
原创
2022-04-21 11:52:57
32阅读
NO： Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of
原创
2022-04-21 14:15:09
35阅读
NO： Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of
原创
2022-04-21 15:02:54
50阅读
NO： Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of
原创
2022-04-21 15:25:30
8阅读
NO： Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of
原创
2022-04-21 17:33:13
62阅读
NO： Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of
原创
2022-04-14 13:55:52
22阅读
NO： Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of
原创
2022-04-14 16:24:57
30阅读
NO： Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of
原创
2022-04-19 15:28:47
27阅读
NO： Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of
原创
2022-04-19 16:12:47
29阅读
NO： Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of
原创
2022-04-19 16:22:18
49阅读
