Housekeeping syslog very slow

Hi there,

I enabled the syslog server about a month ago, and added 10 different hosts that dump their syslogs here...  I quickly ran into space issues and added more space to the server because of this... I thought I had setup the housekeeping script, but I forgot to add the "s" option, so the syslogs were never purged... (I have setup 7 days in the config file)

Now another thing I noticed, was that mysql had created many binlog files (logfiles I guess) which I had to purge first and actually they where the main issue in regards to taking up space..  I have since disabled this logging.

But I still have a 70GB syslog.idb mysql file which I would like to purge down to 7 days.

When I run the housekeeping script, after awhile it asks me if I want to purge 80477997 syslog entries to which I agreed... then it just sits there for like 12 hours now...

The mysql processes is running at 200% so I guess something is "working", yet there is no updates in the housekeeping log... ?

Am I doing something wrong here?

Now the database files are not on a seperate drive, but everything is on enterprise SSDs.

The system is running Ubuntu 20.04, as a virtual VM in VMWare. (4 vCPUS, 16GB Memory, 300GB SSD)

The VM isn't doing much... using about 3GB of memory and using about 50% CPU and not much disk IO...

The Ubuntu nore mysql has been optimized in anyway and is pretty much stock.

So I am a bit confused as to what is going on?  And maybe I'm doing something wrong here?