Monthly Archives: February 2008

Final Mtron SSD, MySQL, MFT Benchmarks and more!

Posted on February 28, 2008 by Matthew Yonkovit

Well its been a while since I started this, so I thought it was about time to put some of this to rest. I have been beating up the Mtron disks for several weeks. During that time I had a … Continue reading →

Posted in hardware, mysql, performance | 2 Comments

SSD and MySQL Tests… The logic behind the tests & wondering did I break it?

Posted on February 16, 2008 by Matthew Yonkovit

Over the last several weeks I have been testing out the 2 mtron drives that easy computing company provided me. In fact I have been testing like a madman. Nightly I would kick off a batch of DBT2 tests, sysbench … Continue reading →

Posted in hardware, linux, mysql, performance, raid | 4 Comments

More XFS & MySQL Benchmarks

Posted on February 11, 2008 by Matthew Yonkovit

I did some more benchmarking on XFS over the weekend. I ran at least 3 independent tests, which were all within 5-10% of the below results. Mtron 4 Disk (15K ) Raid 10 (256MB Cache) Single Raptor Threads read/write test … Continue reading →

Posted in hardware, linux, mysql, performance | 1 Comment

More XFS Fun on Centos 5 with MySQL

Posted on February 10, 2008 by Matthew Yonkovit

More interesting stuff here. I reran the XFS tests yesterday, same old story. The generic sysbench disk ( on mtron ssd ) tests show this: EXT3: Operations performed: 5001 Read, 4999 Write, 12800 Other = 22800 Total Read 78.141Mb Written … Continue reading →

Posted in linux, mysql, performance | Comments Off

XFS & Centos 5 & MySQL Performance

Posted on February 9, 2008 by Matthew Yonkovit

OK, Sometimes you stumble onto things that are just not right. On my own personal set of hardware (independent from the Server with the IBM Raid card) I am still running Tests with the Mtron flash drives. I noticed a … Continue reading →

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

XFS, Centos 5, & IBM ServeRAID 8k Card

Posted on February 5, 2008 by Matthew Yonkovit

Ran into a rather nasty little bug/undocumented feature today. Working on a new system with an IBM Server Raid controller card on a Centos 5 install. One of the key tasks of this engagement is ensure that everything is setup … Continue reading →

Posted in hardware, linux, performance | Comments Off

More Details on MySQL & SSD drive performance…

Posted on February 4, 2008 by Matthew Yonkovit

As mentioned earlier I am testing out SSD disk performance on a 4 core machine with 6GB of memory. I spent last week comparing the drive to a standard 10K RPM SATA Raptor drive (EXT3 file system right now). As … Continue reading →

Posted in hardware, linux, mysql, performance | 3 Comments

DBT2 MySQL SSD Results

Posted on February 2, 2008 by Matthew Yonkovit

Ran DBT2 with the following: [root@localhost scripts]# ./run_workload.sh -s100 -c 16 -w 20 -t 32 -d 1200 -n Here are the results ( This beats a lot of other benchmarks I have seen with 8 core machines & regular disk … Continue reading →

Posted in mysql, performance | Comments Off

Mtron SSD Sysbench/MySQL results ( preview ) …

Posted on February 2, 2008 by Matthew Yonkovit

This week I have been doing a great deal of testing with SSD to determine the feasibility of using SSD in a MySQL production system. I will be working on a complete write up, but I thought I would tantalize … Continue reading →

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

dbt2

Posted on February 2, 2008 by Matthew Yonkovit

Well I am trying to use dbt2 to test some ssd drives.  This is my first time trying to use the tool, and I am not impressed.  Their seems to be a general lack of documentation out there, on top … Continue reading →

Posted in mysql, performance, rant | Comments Off