Tools of a Support Engineer

So, you’ve emailed MySQL Support, they’re working on the problem you’re having. How are they working? What tools do they use? Well, here’s my list: IRC – All MySQL Support Engineers work on IRC, it’s our main communication medium. While you’re only getting emails from one Engineer, it’s quite likely they’re consulting with several others […]

Gig Of The Year: Pillowtalk

I know, it’s pretty early on in the year to be making that claim. But, I think it’s justified. First of all, the performers: Tim Freedman, of The Whitlams Pinky Beecroft, formerly of Machine Gun Fellatio, now of Pinky Beecroft and the White Russians Dave McCormack, formerly of Custard, now of Dave McCormack and the […]

Fed Square Microbreweries Showcase

Yesterday, I went to the Microbreweries Showcase, held at Federation Square. With 17 breweries showing their product, there were plenty to try from. Here are my notes from the variety I tasted: Brewery Brew Notes Arctic Fox Brewery Ice Cap Lager Light flavour, with a slightly fruity aftertaste. Drinkable, but not particularly exciting. Bridge Road […]

Backing up permissions for individual databases

Sometimes, you want to backup individual databases in MySQL to move to a different server. This part is easy using mysqldump: shell> mysqldump -u root -p –databases db1 db2 … > backup.sql The problem is, what happens when you want to backup the permissions associated with these databases? Well, here are a few queries to […]

A Brief Introduction to MySQL Performance Tuning

Here are some common performance tuning concepts that I frequently run into. Please note that this really is only a basic introduction to performance tuning. For more in-depth tuning, it strongly depends on your systems, data and usage. Server Variables For tuning InnoDB performance, your primary variable is innodb_buffer_pool_size. This is the chunk of memory […]