MySQL Forums
Forum List  »  Performance

Re: MySQL 8 - terrible performance
Posted by: Frederic Descamps
Date: February 15, 2019 03:32AM

Hi Hans,

We still have to take a look at the mysqlslap results you provided.

However, meanwhile, I'd like to share some info I received from our development team regarding initialization and mysql_upgrade process. I think you will also find them interesting.

So like I already wrote it, we have added a lot of spatial references. Many inserts are then run in a single transaction during --initialize btu mysql_upgrade is restricted to statements that can be run by the user, and those tables can only be modified by CREATE SPATIAL REFERENCE SYSTEM. And each CREATE statement is a separate transaction.

When you run mysql_upgrade --force (not required after initialize ofc), you then run all these one by one.

lefred.

Options: ReplyQuote


Subject
Views
Written By
Posted
8865
February 11, 2019 02:09AM
2665
February 11, 2019 10:47AM
2334
February 11, 2019 11:55AM
2095
February 11, 2019 12:52PM
1845
February 11, 2019 08:13PM
1756
February 12, 2019 02:59AM
1908
February 13, 2019 03:36AM
1562
February 14, 2019 12:28AM
1589
February 14, 2019 03:33AM
Re: MySQL 8 - terrible performance
1426
February 15, 2019 03:32AM
1454
February 15, 2019 05:23AM
1374
March 18, 2019 05:19AM


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.