Showing 1-30 of 31 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version Target OS Summary Assigned
262322007-02-09
17:28
2012-05-18
20:19
MySQL Server: OptimizerVerified
(3811 days)
S34.1.22, 5.0.34, 5.0.36-BKLinux (Linux)review of bug #20944 / proof of concept attached  
294432007-06-29
13:28
2011-02-16
23:43
MySQL Server: OptimizerVerified
(2474 days)
S35.1.19Anycost calculations are off  
303422007-08-09
18:52
2015-10-07
14:54
MySQL Server: OptimizerVerified
(655 days)
S55.0.37, 5.6.17AnyEquality propagation can make optimization much slower  
357942008-04-03
12:06
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3324 days)
S35.0.45, 5.0, 5.1, 6.0 BKAnyVery bad query optimization on DELETE with subquery  
368022008-05-19
15:42
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3219 days)
S35.0, 5.1, 6.0 BK5.6+AnyMySQL only use covered index when selecting from a view (or subquery) with union Evgeny Potemkin
420942009-01-13
23:01
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3044 days)
S35.15.6+AnyOptimizer chooses a wrong index when group by, order by and limit is present  
429482009-02-17
23:02
2011-02-16
23:43
MySQL Server: OptimizerVerified
(3064 days)
S55.0.67-0ubuntu6, 6.0.11Linux (Ubuntu 8.10)MySQL Optimizer does not properly use Indexes on Views with "Group By"  
442012009-04-10
3:04
2011-02-16
23:43
MySQL Server: OptimizerVerified
(2595 days)
S35.1.32, 5.1.35-bzr, 6.0.11-bzr, 5.0, 5.6.99AnyPerformance problem with View  
445492009-04-29
17:47
2011-02-16
23:43
MySQL Server: OptimizerVerifiedS35.0.80, 5.1.34Anyoptimizer incorrectly chooses table scan and filesort over index  
463762009-07-24
17:05
2011-02-16
23:44
MySQL Server: OptimizerVerified
(2916 days)
S55.0.85, 5.1.36, 5.1.38, 5.1.39Microsoft Windows (XP)Optimizer choose wrong index even when where clause and order-by are covered Tor Didriksen
474542009-09-19
19:33
2011-02-16
23:44
MySQL Server: OptimizerVerified
(2863 days)
S35.1.35AnyNot exists optimization method is not used for NULL columns in the right table  
480492009-10-14
16:46
2011-02-16
23:44
MySQL Server: OptimizerVerifiedS35.1.37, 5.5.7AnySELECT MIN(1) reports differently for MERGE tables in 5.0 and 5.1  
581012010-11-10
0:21
2011-02-16
23:44
MySQL Server: OptimizerVerified
(2446 days)
S55.1.38-community-log, 5.1.54-bzrLinuxOptimizer picks wrong order of queries  
626762011-10-11
1:23
2011-11-29
18:20
MySQL Server: DocumentationVerified
(2112 days)
S35.6.3AnyI don't understand the MRR docs Paul Dubois
645672012-03-06
18:38
2012-03-13
14:39
MySQL Server: OptimizerVerified
(1965 days)
S35.5.20, 5.5.21AnyLast_query_cost is not updated when executing an unique key lookup  
673512012-10-24
8:02
2017-05-03
16:04
MySQL Server: PartitionsVerified
(1695 days)
S25.5.27-29.0LinuxCardinality samples of partitioned tables sometimes widely off  
685542013-03-03
16:16
2016-10-09
20:45
MySQL Server: OptimizerVerified
(1588 days)
S55.6.10AnyOptimizer wrongly choses covering index over ICP Assigned Account
693902013-06-03
18:27
2014-07-25
18:34
MySQL Server: OptimizerOpen
(1095 days)
S25.6.11Linux (Oracle Linux 6.4)Query is more than 2 orders of magnitude slower on MySQL 5.6.11  
711892013-12-20
14:56
2014-01-13
9:53
MySQL Server: DocumentationVerified
(1311 days)
S35.5, anyAnyManual does not provide enough details on how loose index scan really works Paul Dubois
711912013-12-20
15:30
2013-12-20
20:20
MySQL Server: OptimizerVerified
(1311 days)
S35.5.33AnyLoose index scan is used even though full table scan/tight index scan is faster  
711992013-12-21
18:16
2014-01-28
17:45
MySQL Server: OptimizerVerified
(1308 days)
S35.6.14, 5.6.15, 5.5.35AnyOptimizer's estimated number of rows is 2 times wrong for (loose?) index scans  
740492014-09-24
8:01
2014-09-24
10:01
MySQL Server: OptimizerVerified
(1033 days)
S35.6.19-67.0, 5.6.22AnyUpdate query use filesort instead of index  
740832014-09-25
18:11
2014-10-09
12:58
MySQL Server: OptimizerVerified
(1018 days)
S55.6.20, 5.6.22Linux (CentOS 6.5)ENUM index scan is slower than INT index scan  
795472015-12-07
13:59
2015-12-11
12:25
MySQL Server: OptimizerOpen
(592 days)
S35.6Debianbad performance query on mysql 5.6  
800672016-01-20
10:50
2016-02-15
12:44
MySQL Server: OptimizerVerified
(550 days)
S35.6.28, 5.7.10AnyIndex on BIT column is NOT used when column name only is used in WHERE clause  
830622016-09-20
13:18
2016-09-21
8:19
MySQL Server: OptimizerVerified
(305 days)
S35.6.32, 5.7.14, 5.6.33, 5.7.15Anyit'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
(305 days)
S35.7.14, 5.6.*, 5.7.15AnyMySQL prefers first declared index over more useful other indexes  
832482016-10-03
15:57
2016-10-03
17:14
MySQL Server: OptimizerVerified
(293 days)
S38.0.0, 5.7.15AnyPartition pruning is not working with LEFT JOIN  
833232016-10-10
18:02
2017-04-24
21:32
MySQL Server: OptimizerVerified
(90 days)
S35.7, 5.6, 8.0.1AnyOptimizer chooses wrong plan when joining 2 tables  
860362017-04-21
10:08
2017-04-23
0:54
MySQL Server: InnoDB storage engineVerified
(91 days)
S35.7/8.0AnyInnoDB FULLTEXT index has too strict innodb_ft_result_cache_limit max limit  
  Showing 1-30 of 31 (Edit, Save, CSV, Feed) Show Next 30 Entries »