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

Apr 13, 2012 / By Fahd Mirza

Tags: , , ,

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.


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 described in another good post by Charles Hooper.

SQL Server:

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.

MySQL:

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”

  • Peter says:

    Why is this blog constantly ignoring PostgreSQL?

    • Paul Vallee says:

      @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/

    • Fahd Mirza says:

      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.

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>