Mysql database table optimization :: File table taking space

[Anuroop Prakash]

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]#
=============

[Shawn Taylor]

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

--
--
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 bareos-users...@googlegroups.com.
To post to this group, send email to bareos...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Anuroop Prakash]

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

[Shawn Taylor]

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

[Anuroop Prakash]

Thanks Sawn,
Let me check it , appritiate your response .