Log Buffer #269, A Carnival of the Vanities for DBAs

There is no replacement for the documentation of database products. There is no alternative to forums for these technologies, and no alter-ego for database blogs. They create yet another avenue to explore for professionals who need help. This Log Buffer Edition helps professionals locate a few blog posts from across the databases. Enjoy!

Oracle:

What a difference a space can make. Pythian’s leading guru and celebrated author Micheal S. Abbey speaks from the trenches.

Kevin Closson says that the Xeon E5-2600 OS CPU To Core / SMT Thread mapping on Linux matters.

Frits Hoogland has a great post about getting to know Oracle wait events in Linux.

Where is the LOB data actually stored (in the row or the LOB segments) and what are the exact conditions when a switch from one to another may happen? Tanel Poder answers.

What is the meaning of load average and when is it too high? Harald van Breederode has the answer.

Seriously, just when we thought it was great to put the “uid”, “gid”, and “mode” specifications for disk devices into /etc/multipath.conf, it gets once again deprecated in favor of udev. James Morle blogs.

SQL Server:

Some DDL changes have occurred on the SQL Server database. Can I find out who made the changes? Jack Vamvas answers.

Although estimates need not be perfect, they should at least be logical. While estimating the effects of compressing data, Bob Pusateri recently came across a behavior.

Thomas LaRock lists six little-known things that can cause big performance issues.

Mark Broadbent suggests to remember your OS when upgrading to SQL 2012.

Tim and Lori Edwards live and die by OneNote.

MySQL:

Dathan Pattishall has some tips about sizing EC2 Servers to get more Bang for the Buck.

Marco Tusa shares the MySQL bi-weekly news.

It amazes Ronald Bradford when web hosting providers tell their paying client that a MySQL upgrade has been performed, yet they did not have the intelligence to actually look at the error log for confirmation.

Here’s an interesting blog post by Daniel van Eeden about Books vs. e-Books for DBA’s.

With InnoDB’s transportable tablespaces, recovering data from stranded .ibd files is a thing of the past, declares Chris Calender.