MySQL Forums
Forum List  »  Performance

MySQL DDL performance
Posted by: Stepan Furman
Date: April 06, 2020 05:46AM

Upgrading our product to support MySQL-8 we found out, that DDL queries are much slower in MySQL-8 then in MySQL-5.7
It mostly affects the installation and rollback of our application.
Rollback from the dump is 80% slower than with MySQL5.7
We do a lot of rollbacks of a database between running our test groups.
we run around 10000 queries during installation. and around half of them are DDL queries.

Is there any way to speed up DDL queries?
We already disabled binary log, but doesn't help a lot.

Thanks in advance.

Options: ReplyQuote

Written By
MySQL DDL performance
April 06, 2020 05:46AM
April 30, 2020 03:00PM

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.