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. > -- 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.
