Skip to main content
wp-config.org

Server configuration

MariaDB config generator for WordPress

Use this MariaDB config generator to plan database memory, connections and durability for WordPress and WooCommerce on Ubuntu, then review and download your configuration. The settings are written as a separate .cnf file that MariaDB reads along with its main my.cnf, so your changes stay easy to find and undo.

  • Memory plan
  • InnoDB settings
  • Ubuntu commands

Free, no sign-up. It runs in your browser, so nothing you type is sent to this site.

Nothing you enter leaves your browser.

This tool runs in your browser and needs JavaScript. Turn JavaScript on and reload the page.

MariaDB

What you can do

  • Server memory and connection planning

  • InnoDB buffer pool and durability settings

  • Access control and optional TLS

  • Slow query logging and backup-related options

  • Ubuntu install commands and configuration downloads

How to configure MariaDB for WordPress

  1. Describe your server

    Select the Ubuntu release, MariaDB package source and the server resources you plan to use.

  2. Review the plan

    Check the memory allocations, maximum connections, durability, access and logging against your workload.

  3. Install with care

    Read the installation notes, back up your configuration and databases, and check the chosen options against the MariaDB version you install.

Size MariaDB around the whole server

This free MariaDB configuration generator helps you plan a database server for WordPress and WooCommerce on Ubuntu 24.04 LTS or 26.04 LTS. Its memory plan shows each allocation next to the connection limits, InnoDB settings and other options. You can change the starting profile to suit a shared application server or a dedicated database server.

Know the limits

A preset is a starting allocation, not a benchmark or a promise of more speed. PHP, Redis, the operating system and other services need their own memory. Durability, binary logging and backup options affect how well you can recover, so check them against your backup process before you change a live database. The generator does not connect to MariaDB or measure your queries.

Plan PHP-FPM workers and a Redis object cache for the same server, and put the database details in your wp-config.php.

Frequently asked questions

How large should innodb_buffer_pool_size be?

It depends on what else runs on the server. A dedicated database server can give it most of its memory, but when Nginx and PHP share the server it must be much smaller. The generator sizes it around the whole server.

Where is the MariaDB configuration on Ubuntu?

In /etc/mysql. Extra files go in /etc/mysql/mariadb.conf.d and are read in name order, which is why the generated file is called 60-wordpress.cnf.

How do I apply and check the changes?

Restart MariaDB with sudo systemctl restart mariadb, then confirm a value, for example with SHOW VARIABLES LIKE 'innodb_buffer_pool_size';

Will this work for MySQL?

It is written for MariaDB. Many InnoDB settings are similar, but names and defaults differ, so check each one against the MySQL documentation.

Related tools

  • wp-config.php

    Generate a wp-config.php with database settings, new salt keys and explained options.

  • PHP extensions

    Plan PHP extensions, PHP-FPM and OPcache settings for WordPress.

  • Redis

    Generate Redis settings for a WordPress object cache, with matching wp-config.php options.

Host WordPress on StackMattic

StackMattic sponsors these free tools. If you would rather not set up and look after the server yourself, StackMattic runs managed WordPress and server hosting.