Monthly Archives: November 2008

Waffle Grid: 0.2 Patches are available!

Ok, Yves pushed up two patches onto launchpad the other Day. I wanted to get a chance to fully test out the patches before blogging about them, and as I mentioned in my previous blog post, I have been dealing … Continue reading

Posted in mysql, Waffle Grid | 1 Comment

Waffle Grid: Bad Memory!!! Egads

Well my last wafflegrid benchmarks may have been subject to a bad memory chip.  Wednesday I rebooted my server and was greeted with several errors and Ubuntu would not boot.  After yanking my hair out, I ran the memory test … Continue reading

Posted in hardware, Waffle Grid | 1 Comment

Waffle Grid: We need a MRU not an LRU!

I knew something was wrong with my previous numbers, and there is an optimization that should improve it.  So I was trying to test out the performance difference between a Waffle running localhost memcached and one with a remote memcached … Continue reading

Posted in mysql, Waffle Grid | 4 Comments

More Waffle Grid stuff

Continuing on with the discussion on Waffle Grid, I have put together a few interesting benchmarks and wanted to expand on some of the possible deployment scenarios using Waffle. My home laboratory is rather small, so my datasets are limited … Continue reading

Posted in mysql, performance, Waffle Grid | Comments Off on More Waffle Grid stuff

Waffle Grid quick install tutorial

Yesterday we announced what the Waffle Grid project is.  Some people ignored it, others I am sure read it with curiosity, but i figure their is a small subset of folks out their who said: “WOW!!!  That is really cool.  … Continue reading

Posted in mysql, Waffle Grid | Comments Off on Waffle Grid quick install tutorial

Memcached as a L2 Cache for Innodb – The Waffle Grid Project

A few months ago I was at dinner with Yves Trudeau discussing what all consultants discuss in the late hours after a long day of hard work… how to improve performance and scalability.  I brought up an idea to him … Continue reading

Posted in mysql, performance, Waffle Grid | 7 Comments

Ec2 Private Network performance

Been doing some testing in EC2 over the last few weeks, and noticed just how miserable the network performance of the private network.  Thought I would stick this out their for others who may be interested, take a look: 64 … Continue reading

Posted in hardware, performance | Comments Off on Ec2 Private Network performance

24 Hour DBT2 run on the Intel X-25M SSD

Following up on my previous post Peter asked if he could see a 24 hour run on the Intel drive…  took me a few days because I am doing some testing on a few other things, but I kicked a … Continue reading

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

CPU Affinity for Interrupts

Thought I would throw this out here so I remember it, and it maybe useful for someone else.  During a session here at Sun’s CEC conference one of the presenter was talking about setting CPU affinity for hardware interrupts.  This … Continue reading

Posted in hardware, linux, mysql, performance | 2 Comments

Intel x-25m80GB SSD DBT2/MySQL Benchmarks

As promised, here are the DBT2 results for the Intel SSD drive: Raid 5 Raid 10 10K Raptor Matt’s Mtron Matt’s Memoright Intel x-25m 4579 6139 625 4900 4156 6558 8-disks 8-disks 1 disk 1 disk 1 disk 1 disk … Continue reading

Posted in hardware, mysql, performance | 16 Comments