---
title: "Mariadb : Ma configuration pour WordPress"
url: https://www.cyber-neurones.org/2025/11/mariadb-ma-configuration-pour-wordpress/
date: 2025-11-23
modified: 2026-07-07
author: "Frederic"
description: "Ma VM a 32 Go de RAM. Voici ma configuration : # cat /etc/mysql/mariadb.conf.d/50-server.cnf | grep -v \"#\" | grep -v \"^$\" [server] [mysqld] user = mysql pid-file = /run/mysqld/mysqld.pid..."
categories:
  - "Hébergement"
tags:
  - "mariadb"
word_count: 126
---

# Mariadb : Ma configuration pour WordPress

Ma VM a 32 Go de RAM.
Voici ma configuration :

# cat /etc/mysql/mariadb.conf.d/50-server.cnf | grep -v "#" | grep -v "^$"
[server]
[mysqld]
user = mysql
pid-file = /run/mysqld/mysqld.pid
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
lc-messages = en_US
skip-external-locking
skip-name-resolve=ON
performance_schema=ON
query_cache_limit = 1024K
query_cache_min_res_unit = 2k
slow-query-log = 1
slow-query-log-file = /var/lib/mysql/mysql-slow.log
bind-address = 127.0.0.1
key_buffer_size = 24M
max_connections = 200
expire_logs_days = 10
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
innodb_buffer_pool_size = 8G
innodb_buffer_pool_instances = 8
innodb_log_file_size = 2G
innodb_log_buffer_size = 256M
thread_cache_size = 16
query_cache_size = 0
query_cache_type = 0
tmp_table_size = 1024M
max_heap_table_size = 1024M
table_open_cache = 4096
table_definition_cache = 4096
join_buffer_size = 16M
slow_query_log = 1
slow_query_log_file = /var/log/mysql/mysql-slow.log
long_query_time = 2
[embedded]
[mariadb]
[mariadb-10.5]