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: January 29, 2020 04:02AM

we have around 24GB RAM with 4 DB instance, default key_buffer_size is 512M but we have tried till 2GB also. 5.7 we had 512M.

| Key_read_requests | 323102202 |
| Key_reads | 805495 |
| Key_write_requests | 32230358 |
| Key_writes | 2323853

so Key_read_requests / Key_reads =323102202/ 805495 =401

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?
302
January 29, 2020 04:02AM


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.