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 [...]
Along with some others, I have arranged a conference for open-source database users and developers.
Key facts:
It is of, by and for the community (you). At this event, all open-source databases are created equal. We’ll learn together and grow together. It’s a combination conference and hackathon. It’s free. It is Friday night Nov 14, 18:00 through Sun the 16th [...]
After last week’s post on agents versus agentless monitoring systems, I got a lot of email. One, from a customer whose name I am not permitted to mention, sent me the following action shot (posted with permission):
Over half a gigabyte; more than twice what MySQL itself is using. So, that raises an interesting [...]