trouble with mysql replica and 3ware 9590 RAID controller
Marat N.Afanasyev
amarat at ksu.ru
Sat Nov 11 18:37:08 UTC 2006
Hello!
I've encountered a trouble with very low performance of mysql replica on
9590SE controller. as replica, mysql performs only updates and no
selects at all, but I cannot be satisfied by performance of this
replica, because of 100% busy of disk array with about 3-4 MBytes/s
activity, e.g. iostat -x:
extended device statistics
device r/s w/s kr/s kw/s wait svc_t %b
da0 55.5 78.9 928.1 2047.6 1 108.0 98
and more sadly, disk wait time increases sometimes to 300 seconds and more.
I've made NCQ on, changed strategy to perfom, but nothing helps. If I
stop mysql, then I can write about 30-40 MBytes per second to this array
(raid 1)
And I should say that this replica worked just fine on slackware with p3
866 and IDE disks.
Mysql version is 4.0.27, twa firmware is 3.04.01.010
--
SY, Marat
More information about the freebsd-performance
mailing list