Welcome to the 77th edition of Log Buffer, the weekly review of database blogs. This is the last Log Buffer of 2007. . . a time for looking back at the year, looking ahead to the next, and generally focusing on time. It may not be the Oscars, but Firebird News is thrilled that Firebird is Sourceforge’s [...]

Welcome readers to the seventy-sixth edition of Log Buffer, the weekly review of database blogs. As I mentioned in LB#75, this is Yule Log Buffer, a special edition for the busy holiday season. In lieu of a full edition, I’m throwing this one open to you, gentle readers, by asking for your [...]

The “sla” in mysqlsla stands for “statement log analyzer”. This does a much better job than mysqldumpslow of analyzing your slow query log. In fact, you can sort by many different parameters — by sheer number of times the query shows up in the slow query log, by the total or average query [...]

Today I’ve been checking out a new client environment. My mission is to figure out (cold) some of the characteristics of the queries being run, and particularly if they’re “good” or “bad”. In my arsenal of “tools I really want to check out” has been Ma’atkit’s Query Profiler. They’re very different tools. Ma’atkit’s query [...]

Hello everyone, We have several MySQL DBA openings, one in each of our offices in Ottawa, Boston, or Hyderabad, India. (Our Sydney office is doin’ fine.) Working at Pythian is different than working in-house or as a consultant, because you’ll be making your contributions available to each of the customers assigned to your team, allowing you to [...]

Welcome to the 75th edition (a.k.a. the Diamond Edition) of Log Buffer, the weekly review of database blogs. Let’s get things started with some views of the recently finished UKOUG Conference & Exhibition. On blog.gralike.com, Marco Gralike put together a list of articles offering just that, including reporting from Doug Burns, Mark Rittman, Daniel Fink, [...]

A friend of mine asked me: I’m hoping you can help me out with something — I’m trying to optimize a search feature. Since it uses a MySQL database, the search already uses the LIKE statement to get matches for a search query, we might be needing something more flexible. I found mention on MySQL’s website [...]

The Pythian family got a new song last Monday — “Sheeri” means “my song” in Hebrew. This post on my own blog explains how I got the job. High winds delayed my flight last Monday, and we’ve had two snow storms since I arrived. Luckily, my real-life context switch has not been too difficult. [...]

MySQL’s manual page for InnoDB’s adaptive hash states: If a table fits almost entirely in main memory, the fastest way to perform queries on it is to use hash indexes. InnoDB has a mechanism that monitors index searches made to the indexes defined for a table. If InnoDB notices that queries could benefit building a [...]

Niall Litchfield has published the 74th edition of Log Buffer, the weekly review of database blogs. Please step up and do a Log Buffer of your own! You’ll have some fun, bring new readers to your blog, and learn a few things in the process. Send a note to me, the Log Buffer coordinator, [...]