Re: lost connection to mysql server during query 30.000 sec

[leonid lecksunov]

I have checked the query result. The query was executed correctly.
Now i have tried directly shell action.
$ sudo mysql -u user -p
mysql> use nvm;

Database changed

mysql> UPDATE `nvm`.`payment_doc` SET `partition_id` = 0;
Query OK, 219629 rows affected (22,54 sec)
Rows matched: 220872 Changed: 219629 Warnings: 0

mysql> UPDATE `nvm`.`payment_doc` SET `partition_id` = `confirmation_sign`;
Query OK, 219629 rows affected (12,42 sec)
Rows matched: 220872 Changed: 219629 Warnings: 0