>>>>> On Sun, 29 Jan 2006 16:41:20 -0500, Frank Sweetser <[EMAIL PROTECTED]> >>>>> said: > > I've noticed that one of the recurring questions, especially from new users, > is "how large" existing bacula installations are. This can encompas number > of clients being backed up, the amount of data, and how large the catalog > gets. > > To try and gather up some quantitative data on this, I hacked up a perl script > that extracts a few basic statistics out of the catalog. You can find the > script at > > http://paramount.ind.wpi.edu/wiki/doku.php?id=database_statistics > > Once some data starts coming in, I'll put together another site with the > results.
TotalBytes and TotalFiles don't work because the SchedTime is not unique and clients can have multiple filesets (which are not unique either). It also counts non-backups jobs (restore, verify). Maybe something this would be better (for TotalFiles): select sum(J1.JobFiles) from Job as J1 where J1.JobId in ( select J2.JobId from Job as J2 where J2.Name = J1.Name and J2.Type = 'B' and J2.Level = 'F' and J2.JobStatus = 'T' order by J2.SchedTime desc limit 1 ) __Martin ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
