On 26/02/2020 22:34, Andrew Watkins wrote:
Hello,
I am new to Bacula, but I am slowing getting it working. I am using
Bacula 9.4.4 on Solaris and a remote MySQL server as the back end.
I have a couple of problem but will start with just the one for now.
"SD despooling Attributes" is taking forever for a full backup. I come
from using Networker software so am I expect to much?
First of all - have you tuned your MySQL instance? It is notorious for
being useless out of the box.
I spent some time getting MySQL to do the right things on Solaris over a
few years, last time I updated various bits I switched to PostgreSQL,
and things got a lot faster. (Note I build our own versions of MySQL
and PostgreSQL, I don't like the choices that Sun/Oracle made when
building them.)
Grab a copy of
<https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl>
and go to town.
If that doesn't point out anything obvious - other than something like,
"You are on a 4Gb machine, and I would really like 16G," post the output
and we can have a go at it.
I've run both local and remote MySQL and PostgreSQL DB for Bacula on
Solaris, and have noticed no real difference - except obvious ones like
running on a system with more RAM and faster disks and so on.
Secondly, Solaris MySQL has a threadsafe client library, it's
libmysqlclient_r.so, I thought that configure had finally been hammered
enough to pick this up, perhaps I was munging things to use it? Too
long ago now, and I'm over-used to hand-zapping stuff to get it to do
what I want.
Cheers,
Gary B-)
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
