Category Archives: benchmark

Another one down… the problem with storage

Well I just finished my SSD session.  I was concerned by the amount of slides I had so I  kept trimming them back.  What happened?  I finished early.  Why?  The problem with storage is it’s not really that sexy.  I … Continue reading

Posted in benchmark, mysql | 3 Comments

Tease me some more

Take a look here: Response Time (s) Transaction % Average : 90th % Total Rollbacks % ———— —– ——————— ———– ————— —– Delivery 3.98 0.211 : 0.266 274829 0 0.00 New Order 44.78 0.157 : 0.187 3090951 30925 1.00 Order … Continue reading

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

Intel SSD Write Cache… Is it an issue or isn’t it?

I am doing the final prep work for my upcoming UC presentation on SSD’s, and I thought I would throw this out their. Recently their has been a great deal of discussion on the write cache on the Intel x-25e … Continue reading

Posted in benchmark, hardware, mysql, performance | 5 Comments

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:

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

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