Public Repository

Last pushed: 7 months ago
Short Description
MariaDB 10.1 with minimal low resource friendly my.cnf
Full Description

This image is meant for low computing resource scenarios in which running the standard default configuration of MariaDB/MySQL is too heavy. For example, when RAM is limited. In this version among other settings innodb_buffer_pool_size is set to 5m instead of the default 128m. I got my configuration from http://www.tocker.ca/2014/03/10/configuring-mysql-to-use-minimal-memory.html

docker run --name some-mariadb-min -e MYSQL_ROOT_PASSWORD=my-secret-pw -d m0rph/mariadb-min

my.cnf:

[client-server]
[client]

#The MariaDB server
[mysqld]
innodb_buffer_pool_size=5M
innodb_log_buffer_size=256K
query_cache_size=0
max_connections=10
key_buffer_size=8
thread_cache_size=0
host_cache_size=0
innodb_ft_cache_size=1600000
innodb_ft_total_cache_size=32000000

#per thread or per operation settings
thread_stack=131072
sort_buffer_size=32K
read_buffer_size=8200
read_rnd_buffer_size=8200
max_heap_table_size=16K
tmp_table_size=1K
bulk_insert_buffer_size=0
join_buffer_size=128
net_buffer_length=1K
innodb_sort_buffer_size=64K

#settings that relate to the binary log (if enabled)
binlog_cache_size=4K
binlog_stmt_cache_size=4K

Dockerfile

FROM mariadb:latest
COPY ./my.cnf /etc/mysql/my.cnf
CMD ["mysqld"]

Docker Pull Command
Owner
m0rph

Comments (0)