binary log index file content after dump
I'm testing a script that manages the incremental backups generated by mysql. The script does a mysqldump every 24hs and a incremental backup every 2hs. Mysql creates the binary logs (along the binary log index file) on a directory /mysql-log/.
That is every 24hs, it executes something like:
* mysqldump --single-transaction --flush-logs --master-data=2 --routines --delete-master-logs --user=backup_user --password=123456789 <databases> > <somewhere>
where the option --delete-master-logs deletes the binary logs that are no longer needed
What I was expecting is that running this command, the directory /mysql-log/ contained two files:
-rw-rw---- 1 mysql mysql 107 Nov 28 10:54 bin-log.000055
-rw-rw---- 1 mysql mysql 364 Nov 28 10:54 bin-log.index
that is the index file and the newly created binnary log file.
However, the actual content of the /mysql-log/ directory is
-rw-rw---- 1 mysql mysql 148 Nov 28 10:50 bin-log.000051
-rw-rw---- 1 mysql mysql 148 Nov 28 10:51 bin-log.000052
-rw-rw---- 1 mysql mysql 148 Nov 28 10:51 bin-log.000053
-rw-rw---- 1 mysql mysql 148 Nov 28 10:54 bin-log.000054
-rw-rw---- 1 mysql mysql 107 Nov 28 10:54 bin-log.000055
-rw-rw---- 1 mysql mysql 364 Nov 28 10:54 bin-log.index
that is the old binary logs are still available after the dump operation though the dump was done with the --delete-master-logs option.
Moreover, the content of the bin-log.index file is
/mysql-log/bin-log.000042
/mysql-log/bin-log.000043
/mysql-log/bin-log.000044
/mysql-log/bin-log.000045
/mysql-log/bin-log.000046
/mysql-log/bin-log.000047
/mysql-log/bin-log.000048
/mysql-log/bin-log.000049
/mysql-log/bin-log.000050
/mysql-log/bin-log.000051
/mysql-log/bin-log.000052
/mysql-log/bin-log.000053
/mysql-log/bin-log.000054
/mysql-log/bin-log.000055
which does not corresponds to the files in the /mysql-log/ directory.
Any idea what is the issue here?
Thanks
ps: I have tested by running the command
purge binary logs to 'bin-log.000055'
from inside mysql, and then the /mysql-log/ directory contains
-rw-rw---- 1 mysql mysql 107 Nov 28 10:54 bin-log.000055
-rw-rw---- 1 mysql mysql 52 Nov 28 11:28 bin-log.index
Subject
Views
Written By
Posted
binary log index file content after dump
3321
November 28, 2014 07:30AM
1351
November 28, 2014 07:31AM
1357
November 28, 2014 08:03AM
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.