| Showing 1-10 of 97 (Edit, Save, CSV, Feed) | Show Next 10 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 106654 | 2022-03-07 12:06 | 2022-03-10 14:01 | MySQL Server: Optimizer | Verified (771 days) | S5 | 8.0 | Any | Any | join on json key can not use index, but join on virtual column can use index |
| 50367 | 2010-01-15 14:12 | 2011-02-16 23:44 | MySQL Server: General | Verified (5146 days) | S5 | 5.1.42, 5.1 bzr | Any (MS Windows 32 bits, Mac) | Any | REPLACE has quadradic computational complexity on windows server (but not linux) |
| 30342 | 2007-08-09 18:52 | 2015-10-07 14:54 | MySQL Server: Optimizer | Verified (3117 days) | S5 | 5.0.37, 5.6.17 | Any | Any | Equality propagation can make optimization much slower |
| 26832 | 2007-03-04 18:17 | 2011-04-05 14:46 | MySQL Server: Optimizer | Verified (4763 days) | S5 | 5.5 | Any | Any | ENUM types not optimized |
| 114237 | 2024-03-06 6:57 | 2024-03-06 8:30 | MySQL Server: Optimizer | Verified (44 days) | S5 | 8.2.0, 8.3.0 | Any | Any | Unexpected Cardinality by Index |
| 112964 | 2023-11-04 1:54 | 2024-02-15 8:15 | MySQL Server: InnoDB storage engine | Verified (165 days) | S5 | 8.0, 8.0.35 | Any | Any | SELECT COUNT is slow with O_DIRECT |
| 112192 | 2023-08-28 2:55 | 2023-08-30 11:05 | MySQL Server: Optimizer | Verified (233 days) | S5 | 8.0.28 | Any | Any | In MySQL 8.0, one queries need 1000 times more data than MySQL 5.7 |
| 111367 | 2023-06-12 15:36 | 2023-08-04 15:11 | MySQL Server: Optimizer | Verified (259 days) | S5 | 8.0 | Any | Any | OFFSET 99 LIMIT 1 on a compound PK takes ages to execute. |
| 108127 | 2022-08-12 5:57 | 2022-08-16 13:34 | MySQL Server: Optimizer | Verified (612 days) | S5 | 8.0.29 | Any | Any | MySQL optimizer chooses to a inefficient index . |
| 106754 | 2022-03-17 7:06 | 2022-03-21 13:52 | MySQL Server: Optimizer | Verified (764 days) | S5 | 5.7, 8.0, 5.7.37, 8.0.28 | Any | Any | Index-loose scan doesn't work for signle table partition Query |
| Showing 1-10 of 97 (Edit, Save, CSV, Feed) | Show Next 10 Entries » |
