I've set logrotate and garbagecollection to weekly and it seemed to work fine until I moved to a VPS server a few weeks ago.

Now it happens that during the weekly cronjobs the server load is extreme high (due to mysql). This period of high server load lasts quite long, maybe even longer than the cronjobs take to finish. Ever since the move to the new server there is not only one table created due to the logrotate but always several new tables.

Now I'm wondering if this is normal or not. For the last weeks there were alsways 4 or 5 new tables and only one of them had entries. But today there were 13 (!) new tables after the cronjob and two of them contained all log entries that were cleaned up while the other 11 had 0 entries.

I'm wondering if something goes wrong here, i.e. either the many tables only get created because the cronjobs can't be finished at once due to the high server load or the high server load is only the result of something going wrong with the cronjobs.

Today I've restarted mysql as I was not even able to drop the tables for some reason. So maybe the mysql server hangs after the logrotate/garbagecollection cronjobs and only works again after a restart. Has anyone had similar issues? Any idea what to do?

Also, are the cronjobs for example for minute, 5min, 15min necessary if there are no plugins using these slots?