Hey Eric, thanks to reply. Sorry, I said that the table has a about a million lines... but it has more then 156 million lines.
So, I did a query at table Log and it has information about the first log (LogId = 1, JobId = 1). It indicates that no maintenance was done yet. What do you suggest? The Bacula is configured do a prune at expired volumes everyday after complete all backups. Thanks! ________________________________ De: Eric Bollengier via Bacula-users <bacula-users@lists.sourceforge.net> Enviado: quarta-feira, 4 de agosto de 2021 11:56 Para: bacula-users@lists.sourceforge.net <bacula-users@lists.sourceforge.net> Assunto: Re: [Bacula-users] Log table so big Hello, On 8/4/21 15:37, Guilherme Santos wrote: > Hello! > First, thanks to suport. > > I'm using Bacula for a consider time and my Log table is about 19GB. > What's the best solution to "solve" this? This table has more than a million > lines. I'm using Bacula 9.4.4. > 19GB for 1,000,000 records is a lot, you might double check if you run the database maintenance tools properly. Then, I would suggest to have a look to the table content, the last time I saw this problem, a couple of runscripts were generating 95% of the content of the table. If you list the files you backup or something like that in the Messages resource, it can be also very verbose, but you can configure what you want to see or not. A regular job is probably around 20 lines, if you have more than 50,000 jobs in your Job table, it might be normal as well. You can prune your Jobs or also not use the catalog as a Messages destination. Hope it helps! Best Regards, Eric _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.sourceforge.net%2Flists%2Flistinfo%2Fbacula-users&data=04%7C01%7C%7Cbd2ba41655f3418114d108d957586d06%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637636859560124722%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=0pOncDsiNNtAnfqcAuNV%2FtZhCAEJNN%2Fe9L9q8XalOkw%3D&reserved=0
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
