MySQL Forums
Forum List  »  Triggers

Re: How can I create a trigger that increments on read?
Posted by: Roland Bouman
Date: August 20, 2005 12:36PM

Maybe I'm judging this all wrong (anyone?) but I think that this section of the manual:

http://dev.mysql.com/doc/mysql/en/innodb-locking-reads.html

describes a situation quite similar to yours.

I don't have a good answer to your question concerning the "crash / lockout" problem. My hunch is that when you use the builtin transaction support, MySQL is smart enough not to cause such problems in case the client crashes. However, I realize this hunch isnt good enough for you.

You could try an rebuild the example from the pointer, and simply try what happens if you let your client crash.

Good luck, sorry I couldn't help.

Options: ReplyQuote




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.