Can I ask some question regarding update error?
I use mysql 5.6 community version.
I have a table like below.
create table t1
col01 varchar(32) primary key
the table has about 500,000 rows.
I ran update statements 16 times in series. each update statements are different and they update about 90% of data each.
When eight update statement was executed, it died with an error - Statement cancelled due to timeout or client request
until seventh they were successful and take 2 or 3 mins each.
update statements are like
update t1 set col01 = ‘#uid’, col02=’…’, … , col20=’…’ where col01=’#uid’;
they execute commit row by row.
Can anyone let me know the cause of the error?
Can the cause be the pk update?