How can I safely exclude all mysql databases from cagefs?
Forum
  1. Forums
  2. CloudLinux and Control Panels
  3. CloudLinux and cPanel
  1. Anonymous User
  2. Thursday, 23 August 2018
  3.  Subscribe via email
How can I safely exclude all mysql databases from cagefs?
I do not have enough space
Rate this post:
  1. 23.08.2018 09:08:11
  2. # 1
Igor Ghertesco Accepted Answer
Posts: 154
Joined: 07.08.2015
0
Votes
Undo
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-us/articles/115003933574-How-to-move-the-mysql-data-folder
  1. 23.08.2018 13:08:44
  2. # 2
cpBarlo Accepted Answer
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/

  1. 23.08.2018 13:08:20
  2. # 3
Tom Bir Accepted Answer
Posts: 0
Joined: 20.11.2019
0
Votes
Undo
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
  1. 23.08.2018 16:08:17
  2. # 4
Igor Ghertesco Accepted Answer
Posts: 154
Joined: 07.08.2015
0
Votes
Undo
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.
  1. 24.08.2018 21:08:30
  2. # 5
Tom Bir Accepted Answer
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
  1. 27.08.2018 13:08:16
  2. # 6
Vladimir Accepted Answer
Posts: 108
Joined: 04.07.2017
0
Votes
Undo
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
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!
Guest
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below. Supports gif,jpg,png,zip,rar,pdf
• Insert • Remove Upload Files (Maximum File Size: 2 MB)
Captcha
To protect the site from bots and unauthorized scripts, we require that you enter the captcha codes below before posting your question.