From owner-freebsd-performance@FreeBSD.ORG Sat Nov 11 18:37:08 2006 Return-Path: X-Original-To: freebsd-performance@freebsd.org Delivered-To: freebsd-performance@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 226FE16A407 for ; Sat, 11 Nov 2006 18:37:08 +0000 (UTC) (envelope-from amarat@ksu.ru) Received: from zealot.ksu.ru (zealot.ksu.ru [194.85.245.161]) by mx1.FreeBSD.org (Postfix) with ESMTP id 318B443D5A for ; Sat, 11 Nov 2006 18:37:05 +0000 (GMT) (envelope-from amarat@ksu.ru) Received: from [127.0.0.1] (localhost.lnet [127.0.0.1]) by zealot.ksu.ru (8.13.8/8.13.8) with ESMTP id kABIax82034579 for ; Sat, 11 Nov 2006 21:36:59 +0300 (MSK) (envelope-from amarat@ksu.ru) Message-ID: <4556184B.3090604@ksu.ru> Date: Sat, 11 Nov 2006 21:36:59 +0300 From: "Marat N.Afanasyev" User-Agent: Mozilla/5.0 (X11; U; FreeBSD amd64; en-US; rv:1.7.13) Gecko/20060514 X-Accept-Language: ru, en MIME-Version: 1.0 To: freebsd-performance@freebsd.org Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Mailman-Approved-At: Sun, 12 Nov 2006 05:12:35 +0000 Subject: trouble with mysql replica and 3ware 9590 RAID controller X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 11 Nov 2006 18:37:08 -0000 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