On 2/27/20 12:09 PM, Gary R. Schmidt wrote:
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.
Thanks folks, for all the good information and I am looking through
MySQL improvements, but in the end it was my error.
I had presumed I was using BATCH_INSERTS and I was using the correct
MySQL client libraries.
Anyway, because Oracle Solaris 11.4 doesn't ship a libmysqlclient_r.so
well to be honest MySQL doesn't use it any longer. Bacula build only
looks for libmysqlclient_r.so it was not building it correctly.
The only way I fixed it was putting a symbolic link in to point to
libmysqlclient.so (/usr/mysql/5.7/lib/libmysqlclient_r.so ->
amd64/libmysqlclient.so)
After that all worked fine and SD despooling Attributes was much quicker..
# egrep "HAVE_MYSQL_THREAD_SAFE|USE_BATCH_FILE_INSERT" src/config.h
#define HAVE_MYSQL_THREAD_SAFE 1
#define USE_BATCH_FILE_INSERT 1
I have added a bug report https://bugs.bacula.org/view.php?id=2520
gmaike failes due to libmysqlclient_r.a: No such file or directory
Thanks for now..
Andrew
--
Andrew Watkins * Birkbeck, University of London * Computer Science *
* http://notallmicrosoft.blogspot.com *
* tel: 020 7631 6720 *
::e-mails are only read & actioned between 0900 and 1730 hours (Monday - Friday)
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
