How can I safely exclude all mysql databases from cagefs?

[vmarchuk]

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:

https://dba.stackexchange.com/questions/41050/is-it-safe-to-delete-mysql-bin-files

[ighertesco]

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

[ighertesco]

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.

[ighertesco]

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

[ighertesco]

Sorry but i did not understand.
So what does that mean?

du -sh /usr/share/cagefs-skeleton/var/lib/mysql

148G	/usr/share/cagefs-skeleton/var/lib/mysql

du -sh  /var/lib/mysql/

148G	/var/lib/mysql/

[ighertesco]

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

[simplysup]

How can I safely exclude all mysql databases from cagefs?
I do not have enough space