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

Posted in: Technical Track

Database bloggers are blowing their trumpets at full throttle, warming up the hearts of readers across the globe with cool tips, nifty tricks, and glimmering gems. This Log Buffer Edition picks those gems and offers them to you.


Charles Hooper is dealing with a parallel execution challenge.

Why a very simple query against a hash partitioned table was doing so much physical I/O to get a very small amount of data from a single partition, as explained by Jonathan Lewis.

If you want to add a primary key (or unique) constraint to a table where there might be some duplicate data, one of the best strategies for doing so might be to create a non-unique index (with the online option), then add the constraint in the state enable novalidate and  validate the constraint. A cool advice from Jonathan once again.

Stephen William has a gem of an article about preventing problems instead of faster reactions when they rear their head.

Instrumentation in your code is pure gold when it comes to analyzing performance. Doug nails it.

SQL Server:

When it comes to SQLIO, we immediately think: performance capacity. Determine the IO capacity of an IO subsystem for certain types of IO usage relevant to SQL Server. Jack Vamvas has more.

Jakub Dvorak reports that the SQLTreeo is suspended.

Michael Swart has an interesting post about developing on the right side of the brain.

John Sterrett is sharing his first video of a performance tuning process.


Dathan Pattishall has a case for automation of OpenMMS for XTRADB backups with Python.

A nice interview on data privacy and security.

When Artem Livshits talks to prospective customers about the Cloud Storage Engine for MySQL (ClouSE), the question of cloud reliability often comes up.

There is a new release of XAMPP for Windows and Linux.

Ronald Bradford is presenting an evaluation of various compression utilities that he tested when reviewing the various options for MySQL backup strategies.



Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

I have been in love with Oracle blogging since 2007. This blogging, coupled with extensive participation in Oracle forums, plus Oracle related speaking engagements, various Oracle certifications, teaching, and working in the trenches with Oracle technologies has enabled me to receive the Oracle ACE award. I was the first ever Pakistani to get that award. From Oracle Open World SF to Foresight 20:20 Perth. I have been expressing my love for Exadata. For the last few years, I am loving the data at Pythian, and proudly writing their log buffer carnivals.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *