Category Archives: Matt

Leaving Sun/MySQL but not the community

I thought I would put out a quick note about this right now, I am going to be leaving Sun next week. I do have some plans which will start to materialize over the next few weeks and months so … Continue reading

Posted in Matt, mysql, personal | 2 Comments

WaffleGrid: Cream Benchmarks, stable and delivering a 3x boost

Lets get down to how the latest version of Waffle Grid performs. Starting off simple lets look at the difference between the wafflegrid modes. As mentioned before the LRU mode is the “classic” Waffle Grid setup. A page is put … Continue reading

Posted in benchmark, Matt, mysql, performance, Waffle Grid | Comments Off on WaffleGrid: Cream Benchmarks, stable and delivering a 3x boost

WaffleGrid: 0.5 Cream Release

I wanted to let everyone know that we are releasing Waffle Grid 0.5 code named Cream. This release fixes the nasty secondary index bug that plagued the butter release. I have been running tests on this code base for about … Continue reading

Posted in Matt, mysql, performance, Waffle Grid | 1 Comment

Be Wary of Large Log File Sizes

As some people have mentioned here and here Increasing the innodb log file size can lead to nice increases in performance. This is a trick we often deploy with clients so their is not anything really new here. However their … Continue reading

Posted in 5 minute dba, Common Mistakes, Matt, mysql, performance | 1 Comment

Waffle: Progress and a Rearchtecture?

So I spent several hours over the last few days on the Secondary index bug. Out of frustration I decided to try and bypass the LRU concept all together and try going to a true secondary page cache. In standard … Continue reading

Posted in benchmark, innodb internals, linux, Matt, mysql, Waffle Grid | 1 Comment

Waffle: The Mystery Continues

So I spent the weekend looking at places where we may have missed something in the code for waffle. You can actually see some of the stuff I tried in the bug on launchpad about this, but the weird thing … Continue reading

Posted in innodb internals, Matt, mysql, Waffle Grid | 2 Comments

Waffle: limiting the space ids being pushed to memcached

If you read Yves blog post about waffle yesterday we are seeing some weird gremlins in the system and could use some scoobey doo detective work if you have some ideas. The strange thing is it only exhibits under high … Continue reading

Posted in innodb internals, Matt, mysql, Waffle Grid | 3 Comments

Sun/Intel X-25e 4 Disk Raid 10 tests – part 2

So lets test some different configurations and try and build some best practices around Multiple SSD’s: Which is better? Raid 5 or Raid 10? As with regular disks, Raid 10 seems to performance better ( accept for pure reads ).  … Continue reading

Posted in benchmark, hardware, linux, Matt, mysql, performance | Comments Off on Sun/Intel X-25e 4 Disk Raid 10 tests – part 2

x-25e, 25% reduction in random writes…

So in my previous post I showed some benchmarks showing a large drop off in performance when you fill the x-25e. I wanted to followup and say this: even if you do everything correctly ( i.e. leave 50%+ space free, … Continue reading

Posted in benchmark, hardware, Matt, mysql, performance | 3 Comments

Intel X-25e and Mysql Part 1b: Don’t let your Drive Over Eat!

The plan was only to do two quick posts on RAID Performance on the X-25e, but this was compelling enough to post on it’s own.  So in part I Mark Callaghan asked hey what gives with  the SLC Intel’s single … Continue reading

Posted in benchmark, hardware, Matt, mysql | 6 Comments