Public bug reported:
on Ubuntu 16.10, using :
bacula-common-mysql 7.4.3+dfsg-1+sid1build1
mysql-server-5.7 5.7.17-0ubuntu0.16.10.1
some requests are very slow, in particular those used for building the file
list when restoring.
these requests usualy take less than 1sec. but are taking up to 5mn on the same
tables.
this is due to the mysql 5.7 new optimizer_switch "derived_merge".
setting it to off solves the issue.
** Affects: bacula (Ubuntu)
Importance: Undecided
Status: New
** Tags: mysql-server-5.7
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1671027
Title:
Bacula is slow with mysql 5.7
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/bacula/+bug/1671027/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
