Showing 1-30 of 45 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version Target OS CPU Summary Assigned
915852018-07-10
1:16
2018-08-27
11:06
MySQL Server: Stored RoutinesVerified
(253 days)
S55.7, 8.0, 8.0.11, 5.7.23AnyAny“dead” code inside the stored proc or function can significantly slow it down  
816302016-05-28
5:46
2016-08-31
6:30
MySQL Server: ReplicationVerified
(931 days)
S55.7.12AnyAnyMySQL 5.7 is 37-45% slower then 5.6 when using binlogging due to defaults change  
219782006-09-01
22:13
2011-02-16
23:43
MySQL Server: OptionsVerified
(4123 days)
S34.0.18, 5.0, 6.0.10, 5.55.5+Microsoft Windows (Windows 2000)Any'flush_time' value set for 1800 sec. on Non Win9x/Me installs by default  
795472015-12-07
13:59
2015-12-11
12:25
MySQL Server: OptimizerOpen
(1197 days)
S35.6DebianAnybad performance query on mysql 5.6  
442012009-04-10
3:04
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3200 days)
S35.1.32, 5.1.35-bzr, 6.0.11-bzr, 5.0, 5.6.99AnyAnyPerformance problem with View  
559792010-08-13
22:05
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3138 days)
S55.1.39LinuxAnyKey not used if IN() list contains mix of strings and integers  
454242009-06-10
6:58
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3570 days)
S25.0.51a, 5.0.77 and 5.1.34, 5.1, 6.0 bzrLinuxAnyUPDATE statement cause full table scan ?  
463762009-07-24
17:05
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3521 days)
S55.0.85, 5.1.36, 5.1.38, 5.1.39Microsoft Windows (XP)AnyOptimizer choose wrong index even when where clause and order-by are covered Tor Didriksen
274522007-03-26
17:35
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3775 days)
S35.0.40-BK, 5.0.24a-debian-log, 5.1.31-bzr, 6.0.7-alpha, 6.0.9-bzrLinuxAnyCorrelated subquery produces inefficient optimizer plan for INFORMATION_SCHEMA  
466482009-08-11
11:41
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3502 days)
S35.1.32, 4.1, 5.0, 5.1, azalea bzrLinux (2.6.28.7)AnySQL_CALC_FOUND_ROWS kills performance with ORDER BY and LIMIT  
580082010-11-05
9:38
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3057 days)
S35.1, 5.0AnyAnywrong datatype (blob) in the resultset if the string is larger than 512 bytes  
711402013-12-13
9:16
2015-07-31
8:59
MySQL Server: OptimizerVerified
(1328 days)
S25.1, 5.5, 5.6.15, 5.7.7AnyAnyOptimizer does NOT use range checks in typical self-join for InnoDB tables  
589282010-12-14
20:58
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3018 days)
S35.1-bugteamAnyAny"not exists" optimization not applied if relevant table is not single inner one  
783552015-09-07
15:53
2015-09-15
8:51
MySQL Server: OptimizerVerified
(1282 days)
S55.5.41, 5.5.46, 5.5.47Ubuntu (x64)Anynested select query not work on mysql 5.5 but it works well in mysql 5.6  
383972008-07-27
20:13
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3887 days)
S35.1.26, 5.0.62AnyAnyselect distinct + order by desc is executed inefficiently  
478842009-10-07
3:24
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3337 days)
S25.1.39, 5.1.44, 5.5.99Linux (Linux web2 2.6.18-92.1.18.el5.028stab060.8 #1 SMP Mon Feb 9 21:44:50 MSK 2009 x86_64)AnyMySQL 5.1.39 failed to use index  
595572011-01-17
15:26
2018-09-09
20:45
MySQL Server: OptimizerVerified
(2984 days)
S25.1, 5.5AnyAnyMySQL uses order of fields in GROUP BY when ORDER BY NULL is specified  
303422007-08-09
18:52
2015-10-07
14:54
MySQL Server: OptimizerVerified
(1260 days)
S55.0.37, 5.6.17AnyAnyEquality propagation can make optimization much slower  
643402012-02-15
14:07
2013-06-14
15:35
MySQL Server: InnoDB Plugin storage engineVerified
(2105 days)
S55.1.52, 5.1.61AnyAnyrace on no_flush event during buf_flush_free_margin  
665632012-08-28
5:37
2012-08-28
6:55
MySQL Server: InnoDB Plugin storage engineVerified
(2395 days)
S55.1,5.6AnyAnyreduce the number of redundant calls to btr_cur_optimistic_insert()  
597272011-01-25
21:36
2016-12-04
20:45
MySQL Server: InnoDB storage engineVerifiedS55.1 plugin, 5.5, 5.6AnyAnyLRU search can be inefficient with compression Assigned Account
600872011-02-10
13:14
2016-12-04
20:45
MySQL Server: InnoDB storage engineVerified
(2960 days)
S35.5AnyAnyPatch: Minimize InnoDB I/O load by adding a prefetch stage Assigned Account
813762016-05-11
6:48
2018-07-16
8:12
MySQL Server: InnoDB storage engineVerified
(1042 days)
S55.7AnyAnySingle page flushing should be removed  
755042015-01-14
12:52
2015-01-22
14:51
MySQL Server: InnoDB storage engineVerified
(1518 days)
S5AnyAnybtr_search_guess_on_hash makes found block young twice?  
759622015-02-19
3:14
2015-03-03
20:46
MySQL Server: InnoDB storage engineVerified
(1478 days)
S35.6.24, 5.7.6AnyAnyInnodb calls fsync when freeing a LRU page to fulfill page request  
620182011-07-28
15:15
2018-02-11
20:45
MySQL Server: InnoDB storage engineVerified
(2254 days)
S55.6.3AnyAnyinnodb adaptive hash index mutex contention Assigned Account
759812015-02-20
13:56
2017-11-05
7:12
MySQL Server: InnoDB storage engineVerified
(1441 days)
S55.7.6AnyAnyMySQL 5.7.5 30% slower than 5.6.23 for 1 thread write  
744082014-10-15
19:52
2018-07-04
15:16
MySQL Server: InnoDB storage engineVerified
(259 days)
S55.6, 5.7, 8.0AnyAnysrv_conc_enter_innodb() is not optimal  
403672008-10-28
8:55
2011-02-16
23:43
MySQL Server: Information schemaVerified
(3709 days)
S35.1.28, 5.1.29, 5.0, 5.1 bzrAnyAnySHOW on a broad view is taking too long  
427052009-02-09
16:37
2011-02-16
23:43
MySQL Server: GeneralVerified
(3649 days)
S35.1.30AnyAnyReduce malloc/free during query lifecycle.  
  Showing 1-30 of 45 (Edit, Save, CSV, Feed) Show Next 30 Entries »