Announcement

Collapse
No announcement yet.

How can I safely exclude all mysql databases from cagefs?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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 space

  • #2
    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

    Comment


    • #3
      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/

      Comment


      • #4
        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

        Comment


        • #5
          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.

          Comment


          • #6
            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

            Comment


            • #7
              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/questi...ysql-bin-files

              Comment

              Working...
              X