# Slow Performance using MariaDB on Windows

**URL:** <https://community.localwp.com/t/slow-performance-using-mariadb-on-windows/42141>\
**Category:** Resolved\
**Created:** [March 28, 2024, 3:10pm UTC](https://community.localwp.com/t/slow-performance-using-mariadb-on-windows/42141 "2024-03-28T15:10:23Z")\
**Posts on this page:** 8\
**Page:** 2

<div class="post-metadata">

**Author:** ![Nick-B](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/nick-b/32/16140_2.png) [@Nick-B](https://community.localwp.com/u/Nick-B)\
**Post date:** [May 8, 2024, 12:57pm UTC](https://community.localwp.com/t/slow-performance-using-mariadb-on-windows/42141/22 "2024-05-08T12:57:53Z")

</div>

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](https://community.localwp.com/t/local-is-painfully-slow/41777/6):
>
> Here are some performance tips from the team at MariaDB - [https://mariadb.com/kb/en/configuring-mariadb-for-optimal-performance/](https://mariadb.com/kb/en/configuring-mariadb-for-optimal-performance/)

---

<div class="post-metadata">

**Author:** ![system](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/system/32/1_2.png) [@system](https://community.localwp.com/u/system)\
**Post date:** [August 6, 2024, 12:58pm UTC](https://community.localwp.com/t/slow-performance-using-mariadb-on-windows/42141/23 "2024-08-06T12:58:28Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.

---

<div class="post-metadata">

**Author:** ![Nick-B](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/nick-b/32/16140_2.png) [@Nick-B](https://community.localwp.com/u/Nick-B)\
**Post date:** [September 17, 2024, 1:29pm UTC](https://community.localwp.com/t/slow-performance-using-mariadb-on-windows/42141/24 "2024-09-17T13:29:46Z")

</div>



---

<div class="post-metadata">

**Author:** ![OlivierM](https://avatars.discourse-cdn.com/v4/letter/o/edb3f5/32.png) [@OlivierM](https://community.localwp.com/u/OlivierM)\
**Post date:** [October 7, 2024, 9:03pm UTC](https://community.localwp.com/t/slow-performance-using-mariadb-on-windows/42141/25 "2024-10-07T21:03:19Z")

</div>

I have exactly the same problem as in this post :

> [@Using MariaDB add 2 seconds per request to load standard WP install](https://community.localwp.com/t/using-mariadb-add-2-seconds-per-request-to-load-standard-wp-install/36558):
>
> 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.](https://github.com/Rarst/laps))  
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?

---

<div class="post-metadata">

**Author:** ![Nick-B](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/nick-b/32/16140_2.png) [@Nick-B](https://community.localwp.com/u/Nick-B)\
**Post date:** [October 8, 2024, 1:25pm UTC](https://community.localwp.com/t/slow-performance-using-mariadb-on-windows/42141/26 "2024-10-08T13:25:07Z")

</div>

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

> [@Slow Performance using MariaDB on Windows](https://community.localwp.com/t/slow-performance-using-mariadb-on-windows/42141):
>
> 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](https://community.localwp.com/t/optimizing-local-lightning-performance-on-windows-10/18040)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 …](https://localwp.com/help-docs/troubleshooting/retrieving-locals-log-file/)

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](https://community.localwp.com/t/local-is-painfully-slow/41777/6):
>
> Here are some performance tips from the team at MariaDB - [https://mariadb.com/kb/en/configuring-mariadb-for-optimal-performance/](https://mariadb.com/kb/en/configuring-mariadb-for-optimal-performance/)

---

<div class="post-metadata">

**Author:** ![tsmz](https://avatars.discourse-cdn.com/v4/letter/t/dec6dc/32.png) [@tsmz](https://community.localwp.com/u/tsmz)\
**Post date:** [July 16, 2025, 6:26pm UTC](https://community.localwp.com/t/slow-performance-using-mariadb-on-windows/42141/27 "2025-07-16T18:26:01Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Nick-B](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/nick-b/32/16140_2.png) [@Nick-B](https://community.localwp.com/u/Nick-B)\
**Post date:** [July 21, 2025, 1:02pm UTC](https://community.localwp.com/t/slow-performance-using-mariadb-on-windows/42141/28 "2025-07-21T13:02:06Z")

</div>

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](https://community.localwp.com/t/slow-performance-using-mariadb-on-windows/42141/22):
>
> 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.

---

<div class="post-metadata">

**Author:** ![nickc](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/nickc/32/21209_2.png) [@nickc](https://community.localwp.com/u/nickc)\
**Post date:** [July 29, 2026, 5:20pm UTC](https://community.localwp.com/t/slow-performance-using-mariadb-on-windows/42141/29 "2026-07-29T17:20:20Z")

</div>

**Local shipped MariaDB 10.11.18 together with a fix for the Windows performance issue today.**

You don’t need to update Local. Just choose MariaDB 10.11.18 from the “Custom” options when you create your next site:

 ![Download MariaDB 10.11.18 in Local](https://us1.discourse-cdn.com/flex019/uploads/lwpforums/original/3X/4/6/4696a64d8494e89512ad5653ec7855c54e9ff947.png)

You should find that load times are much faster (no more 2-second waits for each request to finish).

* * *

If you have an existing site on an older version of MariaDB, you can try fixing the performance issue by:

1. Editing the site’s `wp-config.php` in your text editor:

2. Change this line:

3. Save the file and restart your site in Local. You should find MariaDB database performance is greatly improved.

**You do not need to modify your `wp-config.php` if you are using the newer MariaDB 10.11.18 or higher. That workaround is only for sites on older MariaDB versions.**

[Previous page](https://community.localwp.com/t/slow-performance-using-mariadb-on-windows/42141.md?page=1)
