Log Buffer #267, A Carnival of the Vanities for DBAs
Apr 13, 2012 / By Fahd Mirza
It seems like yesterday that the blogs appeared. Over the years they have proved to be of much value for the technical and not-so-technical masses. The big boom in this social media outlet has enabled unprecedented sharing of ideas for the database professionals. The nature of databases and the blogging is to always be changing, but Log Buffer Edition stays, and here is the Log Buffer #267.
Richard Foote says that one of the nice features of an IOT Secondary Index is that it contains the mandatory Primary Key of the IOT, which is always maintained and can be used to access the necessary rows of the IOT regardless of row movement within the IOT itself.
Tanel Poder answers a question in the twitter-sphere about Exadata Smart Scan predicate offloading and sequence.NEXTVAL.
Martin blogs about a long overdue issue about a failure to load library.
Jonathan Lewis just discovered a critical weakness in one of the implementation details of 11g extended stats that could lead to some surprising instability in execution plans.
Reproducing a Canned Report using a Single SQL Statement is another good post by Charles Hooper.
Chad Miller wants to show someone how to use table-valued parameters available in SQL Server 2008 and higher and uses example of Table-Valued Parameter.
SQL Server Data Tools (SSDT) is a Business Intelligence Development Studio (BIDS) replacement, James Serra blogs.
Sometimes you find a tool that is so cool, you can’t believe no-one else has picked up on it before. This is one of those times: a few month or so ago, Chris Webb came across a new tool called as Layerscape.
Pinal Dave talks about the social networking sites and the professional profiles.
Have you ever found yourself wanting to make a major shift – in skills, in roles, in relationships? Kevin Kline asks.
Raj Thukral of Pythian shares the presentation from Percona Live MySQL Conference Presentation.
Pythian’s Marco Tusa shares an interesting account of MySQL conference 2012 in Santa Clara proceedings.
As with any open source software, anyone can download MySQL sources, build binaries for some platforms and distribute their own packages, says Maciej Dobrzanski.
Julian Hyde shares the Data-oriented programming for the rest of us.
James Russell and team give an overview of what they have changed and the various configuration variables they have introduced to fine tune the flushing algorithm in InnoDB.
Checkpointing — which involves periodically writing out dirty pages from memory — is central to the design of crash recovery for both TokuDB and InnoDB, Martin Farach-Colton has more.
The story with Adaptive Flushing is so long, Dimitri Kravtchuk shares it.