Page MenuHomePhabricator
Paste P13361

pc2007 vs pc2010 global variables
ActivePublic

Authored by Marostegui on Nov 23 2020, 11:28 AM.
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