Log Buffer #267, A Carnival of the Vanities for DBAs
Apr 13, 2012 / By Fahd Mirza
It feels like blogs appeared just yesterday. 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 an unprecedented sharing of ideas for database professionals. The nature of databases and blogging is to always change, but Log Buffers are here to stay.
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 described in another good post by Charles Hooper.
Chad Miller wants to show how to use table-valued parameters available in SQL Server 2008 and higher and uses examples of the 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 that you can’t believe no-one else has picked up on it before. This is one of those times: A few months or so ago, Chris Webb came across a new tool called as Layerscape.
Pinal Dave talks about social networking sites and professional profiles.
Have you ever found yourself wanting to make a major shift – in skills, roles, or relationships? Kevin Kline asks.
Raj Thukral of Pythian shares his 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 Data-oriented programming for the rest of us.
James Russell and team give an overview of what they have changed and what are 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 long, and Dimitri Kravtchuk shares it.
3 Responses to “Log Buffer #267, A Carnival of the Vanities for DBAs”
Leave a Reply