On Thursday, December 27, 2018 at 8:35:49 PM UTC+5:30, Shawn Taylor wrote: > 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.
Thanks Sawn, Let me check it , appritiate your response . -- -- 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.
