Adds innodb_idle_flush_pct to enable tuning of the page flushing rate
when the system is relatively idle. We care about this, since doing
extra unnecessary flash writes shortens the lifespan of the flash.
Adds innodb_idle_flush_pct to enable tuning of the page flushing rate
when the system is relatively idle. We care about this, since doing
extra unnecessary flash writes shortens the lifespan of the flash.
Jan Lindström (Inactive)
added a comment - commit 2bf3e416fedf9984296da9ff43c7ff54780010d1
Author: Jan Lindström <jan.lindstrom@skysql.com>
Date: Wed Oct 29 13:49:12 2014 +0200
MDEV-6932 : Enable Lazy Flushing
Merge Facebook commit 4f3e0343fd2ac3fc7311d0ec9739a8f668274f0d
authored by Steaphan Greene from https://github.com/facebook/mysql-5.6
Adds innodb_idle_flush_pct to enable tuning of the page flushing rate
when the system is relatively idle. We care about this, since doing
extra unnecessary flash writes shortens the lifespan of the flash.
People
Jan Lindström (Inactive)
Jan Lindström (Inactive)
Votes:
0Vote for this issue
Watchers:
1Start watching this issue
Dates
Created:
Updated:
Resolved:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":761.9000000953674,"ttfb":138,"pageVisibility":"visible","entityId":46707,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"605ce5d3-e13e-4ff3-9892-9fcf72d13dd4","navigationType":0,"readyForUser":881.6999998092651,"redirectCount":0,"resourceLoadedEnd":890,"resourceLoadedStart":143.19999980926514,"resourceTiming":[{"duration":56.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":143.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":143.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":199.69999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":56.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/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":143.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":143.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":200.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":109.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/c54b129276d75dc2a3460e1d78f37913-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":143.59999990463257,"connectEnd":143.59999990463257,"connectStart":143.59999990463257,"domainLookupEnd":143.59999990463257,"domainLookupStart":143.59999990463257,"fetchStart":143.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":143.59999990463257,"responseEnd":253.19999980926514,"responseStart":253.19999980926514,"secureConnectionStart":143.59999990463257},{"duration":314.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/f867843cd2fdb209d4d1d4f760f86346-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/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":143.59999990463257,"connectEnd":143.59999990463257,"connectStart":143.59999990463257,"domainLookupEnd":143.59999990463257,"domainLookupStart":143.59999990463257,"fetchStart":143.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":143.59999990463257,"responseEnd":457.7999997138977,"responseStart":457.7999997138977,"secureConnectionStart":143.59999990463257},{"duration":317.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/ffdb17665775c5b4d6f097f3974ee359-CDN/lu2bsh/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":143.7999997138977,"connectEnd":143.7999997138977,"connectStart":143.7999997138977,"domainLookupEnd":143.7999997138977,"domainLookupStart":143.7999997138977,"fetchStart":143.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":143.7999997138977,"responseEnd":461.2999997138977,"responseStart":461.2999997138977,"secureConnectionStart":143.7999997138977},{"duration":318,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":143.7999997138977,"connectEnd":143.7999997138977,"connectStart":143.7999997138977,"domainLookupEnd":143.7999997138977,"domainLookupStart":143.7999997138977,"fetchStart":143.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":143.7999997138977,"responseEnd":461.7999997138977,"responseStart":461.7999997138977,"secureConnectionStart":143.7999997138977},{"duration":318.40000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bsh/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":144,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":144,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":462.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":318.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":144,"connectEnd":144,"connectStart":144,"domainLookupEnd":144,"domainLookupStart":144,"fetchStart":144,"redirectEnd":0,"redirectStart":0,"requestStart":144,"responseEnd":462.09999990463257,"responseStart":462.09999990463257,"secureConnectionStart":144},{"duration":318.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":144.09999990463257,"connectEnd":144.09999990463257,"connectStart":144.09999990463257,"domainLookupEnd":144.09999990463257,"domainLookupStart":144.09999990463257,"fetchStart":144.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":144.09999990463257,"responseEnd":462.5,"responseStart":462.5,"secureConnectionStart":144.09999990463257},{"duration":318.7000002861023,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bsh/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":144.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":144.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":462.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":318.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/81b5d7c27af3ebc078cc4a36383678ba-CDN/lu2bsh/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":144.40000009536743,"connectEnd":144.40000009536743,"connectStart":144.40000009536743,"domainLookupEnd":144.40000009536743,"domainLookupStart":144.40000009536743,"fetchStart":144.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":144.40000009536743,"responseEnd":463,"responseStart":463,"secureConnectionStart":144.40000009536743},{"duration":606.2000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":145.19999980926514,"connectEnd":145.19999980926514,"connectStart":145.19999980926514,"domainLookupEnd":145.19999980926514,"domainLookupStart":145.19999980926514,"fetchStart":145.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":145.19999980926514,"responseEnd":751.4000000953674,"responseStart":751.4000000953674,"secureConnectionStart":145.19999980926514},{"duration":640.4000000953674,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":145.19999980926514,"connectEnd":145.19999980926514,"connectStart":145.19999980926514,"domainLookupEnd":145.19999980926514,"domainLookupStart":145.19999980926514,"fetchStart":145.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":145.19999980926514,"responseEnd":785.5999999046326,"responseStart":785.5999999046326,"secureConnectionStart":145.19999980926514},{"duration":351,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":399.90000009536743,"connectEnd":399.90000009536743,"connectStart":399.90000009536743,"domainLookupEnd":399.90000009536743,"domainLookupStart":399.90000009536743,"fetchStart":399.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":399.90000009536743,"responseEnd":750.9000000953674,"responseStart":750.9000000953674,"secureConnectionStart":399.90000009536743},{"duration":50.60000038146973,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":755.2999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":755.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":805.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":112.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":777.9000000953674,"connectEnd":777.9000000953674,"connectStart":777.9000000953674,"domainLookupEnd":777.9000000953674,"domainLookupStart":777.9000000953674,"fetchStart":777.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":777.9000000953674,"responseEnd":890,"responseStart":890,"secureConnectionStart":777.9000000953674}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":8,"responseStart":138,"responseEnd":140,"domLoading":141,"domInteractive":935,"domContentLoadedEventStart":935,"domContentLoadedEventEnd":980,"domComplete":1186,"loadEventStart":1186,"loadEventEnd":1186,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":913.4000000953674},{"name":"bigPipe.sidebar-id.end","time":914.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.start","time":914.5999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":915.5},{"name":"activityTabFullyLoaded","time":996.6999998092651}],"measures":[],"correlationId":"fc4f6a5f4e3a06","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":71,"dbReadsTimeInMs":12,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
commit 2bf3e416fedf9984296da9ff43c7ff54780010d1
Author: Jan Lindström <jan.lindstrom@skysql.com>
Date: Wed Oct 29 13:49:12 2014 +0200
MDEV-6932: Enable Lazy FlushingMerge Facebook commit 4f3e0343fd2ac3fc7311d0ec9739a8f668274f0d
authored by Steaphan Greene from https://github.com/facebook/mysql-5.6
Adds innodb_idle_flush_pct to enable tuning of the page flushing rate
when the system is relatively idle. We care about this, since doing
extra unnecessary flash writes shortens the lifespan of the flash.