Type:
Task
Priority:
Major
Resolution:
Fixed
Affects Version/s:
None
While text protocol provides a non blocking api call mysql_send_query (which sends a statement to the server without waiting for response packet), binary protocol has no corresponding api call (prepared statements) which makes asynchronous implementation without internal async api impossible.
Proposal:
Provide a new option MARIADB_OPT_SKIP_READ_RESPONSE which defines if a response from command (text or binary) protocol should be read or not. Additionally mysql->methods structure need to provide a pointer to the function which reads response from statement execution.
Transition
Time In Source Status
Execution Times
Open
Closed
76d 18h 58m
1
{"report":{"fcp":1488.0999999046326,"ttfb":458.39999985694885,"pageVisibility":"visible","entityId":97893,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"6e529c80-758a-4456-abbd-9116475927c2","navigationType":0,"readyForUser":1561.7999999523163,"redirectCount":0,"resourceLoadedEnd":1597.5,"resourceLoadedStart":463.5,"resourceTiming":[{"duration":428.09999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":463.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":463.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":891.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":428.09999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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":463.7999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":463.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":891.8999998569489,"responseStart":0,"secureConnectionStart":0},{"duration":454.2999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":464,"connectEnd":464,"connectStart":464,"domainLookupEnd":464,"domainLookupStart":464,"fetchStart":464,"redirectEnd":0,"redirectStart":0,"requestStart":464,"responseEnd":918.2999999523163,"responseStart":918.2999999523163,"secureConnectionStart":464},{"duration":665.2000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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":464.09999990463257,"connectEnd":464.09999990463257,"connectStart":464.09999990463257,"domainLookupEnd":464.09999990463257,"domainLookupStart":464.09999990463257,"fetchStart":464.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":464.09999990463257,"responseEnd":1129.2999999523163,"responseStart":1129.2999999523163,"secureConnectionStart":464.09999990463257},{"duration":670.5999999046326,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":464.2999999523163,"connectEnd":464.2999999523163,"connectStart":464.2999999523163,"domainLookupEnd":464.2999999523163,"domainLookupStart":464.2999999523163,"fetchStart":464.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":464.2999999523163,"responseEnd":1134.8999998569489,"responseStart":1134.8999998569489,"secureConnectionStart":464.2999999523163},{"duration":671.5999999046326,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":464.5,"connectEnd":464.5,"connectStart":464.5,"domainLookupEnd":464.5,"domainLookupStart":464.5,"fetchStart":464.5,"redirectEnd":0,"redirectStart":0,"requestStart":464.5,"responseEnd":1136.0999999046326,"responseStart":1136.0999999046326,"secureConnectionStart":464.5},{"duration":678.5999999046326,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":464.59999990463257,"connectEnd":464.59999990463257,"connectStart":464.59999990463257,"domainLookupEnd":464.59999990463257,"domainLookupStart":464.59999990463257,"fetchStart":464.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":464.59999990463257,"responseEnd":1143.1999998092651,"responseStart":1143.1999998092651,"secureConnectionStart":464.59999990463257},{"duration":681.2999999523163,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":464.89999985694885,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":464.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1146.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":681.8999998569489,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":465,"connectEnd":465,"connectStart":465,"domainLookupEnd":465,"domainLookupStart":465,"fetchStart":465,"redirectEnd":0,"redirectStart":0,"requestStart":465,"responseEnd":1146.8999998569489,"responseStart":1146.8999998569489,"secureConnectionStart":465},{"duration":683.7999999523163,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/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":465.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":465.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1149.0999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":684.8999998569489,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/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":465.5,"connectEnd":465.5,"connectStart":465.5,"domainLookupEnd":465.5,"domainLookupStart":465.5,"fetchStart":465.5,"redirectEnd":0,"redirectStart":0,"requestStart":465.5,"responseEnd":1150.3999998569489,"responseStart":1150.3999998569489,"secureConnectionStart":465.5},{"duration":959.2999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":471.09999990463257,"connectEnd":471.09999990463257,"connectStart":471.09999990463257,"domainLookupEnd":471.09999990463257,"domainLookupStart":471.09999990463257,"fetchStart":471.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":471.09999990463257,"responseEnd":1430.3999998569489,"responseStart":1430.3999998569489,"secureConnectionStart":471.09999990463257},{"duration":1065.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":471.19999980926514,"connectEnd":471.19999980926514,"connectStart":471.19999980926514,"domainLookupEnd":471.19999980926514,"domainLookupStart":471.19999980926514,"fetchStart":471.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":471.19999980926514,"responseEnd":1536.8999998569489,"responseStart":1536.8999998569489,"secureConnectionStart":471.19999980926514},{"duration":328.2999999523163,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1095,"connectEnd":1095,"connectStart":1095,"domainLookupEnd":1095,"domainLookupStart":1095,"fetchStart":1095,"redirectEnd":0,"redirectStart":0,"requestStart":1095,"responseEnd":1423.2999999523163,"responseStart":1423.2999999523163,"secureConnectionStart":1095},{"duration":169.60000014305115,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":1427.8999998569489,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1427.8999998569489,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1597.5,"responseStart":0,"secureConnectionStart":0},{"duration":121.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/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":1429,"connectEnd":1429,"connectStart":1429,"domainLookupEnd":1429,"domainLookupStart":1429,"fetchStart":1429,"redirectEnd":0,"redirectStart":0,"requestStart":1429,"responseEnd":1550.5,"responseStart":1550.5,"secureConnectionStart":1429},{"duration":142.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/097ae97cb8fbec7d6ea4bbb1f26955b9-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":1429.3999998569489,"connectEnd":1429.3999998569489,"connectStart":1429.3999998569489,"domainLookupEnd":1429.3999998569489,"domainLookupStart":1429.3999998569489,"fetchStart":1429.3999998569489,"redirectEnd":0,"redirectStart":0,"requestStart":1429.3999998569489,"responseEnd":1571.8999998569489,"responseStart":1571.8999998569489,"secureConnectionStart":1429.3999998569489},{"duration":190.90000009536743,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1479.1999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1479.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1670.0999999046326,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":318,"responseStart":458,"responseEnd":465,"domLoading":462,"domInteractive":1736,"domContentLoadedEventStart":1736,"domContentLoadedEventEnd":1781,"domComplete":2135,"loadEventStart":2135,"loadEventEnd":2136,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1689.0999999046326},{"name":"bigPipe.sidebar-id.end","time":1690.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":1691},{"name":"bigPipe.activity-panel-pipe-id.end","time":1697.7999999523163},{"name":"activityTabFullyLoaded","time":1794.5999999046326}],"measures":[],"correlationId":"f85f265034fecf","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":88,"dbReadsTimeInMs":11,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}