.-.-.-.-.-

#
# 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/77-42-6-175.cprapid.com.err

performance-schema=0

max_allowed_packet=256M
open_files_limit=41000

innodb_file_per_table=1
unix_socket=OFF

# MEMORY
innodb_buffer_pool_size=16G
innodb_buffer_pool_instances=8

# NVME OPTIMIZATION
innodb_flush_method=O_DIRECT
innodb_io_capacity=4000
innodb_io_capacity_max=8000

# LOGS
innodb_log_file_size=2G
innodb_log_buffer_size=256M

# CONNECTIONS
max_connections=300
thread_cache_size=100

# TEMP TABLES
tmp_table_size=256M
max_heap_table_size=256M

# TABLE CACHE
table_open_cache=16000
table_definition_cache=4000

# TIMEOUTS
wait_timeout=120
interactive_timeout=120

# INNODB
innodb_flush_log_at_trx_commit=1

# DISABLE DNS LOOKUP
# skip-name-resolve

# QUERY CACHE
query_cache_type=0
query_cache_size=0

# OTHER
sql_mode=NO_ENGINE_SUBSTITUTION

/home/../etc/apache2/../my.cnf