Under the condition of real-time inserts data to a mysql since mysql columns have unique constraints, leading to increased column discontinuous how should solve

CodePudding user response:

For reasons of performance, the increase would not guarantee continuous
If it is to be continuous, you can consider sacrificing performance, use a lock to prevent concurrent, and limit the bulk insert, or in your spare time to regenerate the column value

CodePudding user response:

reference no. 1 floor ZJCXC -- personal WeChat public same response:

for performance reasons, the increase would not guarantee continuous
If need to go, you can consider sacrificing performance, use a lock to prevent concurrent, and limit the bulk insert, or in your spare time to regenerate the column value increasing

learned I try thanks for your reply