Our company uses... In daily production mysql database , There's a table There is a column below column Of datatype yes longtxt. This column is mainly used to upload test data to this column , But if there is a large amount of data uploaded at the same time , The device side will save , Unable to connect to the database or timed out .
The amount of data uploaded is shown in the figure below
Mysql As shown in the figure below
bosses , How to effectively solve the problem of simultaneous upload timeout ？