On Tue, Aug 16, 2016 at 03:14:05PM +0200, rai...@ultra-secure.de wrote: > 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.
Hm, the fact that FreeBSD on bare metal is using ZFS could also make a difference. The ZFS memory caching is quite aggressive, and I expect it should speed up database queries (unless the database itself is fully loaded into RAM, in which case it doesn't matter much). > Could this really be an UFS vs. ext4 thing? Hm, maybe. There are a lot of moving pieces here that make it quite hard to diagnose the issue properly. Could you try to run something like UnixBench (or any other general benchmarking tool) inside of the Linux VM, the FreeBSD VM and a bare metal FreeBSD install? This way we might be able to spot what's causing this slowdown. Roger. _______________________________________________ firstname.lastname@example.org mailing list https://lists.freebsd.org/mailman/listinfo/freebsd-xen To unsubscribe, send any mail to "freebsd-xen-unsubscr...@freebsd.org"