Slow Performance using MariaDB on Windows

[OlivierM]

I have exactly the same problem as in this post :

Using MariaDB add 2 seconds per request to load standard WP install

Using MariaDB instead of MySQL adds 2 seconds for each request When setting up a fresh new site, when choosing MariaDB for the DB, instead of MySQL, every request immediately is delayed by 2 seconds. I used the Laps plugin to pinpoint the delay to the “Core & MU Plugin load” Phase. With MySQL this phase typically is 10 or 20 ms, with MariaDB it becomes 2025 ms or thereabouts. Can it be this loading phase is hitting some timeout (of 2 sec) and then decides to move on? Thanks in advance, Ruud D…

Bug Summary

If you create a local wordpress site with MariaDB selected, your site has a 2 seconds time of response, for each access (on the backend or on the frontend)…

If you use Mysql, everything is very fast, less than 100 ms

Steps to reproduce

Create a fresh new local site 1, and choose MariaDB
Add a performance plugin (Laps for example : GitHub - Rarst/laps: Light WordPress profiler.)
Run your backend wordpress site : Laps shows 2 seconds of response each time you click on an item of the menu…

Create an another fresh new local site 2, and choose Mysql
Add the same performance plugin, and test the response time : very fast : less than 100ms !!!

Environment Info

Describe your environment.

• What Operating System are you using? Windows 11
• What versions of site software (Nginx, Apache, PHP, MySQL) is used? last version of local
• What version of Local is installed?