Re: [Bacula-users] Why it takes so much to "Building directory tree"

You should look out when copying an innodb_buffer_pool_size from a webpage or 
so, the best value for that setting depends too much on local conditions, esp. 
available RAM, database size, and what else is running (and needing memory) on 
the same server.

In general, the higher the setting, the better, but you have to take care not 
to take so much that other components suffer from it.
And of course, setting it higher than your database size is useless, but I 
don't think that will be an issue with Bacula (my bacula db is 11 GB).


I think it's a good approach to log on to the server while backups are running 
and examine the output of the 'free' command a number of times, if possible 
under different circumstances (while clients are being backed up, while the 
director is being backed up, while the MySQL database itself is being dumped, 
while a restore is running, etc.).


If you see that 'free' reports a lot of free memory all of the time, allocate 
part of that for database use by adding it to innodb_buffer_pool_size.
If you experience problems or slow behavior later, check it again. If it is 
reporting low memory then (or especially swap space use of more than a few MB), 
decrease innodb_buffer_pool_size to free some up.


Even better is setting up Munin (or similar) to monitor your Bacula machine and 
examine the memory use graphs.


-----Original Message-----
From: f-otake AT kinryokai DOT net [mailto:f-otake AT kinryokai DOT net] 
Sent: 05 July 2015 1:17
To: Bacula-users AT lists.sourceforge DOT net
Subject: Re: [Bacula-users] Why it takes so much to "Building directory tree"

Many thanks for Heitor Faria(Mr./Ms.) and Randoslaw
Koreniewski(Mr./Ms)
Mysql DB was MyISAM therefore changed to InnoDB.
and also inserted few lines as suggested on http://bacula.us/tuning/
as follows
     sort_buffer_size = 2MB
     innodb_buffer_pool_size = 128MB
     innodb_flush_log_at_trx_commit = 0
     innodb_flush_method = O_DIRECT
then "Bulding directory tree" finish almost immidiatly.
FYI following case take only less than 30seconds
+-------+-------+----------+---------------+---------------------+------------+
| JobId | Level | JobFiles | JobBytes      | StartTime           |
VolumeName |
+-------+-------+----------+---------------+---------------------+------------+
|     4 | F     |  258,441 | 2,262,481,683 | 2015-07-02 14:32:50 |
Vol-0004   |
|    14 | I     |      158 |    79,623,411 | 2015-07-03 04:32:49 |
Vol-0014   |
+-------+-------+----------+---------------+---------------------+------------+
Thanks again for the help.
F.Otake



------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users