Start of change

MySQL configuration file example

You can use the MySQL configuration file (my.cnf) to configure MySQL 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 Specifying Program Options.

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 MySQL binary log.

The MySQL binary log records all updates to the database in a set of files on your hard drive. If the MySQL 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 MySQL binary log is set as inactive because the real-time runtime metrics collection is highly transient and abundant. For more information about the MySQL binary log, see 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_stack = 240K


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
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

# ## Changes for MySQL vs MariaDB
performance_schema = off
skip-log-bin

[mysqldump]
quick
max_allowed_packet = 50M

[mysql]
no-auto-rehash

[mysqlhotcopy]
interactive-timeout

[mysqld_safe]
open-files-limit = 8192
End of change