Monday Feb 23, 2009

Running Sysbench Benchmark on MySQL using Solid State Drives and ZFS

As a follow up to the previous Sysbench benchmark that ran on Solaris UFS (HTTP link pointer), we re-ran the benchmark using ZFS filesystem on the same setup and configuration.  Solaris ZFS does not allow the forcedirectio option as with UFS. We followed the “ZFS Best Practices Guide” recommendations. Namely, we limited the size of the Adaptive Replacement Cache (ARC) to 1GB, and we set the ZFS recordsize to 16K as it matches the Innodb page size. We used the same MySQL configuration file “my.cnf” that was used in the previous UFS test.

[Read More]

Tuesday Nov 04, 2008

Running Sysbench Benchmark on MySQL using Solid State Drives

Sun will soon introduce Solid State Drives (SSDs) to its lineup of systems. SSDs are bound to  change the dynamics of the IO subsystem. A traditional 15K rpm disk can do around 150 random IOs a second. However a single SSD should be able to do up to 30,000 random reads per second and consume a maximum of 3W, as rated by the manufacturer. In addition SSDs can provide faster access to the data (in the order of microseconds), while traditional hard disk drives (HDDs) have access time thousands time slower (in the order of milliseconds). [The test results in this blog were updated 2/23/09.]

[Read More]
About

blueprints

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today
Feeds