Slow Performance using MariaDB on Windows

[nickc]

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:

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:

   define( 'DB_HOST', 'localhost' );
   

   To this instead:

   define( 'DB_HOST', '127.0.0.1' );
   

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.