Log Buffer #277, A Carnival of the Vanities for DBAs
Jul 13, 2012 / By Fahd Mirza
Database bloggers are blowing their trumpets at full throttle warming up the hearts of readers across the globe with cool tips, nifty tricks and gems. This Log Buffer Edition in Log Buffer #277 picks those gems and present 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. Jonathan Lewis answers.
If you want to add a primary key (or unique) constraint to a table where there might be some duplicate data then 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 then validate the constraint, a cool advice from Jonathan once again.
Stephen William has 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 analysing performance, Doug nails it.
When thinking of SQLIO think : performance capacity. Determine the IO capacity of an IO subsystem for certain types of IO usage relevant to SQL Server. Yes Jack Vamvas has more.
Jakub Dvorak informs 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 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.