Hi all,
Can anyone help me with the problem explained here please:
http://www.reddit.com/r/mysql/comments/o256m/a_transactional_problem/
Thanks in advance.
Hola,
At the first look, it looks like one of the following will work:
1.Use MySQL's MERGE statement (that is, INSERT with ON DUPLICATE KEY).
What really happens, when the two transactions execute SELECT followed by an
INSERT, there is no way to hold off SELECT. The natural instinct
INSERT IGNORE is 'the' SQL solution,
as you know and mention.
I dont know Rails but this is not MySQL / SQL / Database issue but more a
specific framework one so the solution depends on it.
You can also make some higher level programming workaround.
Claudio
On Jan 4, 2012 6:46 AM, KK Everest
