When importing a dump created by mysqldump with default options meta-data like Rows and Avg_row_length are 0 and Data_length is 16 KB and indexes are not available anymore which leads to long running or locking queries. Only after executing an optimize table afterwards corrects this or whem using the option skip-disable-keys for creating dump.
In the following example the Data_length is always 16 KB, because of the small table:
Test Table
mysql -e 'CREATE DATABASE testdb;'
mysql testdb -e 'CREATE TABLE testtable ( id int, a int,PRIMARY KEY (id)) ENGINE=InnoDB;'
mysql testdb -e 'INSERT INTO testtable VALUES (1,2),(2,3),(3,4);'
Import with default dump
mysqldump testdb testtable > dump1.sql
mysql -e 'DROP DATABASE IF EXISTS testdb;CREATE DATABASE testdb;'
mysql testdb < dump1.sql
mysql testdb -e 'SHOW TABLE STATUS LIKE "testtable"\G'
Rows: 0
Avg_row_length: 0
Recreate Table
mysql testdb -e 'OPTIMIZE TABLE testtable;'
mysql testdb -e 'SHOW TABLE STATUS LIKE "testtable"\G'
Rows: 3
Avg_row_length: 5461
Import with dump without disabled keys
mysqldump --skip-disable-keys testdb testtable > dump2.sql
mysql -e 'DROP DATABASE IF EXISTS testdb;CREATE DATABASE testdb;'
mysql testdb < dump2.sql
mysql testdb -e 'SHOW TABLE STATUS LIKE "testtable"\G'
It looks like MDEV-28327 is very similar to this issue. However, I can reproduce this issue also with the latest version 10.6.11.
I have also tried the test in MDEV-28327 which is reproduceable in 10.6.10 but not in 10.6.11, as it has been fixed.
@bar You wrote that it is not reproduceable with 10.6.11, have you tried my shell-script?
Attached is a new test-report with 10.6.10 and 10.6.11, where it can be seen that the issue is still existing.
So can you please reopen it.
Alex
added a comment - It looks like MDEV-28327 is very similar to this issue. However, I can reproduce this issue also with the latest version 10.6.11.
I have also tried the test in MDEV-28327 which is reproduceable in 10.6.10 but not in 10.6.11, as it has been fixed.
@bar You wrote that it is not reproduceable with 10.6.11, have you tried my shell-script?
Attached is a new test-report with 10.6.10 and 10.6.11, where it can be seen that the issue is still existing.
So can you please reopen it.
metadata-test2.txt
People
Alexander Barkov
Alex
Votes:
4Vote for this issue
Watchers:
9Start 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":1395.5999999046326,"ttfb":228.89999961853027,"pageVisibility":"visible","entityId":105864,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"d603f856-9aef-43aa-8fea-674aeb243f2a","navigationType":0,"readyForUser":1508.1999998092651,"redirectCount":0,"resourceLoadedEnd":1123.0999999046326,"resourceLoadedStart":235.89999961853027,"resourceTiming":[{"duration":30.200000286102295,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":235.89999961853027,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":235.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":266.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":30.699999809265137,"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":236.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":236.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":266.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":428.2000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":236.39999961853027,"connectEnd":236.39999961853027,"connectStart":236.39999961853027,"domainLookupEnd":236.39999961853027,"domainLookupStart":236.39999961853027,"fetchStart":236.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":271.19999980926514,"responseEnd":664.5999999046326,"responseStart":290.69999980926514,"secureConnectionStart":236.39999961853027},{"duration":838.1999998092651,"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":236.5,"connectEnd":236.5,"connectStart":236.5,"domainLookupEnd":236.5,"domainLookupStart":236.5,"fetchStart":236.5,"redirectEnd":0,"redirectStart":0,"requestStart":270.69999980926514,"responseEnd":1074.6999998092651,"responseStart":298.3999996185303,"secureConnectionStart":236.5},{"duration":56,"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":236.69999980926514,"connectEnd":236.69999980926514,"connectStart":236.69999980926514,"domainLookupEnd":236.69999980926514,"domainLookupStart":236.69999980926514,"fetchStart":236.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":271.69999980926514,"responseEnd":292.69999980926514,"responseStart":290.09999990463257,"secureConnectionStart":236.69999980926514},{"duration":59,"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":236.89999961853027,"connectEnd":236.89999961853027,"connectStart":236.89999961853027,"domainLookupEnd":236.89999961853027,"domainLookupStart":236.89999961853027,"fetchStart":236.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":273.19999980926514,"responseEnd":295.8999996185303,"responseStart":294.5,"secureConnectionStart":236.89999961853027},{"duration":60.40000009536743,"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":237.19999980926514,"connectEnd":237.19999980926514,"connectStart":237.19999980926514,"domainLookupEnd":237.19999980926514,"domainLookupStart":237.19999980926514,"fetchStart":237.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":274.59999990463257,"responseEnd":297.59999990463257,"responseStart":296,"secureConnectionStart":237.19999980926514},{"duration":38.700000286102295,"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":237.39999961853027,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":237.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":276.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":61.299999713897705,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":237.59999990463257,"connectEnd":237.59999990463257,"connectStart":237.59999990463257,"domainLookupEnd":237.59999990463257,"domainLookupStart":237.59999990463257,"fetchStart":237.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":274.7999997138977,"responseEnd":298.8999996185303,"responseStart":296.8999996185303,"secureConnectionStart":237.59999990463257},{"duration":38.30000019073486,"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":237.89999961853027,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":237.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":276.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":61.40000009536743,"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":238.09999990463257,"connectEnd":238.09999990463257,"connectStart":238.09999990463257,"domainLookupEnd":238.09999990463257,"domainLookupStart":238.09999990463257,"fetchStart":238.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":276.19999980926514,"responseEnd":299.5,"responseStart":297.7999997138977,"secureConnectionStart":238.09999990463257},{"duration":882.6999998092651,"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":239.5,"connectEnd":239.5,"connectStart":239.5,"domainLookupEnd":239.5,"domainLookupStart":239.5,"fetchStart":239.5,"redirectEnd":0,"redirectStart":0,"requestStart":318.7999997138977,"responseEnd":1122.1999998092651,"responseStart":1110,"secureConnectionStart":239.5},{"duration":883.5999999046326,"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":239.5,"connectEnd":239.5,"connectStart":239.5,"domainLookupEnd":239.5,"domainLookupStart":239.5,"fetchStart":239.5,"redirectEnd":0,"redirectStart":0,"requestStart":372.7999997138977,"responseEnd":1123.0999999046326,"responseStart":1112.3999996185303,"secureConnectionStart":239.5},{"duration":300.59999990463257,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":982.7999997138977,"connectEnd":982.7999997138977,"connectStart":982.7999997138977,"domainLookupEnd":982.7999997138977,"domainLookupStart":982.7999997138977,"fetchStart":982.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":1250.0999999046326,"responseEnd":1283.3999996185303,"responseStart":1282.5,"secureConnectionStart":982.7999997138977},{"duration":352.30000019073486,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1335.1999998092651,"connectEnd":1335.1999998092651,"connectStart":1335.1999998092651,"domainLookupEnd":1335.1999998092651,"domainLookupStart":1335.1999998092651,"fetchStart":1335.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1649.3999996185303,"responseEnd":1687.5,"responseStart":1686.2999997138977,"secureConnectionStart":1335.1999998092651},{"duration":414.59999990463257,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1388.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1388.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1803.0999999046326,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":58,"responseStart":229,"responseEnd":233,"domLoading":233,"domInteractive":1701,"domContentLoadedEventStart":1701,"domContentLoadedEventEnd":1795,"domComplete":2297,"loadEventStart":2297,"loadEventEnd":2298,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1580.6999998092651},{"name":"bigPipe.sidebar-id.end","time":1581.6999998092651},{"name":"bigPipe.activity-panel-pipe-id.start","time":1581.8999996185303},{"name":"bigPipe.activity-panel-pipe-id.end","time":1583.8999996185303},{"name":"activityTabFullyLoaded","time":1825.0999999046326}],"measures":[],"correlationId":"5e80bef2c4bb12","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":105,"dbReadsTimeInMs":14,"dbConnsTimeInMs":23,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
OK to push after addressing my review comments.