-
Task
-
-
Major
-
Resolution:
Unresolved
-
None
-
-
Spider has many plugin variables regarding table statistics but they looks redundant. Reorganize them as the following:
| New variable |
Corresponding old variables |
Comment |
| |
spider_store_last_crd, spider_store_last_sts, spider_load_crd_at_startup, spider_load_sts_at_startup |
Always persist stats if sync is ON. |
| |
spider_crd_mode, spider_sts_mode |
Use SHOW TABLE/INDEX always. |
| spider_sync_stats_enabled |
spider_crd_bg_mode, spider_crd_sync, spider_bg_sts_mode, spider_sts_sync |
0: no sync, 1: sync background |
| |
spider_table_crd_thread_count, spider_table_sts_thread_count |
A single thread for both crd and sts seems to be enough. |
| |
spider_crd_type, spider_crd_weight |
Make it adaptive someday. |
| spider_sync_stats_interval |
spider_crd_interval, spider_sts_interval |
|
Some comments:
- Ultimately, I think all parameters should be removed (the best settings should be applied automatically).
- Does it make sense to disable stats synchronization, in the first place?
Reference:
{"report":{"fcp":1162.9000000953674,"ttfb":163.10000014305115,"pageVisibility":"visible","entityId":105971,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":0.5,"journeyId":"a3b2a87b-039a-40dd-a0bc-ff20562f70e9","navigationType":0,"readyForUser":1291,"redirectCount":0,"resourceLoadedEnd":1035.4000000953674,"resourceLoadedStart":192.90000009536743,"resourceTiming":[{"duration":424.89999985694885,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":192.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":192.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":617.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":425,"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":193.10000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":193.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":618.1000001430511,"responseStart":0,"secureConnectionStart":0},{"duration":434.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":193.20000004768372,"connectEnd":193.20000004768372,"connectStart":193.20000004768372,"domainLookupEnd":193.20000004768372,"domainLookupStart":193.20000004768372,"fetchStart":193.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":193.20000004768372,"responseEnd":627.7000000476837,"responseStart":627.7000000476837,"secureConnectionStart":193.20000004768372},{"duration":552.8000001907349,"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":193.29999995231628,"connectEnd":193.29999995231628,"connectStart":193.29999995231628,"domainLookupEnd":193.29999995231628,"domainLookupStart":193.29999995231628,"fetchStart":193.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":193.29999995231628,"responseEnd":746.1000001430511,"responseStart":746.1000001430511,"secureConnectionStart":193.29999995231628},{"duration":555.8999998569489,"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":193.90000009536743,"connectEnd":193.90000009536743,"connectStart":193.90000009536743,"domainLookupEnd":193.90000009536743,"domainLookupStart":193.90000009536743,"fetchStart":193.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":193.90000009536743,"responseEnd":749.7999999523163,"responseStart":749.7999999523163,"secureConnectionStart":193.90000009536743},{"duration":568.2999999523163,"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":194,"connectEnd":194,"connectStart":194,"domainLookupEnd":194,"domainLookupStart":194,"fetchStart":194,"redirectEnd":0,"redirectStart":0,"requestStart":194,"responseEnd":762.2999999523163,"responseStart":762.2999999523163,"secureConnectionStart":194},{"duration":569.4000000953674,"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":194,"connectEnd":194,"connectStart":194,"domainLookupEnd":194,"domainLookupStart":194,"fetchStart":194,"redirectEnd":0,"redirectStart":0,"requestStart":194,"responseEnd":763.4000000953674,"responseStart":763.4000000953674,"secureConnectionStart":194},{"duration":573.2999999523163,"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":194.10000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":194.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":767.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":573.5,"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":194.29999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":194.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":767.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":570.2000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":194.29999995231628,"connectEnd":194.29999995231628,"connectStart":194.29999995231628,"domainLookupEnd":194.29999995231628,"domainLookupStart":194.29999995231628,"fetchStart":194.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":194.29999995231628,"responseEnd":764.5,"responseStart":764.5,"secureConnectionStart":194.29999995231628},{"duration":571.2000000476837,"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":194.40000009536743,"connectEnd":194.40000009536743,"connectStart":194.40000009536743,"domainLookupEnd":194.40000009536743,"domainLookupStart":194.40000009536743,"fetchStart":194.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":194.40000009536743,"responseEnd":765.6000001430511,"responseStart":765.6000001430511,"secureConnectionStart":194.40000009536743},{"duration":672.2999999523163,"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":195.5,"connectEnd":195.5,"connectStart":195.5,"domainLookupEnd":195.5,"domainLookupStart":195.5,"fetchStart":195.5,"redirectEnd":0,"redirectStart":0,"requestStart":195.5,"responseEnd":867.7999999523163,"responseStart":867.7999999523163,"secureConnectionStart":195.5},{"duration":833.7999999523163,"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":201.60000014305115,"connectEnd":201.60000014305115,"connectStart":201.60000014305115,"domainLookupEnd":201.60000014305115,"domainLookupStart":201.60000014305115,"fetchStart":201.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":201.60000014305115,"responseEnd":1035.4000000953674,"responseStart":1035.4000000953674,"secureConnectionStart":201.60000014305115},{"duration":269.2999999523163,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":882.4000000953674,"connectEnd":882.4000000953674,"connectStart":882.4000000953674,"domainLookupEnd":882.4000000953674,"domainLookupStart":882.4000000953674,"fetchStart":882.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":882.4000000953674,"responseEnd":1151.7000000476837,"responseStart":1151.6000001430511,"secureConnectionStart":882.4000000953674}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":7,"responseStart":163,"responseEnd":192,"domLoading":176,"domInteractive":1384,"domContentLoadedEventStart":1384,"domContentLoadedEventEnd":1435,"domComplete":2659,"loadEventStart":2659,"loadEventEnd":2662,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1350.2000000476837},{"name":"bigPipe.sidebar-id.end","time":1350.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.start","time":1351.1000001430511},{"name":"bigPipe.activity-panel-pipe-id.end","time":1364.5},{"name":"activityTabFullyLoaded","time":1455.7999999523163}],"measures":[],"correlationId":"3fb465b2429bc1","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":82,"dbReadsTimeInMs":12,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
MDEV-27233 Server hangs when using --init-file which loads Spider and creates a Spider table
