
Hi all, Glad to see that MariaDB has now surpassed MySQL in WordPress usage stats at https://wordpress.org/about/stats/ Version Usage MySQL 8.0 20.77% MariaDB 10.6 19.88% MariaDB 10.11 18.60% MySQL 5.7 17.78% MySQL 5.5 7.03% MariaDB 10.5 6.77% MariaDB 10.3 2.74% MySQL 5.6 1.99% MariaDB 11.4 1.27% MariaDB 10.4 1.07% MariaDB 5.5 0.46% MariaDB 10.1 0.43% MariaDB 10.2 0.32% MySQL 5.1 0.17% MySQL 8.4 0.14% I haven't verified this myself, but I heard that MySQL 8.4 deprecated SQL_CALC_FOUND_ROWS which is heavily used in the WordPress code base, and thus the MySQL 8.4 adoption is nearly zero. Good reminder to have collaboration and joint testing with some of the largest open source projects to avoid accidentally having a new MariaDB version being incompatible with them..

Hi, From https://github.com/WordPress/wordpress-develop/commit/fed98bd9ef9a232d102c41... the version started being reported correctly which means it probably was and is more dominate that reported, but seeing it is a good improvement. Yes - SQL_CALC_FOUND_ROWS - https://core.trac.wordpress.org/ticket/47280 - still open. If anyone has PHP skills/interest in helping complete https://core.trac.wordpress.org/ticket/58871 would be welcome previous WIP: https://github.com/grooverdan/wordpress-develop/commits/uca1400_v2/ On Mon, 5 May 2025 at 01:18, Otto Kekäläinen via developers < developers@lists.mariadb.org> wrote:
Hi all,
Glad to see that MariaDB has now surpassed MySQL in WordPress usage stats at https://wordpress.org/about/stats/
Version Usage MySQL 8.0 20.77% MariaDB 10.6 19.88% MariaDB 10.11 18.60% MySQL 5.7 17.78% MySQL 5.5 7.03% MariaDB 10.5 6.77% MariaDB 10.3 2.74% MySQL 5.6 1.99% MariaDB 11.4 1.27% MariaDB 10.4 1.07% MariaDB 5.5 0.46% MariaDB 10.1 0.43% MariaDB 10.2 0.32% MySQL 5.1 0.17% MySQL 8.4 0.14%
I haven't verified this myself, but I heard that MySQL 8.4 deprecated SQL_CALC_FOUND_ROWS which is heavily used in the WordPress code base, and thus the MySQL 8.4 adoption is nearly zero.
Good reminder to have collaboration and joint testing with some of the largest open source projects to avoid accidentally having a new MariaDB version being incompatible with them.. _______________________________________________ developers mailing list -- developers@lists.mariadb.org To unsubscribe send an email to developers-leave@lists.mariadb.org

This seems important so let's highlight it: https://core.trac.wordpress.org/ticket/58871: support uca14.0.0 collation in database where available to improve WordPress-MariaDB compatibility Do we have anyone from Automattic on this list who could help? They are at least still listed as a sponsor of the MariaDB Foundation
participants (2)
-
Daniel Black
-
Otto Kekäläinen