asanchez75/mysql repository overview

[mysqld]
skip-host-cache
skip-name-resolve

# * Fine Tuning
#
key_buffer      = 256M
sort_buffer_size        = 1M
max_allowed_packet  = 256M
thread_stack        = 192K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover         = BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_type = 1
query_cache_limit   = 2048M
query_cache_size        = 6144M


# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem

innodb_buffer_pool_size = 6G
innodb_log_file_size = 64M
innodb_flush_log_at_trx_commit = 0
innodb_thread_concurrency=8
transaction-isolation=READ-COMMITTED
innodb_flush_method=O_DIRECT
innodb_stats_on_metadata=0