mysql开启并行执行update_利用Python多进程并行执行加快MySQL批量UPDATE执行速度

现在有个表t

mysql> desc t;

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

| Field | Type | Null | Key | Default | Extra |

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

| owner | varchar(30) | YES | | NULL | |

| object_name | varchar(128) | YES | | NULL | |

| subobject_name | varchar(30) | YES | | NULL | |

| object_id | int | NO | PRI | NULL | auto_increment |

| data_object_id | int | YES | | NULL | |

| object_type | varchar(19) | YES | | NULL | |

| created | datetime | YES | | NULL | |

| last_ddl_time | datetime | YES | | NULL | |

| timestamp | varchar(19) | YES | | NULL | |

| status | varchar(7) | YES | | NULL | |

| temporary | varchar(1) | YES | | NULL | |

| generate | varchar(1) | YES | | NULL | |