my.cnf

[mysqld]
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
skip-character-set-client-handshake
init_connect="SET NAMES utf8mb4;"
port=3306
# 테이블명 대소문자 구별없이
lower_case_table_names = 1
# 메모리 설정
innodb_buffer_pool_size = 2G
# 커넥션 설정
max_connections = 2048
thread_pool_max_threads = 2048
# 그 외 기타 설정들
sql_mode = "STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
default_storage_engine = innodb
innodb_log_file_size = 50M
skip-name-resolve
max_allowed_packet = 1G
thread_handling = pool-of-threads
performance_schema = 1
transaction-isolation = READ-COMMITTED
slow-query-log = 1
long_query_time = 0.1
tmp_table_size = 1024M
max_heap_table_size = 1024M
table_open_cache = 8192
innodb_open_files = 8192
table_definition_cache = 8192
innodb_sync_spin_loops = 10
;init-file = "E:/DB_MySQL/start.sql"