Showing 1-30 of 99 (Edit, Save, CSV, Feed) Show Next 30 Entries »
ID# Date Updated Type Status Sev Version OS CPU Summary
535532010-05-11
7:14
2011-02-16
23:44
MySQL Server: OptimizerNo Feedback
(5039 days)
S25.1.46Windows (Windows 7 x64)Any"Copying to tmp table" spend a lot time
700862013-08-19
16:06
2013-11-03
1:00
MySQL Server: OptimizerNo Feedback
(3799 days)
S25.6.13-logLinux (2.6.16.33-xenU x86_64)AnyDegraded performance for index_merge updates
700122013-08-13
11:12
2014-01-10
1:00
MySQL Server: OptimizerNo Feedback
(3731 days)
S25.6.12Solaris (SunOS db-stage02.fmk.netic.dk 5.10 Generic_147441-27 i86pc i386 i86pc)AnyDifferent Optimizer (slower) for Query in 5.6 compared to 5.1
693902013-06-03
18:27
2018-04-24
1:00
MySQL Server: OptimizerNo Feedback
(2166 days)
S25.6.11Linux (Oracle Linux 6.4)AnyQuery is more than 2 orders of magnitude slower on MySQL 5.6.11
640432012-01-16
16:31
2012-02-19
1:00
MySQL Server: OptimizerNo Feedback
(4422 days)
S15.5.19Linux (EL6)AnyAfter version upgrade form 5.0.26 to mysql server 5.5.19 performance degraded
637272011-12-12
22:39
2012-01-14
1:00
MySQL Server: OptimizerNo Feedback
(4458 days)
S214.12Linux (CentOS)AnyFull Table Scan when joining table multiple times with in clause
631732011-11-09
21:15
2011-12-14
7:00
MySQL Server: OptimizerNo Feedback
(4489 days)
S15.1, 5.5LinuxAnyMySql hangs in state statistics - only with specific amount of data-rows
619832011-07-26
12:13
2011-09-28
23:00
MySQL Server: OptimizerNo Feedback
(4566 days)
S25.1.48AnyAnystrange explain plan results
618522011-07-13
11:23
2011-09-14
23:00
MySQL Server: OptimizerNo Feedback
(4579 days)
S35.1.54LinuxAnyQuery returns wrong order of rows with InnoDB + Joins + Order By + Null
609412011-04-21
7:56
2011-06-27
23:00
MySQL Server: OptimizerNo Feedback
(4659 days)
S25.1.52-log, 5.1.56Any (Debian 5.0.8, Windows XP)AnyInvalid use of join conditions
608742011-04-14
18:30
2011-05-14
23:00
MySQL Server: OptimizerNo Feedback
(4702 days)
S2mysql-cluster-gpl-noinstall-7.1.10-win32AnyAnyinner join bug
603172011-03-03
16:20
2011-04-03
23:00
MySQL Server: OptimizerNo Feedback
(4743 days)
S35.1.30-community-logLinux (centos)Anyequivalent queries give different results
599502011-02-04
16:23
2018-09-09
20:45
MySQL Server: OptimizerNo Feedback
(4373 days)
S55.5.8Linux (centos 5.5 64bit)AnyIdentical query taking longer on 5.5.8 compared to 5.1
722422014-04-04
18:34
2014-07-11
1:00
MySQL Server: OptimizerNo Feedback
(3549 days)
S55.6.16, 5.6.17Any (tested on linux)AnyBug query optimizer when multiple conditions are included in ON section
531212010-04-23
16:32
2011-02-16
23:44
MySQL Server: OptimizerNo Feedback
(5058 days)
S25.0.26Linux (OpenSUSE)AnyINSERT and unindexed SELECT on same table deadlock even with low LIMIT
516772010-03-03
8:32
2011-02-16
23:44
MySQL Server: OptimizerNo Feedback
(5003 days)
S55.1.34sp1Linux (rh5.3)Anyoptimizer choose wrong index when using uncorrect character for client
510972010-02-11
14:05
2011-02-16
23:44
MySQL Server: OptimizerNo Feedback
(5131 days)
S35.0.51bWindows (WinXP sys32)AnySELECT INDEX USE
507072010-01-29
1:18
2011-02-16
23:44
MySQL Server: OptimizerNo Feedback
(5142 days)
S5Ver 5.1.26-rc-5.1.26rc-log for debian-liLinux (Debian)AnyInnoDB optimizer does a full table scan for query with IN (...) ORDER BY pk
493602009-12-02
17:53
2013-02-03
19:22
MySQL Server: OptimizerNo Feedback
(4743 days)
S35.0.66 , 5.0.84 , 5.0.84 , 5.1.41, 5.1.43AnyAnyIn some circumstances, GROUP BY WITH ROLLUP is faster then GROUP BY
490922009-11-25
9:37
2011-02-16
23:44
MySQL Server: OptimizerNo Feedback
(5207 days)
S55.0.26LinuxAnyEXISTS clause optimization
480682009-10-15
6:49
2011-12-17
16:51
MySQL Server: OptimizerNo Feedback
(4485 days)
S5MYSQL-5.0.45Linux (RHEL 5.2)Any"Copying to tmp table" taking too much time to execute
479062009-10-08
4:56
2011-02-16
23:44
MySQL Server: OptimizerNo Feedback
(5254 days)
S15.0.85, 5.1.37, 5.1.39, 6.0.9AnyAnyHaving an extra field in a table changes optimizer index choice for other column
458862009-07-01
18:38
2011-02-16
23:44
MySQL Server: OptimizerNo Feedback
(5293 days)
S35.0.45-log, 5.0.83AnyAnyIndex
452282009-05-31
22:56
2011-02-16
23:44
MySQL Server: OptimizerNo Feedback
(5269 days)
S35.4AnyAnyQueries with WHERE <col_1> AND <condition> GROUP BY <col_2> produce bad results
452262009-05-31
22:42
2011-02-16
23:44
MySQL Server: OptimizerNo Feedback
(5269 days)
S35.4AnyAnyextra rows returned for queries using IN,GROUP BY and HAVING clauses
818122016-06-11
14:40
2016-07-15
1:00
MySQL Server: OptimizerNo Feedback
(2814 days)
S15.6UbuntuAnyQuery Planner chooses wrong index for ORDER BY LIMIT 1 and limit 2 and more
1123542023-09-15
7:52
2023-10-20
1:00
MySQL Server: OptimizerNo Feedback
(161 days)
S38.0.28AnyAnyIncorrect result
1038522021-05-29
20:02
2021-07-01
1:00
MySQL Server: OptimizerNo Feedback
(1002 days)
S28.0.17Other (official Docker image)x86intermediate ROLLUP gives incorrect result
1018052020-11-30
16:16
2021-01-02
1:00
MySQL Server: OptimizerNo Feedback
(1182 days)
S25.7.32AnyAnyUsing index for group-by doesn't work with InnoDB compressed table
1007642020-09-08
8:50
2020-10-16
1:00
MySQL Server: OptimizerNo Feedback
(1260 days)
S18.0AnyAnyRename Table causes other SQL execution plans to change.
  Showing 1-30 of 99 (Edit, Save, CSV, Feed) Show Next 30 Entries »