Big DBA Head!

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 you with some findings.

The system running the tests is built from NewEgg.com with the Drives supplied by Easy Computing Company. I am using a Q6600 Quad Core (2.4Ghz) with 6 GB of Ram, and 2 72GB 10K Rpm Raptor drives. These tests are done with 1 32GB mtron device. I tested with the onboard SATA controller and a generic super micro 8 port controller. I will be testing Easy’s Managed Flash Technology soon. The results shown here are not using Easy Computing’s MFT technology.

Random Read Test:

sysbench v0.4.8:  multi-threaded system evaluation benchmark

128 files, 163840Kb each, 20480Mb total
Creating files for the test...
sysbench v0.4.8:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 16

Extra file open flags: 0
128 files, 160Mb each
20Gb total file size
Block size 16Kb
Number of random requests for random IO: 10000
Read/Write ratio for combined random IO test: 1.50
Periodic FSYNC enabled, calling fsync() each 100 requests.
Calling fsync() at the end of test, Enabled.
Using synchronous I/O mode
Doing random read test
Threads started!
Done.

Operations performed:  10000 Read, 0 Write, 0 Other = 10000 Total
Read 156.25Mb  Written 0b  Total transferred 156.25Mb  (82.232Mb/sec)
5262.83 Requests/sec executed

Test execution summary:
total time:                          1.9001s
total number of events:              10000
total time taken by event execution: 30.3437
per-request statistics:
min:                            0.0000s
avg:                            0.0030s
max:                            1.4942s
approx.  95 percentile:         0.0003s

Threads fairness:
events (avg/stddev):           625.0000/155.03
execution time (avg/stddev):   1.8965/0.00

Random Write Test:

sysbench v0.4.8:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 16

Extra file open flags: 0
128 files, 160Mb each
20Gb total file size
Block size 16Kb
Number of random requests for random IO: 10000
Read/Write ratio for combined random IO test: 1.50
Periodic FSYNC enabled, calling fsync() each 100 requests.
Calling fsync() at the end of test, Enabled.
Using synchronous I/O mode
Doing random write test
Threads started!
Done.

Operations performed:  0 Read, 10001 Write, 12807 Other = 22808 Total
Read 0b  Written 156.27Mb  Total transferred 156.27Mb  (1.5602Mb/sec)
99.85 Requests/sec executed

Test execution summary:
total time:                          100.1575s
total number of events:              10001
total time taken by event execution: 226.8494
per-request statistics:
min:                            0.0000s
avg:                            0.0227s
max:                            1.9757s
approx.  95 percentile:         0.0882s

Threads fairness:
events (avg/stddev):           625.0625/70.29
execution time (avg/stddev):   14.1781/2.13

hardware, linux, mysql, performance RSS 2.0 trackback leave a response