Planet MySQL

Displaying posts with tag: polling (reset)

Oct

2007

Posted by Baron Schwartz (xaprb) on Wed 24 Oct 2007 02:00 UTC
Tags:

Replication, sql, polling, High Performance MySQL, Federated storage engine, Giuseppe Maxia, logging, MySQL slave lag, User Defined Functions, MySQL

Very fast, as it turns out. Click through to the full article for details.

Aug

2007

How to notify event listeners in MySQL

Posted by Baron Schwartz (xaprb) on Wed 29 Aug 2007 12:46 UTC
Tags:

sql, perl, Events, consumer, listener, locking, notification, polling, producer, queue, MySQL

A high-performance application that has producers and consumers of some resource, such as a queue of messages, needs an efficient way to notify the consumers when the producer has inserted into the queue. Polling the queue for changes is not a good option. MySQL's GET_LOCK() and RELEASE_LOCK() functions can provide both mutual exclusivity and notifications.

This post was prompted by a message to the MySQL general emailing list some time ago, but I'm finally getting around to actually testing the theoretical solution I mentioned then. I can never just think my way through anything that involves locking and waiting... I have to test it.

Top Authors

Oracle MySQL Blogs

Vendor Blogs

MySQL Links