Monthly Archives: February 2008

Final Mtron SSD, MySQL, MFT Benchmarks and more!

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?

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

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

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 on More XFS Fun on Centos 5 with MySQL

XFS & Centos 5 & MySQL Performance

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 on XFS & Centos 5 & MySQL Performance

XFS, Centos 5, & IBM ServeRAID 8k Card

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 on XFS, Centos 5, & IBM ServeRAID 8k Card

More Details on MySQL & SSD drive performance…

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

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 on DBT2 MySQL SSD Results

Mtron SSD Sysbench/MySQL results ( preview ) …

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 on Mtron SSD Sysbench/MySQL results ( preview ) …

dbt2

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