This is the 149th edition of Log Buffer, the weekly review of database blogs.

MySQL

Let’s begin with the big-picture stuff. Jeremy Zawodny laid out his view of the state of MySQL in Linux Magazine’s blog, noting the rough transition between versions 5.0 and 5.1, the status of storage engines, and outside contributions.

Like Baron Schwartz’s Maatkit, for example. Baron announced this week that he is writing a book about Maatkit, and also …

This is the 148th edition of Log Buffer, the weekly review of database blogs. Welcome.

PostgreSQL

Since PGCon ‘09 has concluded not long ago (and not far away), let’s start with Postgres stuff, much of which has to do with the convention.

Here are Robert Treat’s reflections on PGCon 2009, on his zillablog: “ . . . PGCon always presents the strongest line up of Postgres information available, and this year was certainly no exception.”

Josh Berkus was there, of course, and he sends two detailed reports: …

Welcome to the 147th edition of Log Buffer, the weekly review of database blogs.

Let’s start this week, with blogs from the SQL Server world, where a number of excellent technical posts appear. Alexander Kuznetsov surprises his readers with this assertion: without ORDER BY, there is no default sort order. “Sounds trivial? Right, but different flavors of this myth still persist.  . . .  Because apparently many visitors agreed with this myth, I decided to post a repro script which demonstrates that this is simply not true.”

In their post on …

Hello and welcome to the 146th edition of Log Buffer, the weekly review of database blogs. I have to make this a quick one, but I hope (as always) that the links give you the highlights of this week’s blogs.

Oracle

Let’s start with Jonathan Lewis’s report from IOUG Day 4: ” Not so much a little gem today as a little surprise and a few consequential thoughts. In a presentation on optimising star transformations the presenter pointed out that bitmap indexes are only available in Oracle Enterprise Edition.”

Here’s Doug Burns with the first of a series on …

Welcome to the 145th edition of Log Buffer, the weekly review of database blogs.

MySQL

Since MySQL was surely the belle of the bloggers’ ball this week—why, everyone was talking—let’s begin with it.

Baron Schwartz started something with his post examining why MySQL might not benefit from having a mother ship. Dean Ellis of niflheim responded, arguing that everyone needs the MySQL mothership. And that got Sheeri’s Cabral’s attention—she took the middle path in her …

This edition of Log Buffer is my first article on the Pythian Blog. It seems appropriate that, as I start a new chapter of my life in Canada and am looking to the future, a lot of the blogs this week are doing the same.

After the shock of the Oracle takeover the MySQL community is full of hope. Mark Callaghan has written about the new storage engines for MySQL and also suggestions for what the MySQL community could be doing while they wait to hear what Oracle has planned.

Kaj Arno has looked to the future and he thinks he has found some answers.

With the …

This is the 143rd edition of Log Buffer, the weekly review of database blogs.

So . . .  Anything happen while I was away?

Okay, so I heard the big news. And just in case you haven’t, here it is from Sheeri Cabral: Oracle Buys Sun. This is a sea-change in the hi-tech world, and the DB part of it will also get rocked, Sun being the home of MySQL. There’s lots of comment in Sheeri’s post, and indeed, all over the database blogging world. I will try here to cover the best of it.

Oracle + Sun + MySQL

First, Monty Says: …

Welcome to the 142nd edition of Log Buffer, the weekly review of database blogs.

The SQL Server ’sphere was a busy place this week. On In Recovery… Paul S. Randall posted his latest straw poll, this time looking into your practices around transaction log size management.

Linchi Shea observed, “In a multi-process/multi-thread system, locking is central to maintain data consistency and keep things in order.  . . . [We] need to begin with understanding the locking behavior of the basic building blocks offered by SQL Server . . .  [One] would think that the basic locking behavior …

Welcome to the 141st edition of Log Buffer, the weekly review of database blogs. The Oracle bloggers were especially chatty this week, so let’s start with them.

Rob van Wijk wrote a fine post about choosing between SQL and PL/SQL, defending his choice of straight-up SQL for logic. Naturally, this triggered a lot of discussion, as well as a few responses from other blogs. Chen Shapira framed her response in a question about code life-cycle: would you rather maintain SQL or PL/SQL?

H. Tonguç …

This is the 140th edition of Log Buffer, the weekly review of database blogs. Welcome.

Let us begin with Oracle this week. Dan Norris illustrates how to start database services automatically after instance startup. He says, “Services are an essential component for managing workload in a RAC environment. If you’re not defining any non-default services in your RAC database, you’re making a mistake.”

Vivek Sharma published his tale of, Latch: Row Cache Objects causing huge performance issue. Clever detective …