MySQL Forums
Forum List  »  MyISAM

MySQL 5.6 Upgrade - Hung On Creating sort index
Posted by: Andrew Klug
Date: October 10, 2016 09:52AM

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.

Options: ReplyQuote

Written By
MySQL 5.6 Upgrade - Hung On Creating sort index
October 10, 2016 09:52AM

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.