My.cnf of Slave Server for Radico - Revision history

Biswajit: /* My.cnf of Slave Server for Radico */

2019-08-11T03:22:25Z

My.cnf of Slave Server for Radico

← Older revision		Revision as of 03:22, 11 August 2019
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

Biswajit: /* My.cnf of Slave Server for Radico */

2019-08-11T03:21:56Z

My.cnf of Slave Server for Radico

← Older revision		Revision as of 03:21, 11 August 2019
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

	~~datadir=/var/lib/mysql~~		server-id=101
	~~socket=/var/lib/mysql/mysql.sock~~		event_scheduler=off
			lower_case_table_names = 1
	~~log-error=/var/log/mysqld.log~~		sql_mode = STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
	~~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

Biswajit: 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...."

2019-08-11T03:20:26Z

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...."

New page

[[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. 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