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/

[tsmz]

I have a localwp install on a decent notebook on Windows 11.
Using the default .local domain and the latest MariaDB in the installed options, 3.5s to display admin pages were the norm, some up to 6s. I did a little research, and turns out, using the latest mySQL instead of the latest MariaDB will about cut that in half. Using another domain than .local (.abc) in this case, will cut that in half again. I now have admin pages loading under 1s on the same system, using the same software as before.

There’s good reasons for alternative settings. But the defaults should be chosen in a way that people can get the most out of the software. It doesn’t cost anything either.

[Nick-B]

Hey @tsmz! I’ve merged your post into this current bug for Slow Performance using MariaDB on Windows so you can vote, comment or follow along.

Some users have also found workarounds helpful such as this:

Slow Performance using MariaDB on Windows

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.