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

Jul 13, 2012 / By Fahd Mirza

Tags: , , ,

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.

Oracle:

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.

MySQL:

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.

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>