Improve performance of interactions that involve the database (authoring, processing popularity, etc)

Move what we can outside the database altogether

Disable database logging; use syslog instead

drupal 9 move caching tables out of mysql database

Caching (cache bins) to Memcache - https://www.drupal.org/project/memcache - making cache tables unnecessary: https://git.drupalcode.org/project/memcache/-/blob/8.x-2.x/README.txt

Or to Redis with https://www.drupal.org/project/redis

General cleanup

https://www.drupal.org/project/db_maintenance

https://github.com/Releem/mysqlconfigurer