Category Archives: linux

More Debate, More Flame, More Choosing the correct tool for the job

Posted on March 29, 2010 by Matthew Yonkovit

You have to love all the debating going on over NOSQL -vs- SQL don’t you? With my UC session on choosing the right data storage tools ( does this sound better then SQL-vs-NoSQL?) I have been trying to stay current … Continue reading →

Posted in benchmark, linux, Matt, mysql, NOSQL, performance | 1 Comment

New Benchmark I am working on that tests MYSQL -vs- NOSQL

Posted on March 29, 2010 by Matthew Yonkovit

I am giving a talk in a couple of weeks at the 2010 MySQL User Conference that will touch on use cases for NOSQL tools -vs- More relational tools, the talk is entitled “Choosing the Right Tools for the Job, … Continue reading →

Posted in benchmark, linux, Matt, mysql, NOSQL, performance, Tokyo | 3 Comments

Waffle: Progress and a Rearchtecture?

Posted on May 28, 2009 by Matthew Yonkovit

So I spent several hours over the last few days on the Secondary index bug. Out of frustration I decided to try and bypass the LRU concept all together and try going to a true secondary page cache. In standard … Continue reading →

Posted in benchmark, innodb internals, linux, Matt, mysql, Waffle Grid | 1 Comment

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

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

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

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 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