Poems
For your enjoyment, I occasionally express my opinions in poems.
Database Index
2012-02-21
There is an index on each field
And all selects take long to yield.
Try finding which ones you need,
Remove the rest and feel the speed.
n00b
2011-06-16
Did you forget
That you were once
A novice dev
Without stance?
These youngers devs
Please don’t offend.
Help them evolve,
Don’t condescend.
Code Review
2011-06-15
Your large commits to the codebase
Are very hard for me to trace.
To smaller changes you must break
This code that makes my brain ache.
TDD
2011-06-14
Before you code
You better test,
So that on weekends
You may rest.
I love these! Someone showed me the Feb 21st one (today’s) because I’m a MySQL DBA, and the funny thing is that just today I recorded this week’s OurSQL podcast (http://www.oursql.com) and included a section on pt-index-usage – http://www.percona.com/doc/percona-toolkit/2.0/pt-index-usage.html – a tool that allows you to figure out which indexes are actually used, given logs.
(hope that helps! And keep the poems coming! Note that the podcast itself won’t be published until Friday, we record on Tuesdays and publish on Fridays, and our sound editor works his magic on the days in between.)
Hey Sheery! Long time no see. Thanks for this tool. I didn’t know that it existed. I always relied on my sense of smell for that, but it requires a lot more effort. I’ll try this out and give you some feedback.