From owner-freebsd-questions@freebsd.org  Fri Jun  8 11:42:57 2018
Return-Path: <owner-freebsd-questions@freebsd.org>
Delivered-To: freebsd-questions@mailman.ysv.freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1])
 by mailman.ysv.freebsd.org (Postfix) with ESMTP id 0AE1010188AF
 for <freebsd-questions@mailman.ysv.freebsd.org>;
 Fri,  8 Jun 2018 11:42:57 +0000 (UTC)
 (envelope-from chris@cretaforce.gr)
Received: from smtp2.cretaforce.gr (smtp2.cretaforce.gr [195.201.125.11])
 (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
 (Client CN "*.cretaforce.gr", Issuer "RapidSSL RSA CA 2018" (verified OK))
 by mx1.freebsd.org (Postfix) with ESMTPS id 8DB717EEE4
 for <freebsd-questions@freebsd.org>; Fri,  8 Jun 2018 11:42:56 +0000 (UTC)
 (envelope-from chris@cretaforce.gr)
Received: from server1.cretaforce.gr (server1.cretaforce.gr [138.201.248.69])
 by smtp2.cretaforce.gr (Postfix) with ESMTP id 8F3C73E905
 for <freebsd-questions@freebsd.org>; Fri,  8 Jun 2018 14:42:53 +0300 (EEST)
Received: from [192.168.2.3] (athedsl-4449129.home.otenet.gr [79.129.211.89])
 (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256
 bits)) (Client did not present a certificate)
 (Authenticated sender: chris@cretaforce.gr)
 by server1.cretaforce.gr (Postfix) with ESMTPSA id 61E032732E
 for <freebsd-questions@freebsd.org>; Fri,  8 Jun 2018 14:42:53 +0300 (EEST)
From: Christos Chatzaras <chris@cretaforce.gr>
Content-Type: text/plain;
	charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (Mac OS X Mail 11.3 \(3445.6.18\))
Subject: Re: Toshiba disk low performance 
Date: Fri, 8 Jun 2018 14:42:52 +0300
References: <DC4343C3-AC15-427E-9653-4C6A7F4E34C4@cretaforce.gr>
 <20180607171933.6b4babd094f4d056da797cf5@sohara.org>
 <5D96200B-649B-4851-9FC6-F56F3188326B@cretaforce.gr>
 <d9a93323-cb2c-d7eb-ed5d-657d162c0614@qeng-ho.org>
To: FreeBSD <freebsd-questions@freebsd.org>
In-Reply-To: <d9a93323-cb2c-d7eb-ed5d-657d162c0614@qeng-ho.org>
Message-Id: <18DD35BD-0DA5-4186-9633-F9270744F9AD@cretaforce.gr>
X-Mailer: Apple Mail (2.3445.6.18)
X-CretaForce-MailScanner-Information: Please contact the ISP for more
 information
X-CretaForce-MailScanner-ID: 8F3C73E905.AEC30
X-CretaForce-MailScanner: Found to be clean
X-CretaForce-MailScanner-From: chris@cretaforce.gr
X-Spam-Status: No
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.26
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <https://lists.freebsd.org/mailman/options/freebsd-questions>, 
 <mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions/>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <https://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
 <mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 08 Jun 2018 11:42:57 -0000

I did some benchmarks and the problem exist in both Linux and FreeBSD.

I benchmark a server with Toshiba disks and a server with Seagate disks.

First I install debian without RAID-1. Then I install iozone.

Tests done with hdparm to test disk bandwidth and iozone to test random =
read/writes.

Here are the results:

https://hastebin.com/gayidosaju.pas

As you can see the bandwidth for the Toshiba disks is slower than =
Seagate but this doesn't really matter.

The problem is the second test that does random read/writes which show =
the Toshiba has 10 times slower random write speed than the Seagate.

That's why the issue happens mostly during a "mysql import" and not =
other server tasks.