Community journal

The latest from the MySQL community

Ideas, releases, practical guides, and perspectives from the people building with MySQL.

Follow the feed
Showing entries 1 to 2 of 2 « Previous | Next »
Displaying posts with tag: polling (reset)
Oct
24
2007
How fast is MySQL replication?
Posted by Baron Schwartz (xaprb) on Wed 24 Oct 2007 02:00 UTC
Tags:

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

Aug
29
2007
How to notify event listeners in MySQL
Posted by Baron Schwartz (xaprb) on Wed 29 Aug 2007 12:46 UTC
Tags:

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.