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

There is no replacement for the documentation of the database products. There is no alternative of forums for these technologies, and also there is no alter ego for the database blogs. They add up yet another avenue to explore when the professionals need help. This Log Buffer Edition helps professional in identifying few blog posts from across the databases in Log Buffer #269.

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, then it gets once again deprecated in favour 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.

While 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.

6 Little Known Things That Can Cause Big Performance Issues by Thomas LaRock.

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.

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, Chris Calender opines.