Plik jest wczytywany z katalogu
/var/db/mysql/ dla wersji < 5.7.x
/usr/local/etc/mysql/ dla wersji >= 5.7.x
Konfiguracja przedstawia się następująco:
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld_safe]
socket = /tmp/mysql.sock
#nice = 5
# --- definicje dla mySQL daemon -----------------------------------
#
[mysqld]
user = mysql
socket = /tmp/mysql.sock
port = 3306
tmpdir = /var/tmp/mysql
###language = /usr/local/share/mysql/english
lc-messages-dir = /usr/local/share/mysql
back_log = 50
skip-external-locking
skip-innodb_doublewrite
ft_min_word_len = 3
character_set_filesystem = binary
character_set_server = utf8
bind-address = 127.0.0.1
skip-name-resolve
log-queries-not-using-indexes = 1
slow_query_log = 1
long_query_time = 3
slow_query_log_file = /var/log/mysql/slow-queries.log
max_connections = 390
wait_timeout = 150
interactive_timeout = 300
innodb_file_per_table = 1
default-storage-engine = innodb
innodb_data_file_path=ibdata1:512M;ibdata2:512M;ibdata3:256M:autoextend
innodb_log_group_home_dir=logs/
innodb_data_home_dir = ibdata/
innodb_buffer_pool_size = 512M
innodb_autoextend_increment = 128
innodb_thread_concurrency=16
innodb_log_buffer_size=8M
innodb_additional_mem_pool_size=128M
innodb_flush_log_at_trx_commit=1
innodb_autoinc_lock_mode=0
innodb_write_io_threads = 8
innodb_read_io_threads = 8
innodb-log-file-size = 512M
innodb-flush-method = O_DIRECT
innodb-doublewrite = FALSE
max_allowed_packet = 2M
max_heap_table_size = 1024M
key_buffer_size = 512M
read_buffer_size = 2M
read_rnd_buffer_size = 2M
sort_buffer_size = 8M
join_buffer_size = 16M
myisam_sort_buffer_size = 64M
thread_stack = 512K
thread_cache_size = 8
thread_concurrency = 16
query_cache_type = 1
query_cache_size = 64M
query_cache_limit = 64M
tmp_table_size = 512M
table_cache = 32K
table_definition_cache = 32K
read_rnd_buffer_size = 8M
query_cache_min_res_unit = 2K
thread_concurrency=16
#read_buffer_size = 4M
#innodb_log_file_size=1024M
#key_buffer = 8M
#key_buffer_size = 64M
#sort_buffer_size = 128M
#join_buffer_size = 128M
#query_cache_wlock_invalidate = 1
#delay_key_write = ALL
[mysqldump]
quick
quote-names
max_allowed_packet = 64M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 32M
[myisamchk]
ft_min_word_len=3
Więcej przykładów konfiguracji można znaleźć w katalogu /usr/local/share/mysql/ - pliki my-*.cnf.
Pozostałe sposoby
Inne sposoby są podane w linkach poniżej.