Slow Performance using MariaDB on Windows

[Nick-B]

Hi @kamilweb and @kasik

I just wanted to mention something that another one of our users @jim_hubbard shared in a similar thread over here related to MariaDB performance issues in case this helps.

Local is painfully slow

Here are some performance tips from the team at MariaDB - https://mariadb.com/kb/en/configuring-mariadb-for-optimal-performance/

[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?

[Nick-B]

Hey @OlivierM! We already have a bug for this here:

Slow Performance using MariaDB on Windows

What issue or error are you experiencing? Slow loading pure WP pages, about 2-4 seconds TTFB. What steps can be taken to replicate the issue? Feel free to include screenshots, videos, etc Xdebug is off, changing PHP config from this topi didn’t help: Optimizing Local "Lightning" performance on Windows 10 [obraz] System Details Local Version: Version 8.3.2+6660 Operating System (OS) and OS version: Windows 11 Pro 23H2 Local Logs Attach your Local Logs here (Help Doc - Retrieving Local’s …

I’ll merge your post into that one. For now, something that might help is this comment from another user dealing with the issue previously:

Local is painfully slow

Here are some performance tips from the team at MariaDB - https://mariadb.com/kb/en/configuring-mariadb-for-optimal-performance/