Hello,
The file mysql-bin.[index] keeps a list of all binary logs mysqld has generated and auto-rotated. The mechanisms for cleaning out the binlogs in conjunction with mysql-bin.[index] described here:
Announcement
Collapse
No announcement yet.
How can I safely exclude all mysql databases from cagefs?
Collapse
X
-
In the current path, I have folders called databases, which are natural. I do not think these folders fill space.
But I have more than 180 files in this direction with a total of 1024 megabytes
Why are these files made?!
These files fill a lot of space on my server
-rw-rw---- 1 mysql mysql 48898950 Apr 21 11:25 mysql-bin.000001
-rw-rw---- 1 mysql mysql 13219583 Apr 21 11:31 mysql-bin.000002
-rw-rw---- 1 mysql mysql 1073764161 Jul 18 14:51 mysql-bin.000003
-rw-rw---- 1 mysql mysql 814736967 Jul 18 19:17 mysql-bin.000004
-rw-rw---- 1 mysql mysql 1073743415 Jul 19 07:22 mysql-bin.000005
-rw-rw---- 1 mysql mysql 1073742781 Jul 19 10:53 mysql-bin.000006
-rw-rw---- 1 mysql mysql 1073741978 Jul 19 15:47 mysql-bin.000007
-rw-rw---- 1 mysql mysql 1073741944 Jul 20 03:52 mysql-bin.000008
-rw-rw---- 1 mysql mysql 1073742028 Jul 20 17:45 mysql-bin.000009
-rw-rw---- 1 mysql mysql 1073744242 Jul 21 08:10 mysql-bin.000010
-rw-rw---- 1 mysql mysql 1073798618 Jul 21 11:23 mysql-bin.000011
-rw-rw---- 1 mysql mysql 1073774505 Jul 21 17:03 mysql-bin.000012
-rw-rw---- 1 mysql mysql 618184807 Jul 21 18:59 mysql-bin.000013
-rw-rw---- 1 mysql mysql 1073747360 Jul 22 05:54 mysql-bin.000014
-rw-rw---- 1 mysql mysql 1073784399 Jul 22 09:13 mysql-bin.000015
-rw-rw---- 1 mysql mysql 1073783064 Jul 22 09:50 mysql-bin.000016
-rw-rw---- 1 mysql mysql 1073795915 Jul 22 12:37 mysql-bin.000017
.......
......
......
-rw-rw---- 1 mysql mysql 346 Aug 22 05:00 mysql-bin.000173
-rw-rw---- 1 mysql mysql 1073795090 Aug 22 12:10 mysql-bin.000174
-rw-rw---- 1 mysql mysql 858540662 Aug 22 13:02 mysql-bin.000175
-rw-rw---- 1 mysql mysql 1073741919 Aug 22 21:31 mysql-bin.000176
-rw-rw---- 1 mysql mysql 1073787063 Aug 23 09:50 mysql-bin.000177
-rw-rw---- 1 mysql mysql 1073766160 Aug 23 11:34 mysql-bin.000178
-rw-rw---- 1 mysql mysql 1073742074 Aug 23 14:03 mysql-bin.000179
-rw-rw---- 1 mysql mysql 1073755588 Aug 23 21:26 mysql-bin.000180
-rw-rw---- 1 mysql mysql 1073760528 Aug 24 09:54 mysql-bin.000181
-rw-rw---- 1 mysql mysql 1073742028 Aug 24 19:51 mysql-bin.000182
-rw-rw---- 1 mysql mysql 1088091030 Aug 24 23:21 mysql-bin.000183
-rw-rw---- 1 mysql mysql 633255243 Aug 25 01:44 mysql-bin.000184
Leave a comment:
-
Hello,
/usr/share/cagefs-skeleton/var/lib/mysql is not a copy of /var/lib/mysql. /var/lib/mysql is just mounted to /usr/share/cagefs-skeleton, as it is indicated as a mount point in /etc/cagefs/cagefs.mp file.
You can find more info in this doc section.
Leave a comment:
-
We also have a server
Hard drive with low volume nvme
We have the same problem.
/usr/share/cagefs-skeleton/var/lib/mysql
The mysql path over 100 gigabytes of hard drive space
Leave a comment:
-
Sorry but i did not understand.
So what does that mean?
Code:du -sh /usr/share/cagefs-skeleton/var/lib/mysql 148G /usr/share/cagefs-skeleton/var/lib/mysql
Code:du -sh /var/lib/mysql/ 148G /var/lib/mysql/
Leave a comment:
-
Hello,
MySQL databases are not copied to CageFS skeleton, /var/lib/mysql is just mounted inside it.
You might want to move your MySQL datadir to another partition with more free space: https://cloudlinux.zendesk.com/hc/en...ql-data-folder
Leave a comment:
-
How can I safely exclude all mysql databases from cagefs?
How can I safely exclude all mysql databases from cagefs?
I do not have enough spaceTags: None
Leave a comment: