File: //etc/my.cnf
[mysqld]
socket = /var/lib/mysql/mysql.sock
datadir = /mnt/HC_Volume_101269084/mysql
log-error = /mnt/HC_Volume_101269084/mysql/ws4.angoweb.net.err
performance-schema=0
innodb_file_per_table=1
unix_socket=OFF
max_allowed_packet=268435456
#open_files_limit=80000
local-infile=0
bind-address=0.0.0.0
query_cache_size=65536M
query_cache_type=1
innodb_buffer_pool_size=204800M
innodb_log_file_size = 100M
max_connections = 40000
key_buffer_size =65536M
innodb_lock_wait_timeout = 200
event_scheduler = ON
lower_case_table_names = 1
open_files_limit = 152400
sql_mode = "ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
plugin-load-add=auth_socket.so
[Service]
limitnofile=102400
plugin-load-add=auth_socket.so
[Service]
limitnofile=102400