My.cnf of Slave Server for Radico: Difference between revisions
Appearance
Created page with "category:Radico-Khaitan == My.cnf of Slave Server for Radico == [mysqld] # # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL...." |
|||
| Line 4: | Line 4: | ||
== My.cnf of Slave Server for Radico == | == My.cnf of Slave Server for Radico == | ||
[mysqld] | [mysqld] | ||
# | # | ||
# Remove leading # and set to the amount of RAM for the most important data | # 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%. | # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. | ||
# innodb_buffer_pool_size = 128M | # innodb_buffer_pool_size = 128M | ||
# | # | ||
# Remove the leading "# " to disable binary logging | # Remove the leading "# " to disable binary logging | ||
# Binary logging captures changes between backups and is enabled by | # Binary logging captures changes between backups and is enabled by | ||
# default. It's default setting is log_bin=binlog | # default. It's default setting is log_bin=binlog | ||
# disable_log_bin | # disable_log_bin | ||
# | # | ||
# Remove leading # to set options mainly useful for reporting servers. | # Remove leading # to set options mainly useful for reporting servers. | ||
# The server defaults are faster for transactions and fast SELECTs. | # The server defaults are faster for transactions and fast SELECTs. | ||
# Adjust sizes as needed, experiment to find the optimal values. | # Adjust sizes as needed, experiment to find the optimal values. | ||
# join_buffer_size = 128M | # join_buffer_size = 128M | ||
# sort_buffer_size = 2M | # sort_buffer_size = 2M | ||
# read_rnd_buffer_size = 2M | # read_rnd_buffer_size = 2M | ||
# | # | ||
# Remove leading # to revert to previous value for default_authentication_plugin, | # Remove leading # to revert to previous value for default_authentication_plugin, | ||
# this will increase compatibility with older clients. For background, see: | # 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 | # https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin | ||
default-authentication-plugin=mysql_native_password | 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 | |||
server-id=101 | |||
event_scheduler=off | |||
lower_case_table_names = 1 | |||
sql_mode = STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION | |||
Revision as of 03:21, 11 August 2019
My.cnf of Slave Server for Radico
[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