mysqldump not freeing up memory
Posted by: Richard Lohman
Date: April 07, 2009 08:58AM

All:
I have a mysql database (5.0.18) running on a CentOS box. Each night, we do a mysqldump and dump all databases into a single ascii SQL file, which is subsequently backed up to tape later. Watching the memory on the host, it was running at about 5 - 6Gb free memory right up until we started our mysqldump at midnight. All remaining memory on the host was consumed, and after the dump is complete, that memory is not freed. The dump command is:

/usr/local/mysql/bin/mysqldump --user=root --password='********' --single-transaction --flush-logs --master-data=2 --all-databases > /backups/sqldump/db2-databases-$DATE.sql && rm -rf /backups/binlogs/*

We are setting $DATE at the beginning of the script, and we grab a flushed copy of the most recent binlog every two hours & throw into /backups/binlogs/. These are cleared at the point that we capture a new sql dump.

Any thoughts, or anything further I can provide? TIA!
Rich Lohman

Options: ReplyQuote


Subject
Written By
Posted
mysqldump not freeing up memory
April 07, 2009 08:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.