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
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
227792006-09-28
12:18
2011-04-08
22:36
MySQL Server: OptimizerNo Feedback
(4738 days)
S5 Ver 14.12 Distrib 5.0.24aWindows (Windows 2000 server)Any"order by" clause performance..
807892016-03-18
10:22
2019-06-06
21:10
MySQL Server: OptimizerNo Feedback
(2885 days)
S15.6.27-29, 5.7.11CentOS (x86_64)Any"Select" query gives empty result depending on index or spacing in query
139172005-10-11
8:54
2008-02-09
13:41
MySQL Server: OptimizerNo Feedback
(5892 days)
S55.0.14-rc, 5.0.27Linux (Linux, RedHat AS 3)Any5.0 is slower than 4.1 on many queries
269432007-03-07
23:57
2011-02-16
23:43
MySQL Server: OptimizerNo Feedback
(5241 days)
S25.0.27, 5.0.22, 5.0.68Linux (linux(centos 4.4 server))Any64bit mysql 5 hangs on removing duplicate after query distinct,group by,order by
95232005-03-31
13:15
2011-02-16
23:43
MySQL Server: OptimizerNo Feedback
(5187 days)
S25.0.9-beta, 4.1.10aWindows (Windows XP)Anyabuse of index in simple query
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
795472015-12-07
13:59
2019-06-03
1:00
MySQL Server: OptimizerNo Feedback
(1761 days)
S35.6DebianAnybad performance query on mysql 5.6
831522016-09-26
15:03
2016-10-28
1:00
MySQL Server: OptimizerNo Feedback
(2709 days)
S35.7.14Red Hat (CentOS 7)AnyBadly optimized query with VIEWs (regression)
430672009-02-20
21:22
2011-02-16
23:43
MySQL Server: OptimizerNo Feedback
(5270 days)
S56.0.9-alpha-communityWindowsAnyBug on index query
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
758182015-02-07
15:11
2015-03-11
1:00
MySQL Server: OptimizerNo Feedback
(3306 days)
S55.6.17, 5.6.20Linux (CentOS 5.7)Anycan't utilize more keyparts
728342014-06-02
14:10
2014-07-04
1:00
MySQL Server: OptimizerNo Feedback
(3556 days)
S25.6.12Windows (Microsoft build 9200, 64-bit)AnyCannot query for a date column using time specification with unique index
1003462020-07-28
6:10
2021-10-30
1:00
MySQL Server: OptimizerNo Feedback
(881 days)
S28.0.16-7Anyx86crash
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
308832007-09-07
5:28
2012-05-18
20:19
MySQL Server: OptimizerNo Feedback
(5611 days)
S55.0.27Linux (CentOS 4.3)AnyDependent Sub Queries Very Slow
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
116062005-06-28
9:53
2005-07-28
17:10
MySQL Server: OptimizerNo Feedback
(6818 days)
S24.1.11-standard-logLinux (Fedora Core 2)AnyDuplicate key error in SELECT query
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
490922009-11-25
9:37
2011-02-16
23:44
MySQL Server: OptimizerNo Feedback
(5207 days)
S55.0.26LinuxAnyEXISTS clause optimization
116082005-06-28
10:58
2005-08-01
15:44
MySQL Server: OptimizerNo Feedback
(6814 days)
S24.0.17Linux (Linux Kernal 2.24)AnyExplain select gives two different output, which makes optimisation difficult
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
422822009-01-22
22:23
2011-02-16
23:43
MySQL Server: OptimizerNo Feedback
(5513 days)
S35.0.67AnyAnyFailure to use index for group-by
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
301802007-08-01
14:49
2007-09-01
23:29
MySQL Server: OptimizerNo Feedback
(6053 days)
S25.0.37-communityAnyAnyGetting broken tmp key file on complex query
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
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
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
306862007-08-29
9:37
2011-02-16
23:43
MySQL Server: OptimizerNo Feedback
(5412 days)
S25.1.20-beta-community-nt-debug, 5.1.30Windows ((via TCP/IP))Anyinappropriate LIMIT behavior on partitioned single-table query sorted by PK
  Showing 1-30 of 99 (Edit, Save, CSV, Feed) Show Next 30 Entries »