I have proposed a topic about the MySQL community driven replication monitoring project, …

I have recently added some features to Maatkit’s mk-table-checksum tool that can make it easy to checksum the relevant parts of your data more frequently (i.e. continually, but not continuously). This in turn makes it possible for you to find out much sooner if a slave becomes different from its master, and then you [...]

Want to promote OpenSQL Camp 2008? Use one of the sweet badges shown on this page. A big thank-you to Fixpert for the logo and badges!

There’s a PNG format and a GIF format. To use the badge, download the image, then save it to your server and use the HTML shown below [...]

I just thought I’d drop a line about our book. Sales appear to be doing well still: the book is still at Amazon sales rank 3,213 and seems to hold pretty steady there. A lot of people have discovered it and are recommending it — including members of MySQL’s professional services team. [...]

Over the last few weeks I’ve been looking at several customers’ slow query logs, and I found in many of them an odd type of query. These are SELECT statements that contain an IN clause that includes dozens, sometimes hundreds of values. These statements often end in the slow query log. I’m not sure if these queries are this way by design or if they are generated by a specific database development tool.

I did some tests in one of my own databases, one with only around 10K rows in its largest table. The database corresponds to the Amarok media player. For example, I queried for songs by B. B. King (spelled “BB King”, “B.B. King”, etc. or with other artists: “B. B. King & Eric Clapton”).

The first query used a JOIN and an IN clause with all the …

I don’t think I have heard anything from the Falcon team for a while. What’s new? Did the project really stall when Jim Starkey left, as Vadim Tkachenko wondered might happen?

Download Maatkit

There’s a new release with a lot of goodies — speed, efficiency, user-friendliness, and new features. In particular some of Percona’s clients have sponsored features for things they need such as the ability to more frequently verify that slaves are in sync with their masters. If you need features, please ask Percona [...]

If you thought the activity around planning OpenSQL Camp 2008 had slacked off, it’s only because I’m both moving to a new house and traveling for business, so I haven’t blogged about it. In reality I’m not (and shouldn’t be!) the main driving force behind this event, so my lack of blogging doesn’t reflect [...]

Say you want to randomly select your employee of the month, but not so randomly, better, you'd like to give your best employees a bigger chance to be selected based on their rating.This is just an example, you could be randomly displaying ads from your customers, but giving an higher chance to be displayed to those who are paying more, there can be a million other example, but I hope you got the

Sometimes there are funny communication styles between people who are geographically distributed and working together all the time. Recently one of our team members echoed back to me some answers I gave over a chat session:

Q: Is it OK for me to buy quad-core servers? A: The old man walks slow but carries much, whilst [...]