Re: In-Place Upgrade from MySQL 5.7.33 to MySQL 8.0.25 very slow

[Frederic Descamps]

Hi Ralf,

During the upgrade the tables metadata (structure, ...) are populated from the old format (.frm) to the new Data Dictionary (in InnoDB).

During the cleanup phase of this upgrade, all InnoDB dirty pages (pages marked as chandeg in the Buffer Pool and not yet flushed to disk) are flushed to disk. What you see is in the log are the note messages of InnoDB performing the flush operations.

If you don't want to see the notes, I think you could change the log_Verbosity, however that won't fix the speed of course.

In your case that flushing might take a large amount of time (maybe to underlying storage is somehow slow ?).

How large is the mysql.idb located in the datadir after the process ?

Regards,