Heh - a 'certified' database administrator

| No Comments
Great story about some maroon who took a class and got himself certified. From The Daily WTF:
The Certified DBA
�I�m not questioning your expertise,� Paul cautiously said to the Certified DBA, �it�s just that I�m just not used to requests with� this level of detail.�

Paul should have done what he was asked, exactly how he was asked to do it. After all, he was not an expert but just a lowly systems administrator. Fortunately, the Certified DBA made sure to keep him in his place.

�I would expect not,� smirked the Certified DBA, �system administrators generally don�t know how to tune for database performance, so I have to be very specific on the server configuration.�

The �configuration� that the Certified DBA was referring to was a rather complex set-up of disk partitions and RAID. Per his request, the server Paul was to set up should have six disks, each with ten partitions set-up. Corresponding partitions on disks 1, 3, and 5 were to be concatenated (not striped) to each other via RAID, while the partitions on disks 2, 4, and 6 served as mirrors of their corresponding partitions on disks 1, 2, and 5. All of these partitions were then to be mounted as directories (/p1, /p2, etc) in the file system.

�Fair enough,� Paul acquiesced, �but I�d like to understand why this helps with database tuning . I mean, wouldn�t this just create slower reads and writes? I just don�t see how it helps perfor��

�I�ve been doing this for fifteen years and it�s not like you can understand database tuning overnight.� The Certified DBA was getting aggravated. �The long and the short of it is: the partitions allow me to place datafiles on different physical parts of the disk. The outer edge of the disk is the fastest, so I put indexes in partition 1. Large binary data goes on partition 10. And so on.�
The database, of course, runs very slowly. There is a fix from the DBA but then, the DBA goes on vacation:
Paul, being the lowly system administrator, was not in a position to argue with the Certified DBA, and had little choice but to do what he was told. But instead of doing just that, Paul decided to try something different.

While the Certified DBA was on vacation, Paul took a pair of the 10,000 RPM drives, mirrored them, and then set-up a series of directories (/p1, /p2) on the file system. When the system was brought back online � using a single drive and a single partition � the I/O reads went down by a couple orders of magnitude. The overall application performance improved dramatically, and the users were appreciative.

But there was one thing, however, that was missing: approval by the Certified DBA. Undoubtedly, he�d be upset that his instructions weren�t followed, and accuse the lowly sysadmin of subterfuge and insubordination.

With the Certified DBA returning the following day, Paul was desperate and changed the �df� command such that it executed a shell script that looked identical to the real df command: it listed ten partitions, each mounted in /p1, /p2, and so on.

And the shell script worked. In fact, it worked so well that the Certified DBA took a screenshot of it and used it in an article he wrote about database �tuning� for a trade magazine. And, being the nice guy that he was, the Certified DBA gave Paul a signed copy of that issue.

Though the Certified DBA is long gone, Paul still keeps the signed magazine hanging in his office. It�s taught him more about database tuning than he ever could have hoped for.
When I worked at Microsoft, I was a member of the lab heardware support team for their SQL Server database and then I moved over to the Enterprise Scalability Lab where I got to play with some serious iron. Tuning an array to optimize it for a database is not a black art. Tuning the database software is but the iron is pretty straightforward. Machines that I administered and helped to set up were used in several TPC-C benchmarks...

Leave a comment

August 2019

Sun Mon Tue Wed Thu Fri Sat
        1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31

Environment and Climate
AccuWeather
Cliff Mass Weather Blog
Climate Audit
Climate Depot
Green Trust
ICECAP
Jennifer Marohasy
MetaEfficient
Planet Gore
Science and Public Policy Institute
Solar Cycle 24
Space Weather
Space Weather - Canada
the Air Vent
Tom Nelson
Watts Up With That?


Science and Medicine
Derek Lowe
Junk Science
Life in the Fast Lane
Luboš Motl
Medgadget
New Scientist
Next Big Future
PhysOrg.com
Ptak Science Books
Science Blog


Geek Stuff
Ars Technica
Boing Boing
Don Lancaster's Guru's Lair
Evil Mad Scientist Laboratories
FAIL Blog
Hack a Day
Kevin Kelly - Cool Tools
Neatorama
Slashdot: News for nerds
The Register
The Daily WTF
TYWKIWDBI


Comics
Achewood
The Argyle Sweater
Chip Bok
Broadside Cartoons
Day by Day
Dilbert
Medium Large
Michael Ramirez
Prickly City
Tundra
User Friendly
Vexarr
What The Duck
Wondermark
xkcd


NO WAI! WTF?¿?¿
Awkward Family Photos
Cake Wrecks
Not Always Right
Sober in a Nightclub
You Drive What?


Business and Economics
The Austrian Economists
Carpe Diem
Coyote Blog


Photography and Art
Digital Photography Review
DIYPhotography
James Gurney
Joe McNally's Blog
PetaPixel
photo.net
Shorpy
Strobist
The Online Photographer


Blogrolling
A Western Heart
AMCGLTD.COM
American Digest
The AnarchAngel
Anti-Idiotarian Rottweiler
Babalu Blog
Belmont Club
Bayou Renaissance Man
Classical Values
Cobb
Cold Fury
David Limbaugh
Defense Technology
Doug Ross @ Journal
Grouchy Old Cripple
Instapundit
iowahawk
Irons in the Fire
James Lileks
Lowering the Bar
Maggie's Farm
Marginal Revolution
Michael J. Totten
Mostly Cajun
Neanderpundit
neo-neocon
Power Line
ProfessorBainbridge.com
Questions and Observations
Rachel Lucas
Roger L. Simon
Samizdata.net
Sense of Events
Sound Politics
The Strata-Sphere
The Smallest Minority
The Volokh Conspiracy
Tim Blair
Velociworld
Weasel Zippers
WILLisms.com
Wizbang


Gone but not Forgotten...
A Coyote at the Dog Show
Bad Eagle
Steven DenBeste
democrats give conservatives indigestion
Allah
BigPictureSmallOffice
Cox and Forkum
The Diplomad
Priorities & Frivolities
Gut Rumbles
Mean Mr. Mustard 2.0
MegaPundit
Masamune
Neptunus Lex
Other Side of Kim
Publicola
Ramblings' Journal
Sgt. Stryker
shining full plate and a good broadsword
A Physicist's Perspective
The Daily Demarche
Wayne's Online Newsletter

About this Entry

This page contains a single entry by DaveH published on March 23, 2010 3:01 PM.

Fusion in the news - both cold and hot was the previous entry in this blog.

Happy Birthday - Carl Zeiss lenses is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.

Monthly Archives

Pages

OpenID accepted here Learn more about OpenID
Powered by Movable Type 5.2.9