tag:blogger.com,1999:blog-20434908.post2371202615815899382..comments2023-12-10T07:15:30.512-08:00Comments on Rational Relational: Using the MySQL Event Scheduler to Emulate ThreadsUnknownnoreply@blogger.comBlogger4125tag:blogger.com,1999:blog-20434908.post-53383754860966417252008-04-27T01:50:00.000-07:002008-04-27T01:50:00.000-07:00The future is 6.0+, and it's all too far away... :...The 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.shlomoidhttps://www.blogger.com/profile/08509735030020026930noreply@blogger.comtag:blogger.com,1999:blog-20434908.post-5801783039196727972008-04-27T01:29:00.000-07:002008-04-27T01:29:00.000-07:00Hi again,MYISAM is the only built-in engine. In th...Hi 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/>AndreyAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-20434908.post-63716322948339144322008-04-27T00:48:00.000-07:002008-04-27T00:48:00.000-07:00GET_LOCK() is a great tool, but I don't see how yo...GET_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.shlomoidhttps://www.blogger.com/profile/08509735030020026930noreply@blogger.comtag:blogger.com,1999:blog-20434908.post-67434043289584183282008-04-26T16:06:00.000-07:002008-04-26T16:06:00.000-07:00Hi,you can use GET_LOCK() and the other lock funct...Hi,<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/>AndreyAnonymousnoreply@blogger.com