White scenery @showyou, hatena

If you have any comments, you may also send twitter @shsub or @showyou.

サーバ(ML115)にSSD(Intel X25-M)をつけてみた

マシン
ML115 G5 AthlonX2BE 2350+ 6GB memory
OS
Ubuntu 8.04.3 x64
HDD
HGSTの7200rpm,250GBのやつ(型番忘れた)
SSD
Intel X25-M G2 80G(SSDSA2MH080G2R5)

下記データ見ればわかるけど、SSDはHDDの4倍程度のReadを性能持っている*1。速い。
さて無脳のDBの解析が早くなるかどうか見るか。

$ sudo hdparm -Tt /dev/sda

/dev/sda:
Timing cached reads: 1708 MB in 2.00 seconds = 854.50 MB/sec
Timing buffered disk reads: 148 MB in 3.02 seconds = 48.95 MB/sec

$ sudo hdparm -Tt /dev/sdb

/dev/sdb:
Timing cached reads: 1798 MB in 2.00 seconds = 899.18 MB/sec
Timing buffered disk reads: 646 MB in 3.00 seconds = 215.12 MB/sec

$ sudo hdparm -Tt /dev/sda

/dev/sda:
Timing cached reads: 1820 MB in 2.00 seconds = 909.88 MB/sec
Timing buffered disk reads: 166 MB in 3.03 seconds = 54.78 MB/sec

$ sudo hdparm -Tt /dev/sdb

/dev/sdb:
Timing cached reads: 1660 MB in 2.00 seconds = 829.54 MB/sec
Timing buffered disk reads: 536 MB in 3.00 seconds = 178.41 MB/sec

$ sudo hdparm -Tt /dev/sda

/dev/sda:
Timing cached reads: 1682 MB in 2.00 seconds = 840.75 MB/sec
Timing buffered disk reads: 140 MB in 3.11 seconds = 44.98 MB/sec

$ sudo hdparm -Tt /dev/sdb

/dev/sdb:
Timing cached reads: 1762 MB in 2.00 seconds = 881.21 MB/sec
Timing buffered disk reads: 624 MB in 3.00 seconds = 207.79 MB/sec

*1:SSDが170-215MB/sec,HDDが45MB-54MB/sec