File: //etc/my.cnf
#
# 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/ip7.ip-144-217-195.net.err
performance-schema=0
innodb_buffer_pool_size=134217728
max_allowed_packet=268435456
open_files_limit=67000
innodb_file_per_table=1
unix_socket=OFF
innodb_file_per_table = 1
performance-schema = 0
max_allowed_packet = 512M
#open_files_limit=58000
join_buffer_size = 2024K
tmp_table_size = 1024M
query_cache_size = 100M
max_connections = 200
innodb_buffer_pool_size = 48M
log-error = "/var/log/mysql-error.log"
key_buffer_size = 120M
innodb_write_io_threads = 8
innodb_flush_log_at_trx_commit = 0
query_cache_type = 1
sql_mode = NO_ENGINE_SUBSTITUTION
wait_timeout = 700
plugin-load-add=auth_socket.so