Bacula is slow with mysql 5.7
Bug #1671027 reported by
Jolan
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| bacula (Ubuntu) |
New
|
Undecided
|
Unassigned | ||
| mysql-5.7 (Ubuntu) |
New
|
Undecided
|
Unassigned | ||
Bug Description
on Ubuntu 16.10, using :
bacula-common-mysql 7.4.3+dfsg-
mysql-server-5.7 5.7.17-
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.
To post a comment you must log in.
