tag:blogger.com,1999:blog-20434908.post2371202615815899382..comments2008-04-27T11:50:28.952+03:00Shlomo Priymakhttps://profiles.google.com/116089576530899793016noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-20434908.post-53383754860966417252008-04-27T11:50:00.000+03:002008-04-27T11:50:00.000+03:00The future is 6.0+, and it's all too far away... :) <BR/>I'd use the built-in InnoDB for the mysql schema if I were to decide, but MySQL AB probably avoids depending on it internally due to the fact it's owned by Oracle.Shlomo Priymakhttp://www.blogger.com/profile/08509735030020026930noreply@blogger.comtag:blogger.com,1999:blog-20434908.post-5801783039196727972008-04-27T11:29:00.000+03:002008-04-27T11:29:00.000+03:00Hi again,<BR/>MYISAM is the only built-in engine. In the future MMARlA will be the standard engine.<BR/>Maria will offer ACID.<BR/>You are right about the locks , but probably you can poll using different lock names. For instance, every event puts its lock name includinga tx table. Or just when finishing inserting a row in a tx table.<BR/><BR/>AndreyAndrey Hristovmysql.comnoreply@blogger.comtag:blogger.com,1999:blog-20434908.post-63716322948339144322008-04-27T10:48:00.000+03:002008-04-27T10:48:00.000+03:00GET_LOCK() is a great tool, but I don't see how you can use it in this case. Each connection can only get one lock. You can test for existence of many locks, but you can't assure the order in which the events started. What was your idea?<BR/><BR/>Regarding the non transactional nature: if you want to do something like:<BR/>START TRANSACTION;<BR/>CREATE event...<BR/>CREATE event...<BR/>COMMIT;<BR/>And you need to be certain all of the events were added, you can't. Moreover, since it's MyISAM, a crash in the middle of the event creation can even corrupt the table.<BR/><BR/>Honestly, I really don't understand why MySQL uses MyISAM for the meta-data database.Shlomo Priymakhttp://www.blogger.com/profile/08509735030020026930noreply@blogger.comtag:blogger.com,1999:blog-20434908.post-67434043289584183282008-04-27T02:06:00.000+03:002008-04-27T02:06:00.000+03:00Hi,<BR/>you can use GET_LOCK() and the other lock functions instead of polling mysql.event .<BR/>What's the problem of the table being non-tx with executing & finishing?<BR/><BR/>AndreyAndrey Hristovmysql.comnoreply@blogger.com