MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

mysql 8.0.32 mysqlbinlog point in time recovery very slow after upgrade
Posted by: Ron Tai
Date: March 27, 2024 09:01AM

After upgrading from mysql 8.0.21 to mysql 8.0.32 and using mysqlbinlog to test point in time recovery it takes over 24 hours with 8.0.32, but with 8.0.21 it took less than 6 hours. I am recovering the same amount of binlogs and each binlog is 1 GB large. What might be causing such a large difference in time?
I am using this method.
mysqlbinlog binlog.000001 binlog.000002 | mysql -u root -p

Thanks!

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
mysql 8.0.32 mysqlbinlog point in time recovery very slow after upgrade
163
Ron Tai
March 27, 2024 09:01AM


Sorry, only registered users may post in this forum.
Click here to login

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.