MySQL Forums
Forum List  »  Performance

Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?
Posted by: Sudarshan m
Date: February 11, 2020 04:13AM

Moving to InnoDb will be huge task for now... but from our analysis Mysql 8 performance is slow when the data is more and more.

Below is the comparison, between mysql 8x and 5.7. Time taken for same query in minutes,

1 Million 3 Million 5 Million 8 Million


Mysql 8x(min) 2.5 10.674 35.38 34.54
Mysql 5.7(min) 2.674 8.028 6.924 9.42


One more thing i want to understand is MyISAM performance got degraded in 8.X ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?
1829
February 11, 2020 04:13AM


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.