write performance problem with LSI Logic SAS1068
Having a bit of a problem with our web 2.0 startup.
Were using Ubuntu Server edition (on one of our DB boxes) its an HP DL145 G3 box with a
LSI Logic SAS1068 integrated controller.
Problem is our hosting providers are now saying they wont support
ubuntu server (fiesty).
Issue is - I have really really poor write performance using the above set-up our project pretty much demands good write performance. (our el cheapo dell box here is acheiving in excess of processing 200 products per second - in contrast the Dell is only able to do 20/30) -- we've done a lot of code optimisation / mysql tweakage and im happy that side of things is pretty nailed.
From lspci
02:01.0 SCSI storage controller: LSI Logic / Symbios Logic SAS1068 PCI-X Fusion-MPT SAS
I've tried a bunch of things , enabling write cacheing with sdparm and lsiutil -
Im not convinced this has neccesarily worked though.
because i get errors when i try to check ...
sdparm -6 -vv --get=WCE /dev/sda
mp_settings: page,subpage=
[0x8,0x0] pdt=0 start_byte=0x2 start_bit=2 num_bits=1 val=0 acronym: WCE
inquiry cdb: 12 00 00 00 24 00
/dev/sda: LSILOGIC Logical Volume 3000
Request Sense cmd: 03 00 00 00 40 00
request sense: requested 64 bytes but got 20 bytes
mode sense (6) cdb: 1a 00 08 00 08 00
sg_get_
WCE error in Caching (SBC) mode page
When I try to set write cacheing in lsiutil - it seems to think it has been successful.
with sdparm i get this.
sdparm -6 -vv --set WCE=1 /dev/sda
mp_settings: page,subpage=
pdt=0 start_byte=0x2 start_bit=2 num_bits=1 val=1 acronym: WCE
inquiry cdb: 12 00 00 00 24 00
/dev/sda: LSILOGIC Logical Volume 3000
Request Sense cmd: 03 00 00 00 40 00
request sense: requested 64 bytes but got 20 bytes
mode sense (6) cdb: 1a 00 08 00 04 00
mode sense (6) cdb: 1a 00 08 00 04 00
change_mode_page: page offset failed: given response length too small, offset=12 given_len=4 bd_len=8
.
Having done a bit of research over the past few days im leading in the direction of thinking that
updating the kernel driver might be an idea
lsmod | grep mpt
mptctl 26116 0
mptsas 28040 3
mptscsih 25344 1 mptsas
mptbase 53344 3 mptctl,
scsi_transport_sas 29568 1 mptsas
scsi_mod 142220 7 megaraid_
I've managed to get hold of the driver source code from LSI and compile it successfully/
however im really reluctant to try this on a production server and landing myself a hefty support charge.
Im wondering if anyone can shed any light onto this really frustrating problem. Or if there is a
supported reliable way to fix it ? Id rather not stray too far away from the official ubuntu package manager at this time.
Is this problem fixed in Gutsy (we are on feisty) and would moving to 64bit version help?
Kind Regards
Nick ...
Question information
- Language:
- English Edit question
- Status:
- Answered
- For:
- Ubuntu Edit question
- Assignee:
- No assignee Edit question
- Last query:
- Last reply:
Can you help with this problem?
Provide an answer of your own, or ask nicholas fellows for more information if necessary.