# 2020-09-28
# «The [client] option group is read by all client programs provided in MySQL distributions (but not by mysqld).
# The [client] group enables you to specify options that apply to all clients.
# For example, [client] is the appropriate group to use to specify the password for connecting to the server.
# Be sure not to put an option in the [client] group unless it is recognized by all client programs that you use.
# Programs that do not understand the option quit after displaying an error message if you try to run them.»
# https://dev.mysql.com/doc/refman/5.7/en/option-files.html
[client]
host=localhost
password=vertrigo
port=3306
user=root
[mysql]
default-character-set=utf8
no-beep
# 2024-02-09
# 1) "Disable the «automatic rehashing» feature of `mysql`": https://github.com/dmitrii-fediuk/5.9.188.84/issues/58
# 2) https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html#option_mysql_auto-rehash
skip-auto-rehash
[mysqldump]
no-beep
default-character-set=utf8
[mysqld]
# 2017-04-30 «The path to the MySQL installation directory».
# https://dev.mysql.com/doc/refman/5.7/en/mysql-server.html#option_mysql_server_basedir
# https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_basedir
# Не знаю, надо ли указывать эту опцию.
# Она присутствовала в моём предыдущем файле настроек, но отсутствует в стандартном файле настроек MySQL 5.7.18
basedir = "C:/server/mysql/"
# 2020-09-28 https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_bind_address
bind-address = 127.0.0.1
character-set-server = utf8
datadir = E:/server/mysql/data
default-storage-engine = INNODB
# 2017-05-18
# «The number of days for automatic binary log file removal.
# The default is 0, which means “no automatic removal.”
# Possible removals happen at startup and when the binary log is flushed».
; https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_expire_logs_days
expire_logs_days = 10
# 2017-04-29
# Для устранения предупреждения «TIMESTAMP with implicit DEFAULT value is deprecated»: https://df.tips/t/185
explicit_defaults_for_timestamp = 1
# 2017-04-30 Важно! Чтобы Magento искала по двубуквенным запросам.
ft_min_word_len = 2
# 2018-03-31 https://stackoverflow.com/a/24910831
innodb_adaptive_hash_index = 0
# 2017-04-30 https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_buffer_pool_size
innodb_buffer_pool_size = 16G
# 2017-04-30 https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_checksum_algorithm
innodb_checksum_algorithm = crc32
# 2017-04-30 https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_fast_shutdown
innodb_fast_shutdown = 1
# 2017-04-30 https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_flush_log_at_trx_commit
# 2020-05-26
# «With a setting of 2, logs are written after each transaction commit and flushed to disk once per second.
# Transactions for which logs have not been flushed can be lost in a crash.»
innodb_flush_log_at_trx_commit = 2
# 2019-02-20
# "How have I fixed «InnoDB: Semaphore wait has lasted > 600 seconds. We intentionally crash the server because it appears to be hung.»"
# https://df.tips/t/860
innodb_flush_neighbors = 0
# 2017-04-29
# Для устранения предупреждения «Plugin keyring_file reported: 'keyring_file initialization failure. Please check if the keyring_file_data points to readable keyring file or keyring file can be created in the specified location. The keyring_file will stay unusable until correct path to the keyring file gets provided'».
# https://df.tips/t/188
#keyring_file_data="C:/server/mysql/keyring"
# 2017-04-29
# How to fix the «Cannot open datafile for read-only» / «Could not find a valid tablespace file» MySQL error for an intentionally deleted database?
# https://df.tips/t/189
innodb_force_recovery=0
innodb_log_file_size = 125M
key_buffer_size = 384M
log_error = C:/server/log/mysql.log
# 2017-04-30
# «This variable controls verbosity of the server in writing error, warning, and note messages to the error log.
# The following table shows the permitted values. The default is 3.
# 1 Errors only
# 2 Errors and warnings
# 3 Errors, warnings, and notes»
# https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_log_error_verbosity
log_error_verbosity = 2
log-output = NONE
max_allowed_packet = 1024M
max_binlog_size = 100M
max_connections = 700
# 2017-04-30 https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_myisam_max_sort_file_size
myisam_max_sort_file_size = 100G
myisam_sort_buffer_size = 214M
# 2019-02-20 https://stackoverflow.com/a/10563643
net_read_timeout=2147483
port = 3306
query_cache_size = 200M
read_buffer_size = 1M
read_rnd_buffer_size = 768K
# 2017-04-29
# https://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_secure-file-priv
# https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_secure_file_priv
# Для устранения предупреждения «[Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path».
# https://df.tips/t/187
secure-file-priv = "C:/work"
server-id = 1
# 2017-05-19
# «It suppresses the The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled;
# see the documentation for 'show_compatibility_56'» Backupninja issue:
# https://mail.google.com/mail/u/0/#inbox/15c1ba6ad17205cf
# https://i-mscp.net/index.php/Thread/13361-MySQL-5-7-show-compatibility-56/?postID=45190#post45190
# 2018-03-03
# "How to fix «The 'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled» in MySQL 5.7?"
# https://df.tips/t/513
# https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_show_compatibility_56
show_compatibility_56 = On
sort_buffer_size = 4M
# 2017-04-30 https://df.tips/t/186
# 2018-07-31
# "How to fix the «Invalid default value for 'updated_at'» MySQL 5.7 failire?" https://mage2.pro/t/5629
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO"
# 2017-04-30
# How to remove the «SSL context is not usable without certificate and private key» warning for a localhost-only MySQL server?
# https://df.tips/t/191
ssl = 0
# 2017-04-30 https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_table_definition_cache
table_definition_cache = 20000
# 2019-02-20
# "How have I fixed «InnoDB: Semaphore wait has lasted > 600 seconds. We intentionally crash the server because it appears to be hung.»"
# https://df.tips/t/860
#table_open_cache = 20000
# 2019-02-20
# "How have I fixed «InnoDB: Semaphore wait has lasted > 600 seconds. We intentionally crash the server because it appears to be hung.»"
# https://df.tips/t/860
#thread_cache_size = 200
tmp_table_size = 112M
# 2017-04-30
# Важно! Чтобы при отладке в xDebug MySQL не обрубал соединение.
# https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_wait_timeout
wait_timeout=2147483
#slow_query_log=1
#long_query_time=0.1
#slow_query_log_file=C:/server/log/mysql-slow.log
innodb_purge_threads = 1
[mysqld_safe]
open-files-limit = 20000