|binlog was corrupted after shutdown and restart the server||weixiang zhai||9/14/12 2:29 AM|
Recently we stopped the server and restart it as below:
1. execute "stop slave"
2. execute "flush tables"
3. drop cache:
sync ; sync ; sync ;
4. mysqladmin –uroot –h127.0.0.1 shutdown
the server was shutdown normally.
we restarted the server later, and Last MySQL binlog information in error log is :
InnoDB: Last MySQL binlog file position 0 59707, file name /home/mysql/data3306/mysql/mysql-bin.063722
but the actual size of mysql-bin.063722 is 4096, and the io thread of slave reported an error that binlog was corrupted
Is there anyone knows why this happen?
Version: Percona Server 5.5.18