Re: [Bacula-users] Tuning for large (millions of files) backups?
2010-11-09 06:26:28
On 08/11/10 22:21, Gavin McCullagh wrote:
>
> Right you are....
>
> http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_sql_results_from_mysql_catalog
>
> There is still an element of "move to postgresql" though
>
With good reason. I did resist moving to pgsql for quite a while but it
does work better.
> We seem to have the correct indexes on the file table. I've run
optimize table
> and it still takes 14 minutes to build the tree on one of our bigger clients.
> We have 51 million entries in the file table.
>
Add individual indexes for Fileid, Jobid and Pathid
Postgres will work with the combined index for individual table queries, but
mysql won't.
AB
------------------------------------------------------------------------------
The Next 800 Companies to Lead America's Growth: New Video Whitepaper
David G. Thomson, author of the best-selling book "Blueprint to a
Billion" shares his insights and actions to help propel your
business during the next growth cycle. Listen Now!
http://p.sf.net/sfu/SAP-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
|
|