From owner-freebsd-xen@freebsd.org Tue Aug 16 13:14:15 2016 Return-Path: Delivered-To: freebsd-xen@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id E7E15BBB051 for ; Tue, 16 Aug 2016 13:14:15 +0000 (UTC) (envelope-from rainer@ultra-secure.de) Received: from connect.ultra-secure.de (connect.ultra-secure.de [88.198.71.201]) by mx1.freebsd.org (Postfix) with ESMTP id 4F5491BB4 for ; Tue, 16 Aug 2016 13:14:14 +0000 (UTC) (envelope-from rainer@ultra-secure.de) Received: (Haraka outbound); Tue, 16 Aug 2016 15:14:12 +0200 Authentication-Results: connect.ultra-secure.de; auth=pass (login); spf=none smtp.mailfrom=ultra-secure.de Received-SPF: None (connect.ultra-secure.de: domain of ultra-secure.de does not designate 127.0.0.10 as permitted sender) receiver=connect.ultra-secure.de; identity=mailfrom; client-ip=127.0.0.10; helo=connect.ultra-secure.de; envelope-from= Received: from connect.ultra-secure.de (webmail [127.0.0.10]) by connect.ultra-secure.de (Haraka/2.6.2-toaster) with ESMTPSA id 1938CEB6-342A-4A1A-9AEB-D744CFAD7202.1 envelope-from (authenticated bits=0) (version=TLSv1/SSLv3 cipher=AES256-SHA verify=NO); Tue, 16 Aug 2016 15:14:06 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Date: Tue, 16 Aug 2016 15:14:05 +0200 From: rainer@ultra-secure.de To: =?UTF-8?Q?Roger_Pau_Monn=C3=A9?= Cc: freebsd-xen@freebsd.org Subject: Re: Is it me or is FreeBSD slower on Xen than Linux? In-Reply-To: <20160816110759.6xlvxikw3tziahfd@mac> References: <20160816085455.46a5slqsbgauod5t@mac> <2a0a5ae2821551935de329b8665834be@ultra-secure.de> <20160816100605.la63x2ju5bmtdqhl@mac> <20160816110759.6xlvxikw3tziahfd@mac> Message-ID: X-Sender: rainer@ultra-secure.de User-Agent: Roundcube Webmail/1.2.0 X-Haraka-GeoIP: --, , NaNkm X-Haraka-GeoIP-Received: X-Haraka-p0f: os="undefined undefined" link_type="undefined" distance=undefined total_conn=undefined shared_ip=Y X-Spam-Checker-Version: SpamAssassin 3.4.1 (2015-04-28) on spamassassin X-Spam-Level: X-Spam-Status: No, score=-2.9 required=5.0 tests=ALL_TRUSTED,BAYES_00 autolearn=ham autolearn_force=no version=3.4.1 X-Haraka-Karma: score: 6, good: 17, bad: 0, connections: 17, history: 17, pass:all_good, relaying X-BeenThere: freebsd-xen@freebsd.org X-Mailman-Version: 2.1.22 Precedence: list List-Id: Discussion of the freebsd port to xen - implementation and usage List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 16 Aug 2016 13:14:16 -0000 Am 2016-08-16 13:08, schrieb Roger Pau Monné: > And FreeBSD on bare metal is equally fast as Linux then? (ie: the > slowdown > is only noticeable when running FreeBSD on Xen) Yes. I should clarify a bit more. The task involves 12000 (simple) MySQL-Queries, where the script basically selects the numbers 1...4000 from a table (it's stupid, I know) and then proceeds to run a for i in ... loop 4000 times which consists of three other sql-queries, where the WHERE-clause is constrained by the value from above. We've now found that indeed MariaDB is much faster on Xen-Linux than Xen-FreeBSD. The tables all use innodb and the DB is sitting on UFS (in the FreeBSD-on-Xen case, the FreeBSD-on-bare-metal has ZFS). Linux is using ext4. Could this really be an UFS vs. ext4 thing? I assume that optimizations in MariaDB 10.1 lead to less disk-activity. I haven't had a chance to try MariaDB on Linux on bare-metal (we don't really have one where I could test this ATM). > If you can provide me with some way to synthesize this workload that > doesn't > involve setting up the full stack plus your app I can try to reproduce > it > locally and analyze it in order to find the bottlenecks. It's a bit of a pain to setup (mariadb, php-fpm, nginx). Also, you need some files from another framework (apparently)....