MariaDB configuration file example
You can use the MariaDB configuration file (my.cnf) to configure MariaDB for your system.
The following example of the my.cnf file contains the minimum resource configuration that was tested for runtime metrics collection. For more information about modifying your my.cnf file, see Configuring MariaDB with my.cnf. For a full list of the MariaDB server system variables, see server system variables.
If you want to capture results over long periods of time by using real-time runtime metrics collection, disable or limit the size of the MariaDB binary log.
The MariaDB binary log records all updates to the database in a set of files on your hard drive. If the MariaDB binary log is not limited in size when collection is running and real-time runtime metrics collection is analyzing name-value pair collection results, the log will eventually consume all hard drive space in your Linux® environment and cause various components to fail.
In the following example, the MariaDB binary log is set as inactive because the real-time runtime metrics collection is highly transient and abundant. For more information about the MariaDB binary log, see Overview of the Binary Log.
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
back_log = 50
max_connections = 100
wait_timeout = 256
max_connect_errors = 10
table_open_cache = 2048
max_allowed_packet = 16M
max_heap_table_size = 512M
read_buffer_size = 64M
read_rnd_buffer_size = 64M
sort_buffer_size = 64M
join_buffer_size = 64M
thread_cache_size = 8
thread_concurrency = 8
thread_stack = 240K
query_cache_size = 128M
query_cache_limit = 2M
ft_min_word_len = 4
default-storage-engine = InnoDB
transaction_isolation = REPEATABLE-READ
tmp_table_size = 512M
slow_query_log
long_query_time = 2
server-id = 1
# INNODB options
innodb_buffer_pool_size = 4G 1
innodb_buffer_pool_instances = 8
innodb_data_file_path = ibdata1:10M:autoextend
innodb_write_io_threads = 8
innodb_read_io_threads = 8
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit = 1
innodb_log_buffer_size = 1GB
innodb_change_buffering = all
innodb_change_buffer_max_size = 25
innodb_log_file_size = 125M
innodb_log_files_in_group = 2
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 256
innodb_file_per_table
default_time_zone = +00:00
[mysqldump]
quick
max_allowed_packet = 50M
[mysql]
no-auto-rehash
[mysqlhotcopy]
interactive-timeout
[mysqld_safe]
open-files-limit = 8192- If the tape approaches 500 MB in size, Linux requires 8 GB of memory to process the tape. Set
innodb_buffer_pool_size = 7Gand restart MariaDB.