Konfiguracja mySQL - my.cnf

/!\ Plik jest wczytywany z katalogu

  1. /var/db/mysql/ dla wersji < 5.7.x

  2. /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.