>>>>> On Mon, 3 Jul 2006 10:34:53 -0400, Bill Moran said: > > As many of you have, I've seen the discussions of performance issues > with very large filesets. > > I noticed this morning that bacula-web claims our primary Bacula server > has a total number of files of 302,000. I know this is wrong, because > our largest server alone has nearly a million. > > So I did a "select count(*) from file;" in the database and got > 10354446. > > So my first question is: is there any reason not to trust that I'm tracking > about 10 million files? (Assuming, of course that I run dbcheck often > enough that I don't have a lot of orphans)
Don't forget that the File table contains one line per file per backup. Use the "list jobs" command to see how many files were saved in each job. See also the query command to list the file names if that information has not been pruned. __Martin Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
