Monthly Archives: February 2009

Patch to Disable Innodb’s Dynamic Stat Generation

Posted on February 27, 2009 by Matthew Yonkovit

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!

Posted on February 25, 2009 by Matthew Yonkovit

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

Posted on February 24, 2009 by Yves Trudeau

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

Fun with innodb stats

Posted on February 24, 2009 by Matthew Yonkovit

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

Posted on February 22, 2009 by Matthew Yonkovit

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

Posted on February 21, 2009 by Matthew Yonkovit

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?

Posted on February 21, 2009 by Matthew Yonkovit

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

Follow up on my Ec2 Latency Rant

Posted on February 20, 2009 by Matthew Yonkovit

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

Darn Ec2 Latency!

Posted on February 19, 2009 by Matthew Yonkovit

——— 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

Posted on February 19, 2009 by Matthew Yonkovit

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