Category Archives: hardware

StorMan Adaptec Controller Cheatsheet

Posted on May 21, 2009 by Matthew Yonkovit

Not really a MySQL related topic, but so I do not forget later on and for those who end up working with the StorMan CLI to manage their controller cards I thought I would publish my quick down and dirty … Continue reading →

Posted in hardware, linux, performance, raid | Comments Off

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

Posted on May 17, 2009 by Matthew Yonkovit

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

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

Posted on May 14, 2009 by Matthew Yonkovit

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

Intel X-25e and Mysql Part 1b: Don’t let your Drive Over Eat!

Posted on May 12, 2009 by Matthew Yonkovit

The plan was only to do two quick posts on RAID Performance on the X-25e, but this was compelling enough to post on it’s own.  So in part I Mark Callaghan asked hey what gives with  the SLC Intel’s single … Continue reading →

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

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

Posted on May 9, 2009 by Matthew Yonkovit

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

My Really High DBT2 Scores

Posted on April 26, 2009 by Matthew Yonkovit

Pre-UC I put out a teaser on some dbt2 scores in the 50K range.   I mentioned and showed the graphs during my SSD session, but I thought I would show them here for those who skipped the UC or did … Continue reading →

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

Tease me some more

Posted on April 13, 2009 by Matthew Yonkovit

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

Posted on April 12, 2009 by Matthew Yonkovit

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?

Posted on April 10, 2009 by Matthew Yonkovit

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

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