Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 16 Aug 2016 15:14:05 +0200
From:      rainer@ultra-secure.de
To:        =?UTF-8?Q?Roger_Pau_Monn=C3=A9?= <roger.pau@citrix.com>
Cc:        freebsd-xen@freebsd.org
Subject:   Re: Is it me or is FreeBSD slower on Xen than Linux?
Message-ID:  <c3a3a7da26cd1a6a114c03e823926272@ultra-secure.de>
In-Reply-To: <20160816110759.6xlvxikw3tziahfd@mac>
References:  <b0fdde5d7abf905ca6dfd176f028332e@ultra-secure.de> <20160816085455.46a5slqsbgauod5t@mac> <2a0a5ae2821551935de329b8665834be@ultra-secure.de> <20160816100605.la63x2ju5bmtdqhl@mac> <e62d4e94ec36fa859783ddc0aeb1aa28@ultra-secure.de> <20160816110759.6xlvxikw3tziahfd@mac>

next in thread | previous in thread | raw e-mail | index | archive | help
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)....









Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?c3a3a7da26cd1a6a114c03e823926272>