mysql5.5升级5.6_将MySQL从5.5升级到5.6后查询缓慢

我们正在将mysql从5.5升级到5.6,现在某些查询的速度非常慢.

以前需要0.005秒的查询现在需要49秒.

对5.6的查询似乎跳过了索引：

+----+-------------+-------+-------+----------------------------------------------------+---------+---------+------+--------+-------------+

| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |

+----+-------------+-------+-------+----------------------------------------------------+---------+---------+------+--------+-------------+

| 1 | SIMPLE | pens | index | index_contents_on_slug,index_contents_on_slug_hash | PRIMARY | 4 | NULL | 471440 | Using where |

+----+-------------+-------+-------+----------------------------------------------------+---------+---------+------+--------+-------------+

1 row in set (0.00 sec)

但是在5.5上并没有被跳过：

+----+-------------+-------+-------------+----------------------------------------------------+----------------------------------------------------+---------+------+------+----------------------------------------------------------------------------------------------+

| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |

+----+-------------+-------+-------------+----------------------------------------------------+----------------------------------------------------+---------+------+------+----------------------------------------------------------------------------------------------+

| 1 | SIMPLE | pens | index_merge | index_contents_on_slug,index_contents_on_slug_hash | index_contents_on_slug_hash,index_contents_on_slug | 768,768 | NULL | 2 | Using union(index_contents_on_slug_hash,index_contents_on_slug); Using where; Using filesort |

+----+-------------+-------+-------------+----------------------------------------------------+----------------------------------------------------+---------+------+------+----------------------------------------------------------------------------------------------+

1 row in set (0.00 sec)

两个数据库都是从相同的mysql转储创建的.

在5.6上进行导入时,是否不会构建这些索引？如何强制创建索引？

查询：

SELECT `pens`.* FROM `pens` WHERE (slug_hash = 'style' OR slug = 'style') ORDER BY `pens`.`id` DESC LIMIT 1

编辑：删除架构