Clean a huge database

Hello 🙂

We have a very big database, thousands of tables and a few hundreds of gigabytes in size, it’s time for a cleanup and this plugin looks like the best options!

But, I am concerned with the load. I am testing the plugin now on a much smaller staging site, and for example on the setting page all the tables are displayed, this can cause a timeout on our live server. And after we start the optimization, I am not sure what will happen with all this tables to work on ..

Any recommendation on how to handle our situation ?

If not, i have a suggestion :
We are using wordpress multisite, so all tables have the site ID number after the prefix (like wp_32_options for site ID = 32). How can we modify the plugin to only clean the tables that ARE checked in the settings AND modify the code to display only the tables from site ID = X to site ID = Y.

This way, we can display in the setting a reduced number of tables, for example only 10 sites (and avoid a timeout)–> check all –> clean only this 10 sites. And do this several time with the next 10 sites to clean the whole database.
No need to use the scheduler feature.

Thank you for your help!