Hello,
Thank you for contacting Rank Math and bringing your concern to our attention. I’m sorry for any inconvenience this issue may have caused you.
The best way to reduce the size of the database if you are using the Analytics module is to reduce the number of days that you keep the data in the plugin.
To do that, you can reduce the number of days under WordPress Dashboard > Rank Math > General Settings > Analytics and then follow the steps here to delete the old data and import new ones: https://rankmath.com/kb/delete-old-analytics-data/
You can also reduce the size by purging the ActionScheduler database with all the completed actions which serve no purpose other than as a history log.
For that you can use the following plugin: https://wordpress.org/plugins/cleanup-action-scheduler/
Hope that helps.
Thank you.
Hello,
Since we did not hear back from you for 15 days, we are assuming that you found the solution. We are closing this support ticket.
If you still need assistance or any other help, please feel free to open a new support ticket, and we will be more than happy to assist.
Thank you.