cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Community Helping Community

794
Views
0
Helpful
0
Replies
Highlighted
Beginner

CPAM db size Issue

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

Everyone's tags (3)
CreatePlease to create content
Content for Community-Ad
FusionCharts will render here
This widget could not be displayed.