#
# 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/server.uttaco.com.err
performance-schema=0
innodb_file_per_table=1
max_allowed_packet=268435456
unix_socket=OFF

#skip-name-resolve
join_buffer_size = 512K
tmp_table_size = 256M
max_heap_table_size = 256M
table_definition_cache = 5800
performance_schema=ON
key_buffer_size = 8K
innodb_buffer_pool_size = 4G
innodb_log_file_size = 1G
table_open_cache = 2048

slow_query_log = 1
slow-query_log_file = /var/lib/mysql/slow.log
long_query_time = 10
plugin-load-add=auth_socket.so

max_connections = 512