Re: MySql 5.7.3 m13 deadly slow - config issue?
Hi Øystein,
Your got it with the Collate, the Company table had COLLATE ascii_bin while the other didn't.
I added the collate to the temp_company table and the query took 3 seconds. Fabulous.
Out of interest - Why would an added collate stop two varchars using an index? (and why was this ok in an earlier Mysql version?)
Edited 1 time(s). Last edit at 01/14/2014 12:25PM by Adam Knights.
Subject
Views
Written By
Posted
4603
January 13, 2014 06:21PM
1771
January 14, 2014 03:40AM
Re: MySql 5.7.3 m13 deadly slow - config issue?
1457
January 14, 2014 12:24PM
1796
January 15, 2014 04:38AM
1198
January 14, 2014 04:27PM
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.