I am planning on running some tests on a SATA server with a 3ware 9000
series RAID card to see if there's a stripe size that performs better than
the current setting (which I don't recall at the moment, probably
whatever the max is). This will be RAID10 and our databases are either in
the 500Mb or 10G range (both data and index). Most of the queries use
proper indexing so there shouldn't be a need for full table scans.
This is on a FreeBSD 4.10 system and so far the SATA+RAID10 performance is
shitty compared to a single SCSI server. IO is constantly at or above the
below and the OS is noticably laggy (which even at twice the IO is not
noticable on a single SCSI disk):
tty da0 pass0 cpu
tin tout KB/t tps MB/s KB/t tps MB/s us ni sy in id
0 8 16.00 2320 36.25 0.00 0 0.00 1 7 5 2 85
0 61 18.38 148 2.65 0.00 0 0.00 0 9 4 2 86
0 59 21.03 157 3.23 0.00 0 0.00 0 8 3 1 88
0 60 22.38 151 3.31 0.00 0 0.00 0 13 2 1 84
0 60 19.95 152 2.97 0.00 0 0.00 0 11 1 1 88
0 59 22.04 186 4.01 0.00 0 0.00 0 10 2 2 86
0 60 17.07 133 2.21 0.00 0 0.00 0 21 7 2 71
0 60 21.86 192 4.10 0.00 0 0.00 0 2 1 2 95
0 60 18.88 149 2.74 0.00 0 0.00 0 5 3 2 91
0 59 19.63 161 3.09 0.00 0 0.00 0 5 0 1 94
What are other users experiences with setups like this (stripe size, OS
settings like sysctl, etc)? Is linux preferred, if so why?
Thanks!
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
