Category Archives: hardware

Testing MYSQL on the Violin Memory Flash 1010 Part II:

Continuing my series on the Violin Memory 1010 I am turning my attention to the DBT2 benchmark which simulates an OLTP workload. I started with my typical “waffle” workload which is a 20 warehouse setup ( about 2.5 GB ) … Continue reading

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

Testing MYSQL on the Violin Memory Flash 1010 Part I:

Continuing my series of in depth looks at flash appliances, sans, and drives I spent a few weeks test driving the Violin Memory flash ( and DDR based ) solutions. Just from the specs the Violin Memory 1010 is impressive. … Continue reading

Posted in benchmark, hardware, linux, Matt, mysql | 4 Comments

Testing Performance on a Texas Memory System RAMSAN-500 pt3

This is part 3 in my RAMSan Series. While I am confident the read-only test was a reasonably good test ( I just needed to push more ), my mixed load test was marred by issues.  It was really a … Continue reading

Posted in benchmark, hardware, linux, Matt, mysql, performance, raid | Comments Off on Testing Performance on a Texas Memory System RAMSAN-500 pt3

Testing Performance on a Texas Memory System RAMSAN-500 pt2

This is part 2 of My RAMSan Series. In my normal suite of benchmarks I typically run dbt2 & sysbench oltp benchmarks next…  and I did run then, but to be honest they just weren’t that interesting.  They showed an … Continue reading

Posted in hardware, linux, mysql, performance, raid | Comments Off on Testing Performance on a Texas Memory System RAMSAN-500 pt2

Testing Performance on a Texas Memory System RAMSAN-500

Well its about time I posted this:)  This is part 1 of 3 in my Ramsan series. For those who have paid attention to my blog, know I love talking  IO!  I also love performance.  Absolutely love it.  Love disk, … Continue reading

Posted in hardware, linux, mysql, performance, raid | 7 Comments

Random thoughts on a MySQL Disk Bound Benchmark

So since last talking about a new benchmark I found a need for one.  Specifically the need to truly test IO bound workloads in mysql to flex fast storage subsystems.  Tackling a new benchmark is not as easy as I … Continue reading

Posted in hardware, mysql, performance | 4 Comments

MySQL Memory allocation & TMPDIR

A quick one here, we often talk about effectively utilizing memory to get the most of your MySQL Server.  I wanted to remind folks to not forget about allocating memory to a tmpfs for the tmpdir.  Certainly this is not … Continue reading

Posted in Common Mistakes, hardware, mysql, performance | 14 Comments

Waffle Grid: Testing Waffle With Dolphin Interconnects

Let’s grab your attention with a shameless marketing ploy:  How would you like up to a 14X performance boost in your Mysql database performance? Now your hooked who wouldn’t want a 14x boost?  Well we got that using Dolphin interconnects … Continue reading

Posted in HA, hardware, mysql, performance, Waffle Grid | 1 Comment

Wafflegrid: DBT2, Dolphin and Innodb Readahead

Ok, I am perplexed… i don’t say that often.   I have the privilege of testing out a couple of Dolphin Interconnects with Waffle Grid.   They are proving to substantially improve our transactions throughput, I mean we are getting 3x performance … Continue reading

Posted in hardware, mysql, performance, Waffle Grid | 2 Comments

Exciting, Fun, and Fast …

Some good news.  I have been able to secure some additional hardware for testing over the next few months.  First up I received a pair of Dolphin interconnect cards which I will be putting through the paces sooner rather then … Continue reading

Posted in hardware, mysql, Waffle Grid | Comments Off on Exciting, Fun, and Fast …