NSK wrote:
On Friday 22 October 2004 05:19, Tim Starling wrote:
I've just heard that ariel, our master DB server, recently ran out of disk space.
You should implement some form of automatic checkup for empty disk space, or you should consider buying more disks. Disk space is cheap.
Ariel has 6x73GB 15K SCA SCSI drives (4 RAID 1+0 (146GB), 2 RAID 1 (72GB)), and is out of drive bays. Disk space is not cheap.
We certainly should write a script to shut down the master database server safely before it runs out of disk space. Perhaps we should also submit a feature request to MySQL AB asking them to prevent this situation.
We have used a script to automatically move old binlogs in the past, but we haven't been using it recently. It takes some amount of effort to set up and maintain.
-- Tim Starling