IPS Cloud hosting may be a good idea if you don't want to be involved in this way with the administration of your server.
That said, you can learn about MySQL OPTIMIZE TABLE here:
https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html
This is not something that IPS does for you (nor would you want it to).
Other database maintenance statements are outlined here: https://dev.mysql.com/doc/refman/8.0/en/table-maintenance-statements.html
You can find scheduled tasks by searching for "Tasks" in ACP.