Monthly Archives: March 2009

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

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

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 on vmplot.sh, a useful tool for MySQL performance tuning

Testing MYSQL on the Violin Memory Flash 1010 Part III:

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 on Testing MYSQL on the Violin Memory Flash 1010 Part III:

Wafflegrid memcached 1.3.2

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 on Wafflegrid memcached 1.3.2

Playing with Waffle & Mecached 1.3.2

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 on Playing with Waffle & Mecached 1.3.2

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

Efficient sequences with MySQL

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:

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

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 on Juicey: New Juice Benchmark Output

The upcoming MySQL UC 2009

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