MySQL Amazon RDS:超出了锁定等待超时 [英] MySQL Amazon RDS: Lock Wait timeout exceeded

问题描述

在Mysql(Amazon RDS)上，当我尝试运行以下SQL查询时

On Mysql (Amazon RDS), when I try to run the following SQL query

UPDATE
    table1 INNER JOIN table2 USING (CommonColumn)
SET
    table1.col1 = table2.x,
    table1.col2 = table2.y

大约52秒后，我收到此错误:

I get this error after around 52 seconds consistently:

Error Code: 1205. Lock wait timeout exceeded; try restarting transaction

我应该如何解决?

table2具有大约1700万条记录，而table2是table1的子集，具有400万条记录.问题是表的大小还是我的查询有问题?

table2 has around 17 million records and table2 which is a subset of table1 has 4 million records. Could it be the size of the tables that is the problem or is something wrong with my query?

推荐答案

我重新启动了MySQL实例，并且相同的查询也起作用了.

I restarted the MySQL instance and the same query worked.

这篇关于MySQL Amazon RDS:超出了锁定等待超时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！