Re: Updating a record taking long time - MySQL 5.6.14
This shows that it is a table scan:
mysql> explain select * from trackfield_table where track_id = 24.753079659952466;
+----+-------------+------------------+------+---------------+------+---------+------+-------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+------------------+------+---------------+------+---------+------+-------+-------------+
| 1 | SIMPLE | trackfield_table | ALL | track_id_FK | NULL | NULL | NULL | 39570 | Using where |
However note that track_id is VARCHAR, yet you are testing it against a DOUBLE (the UNquoted 24.753079659952466).
If adding quotes around 24.753079659952466 does not fix the problem, then complain on bugs.mysql.com.
Subject
Written By
Posted
Re: Updating a record taking long time - MySQL 5.6.14
June 26, 2014 01:48PM
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.