mysql init 状态_MySQL Query：长时间处于’init’状态

我正在对

MySQL表(myisam引擎)执行更新,根据分析器,它在’init’状态下花费了过多的时间：

mysql> show profile for query 2;

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

| Status | Duration |

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

| starting | 0.000057 |

| checking permissions | 0.000006 |

| Opening tables | 0.000020 |

| System lock | 0.000007 |

| Table lock | 0.000005 |

| init | 21.911657 |

| Updating | 0.002363 |

| end | 0.000009 |

| query end | 0.000004 |

| freeing items | 0.000051 |

| logging slow query | 0.000003 |

| logging slow query | 0.000002 |

| cleaning up | 0.000005 |

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

查询如下：

mysql> update my_table

-> set rank =

-> greatest(

-> @rank := if(@score = score, &#