SQL database self-inflating

bugless · 2018-12-03 17:56:39

Using Centos 7.5.

Database seems to be "self-inflating" by itself.
I mean, 6 months ago I made a backup with mysqldump, file was 70 Mb large. GLPI data has remained totally untouched since then -yes, I'm sure-, though server has remained certainly powered on, obviously. Few days ago I was asked for another backup, so I did mysqldump again, and this time file was 150 Mb large!?

I have no auto-inventory installed; no OCS nor Fusion nor the like.

Could anyone help with this by chance?
Thanks.

makeijan · 2018-12-04 18:37:30

Which ones are the biggest tables?
They might be log ones.
You'll need to configure some purging to avoid them growing too much.

bugless · 2018-12-05 01:34:36

In the mysql console I used

show table status from <glpi_database>;

I could only judge by number of rows, and some of the "bigger" tables were
glpi_crontasks (rows = 31)
glpi_crontasklogs (rows = 2308310)
glpi_events (rows = 1130)
glpi_logs (rows = 1197)

I also searched for those tables that could potentially be changing by themselves on daily basis, loosely guessing (I may be wrong, I know...) that all those "updated" today could be the ones changing *daily*. Tables updated today I only found:
glpi_computers
glpi_crontasks
glpi_crontasklogs
(Why would computers table be changing by itself!?)

Just as a vague guess, the crontasklogs table could look kinda big...
Do these details tell you something?

makeijan · 2018-12-05 02:06:30

Well, glpi_crontasklogs could be keeped under control if automatic actions had reasonable purge limits.

I don't think glpi_computers had any issues. Search for the ones been updated yesterday and history will tell you what was the las edit on each of them.

bugless · 2018-12-05 03:46:37

Your post did not help at all.
It's rather seem like you wanted to look pretentious with random words.

I'll try to be more direct.
I'm starting to suspect glpi_crontasklogs. Anyone else could agree, or is willing to help?
If so, how could I purge this table, both manually and automatically?

I just confirmed sql backup file with mysqldump gets bigger everyday just by itself; this is not longer a "I think/I guess". And it's a real problem for me.

yllen · 2018-12-05 14:57:24

If you have automatic actions running in CLI mode, they are launched even if you have no actions in GLPI.
So glpi_crontasklogs will grow in time

Forum GLPI-Project

Announcement

#1 2018-12-03 17:56:39

SQL database self-inflating

#2 2018-12-04 18:37:30

Re: SQL database self-inflating

#3 2018-12-05 01:34:36

Re: SQL database self-inflating

#4 2018-12-05 02:06:30

Re: SQL database self-inflating

#5 2018-12-05 03:46:37

Re: SQL database self-inflating

#6 2018-12-05 14:57:24

Re: SQL database self-inflating

Board footer