#
# 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/atali.colombiahosting.com.co.err
#max_user_connections = 150
#max_connections = 150
log-error=/var/log/mysqld.log
#bind-address = 127.0.0.1
thread_cache_size = 50
table_open_cache = 4000
table_definition_cache = 2000
open_files_limit=80000

innodb_buffer_pool_size = 60G
#innodb_buffer_pool_instances = 8
innodb_log_file_size = 1G
innodb_log_buffer_size = 64M
innodb_flush_log_at_trx_commit = 2
innodb_file_per_table = 1
innodb_flush_method = O_DSYNC
innodb_io_capacity = 2000

performance_schema = OFF
tmp_table_size = 64M
max_heap_table_size = 64M
join_buffer_size = 4M
sort_buffer_size = 4M
read_rnd_buffer_size = 2M
wait_timeout = 300
interactive_timeout = 300
# log_warnings = 2
#log_slow_query=1
log_slow_query=1
#log_slow_query_file="/var/log/mariadb-slow.log"
log_slow_query_time=2
sql_mode=""
max_allowed_packet=268435456
unix_socket=OFF