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]
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