MySQL Forums
Forum List  »  Performance

Re: MySQL 8 - terrible performance
Posted by: Hans Meiser
Date: February 14, 2019 03:33AM


i tried changing innodb_flush_log_at_trx_commit, but there is no change.
with netdata i collected some charts during run of mysql_upgrade. there are only a few peaks in time, most of time there seems to be no activity.
last peak on right side marks end of mysql_upgrade process.

yes, initialization process happens only once, but if i notice this timeusage, iam afraid of having bad performance on production servers when running typical webapplications.
Can you confirm same behaviour and time difference when comparing this standardoperations with mysql 5.7 and 8.0 on same machine. can you confirm, that we see a regular behaviour at this point?

initialization process is one thing and i could live with it as a one time thing. But my benchmarks in first posting also dont look good. the benchmark shows bad performance with mysql8.0 just by running a lot selects. testdb is not optimized for mysql8, but i did not expect that timeusage and difference between 5.7 and 8.0

Another server - another test.
With mysql 5.7 i installed testdb and run mysqlslap.
result: 42.493 seconds

Now upgrade to mysql8.0 and rerun test with former installed db
result: 127.696 seconds

This reflects my fear: If we install/upgrade mysql8 on customer servers and typical webapps running slower then expected we will have much trouble with customers.


Options: ReplyQuote

Written By
February 11, 2019 02:09AM
February 11, 2019 10:47AM
February 11, 2019 11:55AM
February 11, 2019 12:52PM
February 11, 2019 08:13PM
February 12, 2019 02:59AM
February 13, 2019 03:36AM
Re: MySQL 8 - terrible performance
February 14, 2019 03:33AM
February 15, 2019 05:23AM
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.