#
# This group is read both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# include *.cnf from the config directory
#
!includedir /etc/my.cnf.d

[mysqld]
log-error="/var/lib/mysql/cpamg06.err"
performance-schema=0
unix_socket=OFF
plugin-load-add=auth_socket.so

skip-external-locking
max_allowed_packet=268435456
# Try number of CPU's x 2 for thread_concurrency
innodb_thread_concurrency = 8

default_storage_engine = InnoDB
innodb_buffer_pool_size=134217728
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 0
innodb_flush_method = O_DIRECT
innodb_log_file_size=50331648

interactive_timeout=28800
wait_timeout=28800
connect_timeout=20
open_files_limit=40000
tmp_table_size=16777216
join_buffer_size=262144
max_heap_table_size=16777216