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.
