MySQL Forums :: Performance :: Performance issues afre upgrading to 5.7


Advanced Search

Re: Performance issues afre upgrading to 5.7
Posted by: Øystein Grøvlen ()
Date: November 25, 2016 07:28AM

Peter Brawley Wrote:
-------------------------------------------------------
> Pretty obviously it's a bug they're having
> difficulty with.
>
> A workaround: pick off the rows column value from
> ...
>
> EXPLAIN SELECT COUNT(PKcolname) FROM tblname USE
> INDEX (PRIMARY)

Hi,

The problem in this case s actually that the primary index is used for the counting instead of another index. Hence, USE INDEX (PRIMARY) would be counter productive. As I wrote in another answer, from 5.7.18, it will be possible to FORCE a specific index to be used.

Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway

Options: ReplyQuote


Subject Views Written By Posted
Performance issues afre upgrading to 5.7 360 Alexandru Badulescu 11/24/2016 08:48AM
Re: Performance issues afre upgrading to 5.7 275 Peter Brawley 11/24/2016 11:32AM
Re: Performance issues afre upgrading to 5.7 181 Øystein Grøvlen 11/25/2016 07:28AM
Re: Performance issues afre upgrading to 5.7 195 Øystein Grøvlen 11/25/2016 06:16AM
Re: Performance issues afre upgrading to 5.7 187 Alexandru Badulescu 11/25/2016 06:59AM
Re: Performance issues afre upgrading to 5.7 272 Øystein Grøvlen 11/25/2016 07:53AM
Re: Performance issues afre upgrading to 5.7 185 Rick James 11/25/2016 08:18PM


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.