Hi All,
I have been having an issue with the /db partition in the CPAM. It fills to 100% and then the client can not log in. I have cleared out some back ups in the /db/cpam-webapp/backup directory. This has cleared some space but it will hit 100% again if i run a backup. I have noticed that the majority of the /dev/sda2 is took up by files in the /db/cpam directory. These are all named mysql-bin.00047 to mysql-bin.000137. These files 1GB each and therefore are completely filling the partition. Could anyone give me a detailed explanation of what these bin files are and how I can clear them out?
I obviously will not be taking any action without comfirmation that there will not be any deterimental effects to the system.
Examples below:
-rw-rw---- 1 mysql mysql 1073742288 Jan 14 2011 mysql-bin.000048
-rw-rw---- 1 mysql mysql 1073741924 Jan 21 2011 mysql-bin.000049
-rw-rw---- 1 mysql mysql 1073742932 Jan 28 2011 mysql-bin.000050
-rw-rw---- 1 mysql mysql 1073748814 Feb 3 2011 mysql-bin.000051
-rw-rw---- 1 mysql mysql 1073744940 Feb 9 2011 mysql-bin.000052
-rw-rw---- 1 mysql mysql 1073761323 Feb 15 2011 mysql-bin.000053
-rw-rw---- 1 mysql mysql 1073781523 Feb 21 2011 mysql-bin.000054
-rw-rw---- 1 mysql mysql 1073744447 Feb 26 2011 mysql-bin.000055
-rw-rw---- 1 mysql mysql 1073742288 Jan 14 2011 mysql-bin.000048
-rw-rw---- 1 mysql mysql 1073741924 Jan 21 2011 mysql-bin.000049
-rw-rw---- 1 mysql mysql 1073742932 Jan 28 2011 mysql-bin.000050
-rw-rw---- 1 mysql mysql 1073748814 Feb 3 2011 mysql-bin.000051
-rw-rw---- 1 mysql mysql 1073744940 Feb 9 2011 mysql-bin.000052
-rw-rw---- 1 mysql mysql 1073761323 Feb 15 2011 mysql-bin.000053
-rw-rw---- 1 mysql mysql 1073781523 Feb 21 2011 mysql-bin.000054
-rw-rw---- 1 mysql mysql 1073744447 Feb 26 2011 mysql-bin.000055
Thanks again,
Adam
