26
A MySQL Story
The Taso Dump
I’ve gotto go, my time has come. (maintenance window needed)
Could not get a lock. (table lock)
I needed a blocker to ensure a single thread. (–single-transaction)
Finally, got a lock. (–lock-tables)
Need to ensure no transactions lost.
Dump, Dump, Dump. (mysqldump)
I’m having flow problems.
Was the buffer to small? (key_buffer_size)
Was it the query cache? (query_cache)
My Dirty Pages may be too high? (innodb_max_dirty_pages_pct)
Or was it just Too Many Connections? (max_connections)
But it was just waiting on the flush (flush tables with read lock)
Time passes, Time Passes. No output yet.
Is it network saturation?
Is it IO bound?
Do I need a better flushing method (innodb_flush_method)
No, it was just the lag? (Seconds_behind_master)
Dump is complete (unlock tables)
Now it’s time to Purge (purge logs)
If there is an attempt to restore.
The backup would be empty.
Blackhole would be found as the cause.
In the end, all transactions lost!
If you weren’t at Friday dinner after MySQL Camp II you missed it.
It’s not meant to be MySQL grammar correct, it’s just some random words we were throwing around.
I am so tempted to craft this into rhyming lyrics and write a tune.
Or do you already have one in mind?
PJ
Comment by PJ — August 26, 2007 @ 3:27 pm
haha, I like it
Comment by Jad — August 26, 2007 @ 10:37 pm
Heh, yeah — what tune is this song to?
Comment by Dossy Shiobara — August 27, 2007 @ 3:39 am
This is just so funny.
Comment by Frank Mashraqi — August 27, 2007 @ 10:07 am
Common guys, I don’t need this shit. Actually, yea I do; Ronald, guard the door.
Comment by Taso — August 28, 2007 @ 2:28 am