Bug #112556 | Created_tmp_disk_tables doesn't count on-disk temptable with fallback | ||
---|---|---|---|
Submitted: | 28 Sep 2023 7:03 | Modified: | 2 Jul 2024 3:40 |
Reporter: | tianfeng li (OCA) | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Information schema | Severity: | S2 (Serious) |
Version: | 8.0.30,8.4.0 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | Contribution |
[28 Sep 2023 7:03]
tianfeng li
[28 Sep 2023 7:13]
tianfeng li
db_type-set-incorrectly-with-small-initial-tmp_table (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Contribution: 0001-db_type-set-incorrectly-with-small-initial-tmp_table.patch (application/octet-stream, text), 1.10 KiB.
[3 Oct 2023 6:40]
MySQL Verification Team
Hello tianfeng li, Thank you for the report and contribution. regards, Umesh
[2 Jul 2024 3:40]
tianfeng li
Note that affected in 8.4.0: mysql> Show status like '%Created_tmp%'; +-------------------------+-------+ | Variable_name | Value | +-------------------------+-------+ | Created_tmp_disk_tables | 1 | | Created_tmp_files | 5 | | Created_tmp_tables | 3 | +-------------------------+-------+ 3 rows in set (0.02 sec) mysql> Select count(distinct b) from t1; +-------------------+ | count(distinct b) | +-------------------+ | 30000 | +-------------------+ 1 row in set (6.78 sec) mysql> Show status like '%Created_tmp%'; +-------------------------+-------+ | Variable_name | Value | +-------------------------+-------+ | Created_tmp_disk_tables | 1 | | Created_tmp_files | 5 | | Created_tmp_tables | 4 | +-------------------------+-------+ 3 rows in set (0.01 sec)