pc2007 vs pc2010 global variables
No One
Actions

Authored By

	Marostegui
	Nov 23 2020, 11:28 AM

Size

3 KB

Referenced Files

None

Subscribers

None

pc2007 vs pc2010 global variables
View Options

	root@cumin1001:/home/marostegui# diff -u pc2007 pc2010
	--- pc2007 2020-11-22 07:41:41.663281632 +0000
	+++ pc2010 2020-11-22 07:41:35.291277185 +0000
	@@ -101,16 +101,16 @@
	ft_query_expansion_limit 20
	ft_stopword_file (built-in)
	general_log OFF
	-general_log_file pc2007.log
	+general_log_file pc2010.log
	group_concat_max_len 1048576
	-gtid_binlog_pos 0-171966644-49693925073
	-gtid_binlog_state 0-180355176-49693924645,0-171966476-27213441963,0-171978926-27444003403,0-171966644-49693925073
	+gtid_binlog_pos 0-171966644-49693921815
	+gtid_binlog_state 0-180355176-49621941336,0-171966476-27213442014,0-180367374-49693921686,0-171978926-49122531009,0-171966644-49693921816
	gtid_cleanup_batch_size 64
	-gtid_current_pos 0-171966644-49693925073
	+gtid_current_pos 0-171966644-49693921815
	gtid_domain_id 0
	gtid_ignore_duplicates OFF
	gtid_pos_auto_engines
	-gtid_slave_pos 0-171966644-49693925073
	+gtid_slave_pos 0-171966644-49693921816
	gtid_strict_mode OFF
	have_compress YES
	have_crypt YES
	@@ -125,7 +125,7 @@
	histogram_size 254
	histogram_type DOUBLE_PREC_HB
	host_cache_size 853
	-hostname pc2007
	+hostname pc2010
	idle_readonly_transaction_timeout 0
	idle_transaction_timeout 0
	idle_write_transaction_timeout 0
	@@ -237,6 +237,7 @@
	innodb_max_dirty_pages_pct_lwm 0.000000
	innodb_max_purge_lag 0
	innodb_max_purge_lag_delay 0
	+innodb_max_purge_lag_wait 0
	innodb_max_undo_log_size 10485760
	innodb_monitor_disable
	innodb_monitor_enable
	@@ -291,7 +292,7 @@
	innodb_undo_tablespaces 0
	innodb_use_atomic_writes ON
	innodb_use_native_aio ON
	-innodb_version 10.4.15
	+innodb_version 10.4.17
	innodb_write_io_threads 4
	interactive_timeout 28800
	join_buffer_size 262144
	@@ -315,10 +316,10 @@
	lock_wait_timeout 86400
	locked_in_memory OFF
	log_bin ON
	-log_bin_basename /srv/sqldata-cache/pc2007-bin
	+log_bin_basename /srv/sqldata-cache/pc2010-bin
	log_bin_compress OFF
	log_bin_compress_min_len 256
	-log_bin_index /srv/sqldata-cache/pc2007-bin.index
	+log_bin_index /srv/sqldata-cache/pc2010-bin.index
	log_bin_trust_function_creators OFF
	log_disabled_statements sp
	log_error
	@@ -428,7 +429,7 @@
	performance_schema_setup_actors_size 100
	performance_schema_setup_objects_size 100
	performance_schema_users_size 100
	-pid_file /srv/sqldata-cache/pc2007.pid
	+pid_file /srv/sqldata-cache/pc2010.pid
	plugin_dir /opt/wmf-mariadb104/lib/plugin/
	plugin_maturity gamma
	port 3306
	@@ -466,7 +467,7 @@
	replicate_ignore_table
	replicate_wild_do_table
	replicate_wild_ignore_table
	-report_host pc2007.codfw.wmnet
	+report_host pc2010.codfw.wmnet
	report_password
	report_port 3306
	report_user
	@@ -483,7 +484,7 @@
	secure_auth ON
	secure_file_priv /dev/null/
	secure_timestamp NO
	-server_id 180355176
	+server_id 180367374
	session_track_schema ON
	session_track_state_change OFF
	session_track_system_variables autocommit,character_set_client,character_set_connection,character_set_results,time_zone
	@@ -512,7 +513,7 @@
	slave_type_conversions
	slow_launch_time 2
	slow_query_log OFF
	-slow_query_log_file pc2007-slow.log
	+slow_query_log_file pc2010-slow.log
	socket /run/mysqld/mysqld.sock
	sort_buffer_size 2097152
	sql_auto_is_null OFF
	@@ -580,12 +581,12 @@
	updatable_views_with_limit YES
	use_stat_tables PREFERABLY
	userstat OFF
	-version 10.4.15-MariaDB-log
	+version 10.4.17-MariaDB-log
	version_comment MariaDB Server
	version_compile_machine x86_64
	version_compile_os Linux
	version_malloc_library system
	-version_source_revision a6e451dc7272c408ace8b3fb4d86c79263f7247e
	+version_source_revision 5fbfdae130950d0a5a07d4b909f3bf1ff0498d34
	version_ssl_library OpenSSL 1.1.1d 10 Sep 2019
	wait_timeout 3600
	wsrep_osu_method TOI
	@@ -614,7 +615,7 @@
	wsrep_mysql_replication_bundle 0
	wsrep_node_address
	wsrep_node_incoming_address AUTO
	-wsrep_node_name pc2007
	+wsrep_node_name pc2010
	wsrep_notify_cmd
	wsrep_on OFF
	wsrep_patch_version wsrep_26.22

File Metadata

Mime Type: text/plain; charset=utf-8
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 8790827
Default Alt Text: pc2007 vs pc2010 global variables (3 KB)

pc2007 vs pc2010 global variablesNo OneActions

pc2007 vs pc2010 global variablesView Options

File Metadata

Event Timeline

pc2007 vs pc2010 global variables
No One
Actions

pc2007 vs pc2010 global variables
View Options