Category Archives: benchmark

Innodb Compression: When More is Less

Posted on May 22, 2011 by Matthew Yonkovit

So Vadim posted on the MySQL Performance Blog about poor benchmarks when running innodb compressed pages.  I ran some tests a few weeks ago and did not see the same results as him and checked into my previous tests and … Continue reading →

Posted in benchmark, innodb internals, mysql | Comments Off

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

WaffleGrid: Cream Benchmarks, stable and delivering a 3x boost

Posted on June 7, 2009 by Matthew Yonkovit

Lets get down to how the latest version of Waffle Grid performs. Starting off simple lets look at the difference between the wafflegrid modes. As mentioned before the LRU mode is the “classic” Waffle Grid setup. A page is put … Continue reading →

Posted in benchmark, Matt, mysql, performance, Waffle Grid | Comments Off

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

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