Re: Server 8.0 is extremaly slow
Hi Rafael,
From the status you sent above, it's obvious that most of your workload is performing FULL TABLE SCANS (worse case ever):
Handler_read_first 91
Handler_read_key 5917
Handler_read_last 0
Handler_read_next 9010
Handler_read_prev 0
Handler_read_rnd 695
Handler_read_rnd_next 167733056 <---- here !
Handler_rollback 0
So, I've 2 comments here:
1. As you are also using a lot of MyISAM, is the hardware the same (disk wise?)
2. On MySQL 5.5 I believe you have the Query_Cache enabled, isn't it ?
Subject
Written By
Posted
December 16, 2019 11:23AM
December 16, 2019 01:06PM
December 16, 2019 01:47PM
December 16, 2019 03:39PM
December 16, 2019 03:42PM
December 17, 2019 01:53AM
December 17, 2019 02:05AM
December 17, 2019 02:12AM
December 17, 2019 02:14AM
December 17, 2019 02:25AM
December 17, 2019 02:34AM
December 17, 2019 02:41AM
December 17, 2019 03:16AM
December 17, 2019 04:40AM
December 19, 2019 08:20AM
December 19, 2019 11:47AM
Re: Server 8.0 is extremaly slow
December 17, 2019 05:05AM
December 19, 2019 08:26AM
December 17, 2019 05:01AM
December 17, 2019 05:35AM
December 19, 2019 08:29AM
December 19, 2019 12:55PM
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.