Database growing 50MB a day

I noticed a few days ago while backing up my database that it is growing by about 50mb per day.
So I checked what tables it is, and it seems to be the jobs que that is growing so much.

I checked the scheduler and it says it is running successfully, but obviously its not.

How would one fix this, can I just drop all the entries in that table, or will it break the scheduler?

Hi @Daniel4
This Blog is helping to database tips and trick.

You can drop all rows from job_queue with status=done, older than a month. This I am sure will not harm your server.

1 Like

You might also want to consider using before save hooks instead of Workflow for tasks that happen on save. I did the same thing once, trying to synch fields between modules and my DB grew to over 2GB with just people opening and saving records.

1 Like

It would more useful and less spammy if you link to the exact tip that answers this user’s question, or, if you don’t have the answer, don’t link…