My.cnf of Slave Server for Radico: Difference between revisions
Appearance
| Line 43: | Line 43: | ||
table-definition-cache = 4096 | table-definition-cache = 4096 | ||
table-open-cache = 2048 | table-open-cache = 2048 | ||
server-id=101 | server-id=101 | ||
event_scheduler=off | event_scheduler=off | ||
lower_case_table_names = 1 | lower_case_table_names = 1 | ||
sql_mode = STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION | sql_mode = STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION | ||
Latest revision as of 03:22, 11 August 2019
My.cnf of Slave Server for Radico[edit]
[mysqld] # # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # # Remove the leading "# " to disable binary logging # Binary logging captures changes between backups and is enabled by # default. It's default setting is log_bin=binlog # disable_log_bin # # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M # # Remove leading # to revert to previous value for default_authentication_plugin, # this will increase compatibility with older clients. For background, see: # https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin default-authentication-plugin=mysql_native_password datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid #innodb-flush-method = O_DIRECT #innodb-flush-log-at-trx-commit = 2 #innodb-file-per-table = 1 innodb-buffer-pool-size = 50G default-storage-engine = InnoDB # CACHES AND LIMITS # tmp-table-size = 4092M max-heap-table-size = 32M max-connections = 500 thread-cache-size = 500 open-files-limit = 65535 table-definition-cache = 4096 table-open-cache = 2048 server-id=101 event_scheduler=off lower_case_table_names = 1 sql_mode = STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION