In my extensive search for the tech-stack that suits WordPress best, MariaDB showed significant performance increases among it’s competitors. …but will it work in the WordPress ecosystem? First thing to check when testing a new database engine with WordPress is compatibility. WordPress officially supports only MySQL, though there are some database layer-abstraction techniques which are too complex to execute to be offering any performance increases. MariaDB, on the other hand, is 100% compatible with MySQL. All the goodies that increase performance and offer new features are tucked under the hood of the familiar MySQL. Compatibility – check! Caching Unlike MySQL, MariaDB comes with query caching on by default. What this means is that every query that is being sent to the database engine is first looked up in the cache to see if the user can get what he wants without even running a query on the database. Performance increases on a WordPress site, which always has a much larger number of database reads than writes, are significant. Subquery caching Another form of caching which MariaDB offers is subquery caching. If we have two queries run one after another: Query 1: SELECT COUNT(*) FROM
Share This