Preventing database lock problems
Mentions Memcache and Redis and recommends MariaDB over MySQL: https://www.valuebound.com/resources/blog/a-beginners-guide-to-performance-optimization-drupal-8
https://www.drupal.org/project/memcache
Oh and there’s also Memcache Storage module but it’s not had a release for Drupal 8 in four years!?
Oh but then we read that Redis is better: https://pantheon.io/blog/why-we-recommend-redis-drupal-or-wordpress-caching-backend
Oh but then David Strauss who worked on all that is saying not to use Memcached or Redis? But it’s not clear what we’re supposed to use? OK finally there’s a little blog post from Pantheon.
https://www.drupal.org/project/lcache
… and that hasn’t been worked on