[mysqld]
bind-address = 0.0.0.0

# filesystem layout
innodb_file_per_table = 1
lower_case_table_names = 1
tmpdir = "/dev/shm"
symbolic-links = 0

# logging
log_error_verbosity = 2
log_error=/var/lib/mysql/lhcp3406.webapps.net.err
slow_query_log = OFF
long_query_time = 20

# end-user semantic
performance-schema = 1
event_scheduler = ON
wait_timeout = 180

# data format
default-storage-engine = InnoDB
max_connections = 600
max_user_connections = 50
max_allowed_packet = 256M
open_files_limit = 32768
max_heap_table_size = 32M
tmp_table_size = 512M

# generic cache
thread_cache_size = 64
table_open_cache = 8192
table_open_cache_instances = 8

# innodb cache
innodb_buffer_pool_size = 4G
innodb_buffer_pool_instances = 4
innodb_redo_log_capacity=536870912
innodb_log_buffer_size = 128M
innodb_flush_log_at_trx_commit = 2

# innodb io
innodb_flush_neighbors = 0
innodb_flush_sync = 0
innodb_io_capacity_max = 1200

# myisam limits
key_buffer_size = 16M
read_buffer_size = 128k
sort_buffer_size = 512k
read_rnd_buffer_size = 512k
bulk_insert_buffer_size = 8M
myisam_sort_buffer_size = 8M

# mysql 8.0 upgrade specific
mysqlx = 0
skip-log-bin
default-authentication-plugin = mysql_native_password
sql_mode = NO_ENGINE_SUBSTITUTION
# MY-013360 - 'mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead
# MY-010055 - IP address ... could not be resolved: Name or service not known
log_error_suppression_list='MY-013360,MY-010055'

[mysqldump]
max_allowed_packet = 512M