Showing 1-10 of 66 (Edit, Save, CSV, Feed) | Show Next 10 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
98770 | 2020-02-28 4:02 | 2020-03-03 15:05 | MySQL Server: Optimizer | Verified (406 days) | S5 | 8.0.19 | Any | Any | Non-covering full index scan is always preferred over table scan for GROUP BY |
103300 | 2021-04-13 11:24 | 2021-04-13 13:55 | MySQL Server: Optimizer | Open | S5 | 5.7.33-36-log | CentOS | x86 | Query response slowness on 5.7 which is taking 0.36 secs and in 5.6 0.00 secs |
87947 | 2017-10-03 4:00 | 2018-06-11 19:57 | MySQL Server: Optimizer | Verified (1282 days) | S5 | 5.7.19 | Any | Any | Optimizer chooses ref over range when access when range access is faster |
38550 | 2008-08-04 21:47 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4562 days) | S5 | 5.0.60, 5.1 | Any | Any | multiple optimizer bugs for queries with references from preceding table |
95080 | 2019-04-23 7:24 | 2019-04-30 14:09 | MySQL Router | Verified (714 days) | S5 | 8.0.15, 8.0.16 | Oracle Linux (Oracle Linux Server 7.5, Linux 4.1.12-124.18.6.el7uek.x86_64 ) | x86 (Intel(R) Xeon(R) CPU E5-2699 v3 @ 2.30GHz) | MySQL Router consuming mor CPU resources than it should |
58234 | 2010-11-16 16:26 | 2014-02-26 12:47 | MySQL Server: InnoDB storage engine | Verified (3404 days) | S5 | 5.1.49-r1, 5.5.20 | Any | Any | LENGTH() / OCTET_LENGTH() on BLOB field very slow |
63905 | 2012-01-02 23:47 | 2012-01-16 18:35 | MySQL Server: Optimizer | Verified (3375 days) | S5 | 5.1.60 | Microsoft Windows | Any | handler_read_next is suprisingly high and slows queries |
78407 | 2015-09-11 12:45 | 2015-09-15 7:50 | MySQL Server: Optimizer | Analyzing (2037 days) | S5 | 7.4.6/5.6.24 | Linux | Any | wrong index being used in subqueries? |
99994 | 2020-06-26 7:57 | 2020-06-26 13:08 | MySQL Server: Optimizer | Verified (291 days) | S5 | 8.0 | Any | Any | Index range scan is chosen where table scan takes 40% less time |
101391 | 2020-10-30 3:04 | 2020-11-19 16:59 | MySQL Server: Performance Schema | Verified (145 days) | S5 | 8.0, 8.0.22 | Any | Any | Performance Schema storage engine doesn't use index optimizations on group by |
Showing 1-10 of 66 (Edit, Save, CSV, Feed) | Show Next 10 Entries » |