From owner-freebsd-scsi@FreeBSD.ORG Tue Nov 18 02:32:50 2014 Return-Path: Delivered-To: freebsd-scsi@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id CB14CAD4 for ; Tue, 18 Nov 2014 02:32:50 +0000 (UTC) Received: from BLU004-OMC1S11.hotmail.com (blu004-omc1s11.hotmail.com [65.55.116.22]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-SHA384 (256/256 bits)) (Client CN "*.outlook.com", Issuer "MSIT Machine Auth CA 2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 851BDC13 for ; Tue, 18 Nov 2014 02:32:49 +0000 (UTC) Received: from BLU436-SMTP47 ([65.55.116.7]) by BLU004-OMC1S11.hotmail.com over TLS secured channel with Microsoft SMTPSVC(7.5.7601.22751); Mon, 17 Nov 2014 18:32:43 -0800 X-TMN: [kJnAdZ54rMbJksiYOHttbiwq2Ld3zOQg] X-Originating-Email: [moremore2@outlook.com] Message-ID: Date: Tue, 18 Nov 2014 10:32:38 +0800 From: k simon User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:31.0) Gecko/20100101 Thunderbird/31.2.0 MIME-Version: 1.0 To: freebsd-scsi@freebsd.org Subject: Fwd: Re: HDD slow down in heavy load References: <546AAF7F.7000409@outlook.com> In-Reply-To: <546AAF7F.7000409@outlook.com> X-Forwarded-Message-Id: <546AAF7F.7000409@outlook.com> Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 18 Nov 2014 02:32:42.0822 (UTC) FILETIME=[EE042E60:01D002D7] X-BeenThere: freebsd-scsi@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: SCSI subsystem List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 18 Nov 2014 02:32:50 -0000 Yes, you are right. Zabbix 1.8 postgres database design is ugly, when zabbix database do "housekeeping" means scan the fulltable again and again, the SQL query lost response and the tags dev_acive is full. Compred with FB\LINUX, I can't say DFBSD response immediately, but it can accomplish it in one minutes. And DFBSD have a feature named swapcache can speed up HDD, but I havn't test it. And I have changed the disk with a SSD yet, but I think FB can do somethings better. Simon