On 2020-02-26 06: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.
> For example the last tape write finished at 06:18:20 and 5hours later it > is still waiting... > On MySQL Server I can see the inserts happening... > > mysql> show processlist; > +-------+------------+--------------+----------+-------------+-------+---------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ > | Id | User | Host | db | Command | Time | > State | Info | > +-------+------------+--------------+----------+-------------+-------+---------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ > | 46212 | bacula | cronus:57598 | baculadb | Query | 0 | Sending > to client | INSERT INTO File > (FileIndex,JobId,PathId,FilenameId,LStat,MD5,DeltaSeq) VALUES > (2923256,15,469886,14 | > | 48920 | slave_user | apollo:56851 | NULL | Binlog Dump | 18402 | > Master has sent all binlog to slave; waiting for more updates | NULL | > | 51226 | root | localhost | NULL | Query | 0 | > starting | show > processlist | > +-------+------------+--------------+----------+-------------+-------+---------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ > 3 rows in set (0.00 sec) > > I think I have batch inserts on: > > src/config.h:#define USE_BATCH_FILE_INSERT 1 > > But, HAVE_MYSQL_THREAD_SAFE is not set, but not sure if this is a > problem. Solaris does not use libmysqlclient_r.a so I have to use > MYSQL_LIBS="-L/usr/mysql/5.7/lib/amd64 -lmysqlclient" > > src/config.h:/* #undef HAVE_MYSQL_THREAD_SAFE */ > > Any ideas? Andrew, Assuming you've managed to jump through all the correct hoops to get a correct 64-bit MySQL install on Solaris, this sounds like probably a tuning problem. MySQL's default configuration out of the box is really not well suited to any but the smallest tasks. What tuning have you done? I install Bacula without attribute spooling because I find it not to work well on MySQL. Yes, it can indeed take hours to insert all the attributes after a job. I remain unconvinced that attribute spooling against a properly tuned MySQL DB offers any net performance benefit. -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: +1.603.293.8485 Mobile: +1.603.998.6958 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
