Monthly Archives: March 2009

What’s the Performance impact of the Double Write Buffer?

Posted on March 31, 2009 by Matthew Yonkovit

I have been benchmarking Waffle Grid using the new Innodb Plugin 1.03 the past couple of days. Let me say the plugin is fast. Which got me thinking, generally when you fix a bottleneck another area becomes a bottleneck… its … Continue reading →

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

vmplot.sh, a useful tool for MySQL performance tuning

Posted on March 30, 2009 by Yves Trudeau

I don’t know if it is because of my science background, I am a physicist, I do like graphs, especially when I do performance tuning. With UNIX like operating systems, the vmstat command give you an easy way to grab … Continue reading →

Posted in benchmark, linux, mysql, performance, yves | Comments Off

Testing MYSQL on the Violin Memory Flash 1010 Part III:

Posted on March 29, 2009 by Matthew Yonkovit

So we have already looked at sysbench & dbt2 tests… now we have to look at the new Juice DB benchmark. Juice runs a series of queries generate its load, these queries are combined into a workload. I tested the … Continue reading →

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

Wafflegrid memcached 1.3.2

Posted on March 28, 2009 by Matthew Yonkovit

Quick note I got memcached 1.3.2 working with waffle. I added a lot more code then I needed, and I think I may be able to get this down to a 1 or 2 line patch… In case your interested … Continue reading →

Posted in Matt, mysql, Waffle Grid | Comments Off

Playing with Waffle & Mecached 1.3.2

Posted on March 27, 2009 by Matthew Yonkovit

So I got our Waffle specific code over into Memcached 1.3.2 last night…  not 100% sure why at this point but I am seeing a huge change in the the hit rate between 1.2.5 and 1.3.2.  Take a look: Old … Continue reading →

Posted in benchmark, Matt, mysql, Waffle Grid | Comments Off

Testing MYSQL on the Violin Memory Flash 1010 Part II:

Posted on March 27, 2009 by Matthew Yonkovit

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

Efficient sequences with MySQL

Posted on March 26, 2009 by Yves Trudeau

As you probably now if you reading this blog, MySQL does not support SQL sequences. Logically, it is very easy to implement something equivalent to a sequence using transaction with InnoDB with a simple 2 columns table, name and value. … Continue reading →

Posted in mysql, yves | 5 Comments

Testing MYSQL on the Violin Memory Flash 1010 Part I:

Posted on March 25, 2009 by Matthew Yonkovit

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

Juicey: New Juice Benchmark Output

Posted on March 24, 2009 by Matthew Yonkovit

Pushed about a ton of changes to the Juice benchmark since I announced it… lots of little fixes and a few big ones… really their are too many to talk about, and a lot of the new stuff is boring … Continue reading →

Posted in benchmark, Matt, mysql | Comments Off

The upcoming MySQL UC 2009

Posted on March 24, 2009 by Yves Trudeau

The MySQL UC 2009 is coming and it is time for my own little marketing. As Matt already annonced it a few months ago we (Matt and I) are doing a WaffleGrid presentation, Distributed InnoDB caching with Memcached, Tuesday at … Continue reading →

Posted in mysql, NDB Cluster, Waffle Grid, yves | 1 Comment