Monthly Archives: February 2009

Patch to Disable Innodb’s Dynamic Stat Generation

Alright my stats patch appears to be working ( its a first step anyways ), eventually this is going to make it into waffle grid… but I thought it would be useful as a standalone patch.  Basically what this patch … Continue reading

Posted in mysql, performance, Waffle Grid | 4 Comments

Resolving Common Performance Issues Webinar!

I will be giving a webinar on march 9th about  common performance issues and how we in the MySQL Professional Services team go about fixing them.   So stop on by and say hi!  You can register here: http://www.mysql.com/news-and-events/web-seminars/display-298.html

Posted in mysql | 1 Comment

WaffleGrid new features

Recently, I have been traveling a lot to the west coast (I live in Quebec) so I had plenty of time to update WaffleGrid while flying. Here are the new features/ports: Dynamic memcached servers list Matt enhanced stats ported from … Continue reading

Posted in mysql, Waffle Grid, yves | Comments Off on WaffleGrid new features

Fun with innodb stats

I scrubbed the SQL here to protect the innocent, but check this fun stuff out.  Working with a client who randomly started seeing huge spikes in CPU and disk activity on their server after weeks of seemingly running fine.  I … Continue reading

Posted in mysql, performance, rant | 7 Comments

We need a better benchmark

Boy am I sick or what, maybe I should see a shrink or something.  What’s the first thing that runs through my head when I wake up on a Sunday morning?  Is it thoughts of family, the days events, happy … Continue reading

Posted in mysql, performance, rant | 7 Comments

The 5 minute DBA: Storage Engine Selection

I was soooo tempted to post a 1 word post on this, just posting “Innodb”. It would be very easy, and its the advice that I am going to give in the end anyways. After all we need to get … Continue reading

Posted in 5 minute dba, mysql | 1 Comment

What do we do here at bigdbahead.com over the weekend?

We have benchmark parties!  Yes , I spend my weekend glued to the LCD running benchmarks day and night.  While it may seem like the work of a madman or a lonely bunch of geeks without a date who are … Continue reading

Posted in mysql, performance, Waffle Grid | Comments Off on What do we do here at bigdbahead.com over the weekend?

Follow up on my Ec2 Latency Rant

I was testing up our latest Waffle release when I saw this horrid latency, average in the 12+ms range.  So I decided to dig a bit deeper today: i’ll start with a Single threaded test on the ec2 setup I … Continue reading

Posted in mysql, performance, Waffle Grid | Comments Off on Follow up on my Ec2 Latency Rant

Darn Ec2 Latency!

——— MEMCACHED ——— Memcached puts    141075 Memcached hits    122696 Memcached misses  18329 Memcached Prefix:  29298 Memcached Get Total Lat 12222 (us) Memcached Get Recent Lat 10925 (us) Memcached Miss Total Lat 8490 (us) Memcached Miss Recent Lat 5740 (us) Memcached … Continue reading

Posted in mysql, performance, rant, Waffle Grid | 5 Comments

Waffle Grid: bugs & future features

As we have mentioned several times you probably know we are planning to migrate our development over to the innodb-plugin and start following the path of the storage engine.  That’s all well and good but what are the warts and … Continue reading

Posted in mysql, performance, Waffle Grid | Comments Off on Waffle Grid: bugs & future features