Skip navigation links

MySQL Forums :: InnoDB :: COMMIT function take too much time to respond


Advanced Search

Re: COMMIT function take too much time to respond
Posted by: Rick James ()
Date: April 11, 2011 09:41PM

Thanks. Alas, no good clues.

A side issue...
UPDATE `gc_monster` SET `loyalty` = CASE `id` WHEN '11' THEN 100 WHEN '12' THEN 100 WHEN '13' THEN 100 ELSE `loyalty` END WHERE `id` IN (11, 12, 13) LIMIT 3;
could be written
UPDATE `gc_monster` SET `loyalty` = 100 ELSE WHERE `id` IN (11, 12, 13);
The UPDATE in the PNG, also has a constant value (23), so I am wondering whether this the normal case?

Another puzzle... I see that the COMMIT and the UPDATE all have about the same "Time" (about 1333 seconds). Are you running with autocommit on or off? Are you using BEGIN (START TRANSACTION)? What comes _before_ the UPDATE? Are there several statements between the BEGIN and COMMIT? And, maybe, the UPDATE is the last one? Is something else leading to a 20 minute delay? Is that delay pretty consistent in other cases?

Options: ReplyQuote


Subject Views Written By Posted
COMMIT function take too much time to respond 1767 He Ha 04/09/2011 02:35AM
Re: COMMIT function take too much time to respond 559 Rick James 04/10/2011 04:11PM
Re: COMMIT function take too much time to respond 500 He Ha 04/10/2011 08:09PM
Re: COMMIT function take too much time to respond 490 Rick James 04/10/2011 10:15PM
Re: COMMIT function take too much time to respond 789 He Ha 04/10/2011 10:23PM
Re: COMMIT function take too much time to respond 572 Rick James 04/11/2011 09:41PM


Sorry, you can't reply to this topic. It has been closed.

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.