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