Антивирус отключен.
Содержимое my.ini (C:\ProgramData\MySQL\MySQL Server 8.0\my.ini):
[client]
default-character-set=cp1251
# pipe=
connect_timeout=600
mysqlx_connect_timeout=600
mysqlx_read_timeout=600
net_read_timeout = 600
# socket=MYSQL
port=3306
[mysql]
no-beep
default-character-set=cp1251
[mysqld]
connect_timeout=600
mysqlx_connect_timeout=600
mysqlx_read_timeout=600
net_read_timeout = 600
log_bin_trust_function_creators = 1
# The next three options are mutually exclusive to SERVER_PORT below.
# skip-networking
# enable-named-pipe
# shared-memory
# shared-memory-base-name=MYSQL
# The Pipe the MySQL Server will use
# socket=mysql=MYSQL
# The TCP/IP Port the MySQL Server will listen on
port=3306
# Path to installation directory. All paths are usually resolved relative to this.
# basedir="C:/Program Files/MySQL/MySQL Server 8.0/"
# Path to the database root
datadir=X:\Data
# The default character set that will be used when a new schema or table is
# created and no character set is defined
character-set-server=cp1251
#skip-character-set-client-handshake
# The default authentication plugin to be used when connecting to the server
default_authentication_plugin=caching_sha2_password
# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB
# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
# General and Slow logging.
log-output=FILE
general-log=0
general_log_file="CHD-DIR440.log"
slow-query-log=1
slow_query_log_file="CHD-DIR440-slow.log"
long_query_time=10
# Binary Logging.
# log-bin
# Error Logging.
log-error="CHD-DIR440.err"
# Server Id.
server-id=1
# Secure File Priv.
#secure-file-priv=""
secure-file-priv="C:/ProgramData/MySQL/MySQL Server 8.0/Uploads"
#secure-file-priv="X:/"
max_connections=151
table_open_cache=2000
# tmp_table_size
thread_cache_size=10
myisam_max_sort_file_size=100G
# myisam_sort_buffer_size
# key_buffer_size
# read_buffer_size
# read_rnd_buffer_size
# innodb_data_home_dir=
# skip-innodb
innodb_flush_log_at_trx_commit=1
# innodb_log_buffer_size
# innodb_buffer_pool_size
innodb_log_file_size=48M
innodb_thread_concurrency=8
innodb_autoextend_increment=64
# innodb_buffer_pool_instances
innodb_concurrency_tickets=5000
innodb_old_blocks_time=1000
# innodb_open_files
innodb_stats_on_metadata=0
innodb_file_per_table=1
innodb_checksum_algorithm=0
back_log=80
flush_time=0
join_buffer_size=256K
max_allowed_packet=16M
max_connect_errors=100
open_files_limit=4161
sort_buffer_size=256K
table_definition_cache=1400
binlog_row_event_max_size=8K
sync_master_info=10000
sync_relay_log=10000
sync_relay_log_info=10000
# plugin_load
# loose_mysqlx_port=33060
