Showing 1-30 of 34 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version OS CPU Summary
1101172023-02-17
13:22
2023-02-17
15:32
MySQL Server: DocumentationVerified
(406 days)
S38.0AnyAnyLack of instrumentation for index condition impact on the query plan
711892013-12-20
14:56
2021-08-08
20:45
MySQL Server: DocumentationVerified
(3752 days)
S35.5, anyAnyAnyManual does not provide enough details on how loose index scan really works
860362017-04-21
10:08
2018-11-13
7:55
MySQL Server: InnoDB storage engineVerified
(2532 days)
S35.7/8.0AnyAnyInnoDB FULLTEXT index has too strict innodb_ft_result_cache_limit max limit
1008852020-09-18
3:43
2020-11-09
11:38
MySQL Server: JSONVerified
(1288 days)
S55.7.31AnyAnygenerated column index against json column is not used with different encoding
1049782021-09-17
19:57
2021-09-20
9:02
MySQL Server: OptimizerVerified
(921 days)
S58.0.26, 5.7.35WindowsAnyAdding Join Index forces query optimizer to use inefficient execution plan
830622016-09-20
13:18
2018-04-24
20:15
MySQL Server: OptimizerVerified
(2746 days)
S35.6.32, 5.7.14, 5.6.33, 5.7.15AnyAnyit's no longer possible to determine used key parts by looking at key_length
830712016-09-21
8:02
2016-09-21
8:34
MySQL Server: OptimizerVerified
(2746 days)
S35.7.14, 5.6.*, 5.7.15AnyAnyMySQL prefers first declared index over more useful other indexes
832482016-10-03
15:57
2023-02-22
1:40
MySQL Server: OptimizerVerified
(2734 days)
S38.0.0, 5.7.15AnyAnyPartition pruning is not working with LEFT JOIN
833232016-10-10
18:02
2018-04-13
12:41
MySQL Server: OptimizerVerified
(2531 days)
S35.7, 5.6, 8.0.1AnyAnyOptimizer chooses wrong plan when joining 2 tables
933602018-11-27
9:41
2018-12-12
14:48
MySQL Server: OptimizerVerified
(1934 days)
S55.6.16,5.7.23Linuxx86mysterious optimizer behavior
303422007-08-09
18:52
2015-10-07
14:54
MySQL Server: OptimizerVerified
(3096 days)
S55.0.37, 5.6.17AnyAnyEquality propagation can make optimization much slower
1064732022-02-16
8:55
2022-03-10
9:27
MySQL Server: OptimizerVerified
(750 days)
S38.0.28AnyAnyInner table of OUT-JOIN is nullable, after applying OUTER2INNER transformation
996842020-05-25
12:19
2022-06-08
12:02
MySQL Server: OptimizerVerified
(1401 days)
S35.6, 5.7, 8.0AnyAnyincorrect determination of big test
1081272022-08-12
5:57
2022-08-16
13:34
MySQL Server: OptimizerVerified
(591 days)
S58.0.29AnyAnyMySQL optimizer chooses to a inefficient index .
1101112023-02-17
12:53
2023-02-20
12:35
MySQL Server: OptimizerVerified
(403 days)
S58.0.31AnyAnyOptimizer chooses worst plan when index condition pushdown opportunity
1108482023-04-27
15:04
2023-05-03
9:59
MySQL Server: OptimizerVerified
(331 days)
S58.0.28, 8.0.33AnyAnymissing considering on order by and limit clause in cost calculation
1114312023-06-15
8:47
2023-06-26
14:48
MySQL Server: OptimizerVerified
(288 days)
S38.0.33Ubuntu (22.04)Other (x86_64)condition_fanout_filter optimizer wrong result?
1129022023-10-31
14:39
2024-02-26
11:07
MySQL Server: OptimizerVerified
(32 days)
S58.0.31, 8.0.35Linux (n.a.)x86 (x86_64)Optimizer in MySQL 8 is significantly slower on dependent subqueries than 5.7
262322007-02-09
17:28
2018-09-09
20:45
MySQL Server: OptimizerVerified
(6252 days)
S34.1.22, 5.0.34, 5.0.36-BKLinux (Linux)Anyreview of bug #20944 / proof of concept attached
800672016-01-20
10:50
2020-06-17
23:13
MySQL Server: OptimizerVerified
(2991 days)
S35.6.28, 5.7.10AnyAnyIndex on BIT column is NOT used when column name only is used in WHERE clause
740832014-09-25
18:11
2014-10-09
12:58
MySQL Server: OptimizerVerified
(3459 days)
S55.6.20, 5.6.22Linux (CentOS 6.5)AnyENUM index scan is slower than INT index scan
740492014-09-24
8:01
2014-09-24
10:01
MySQL Server: OptimizerVerified
(3474 days)
S35.6.19-67.0, 5.6.22AnyAnyUpdate query use filesort instead of index
711992013-12-21
18:16
2014-01-28
17:45
MySQL Server: OptimizerVerified
(3749 days)
S35.6.14, 5.6.15, 5.5.35AnyAnyOptimizer's estimated number of rows is 2 times wrong for (loose?) index scans
711912013-12-20
15:30
2013-12-20
20:20
MySQL Server: OptimizerVerified
(3752 days)
S35.5.33AnyAnyLoose index scan is used even though full table scan/tight index scan is faster
685542013-03-03
16:16
2022-03-14
16:43
MySQL Server: OptimizerVerified
(4029 days)
S55.6.10AnyAnyOptimizer wrongly choses covering index over ICP
581012010-11-10
0:21
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4887 days)
S55.1.38-community-log, 5.1.54-bzrLinuxAnyOptimizer picks wrong order of queries
474542009-09-19
19:33
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5304 days)
S35.1.35AnyAnyNot exists optimization method is not used for NULL columns in the right table
480492009-10-14
16:46
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.1.37, 5.5.7AnyAnySELECT MIN(1) reports differently for MERGE tables in 5.0 and 5.1
463762009-07-24
17:05
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5357 days)
S55.0.85, 5.1.36, 5.1.38, 5.1.39Windows (XP)AnyOptimizer choose wrong index even when where clause and order-by are covered
442012009-04-10
3:04
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5036 days)
S35.1.32, 5.1.35-bzr, 6.0.11-bzr, 5.0, 5.6.99AnyAnyPerformance problem with View
  Showing 1-30 of 34 (Edit, Save, CSV, Feed) Show Next 30 Entries »