MySQL 5.6 Upgrade - Hung On Creating sort index
We recently upgraded servers from 5.1 to 5.6.
Instantly we found that queries on large tables (1.4M rows, 4G+) that used to run in half a second were taking 1-3 minutes, all the while in "Creating sort index" status.
Has anyone experienced anything like this in upgrading to 5.6 or have any tips on what needs to be adjusted? We tried many my.cnf as well as kernel level tweaks to no avail.
The new server has faster hardware, so slower queries is not what we expected.
Subject
Views
Written By
Posted
MySQL 5.6 Upgrade - Hung On Creating sort index
3998
October 10, 2016 09:52AM
2323
October 10, 2016 12:45PM
2278
October 16, 2016 04:56PM
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.