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.
Oracle:
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.
SQL Server:
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.
MySQL:
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.
3 comments on “Log Buffer #267, A Carnival of the Vanities for DBAs”
Leave a Reply
You must be logged in to post a comment.
Why is this blog constantly ignoring PostgreSQL?
@Peter, it’s a carnival of the vanities.
You can submit the posts you would like covered and they should be covered. If you’ve been submitting PostgreSQL posts and they have not been covered, send me a note and let me know, although what I suspect is going on is simply that you have not been submitting posts.
The posts included are the ones submitted or the ones the host (in this case Fahd, an Oracle guy) would otherwise have been reading.
Another option is to simply host a log buffer yourself. In that case, you will include whatever you like (but of course also including the posts submitted to you).
You can find out more about how Log Buffer (and in fact every carnival of the vanities) works at the about post, linked above … or just click http://www.pythian.com/news/about-log-buffer/
Thanks Peter for your feedback. The upcoming Log Buffer would also cover PostgreSQL along with DB2.
Your are very much welcome to send any posts you like to be included or host the log buffer yourself.
Thank you.