MySQL Forums
Forum List  »  Performance

Re: MySQL 8 - terrible performance
Posted by: Frederic Descamps
Date: February 14, 2019 12:28AM

Hi this is indeed during initialization part, don't forget that in MySQL 8.0 there is a transactional DataDictionary that must be created with several GIS information too.

This should be an operation that will occur only once.

Of course, a poor storage is much more affected. If you want to improve this, you can try to replay your test using --innodb_flush_log_at_trx_commit=0

Regards,

Options: ReplyQuote


Subject
Views
Written By
Posted
8383
February 11, 2019 02:09AM
2529
February 11, 2019 10:47AM
2210
February 11, 2019 11:55AM
1983
February 11, 2019 12:52PM
1729
February 11, 2019 08:13PM
1649
February 12, 2019 02:59AM
1748
February 13, 2019 03:36AM
Re: MySQL 8 - terrible performance
1453
February 14, 2019 12:28AM
1488
February 14, 2019 03:33AM
1324
February 15, 2019 03:32AM
1329
February 15, 2019 05:23AM
1270
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.