Mailinglist Archive: opensuse (1470 mails)

< Previous Next >
Re: [opensuse] Why Is Leap 42.1 Benchmarking Poorly?
  • From: Vojtěch Zeisek <vojtech.zeisek@xxxxxxxxxxxx>
  • Date: Thu, 25 Feb 2016 12:28:17 +0100
  • Message-id: <10711664.4o8Cg6bIxU@veles>
Dne Čt 25. února 2016 12:06:48, Per Jessen napsal(a):
Vojtěch Zeisek wrote:
Dne Čt 25. února 2016 11:06:16, Per Jessen napsal(a):
Carlos E. R. wrote:
On 2016-02-25 10:52, Per Jessen wrote:
Carlos E. R. wrote:
That's not the default for system databases.

What's a "system database" ? Leap uses mysql/mariadb by default, but
the tests were done with postgres.

It it by default in /var/lib/pgsql on separate Btrfs subvolume.

I have no idea what kind of performance to expect with butterfs, but
it's an interesting question. The article seemed keen to point out
the /home was on XFS, and that tests were run from there.

Copy-on-write is terribly slowing down any DB. Also snapshots don't make sense
for DB (use DB's tools). Maybe there are more problematic points. That is why
Btrfs is the worst for any DB. And that's why oS has special subvolumes for
default Btrfs locations where those nice features are turned off. Btrfs then
shouldn't have *significantly* different performance than any other common FS.
Similarly, as Btrfs snapshoting is not good for quickly changing directories,
there are (oS default) subvolumes for directories like /tmp. Activedoc is
currently inaccessible (error 503, maintenance), so see details here
https://www.suse.com/documentation/sles-12/stor_admin/data/sec_filesystems_major.html

--
Vojtěch Zeisek

Komunita openSUSE GNU/Linuxu
Community of the openSUSE GNU/Linux

https://www.opensuse.org/
https://trapa.cz/
< Previous Next >