Category Archives: performance

Sun/Intel X-25e 4 Disk Raid 10 tests – part 2

So lets test some different configurations and try and build some best practices around Multiple SSD’s: Which is better? Raid 5 or Raid 10? As with regular disks, Raid 10 seems to performance better ( accept for pure reads ).  … Continue reading

Posted in benchmark, hardware, linux, Matt, mysql, performance | Comments Off on Sun/Intel X-25e 4 Disk Raid 10 tests – part 2

x-25e, 25% reduction in random writes…

So in my previous post I showed some benchmarks showing a large drop off in performance when you fill the x-25e. I wanted to followup and say this: even if you do everything correctly ( i.e. leave 50%+ space free, … Continue reading

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

Sun/Intel X-25e 4 Disk Raid 10 tests – part 1

Everyone loves SSD.  It’s a hot topic all around the MySQL community with vendors lining up all kinds of new solutions to attack the “disk io”  problem that has plagued us all for years and years.  At this year’s user … Continue reading

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

Counting down the days before UC Time!!

One last reminder, we ( Yves and I ) will be appearing all over the place at the UC. Here is a quick run down of our schedule: Tuesday 10:50 am – 11:35 pm (Free MySQL Camp) I will be … Continue reading

Posted in Matt, mysql, performance, Waffle Grid, yves | Tagged | Comments Off on Counting down the days before UC Time!!

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

Tease me, SUN SSD Benchmarks

Only a little over a week before the User conference and I am still burning the midnight oil to get as much information for my presentations as possible. I thought I would tease you a bit here. What do you … Continue reading

Posted in hardware, linux, Matt, mysql, performance, raid, Uncategorized | 5 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

WaffleGrid is plugging along!

Yes we are still plugging away working on Waffle Grid, in fact I am testing the heck out of the plugin release this week. Some good news, great news, and bad news to report. The good news on the testing … Continue reading

Posted in Matt, mysql, performance, Waffle Grid | 1 Comment

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