I am running a sql script on mysql 5.7.18 ubuntu server 16.04 that does a large number of updates in one table. Each one of the 50k updates takes under a second but the total run time is very long (>20m).
I can see from PROCESSLIST that only one thread is running and is processing the updates one-by-one.
How can I use multiple threads to speed the execution ?
Asked by rwms
(201 rep)
Jun 9, 2017, 12:53 PM
Last activity: Feb 22, 2023, 10:16 AM
Last activity: Feb 22, 2023, 10:16 AM