Re: Deadlock Issue

[Jessica Here]

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?