Log Buffer #142: A Carnival of the Vanities for DBAs
Apr 10, 2009 / By David Edwards
Welcome to the 142nd edition of Log Buffer, the weekly review of database blogs.
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 of these building blocks . . . would be well documented. Unfortunately, that is not the case at all.” Is it too much to ask for, he wonders, to document the locking behavior?
On thinking outside the box, Peter Larsson offered a little introduction to composable DML, a new tool in 2008. “What is Composable DML? Well, with this tool you can have a statement of UPDATE, DELETE and even MERGE as a data source for your query!”
Michelle Ufford, the SQL Fool, wrote, “[While] I was at the grocery store last night, my mind wandered to SQL Server.” (Yes, that happens to me too.) “This time, I was pondering what happens to a page split if the transaction is rolled back.”
Aaron Alton of The Hobt bravely interposed himself in the ongoing DBA-vs.-developer scuffle to say, “Developer, meet tempdb. tempdb, meet Developer. What’s that, DBA? You’ve never met either? Oh, how rude I’ve been. Allow me to introduce you.” Most cordial of him, I think. He kind of loses his cool though—“For the Love of All That is Good and Pure, tempdb is Your Friend!”
On the Oracle side, our old friend Chen Shapira discovered an unexpected side effect of table shrinking, “ . . . especially when using ‘enable row movement’. . . . As the name implies, after enabling row movement, rows get moved around. This can impact the clustering factor of your primary key.” In the comments, Yas links to a post illustrating the culprit here—buffer pinning, by Don Chio.
Chen also brings news of the First International NoCoug SQL Challenge. Although the contest is still open, Rob van Wijk thinks he may have found the winner in Alberto Dell’Era, by whose solution Chen says she was blown away.
While we’re on bugs (or while they’re on us), let’s look at some MySQL ones. Baron Schwartz found, in MySQL 5.1.33, 4 secret bugs. This follows an item on MySQL and IBM by Baron’s colleague Vadim, in which the latter discovers an unheralded new storage engine in 5.1.33.
Ronald Bradford appeared with the latest in his series a beginners look at Drizzle – Datatypes and Tables.
Do we need a MySQL for dummies? Morgan Tocker wonders, who is going to make MySQL easier to use?, with a laundry-list of things that interfere with ease-of-use. Unfortunately, the comments degenerate from a styling of MySQL as “CSV on Steroids” by a PostgreSQL fan.
Well, some people know how to get along. Baron Schwartz is after all, a big MySQL guy. Yet, here he is reporting the highlights PostgreSQL Conference East 2009, Day Two.
And now, a little levity to close this busy edition. Maybe a very little. What do you call a Santa that can turn into a wolf? Click through for the big payoff, courtesy syscomments. Me, I’m just glad there ain’t no sanity clause.
And that is all. As always, I invite you to leave your favourite DB blogs from this week in the comments. And please send me an email if you’d like to publish an edition of Log Buffer on your own blog.
See you in a week’s time!