2016-04-22 09:08:32 +02:00
|
|
|
---
|
2022-09-10 17:09:12 +02:00
|
|
|
# ansible.builtin.file: roles/mariadb/defaults/main.yml
|
2016-04-22 09:08:32 +02:00
|
|
|
#
|
|
|
|
|
# Based on my running of mysqltuner.pl on a host with three WordPress databases
|
|
|
|
|
#
|
|
|
|
|
|
|
|
|
|
# default is 128MB but is a waste because it seems only the mysql table uses it
|
2020-12-29 09:58:12 +01:00
|
|
|
key_buffer_size: 8M
|
2016-04-22 09:08:32 +02:00
|
|
|
|
|
|
|
|
# default is 128MB but is a waste because it seems only information_schema uses
|
|
|
|
|
# AriaDB, see: https://mariadb.com/kb/en/mariadb/aria-system-variables
|
|
|
|
|
aria_pagecache_buffer_size: 8M
|
|
|
|
|
|
|
|
|
|
# default is 128M, but set to at least the size of your InnoDB data
|
|
|
|
|
innodb_buffer_pool_size: 256M
|
|
|
|
|
|
2019-07-23 16:26:23 +02:00
|
|
|
# Ansible 2.7.x with PyMySQL seems to default to TCP connection so we should
|
|
|
|
|
# force it to use a Unix socket.
|
|
|
|
|
# See: https://github.com/ansible/ansible/issues/47736
|
2021-09-08 14:50:48 +02:00
|
|
|
mariadb_login_unix_socket: /run/mysqld/mysqld.sock
|
2019-07-23 16:26:23 +02:00
|
|
|
|
2016-04-22 09:08:32 +02:00
|
|
|
# default is 100 but the max I've seen used is 5, so let's reduce it
|
|
|
|
|
max_connections: 33
|
|
|
|
|
|
2020-12-29 10:07:33 +01:00
|
|
|
# disable the query cache by default
|
|
|
|
|
query_cache_size: 0
|
|
|
|
|
query_cache_type: 0
|
|
|
|
|
|
2020-12-29 10:10:31 +01:00
|
|
|
# mysqltuner says we should use larger than 32M on our setup
|
|
|
|
|
tmp_table_size: 64M
|
|
|
|
|
max_heap_table_size: 64M
|
|
|
|
|
|
2016-04-22 09:08:32 +02:00
|
|
|
# vim: set ts=2 sw=2:
|
