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?
You can drop all rows from job_queue with status=done, older than a month. This I am sure will not harm your server.
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.
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…
