Databases

MariaDB 11 and MySQL 8 as a performance foundation

CMS and shops rely on the database. Current engine, application compatibility, indexes, sensible queries and cache decide how fast the panel, cart and product page work.

The database can be a bottleneck

In large shops and CMS systems, response time often depends on SQL queries, indexes, option tables, logs and plugins.

Migration requires compatibility checks

Before changing engine versions, application, plugin, encoding and query compatibility should be checked.

Cache reduces database load

Redis, Memcached, OPcache and page cache reduce database queries, but they do not fix bad queries or plugin overload.

Technical references