Bug #109416 | inplace alter table stuck table access on btr_drop_ahi_for_table phrase | ||
---|---|---|---|
Submitted: | 16 Dec 2022 23:17 | Modified: | 20 Dec 2022 5:52 |
Reporter: | Fangxin Flou (OCA) | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S3 (Non-critical) |
Version: | 8.0.31 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | adaptive hash index, ALTER TABLE |
[16 Dec 2022 23:17]
Fangxin Flou
[18 Dec 2022 1:20]
Fangxin Flou
It's easy to reproduce -- session 1: mysql> alter table sbtest1 engine innodb; Query OK, 0 rows affected (25 min 57.36 sec) Records: 0 Duplicates: 0 Warnings: 0 -- run sysbench [ 1546s ] thds: 256 tps: 361866.67 qps: 361866.67 (r/w/o: 361866.67/0.00/0.00) lat (ms,95%): 1.55 [ 1547s ] thds: 256 tps: 173134.68 qps: 173134.68 (r/w/o: 173134.68/0.00/0.00) lat (ms,95%): 1.55 [ 1548s ] thds: 256 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,95%): 0.00 [ 1549s ] thds: 256 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,95%): 0.00 [ 1550s ] thds: 256 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,95%): 0.00 ...... [ 1577s ] thds: 256 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,95%): 0.00 [ 1578s ] thds: 256 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,95%): 0.00 [ 1579s ] thds: 256 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,95%): 0.00 [ 1580s ] thds: 256 tps: 504768.91 qps: 504768.91 (r/w/o: 504768.91/0.00/0.00) lat (ms,95%): 0.75 [ 1581s ] thds: 256 tps: 820775.44 qps: 820775.44 (r/w/o: 820775.44/0.00/0.00) lat (ms,95%): 0.54 [ 1582s ] thds: 256 tps: 858924.56 qps: 858924.56 (r/w/o: 858924.56/0.00/0.00) lat (ms,95%): 0.46
[20 Dec 2022 5:52]
MySQL Verification Team
Hello Fangxin Flou, Thank you for the report and feedback. regards, Umesh
[13 Jun 2023 14:22]
Marcos Albe
Possible dupe of https://bugs.mysql.com/bug.php?id=107308 ?