Re: In-Place Upgrade from MySQL 5.7.33 to MySQL 8.0.25 very slow
Posted by:
Ralf Meyer
Date: August 13, 2021 06:33AM
I have increased innodb_open_files significantly (to 32000). After this, the upgrade runs within a much more reasonable time frame:
innodb_open_files default:
# time systemctl start mysql
real 55m24.631s
user 0m0.000s
sys 0m0.000s
innodb_open_files = 32000:
# time systemctl start mysql
real 6m2.449s
user 0m0.000s
sys 0m0.000s
I therefore consider this fixed. If I encounter any further issues, I will let you know.
Thanks once more for the help.
Kind regards,
Ralf
Subject
Written By
Posted
Re: In-Place Upgrade from MySQL 5.7.33 to MySQL 8.0.25 very slow
August 13, 2021 06:33AM
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.