Program an accidental error, when downloaded more than 300 data files, batch delete a server error, a deadlock, bosses look

CodePudding user response:

Do you want to check your transaction level, check whether there are multiple clients/process/thread concurrent deleted, concurrency is the source of deadlocks
You can optimize the necessity of considering transaction, consider deleting rather than batch delete, applicable conditions

CodePudding user response:

reference 1st floor github_36000833 response:

what do you want to check your transaction level, check whether there are multiple clients/process/thread concurrent deleted, concurrency is the source of deadlocks
You can optimize the necessity of considering transaction, consider deleting rather than batch delete, applicable condition

I baidu the fault of the log, baidu is a timeout, is brought about because of a deadlock timeout