Hi @expressweldcare
Maybe there are two causes. You have a lot of archives and plugins, and a conflict with another plugin is causing an unnecessary duplication of archive options.
I say that because a length of 445938 would not be justified even with a lot of archives and plugins.
Moreover, if you say that it happened overnight, it means something strange happened. It can’t be only the number of archives and plugins.
Anyway, you can probaly solving by doing so:
- Make a backup of the database (if you have enough space on the server)
- Go to Freesoul Deactivate Plugins => Experiments
- Check “Check this if you want to save the Archives and Terms Archives settings in the filesystem…”
- Digit FYLESYSTEM to conform
- Click on “Yes, I’m sure”
After doing that the size of eos_dp_archives will go to 0 bytes. The options will be distributed in the filesystem and removed from the database. They will be many very tiny files.
The size of each file will be practically zero, and it will be called only when the URL matches with the archive related to that file.
It’s important you make a backup of the database because it’s not normal you have a length of 445938 for eos_dp_archives.
However, i’m not sure eos_dp_archives is the only cause of the enormous size of the database. A length of 445938 doesn’t justify 9.8 Gb. You probably have also other problems somewhere else.
I hope it helps.
Please, let me know if you still need help.
Have a great day!
Jose
