Skip to main content
Question

var/lib/mysql growing 5GB per week

  • 24 May 2024
  • 2 replies
  • 38 views

Hi at all,

the volume var/lib/mysql growing 5GB per week. I gave it more space two weeks ago, from 60GB to120GB. This is the graph in 4 months:

 

 

Two weeks ago the volume filled up, this caused the db logs table to be deleted. I recreated the table, but now it’s not partitioned. 

So, I have two question:

 

  • Why the var/lib/mysql volume growing so quickly? 
  • Is it a problem if the logs table is not partitioned?

 

I'm waiting for a response, thank you very much!!

 

2 replies

Userlevel 6
Badge +20

HI @Kalos the growth depend of the number of resources you monitor, the number of events per resources, the number of actions per resources, etc.

You must partition this table in order to purge old data with the associate Centreon cron.

 

Userlevel 5
Badge +11

Hi @Kalos,
Did you manage to find a solution to your issue? If so, feel free to share how you did it; it will help someone with the same problem find a solution easily.
Thank you,

Reply