Re: [Bacula-users] Problem Restoration

[Philippe MULLER]

Christoph Haas a écrit : On Wednesday 26 October 2005 12:33, Philippe MULLER wrote: Christoph Haas a écrit : See if your "File" table has proper indices. Mine show this: mysql> show index from File; | File | 1 | JobId | 1 | JobId | Looks okay. How many entries in the database do you have? How large are the tables (especially the "File" table). mysql> SELECT count(*) FROM File; > +----------+ > | count(*) | > +----------+ > | 801 793 | > +----------+ mysql> select count (*) from Path; > +----------+ > | count(*) | > +----------+ > | 4 545 | > +----------+ How many files do you store how often? JobFiles : 101 746 JobBytes : 30 Go Run = Level=Full mon-fri at 02:00 Do you use proper retention so that older entries get thrown out? File Retention = 6 days Job Retention = 6 days Volume Retention = 6 days AutoPrune = yes Recycle = yes Philippe.