MySQL Forums
Forum List  »  InnoDB

Re: Deadlock Issue
Posted by: Jessica Here
Date: August 09, 2017 12:48AM

Do the Update stmts target many rows?
No, only single row is updating.

WHEN 'Stat0' THEN
UPDATE FileProcess SET Status1 = Stat1 + 1, Time = NOW() WHERE UserName = User;
WHEN 'Stat1' THEN
UPDATE FileProcess SET Status2 = Stat2 + 1, Time = NOW() WHERE UserName = User;
WHEN 'Stat2' THEN
UPDATE FileProcess SET Status3 = Stat3 + 1, Time = NOW() WHERE UserName = User;

Is it a busy system?
Yes, 100 file processing per minute.

Are other things being done in the transaction?
No.

Does the transaction block code know how to restart in the event of a deadlock?
No.

Please advise how these questions are related to mysql version upgrade?

Options: ReplyQuote


Subject
Views
Written By
Posted
208
August 08, 2017 02:29AM
50
August 08, 2017 09:44AM
Re: Deadlock Issue
53
August 09, 2017 12:48AM
57
August 09, 2017 04:55AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.