If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.
Announcement
Collapse
No announcement yet.
How can I safely exclude all mysql databases from cagefs?
/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.
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
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:
I have MM Replication in mysql, and I want to squeeze some free space in the box be deleting unnecessary files, I came across these mysql-bin files inside /var/db/mysql/ There are hundreds of those...
Comment