When adding or removing a non-materialized virtual column to/from a MyISAM table with ALTER TABLE, MariaDB recreates the whole table although only the metadata should be affected:
MariaDB [test]> ALTER TABLE test ADD COLUMN testcolumn INT AS (othercolumn+1) VIRTUAL;
|
Stage: 1 of 2 'copy to tmp table' 0.001% of stage done
|
This is especially annoying for multi-gigabyte tables, where this operation takes a long time.
- relates to
-
MDEV-6303
MyISAM/Aria: Adding/removing non-materialized virtual column triggers table recreation
-
-
Open
{"report":{"fcp":2550.5999999046326,"ttfb":1204.7000000476837,"pageVisibility":"visible","entityId":35118,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"baa046bc-0501-4af6-8700-b3c6075bcc12","navigationType":0,"readyForUser":2643.2000000476837,"redirectCount":0,"resourceLoadedEnd":3027.899999856949,"resourceLoadedStart":1210.5,"resourceTiming":[{"duration":751.2000000476837,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":1210.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1210.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1961.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":751.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":1210.7999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1210.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1962.2999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":793.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":1210.8999998569489,"connectEnd":1210.8999998569489,"connectStart":1210.8999998569489,"domainLookupEnd":1210.8999998569489,"domainLookupStart":1210.8999998569489,"fetchStart":1210.8999998569489,"redirectEnd":0,"redirectStart":0,"requestStart":1210.8999998569489,"responseEnd":2004.5999999046326,"responseStart":2004.5999999046326,"secureConnectionStart":1210.8999998569489},{"duration":910.6000001430511,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":1211.0999999046326,"connectEnd":1211.0999999046326,"connectStart":1211.0999999046326,"domainLookupEnd":1211.0999999046326,"domainLookupStart":1211.0999999046326,"fetchStart":1211.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1211.0999999046326,"responseEnd":2121.7000000476837,"responseStart":2121.7000000476837,"secureConnectionStart":1211.0999999046326},{"duration":915,"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":1211.3999998569489,"connectEnd":1211.3999998569489,"connectStart":1211.3999998569489,"domainLookupEnd":1211.3999998569489,"domainLookupStart":1211.3999998569489,"fetchStart":1211.3999998569489,"redirectEnd":0,"redirectStart":0,"requestStart":1211.3999998569489,"responseEnd":2126.399999856949,"responseStart":2126.399999856949,"secureConnectionStart":1211.3999998569489},{"duration":915.2000000476837,"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":1211.5999999046326,"connectEnd":1211.5999999046326,"connectStart":1211.5999999046326,"domainLookupEnd":1211.5999999046326,"domainLookupStart":1211.5999999046326,"fetchStart":1211.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1211.5999999046326,"responseEnd":2126.7999999523163,"responseStart":2126.7999999523163,"secureConnectionStart":1211.5999999046326},{"duration":915.4000000953674,"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":1211.7999999523163,"connectEnd":1211.7999999523163,"connectStart":1211.7999999523163,"domainLookupEnd":1211.7999999523163,"domainLookupStart":1211.7999999523163,"fetchStart":1211.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":1211.7999999523163,"responseEnd":2127.2000000476837,"responseStart":2127.2000000476837,"secureConnectionStart":1211.7999999523163},{"duration":951.7000000476837,"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":1211.8999998569489,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1211.8999998569489,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2163.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":915.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":1212.0999999046326,"connectEnd":1212.0999999046326,"connectStart":1212.0999999046326,"domainLookupEnd":1212.0999999046326,"domainLookupStart":1212.0999999046326,"fetchStart":1212.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1212.0999999046326,"responseEnd":2127.5999999046326,"responseStart":2127.5999999046326,"secureConnectionStart":1212.0999999046326},{"duration":951.5,"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":1212.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1212.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2163.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":915.7000000476837,"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":1212.5,"connectEnd":1212.5,"connectStart":1212.5,"domainLookupEnd":1212.5,"domainLookupStart":1212.5,"fetchStart":1212.5,"redirectEnd":0,"redirectStart":0,"requestStart":1212.5,"responseEnd":2128.2000000476837,"responseStart":2128.2000000476837,"secureConnectionStart":1212.5},{"duration":1505.4000000953674,"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":1213.3999998569489,"connectEnd":1213.3999998569489,"connectStart":1213.3999998569489,"domainLookupEnd":1213.3999998569489,"domainLookupStart":1213.3999998569489,"fetchStart":1213.3999998569489,"redirectEnd":0,"redirectStart":0,"requestStart":1213.3999998569489,"responseEnd":2718.7999999523163,"responseStart":2718.7999999523163,"secureConnectionStart":1213.3999998569489},{"duration":1808.7999999523163,"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":1219.0999999046326,"connectEnd":1219.0999999046326,"connectStart":1219.0999999046326,"domainLookupEnd":1219.0999999046326,"domainLookupStart":1219.0999999046326,"fetchStart":1219.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1219.0999999046326,"responseEnd":3027.899999856949,"responseStart":3027.899999856949,"secureConnectionStart":1219.0999999046326},{"duration":554.6000001430511,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":2196.0999999046326,"connectEnd":2196.0999999046326,"connectStart":2196.0999999046326,"domainLookupEnd":2196.0999999046326,"domainLookupStart":2196.0999999046326,"fetchStart":2196.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":2196.0999999046326,"responseEnd":2750.7000000476837,"responseStart":2750.7000000476837,"secureConnectionStart":2196.0999999046326},{"duration":533.7000000476837,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":2542.5999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":2542.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":3076.2999999523163,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":1049,"responseStart":1205,"responseEnd":1210,"domLoading":1208,"domInteractive":3082,"domContentLoadedEventStart":3082,"domContentLoadedEventEnd":3168,"domComplete":3724,"loadEventStart":3724,"loadEventEnd":3725,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":3030},{"name":"bigPipe.sidebar-id.end","time":3031.2999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":3031.399999856949},{"name":"bigPipe.activity-panel-pipe-id.end","time":3033.399999856949},{"name":"activityTabFullyLoaded","time":3203.5999999046326}],"measures":[],"correlationId":"d83ad036d6db","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":97,"dbReadsTimeInMs":11,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
serg, please review fix for this bug.