summaryrefslogtreecommitdiffstats
path: root/projectroot/etc/mariadb/my.cnf
blob: da402c47a616abca244c213e7b64fbb1c79678e9 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
# MariaDB config file for small systems.
#
# This is for a system with little memory where MariaDB is only used
# from time to time and it's important that the mysqld daemon doesn't
# use much resources.

[mysqld]
# These are commonly set, remove the # and set as required.
#port = .....
#socket = .....

skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 240K

# we have a read-only filesystem with one persistent writeable area only
# so point to this single writeable location
datadir = /var/lib/mysql/data