Hi, 05.10.2007 16:19,, Gabriele Bulfon wrote:: > > Hi, I recently upgraded to Bacula 2.2.2 on my Solaris 10 installation to > benefit from the Batch insert feature.
You should upgrade to 2.2.4 - one rather serious bug is still present in 2.2.2. IIRC, of course. > I installed the mysql thread safe client libraries and built bacula. > The output of the build says "Batch Insert Enabled : yes". A good first start. > I don't see performance improvements, so I'm guessin if the software is > actually using bacth inserts. It is not necessarily the case that your setup is getting better performance with batch inserts. With lots and lots of files, preferably small ones, you'll get most of an improvement. > Reading the thread, I found someone saying that I should see some kind > of "batch..." table inside bacula tables when bacula is operating this > way and something is running. The batch table is a temporary table, and IIRC, in MySQL, these only exist for the session that created it. So you can not simply watch the catalog database for its creation. I'm not sure if it's possible to directly observe the existence of temporary tables, but either looking for related files in the temp directory MySQL uses might work, or watching MySQLs query log. > I don't see it. > Does it mean that my installation is not using batch inserts? > How do I know if it is or not? If it's configured to use batch tables, you'd rather see errors when the feature does NOT work. So I assume that, if configure states Bacula is configured to use batch inserts, and your jobs run ok, Bacula uses batch inserts. I don't know if the DIR can report back about the batch insert feature. > May I force it with sum runtime parameter? No, this is ./configure time only. Arno > Thanx > Gabriele. > > <http://www.sonicle.com> > Gabriele Bulfon - Sonicle S.r.l. > Tel +39 028246016 Int. 30 - Fax +39 028243880 > Via Felice Cavallotti 16 - 20089, Rozzano - Milano - ITALY > http://www.sonicle.com > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > > > ------------------------------------------------------------------------ > > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users -- Arno Lehmann IT-Service Lehmann www.its-lehmann.de ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
