MySQL Forums
Forum List  »  Newbie

Re: Updating a record taking long time - MySQL 5.6.14
Posted by: Rick James
Date: June 26, 2014 01:48PM

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.

Options: ReplyQuote


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.