Opened 17 years ago

Closed 16 years ago

#88 closed task (fixed)

MySQL backups going berserk

Reported by: hobu Owned by: sbarnes
Priority: major Milestone:
Component: SysAdmin Keywords:
Cc: hobu@…

Description

Shawn,

MySQL backups are currently at 54gb. Can you investigate?

Howard

Change History (3)

comment:1 by sbarnes, 17 years ago

Status: newassigned

I've cleaned out some of the backups.

And will change the mysql backup configuration. It was keeping 10 weeks of uncompressed of backups.

I changed the configuration to use gzip to compress the mysql backups

Should we change the time to keep backups to less than 10 weeks

shawn

comment:2 by sbarnes, 17 years ago

Cc: hobu@… added

I just did a massive clean up of the mysql backups, freeing up a significant amount of space.

I've adjusted the crontab of the mysql backup to do a full backup at 3 am only not, every 3 hours. And changed the purge to only keep 5 days of backups. This should keep the mysql backups from eating up all the disk space.

I'll keep this ticket open for awhile for any suggestions on changing the crontab or number of days to keep backups

shawn

comment:3 by warmerdam, 16 years ago

Resolution: fixed
Status: assignedclosed

Things seem to be managable now (also see #126).

Closing.

Note: See TracTickets for help on using tickets.