The documentation here:
https://mariadb.com/kb/en/wsrep_provider_options/#gcacherecover
states, that wsrep.recover by default is set to no:
Default: no
This is not true any more:
SQL> show global variables like 'wsrep_provider_options'\G
|
*************************** 1. row ***************************
|
Variable_name: wsrep_provider_options
|
Value: base_dir = /var/lib/mysql/; base_host = 10.116.63.153; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.causal_keepalive_period = PT1S; evs.debug_log_mask = 0x1; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.info_log_mask = 0; evs.install_timeout = PT7.5S; evs.join_retrans_period = PT1S; evs.keepalive_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.use_aggregate = true; evs.user_send_window = 2; evs.version = 1; evs.view_forget_timeout = P1D; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.keep_plaintext_size = 128M; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; *gcache.recover = yes*; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.fc_single_primary = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.listen_addr = tcp://0.0.0.0:4567; gmcast.mcast_addr = ; gmcast.mcast_ttl = 1; gmcast.peer_timeout = PT3S; gmcast.segment = 0; gmcast.time_wait = PT5S; gmcast.version = 0; ist.recv_addr = 10.116.63.153; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.linger = PT20S; pc.npvo = false; pc.recovery = true; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = PT30S; pc.weight = 1; protonet.version = 0; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.max_ws_size = 2147483647; repl.proto_max = 11; socket.checksum = 2; socket.recv_buf_size = auto; socket.send_buf_size = auto;
|
Please fix the docu.
Sergei Golubchik
made changes -
Field |
Original Value |
New Value |
Description
|
The documentation here:
https://mariadb.com/kb/en/wsrep_provider_options/#gcacherecover
states, that wsrep.recover by default is set to no:
Default: no
This is not true any more:
SQL> show global variables like 'wsrep_provider_options'\G
*************************** 1. row ***************************
Variable_name: wsrep_provider_options
Value: base_dir = /var/lib/mysql/; base_host = 10.116.63.153; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.causal_keepalive_period = PT1S; evs.debug_log_mask = 0x1; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.info_log_mask = 0; evs.install_timeout = PT7.5S; evs.join_retrans_period = PT1S; evs.keepalive_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.use_aggregate = true; evs.user_send_window = 2; evs.version = 1; evs.view_forget_timeout = P1D; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.keep_plaintext_size = 128M; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; *gcache.recover = yes*; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.fc_single_primary = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.listen_addr = tcp://0.0.0.0:4567; gmcast.mcast_addr = ; gmcast.mcast_ttl = 1; gmcast.peer_timeout = PT3S; gmcast.segment = 0; gmcast.time_wait = PT5S; gmcast.version = 0; ist.recv_addr = 10.116.63.153; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.linger = PT20S; pc.npvo = false; pc.recovery = true; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = PT30S; pc.weight = 1; protonet.version = 0; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.max_ws_size = 2147483647; repl.proto_max = 11; socket.checksum = 2; socket.recv_buf_size = auto; socket.send_buf_size = auto;
Please fix the docu.
|
The documentation here:
https://mariadb.com/kb/en/wsrep_provider_options/#gcacherecover
states, that wsrep.recover by default is set to no:
Default: no
This is not true any more:
{noformat}
SQL> show global variables like 'wsrep_provider_options'\G
*************************** 1. row ***************************
Variable_name: wsrep_provider_options
Value: base_dir = /var/lib/mysql/; base_host = 10.116.63.153; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.causal_keepalive_period = PT1S; evs.debug_log_mask = 0x1; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.info_log_mask = 0; evs.install_timeout = PT7.5S; evs.join_retrans_period = PT1S; evs.keepalive_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.use_aggregate = true; evs.user_send_window = 2; evs.version = 1; evs.view_forget_timeout = P1D; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.keep_plaintext_size = 128M; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; *gcache.recover = yes*; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.fc_single_primary = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.listen_addr = tcp://0.0.0.0:4567; gmcast.mcast_addr = ; gmcast.mcast_ttl = 1; gmcast.peer_timeout = PT3S; gmcast.segment = 0; gmcast.time_wait = PT5S; gmcast.version = 0; ist.recv_addr = 10.116.63.153; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.linger = PT20S; pc.npvo = false; pc.recovery = true; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = PT30S; pc.weight = 1; protonet.version = 0; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.max_ws_size = 2147483647; repl.proto_max = 11; socket.checksum = 2; socket.recv_buf_size = auto; socket.send_buf_size = auto;
{noformat}
Please fix the docu.
|
{"report":{"fcp":970.4000000357628,"ttfb":303.10000002384186,"pageVisibility":"visible","entityId":133163,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"b19ad793-d60d-43c5-b39c-bfbab08d4f6e","navigationType":0,"readyForUser":1072.300000011921,"redirectCount":0,"resourceLoadedEnd":774.8000000119209,"resourceLoadedStart":313,"resourceTiming":[{"duration":101.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":313,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":313,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":414.5,"responseStart":0,"secureConnectionStart":0},{"duration":101.39999997615814,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":313.4000000357628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":313.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":414.80000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":229,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":313.60000002384186,"connectEnd":416,"connectStart":416,"domainLookupEnd":416,"domainLookupStart":416,"fetchStart":313.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":417,"responseEnd":542.6000000238419,"responseStart":432.80000001192093,"secureConnectionStart":416},{"duration":383.9000000357628,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":314.30000001192093,"connectEnd":314.30000001192093,"connectStart":314.30000001192093,"domainLookupEnd":314.30000001192093,"domainLookupStart":314.30000001192093,"fetchStart":314.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":417.5,"responseEnd":698.2000000476837,"responseStart":436.5,"secureConnectionStart":314.30000001192093},{"duration":120.20000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":314.5,"connectEnd":314.5,"connectStart":314.5,"domainLookupEnd":314.5,"domainLookupStart":314.5,"fetchStart":314.5,"redirectEnd":0,"redirectStart":0,"requestStart":418.10000002384186,"responseEnd":434.7000000476837,"responseStart":432.10000002384186,"secureConnectionStart":314.5},{"duration":123.89999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":314.7000000476837,"connectEnd":314.7000000476837,"connectStart":314.7000000476837,"domainLookupEnd":314.7000000476837,"domainLookupStart":314.7000000476837,"fetchStart":314.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":419,"responseEnd":438.60000002384186,"responseStart":435.5,"secureConnectionStart":314.7000000476837},{"duration":140.4000000357628,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":314.80000001192093,"connectEnd":314.80000001192093,"connectStart":314.80000001192093,"domainLookupEnd":314.80000001192093,"domainLookupStart":314.80000001192093,"fetchStart":314.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":431.10000002384186,"responseEnd":455.2000000476837,"responseStart":451.60000002384186,"secureConnectionStart":314.80000001192093},{"duration":103.70000004768372,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":315,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":315,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":418.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":141,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":315.2000000476837,"connectEnd":315.2000000476837,"connectStart":315.2000000476837,"domainLookupEnd":315.2000000476837,"domainLookupStart":315.2000000476837,"fetchStart":315.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":431.80000001192093,"responseEnd":456.2000000476837,"responseStart":454.10000002384186,"secureConnectionStart":315.2000000476837},{"duration":114.30000001192093,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":315.30000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":315.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":429.60000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":140.9000000357628,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":315.5,"connectEnd":315.5,"connectStart":315.5,"domainLookupEnd":315.5,"domainLookupStart":315.5,"fetchStart":315.5,"redirectEnd":0,"redirectStart":0,"requestStart":431.9000000357628,"responseEnd":456.4000000357628,"responseStart":452.30000001192093,"secureConnectionStart":315.5},{"duration":452.0999999642372,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":316.9000000357628,"connectEnd":316.9000000357628,"connectStart":316.9000000357628,"domainLookupEnd":316.9000000357628,"domainLookupStart":316.9000000357628,"fetchStart":316.9000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":590.9000000357628,"responseEnd":769,"responseStart":762.1000000238419,"secureConnectionStart":316.9000000357628},{"duration":456.80000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":318,"connectEnd":318,"connectStart":318,"domainLookupEnd":318,"domainLookupStart":318,"fetchStart":318,"redirectEnd":0,"redirectStart":0,"requestStart":704.2000000476837,"responseEnd":774.8000000119209,"responseStart":771.1000000238419,"secureConnectionStart":318},{"duration":86.40000003576279,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":677,"connectEnd":677,"connectStart":677,"domainLookupEnd":677,"domainLookupStart":677,"fetchStart":677,"redirectEnd":0,"redirectStart":0,"requestStart":722.4000000357628,"responseEnd":763.4000000357628,"responseStart":760.8000000119209,"secureConnectionStart":677},{"duration":122.69999998807907,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":922.7000000476837,"connectEnd":922.7000000476837,"connectStart":922.7000000476837,"domainLookupEnd":922.7000000476837,"domainLookupStart":922.7000000476837,"fetchStart":922.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":1010.3000000119209,"responseEnd":1045.4000000357628,"responseStart":1044.2000000476837,"secureConnectionStart":922.7000000476837},{"duration":212.5999999642372,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":962.7000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":962.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1175.300000011921,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":62,"domainLookupEnd":113,"connectStart":113,"connectEnd":135,"secureConnectionStart":122,"requestStart":137,"responseStart":303,"responseEnd":317,"domLoading":307,"domInteractive":1124,"domContentLoadedEventStart":1124,"domContentLoadedEventEnd":1172,"domComplete":1457,"loadEventStart":1457,"loadEventEnd":1457,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1104.1000000238419},{"name":"bigPipe.sidebar-id.end","time":1104.9000000357628},{"name":"bigPipe.activity-panel-pipe-id.start","time":1105.1000000238419},{"name":"bigPipe.activity-panel-pipe-id.end","time":1106.300000011921},{"name":"activityTabFullyLoaded","time":1185.1000000238419}],"measures":[],"correlationId":"d5ef94d5fca5d9","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":96,"dbReadsTimeInMs":12,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}