Bacula is slow with mysql 5.7

Bug #1671027 reported by Jolan on 2017-03-08
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
bacula (Ubuntu)
Undecided
Unassigned
mysql-5.7 (Ubuntu)
Undecided
Unassigned

Bug Description

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.

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers