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:53AM

Hi,

Unfortunately, I do not know the planned release date, and would probably not have the liberty to tell you, if I had known it. :-)

Until then, a possible work-around that may work is "SELECT COUNT(DISTINCT <all pkcols>) ...", or if there is an indexed column with no NULL values, you can try "SELECT COUNT(<col>) ..."

Ø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 311 Alexandru Badulescu 11/24/2016 08:48AM
Re: Performance issues afre upgrading to 5.7 249 Peter Brawley 11/24/2016 11:32AM
Re: Performance issues afre upgrading to 5.7 158 Øystein Grøvlen 11/25/2016 07:28AM
Re: Performance issues afre upgrading to 5.7 175 Øystein Grøvlen 11/25/2016 06:16AM
Re: Performance issues afre upgrading to 5.7 162 Alexandru Badulescu 11/25/2016 06:59AM
Re: Performance issues afre upgrading to 5.7 254 Øystein Grøvlen 11/25/2016 07:53AM
Re: Performance issues afre upgrading to 5.7 165 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.