The mysql update performance data shows that the mysql performance of the program is poor. Let's take a look at the actual situation on the Internet. After a test, test data (not strict data, perform other computer operations during the test): The environment is linux, mysql 5.1, and a database table is 3.3 million data, innoDB performs the update operation (single asynchronous insert) with poor performance. It takes 19 seconds for 1000 data records. (MyISAM has good performance. The data is as follows: 20:31:06 + 0800 [-] start test (update times: 1000) 20:31:11 + 0800 [-] finished 20:32:42 + 0800 [-] start test (update times: 10000) 20:33:39 + 0800 [-] finished 20:35:11 + 0800 [-] start test (update times: 50000) 20:37:33 + 0800 [-] finished 20:39:11 + 0800 [-] start test (update times: 100000) 20:41:24 + 0800 [-] finished 20:43:00 + 0800 [-] start test (update times: 200000) 20:45:59 + 0800 [-] finished 20:47:40 + 0800 [-] start test (update times: 300000) 20:52:40 + 0800 [-] finished update times 1000 10000 50000 100000 200000 time (s) 5 57 142 133 179 300