Hi,

From https://github.com/WordPress/wordpress-develop/commit/fed98bd9ef9a232d102c41e74944d3c21cd6183e 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