mysql8 內存優化配置

# The minimum and default values are both 400.

table_definition_cache=2048

# Specify the maximum size of a row-based binary log event, in bytes.

# Rows are grouped into events smaller than this size if possible. The value should be a multiple of 256.

binlog_row_event_max_size=8K

# If the value of this variable is greater than 0, a replication slave synchronizes its master.info file to disk.

# (using fdatasync()) after every sync_master_info events.

sync_master_info=10000

# If the value of this variable is greater than 0, the MySQL server synchronizes its relay log to disk.

# (using fdatasync()) after every sync_relay_log writes to the relay log.

sync_relay_log=10000

# If the value of this variable is greater than 0, a replication slave synchronizes its relay-log.info file to disk.

# (using fdatasync()) after every sync_relay_log_info transactions.

sync_relay_log_info=10000

# Load mysql plugins at start."plugin_x ; plugin_y".

# plugin_load=

# MySQL server's plugin configuration.

# loose_mysqlx_port=33060

閱讀更多 程序員小新人學習 的文章

關鍵字: 內存 配置 Line