https://www.bareos.org/en/news/bareos-17-2-published-348.html
Based on that post it looks like 17.2 introduced a denormalized file table to improve performance. If you backup a lot of unique files this table might grow unrestricted. But that article says it only tracks a file once. You’ll need to watch the table growth,but if it’s a new server it might have grown quickly in the first month as you added clients. Then the growth should be limited to new files on those clients which should be pretty small I assume. I am new to Bareos so take all of this with a grain of salt and make sure my assumptions are correct. Shawn On Thu, Dec 27, 2018 at 7:10 AM Anuroop Prakash < [email protected]> wrote: > On Thursday, December 27, 2018 at 5:15:12 PM UTC+5:30, Shawn Taylor wrote: > > You can put a delete statement in a cron to achieve the pruning, but > then you’ll lose that data. > > > > > > > > Why is the size of the table a problem? > > > > > > > > Shawn > > > > > > > > > > > > On Thu, Dec 27, 2018 at 12:43 AM Anuroop Prakash < > [email protected]> wrote: > > I am using MySQL as the database for my BareOS but day by day my > ibdata starts growing. I have enabled "innodb_file_per_table=1" in my.cnf > to identify which table is utilizing space and found that the table "File" > is taking space. Its around 21 Gb. > > > > > > > > > > > > Could anyone help in this? I don't know why this table "File" is taking > this much space? Is there any way to auto prune or recycle bareos > database/tables. > > > > > > > > It would be helpful if anyone can help me in this. Thanks in advance > > > > > > > > > > > > ============= > > > > [root@bareosvm bareos]# du -sch File.ibd > > > > 21G File.ibd > > > > 21G total > > > > [root@bareosvm bareos]# > > > > ============= > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > -- > > > > CONFIDENTIALITY NOTICE: This e-mail and any attachments hereto are > > > > intended only for use by the addressee(s) named herein and may contain > > > > legally privileged and/or confidential information. If you are not the > > > > intended recipient of this e-mail, you are hereby notified that any > > > > dissemination, distribution or copying of this e-mail, and any > attachments > > > > thereto, is strictly prohibited. If you have received this e-mail in > error, > > > > please notify the sender by replying to this message and permanently > delete > > > > the original and any copy of this e-mail and any printout thereof. > > > > > > > > -- > > > > You received this message because you are subscribed to the Google > Groups "bareos-users" group. > > > > To unsubscribe from this group and stop receiving emails from it, send > an email to [email protected]. > > > > To post to this group, send email to [email protected]. > > > > For more options, visit https://groups.google.com/d/optout. > > Hi Shawn, > Thanks for your response. > I can't delete those datas. > > Why is the size of the table a problem? > > I have partitioned my drives and within a month the "File" tables grows to > 21 GB its growing day by day according to the backup jobs currently I am > running incremental backups daily and a full backup weekly if this > continues next month my database will be at least 50gb size :( > > Is there a way to prune and recycle the database/table like we are doing > for storage pools/volumes. > > And do you know the reason behind the growth of this particular "File" > table > > > > -- > -- > CONFIDENTIALITY NOTICE: This e-mail and any attachments hereto are > intended only for use by the addressee(s) named herein and may contain > legally privileged and/or confidential information. If you are not the > intended recipient of this e-mail, you are hereby notified that any > dissemination, distribution or copying of this e-mail, and any attachments > thereto, is strictly prohibited. If you have received this e-mail in > error, > please notify the sender by replying to this message and permanently > delete > the original and any copy of this e-mail and any printout thereof. > > -- > You received this message because you are subscribed to the Google Groups > "bareos-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
