Monthly Archives: May 2009

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

StorMan Adaptec Controller Cheatsheet

Not really a MySQL related topic, but so I do not forget later on and for those who end up working with the StorMan CLI to manage their controller cards I thought I would publish my quick down and dirty … Continue reading

Posted in hardware, linux, performance, raid | Comments Off on StorMan Adaptec Controller Cheatsheet

What’s up with WaffleGrid?

You probably haven’t noticed but I have not blogged since the UC. It is not because I am upset by the perspective of working for Oracle, I have simply been busy tracking down an issue we have with WaffleGrid. We … Continue reading

Posted in mysql, Waffle Grid, yves | 6 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

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

Everyone loves SSD.  It’s a hot topic all around the MySQL community with vendors lining up all kinds of new solutions to attack the “disk io”  problem that has plagued us all for years and years.  At this year’s user … Continue reading

Posted in benchmark, hardware, linux, Matt, mysql, performance | 10 Comments

Boy am I a slacker!

Must of really been worn out post UC because my experiments and blogging have dipped to all time lows… but rest assured I am on my way back. I will be following up posting some posts on my Sun/Intel SSD … Continue reading

Posted in Matt, mysql | Comments Off on Boy am I a slacker!