Showing 1-30 of 99 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
53553 | 2010-05-11 7:14 | 2011-02-16 23:44 | MySQL Server: Optimizer | No Feedback (5039 days) | S2 | 5.1.46 | Windows (Windows 7 x64) | Any | "Copying to tmp table" spend a lot time |
48068 | 2009-10-15 6:49 | 2011-12-17 16:51 | MySQL Server: Optimizer | No Feedback (4485 days) | S5 | MYSQL-5.0.45 | Linux (RHEL 5.2) | Any | "Copying to tmp table" taking too much time to execute |
22779 | 2006-09-28 12:18 | 2011-04-08 22:36 | MySQL Server: Optimizer | No Feedback (4738 days) | S5 | Ver 14.12 Distrib 5.0.24a | Windows (Windows 2000 server) | Any | "order by" clause performance.. |
80789 | 2016-03-18 10:22 | 2019-06-06 21:10 | MySQL Server: Optimizer | No Feedback (2885 days) | S1 | 5.6.27-29, 5.7.11 | CentOS (x86_64) | Any | "Select" query gives empty result depending on index or spacing in query |
13917 | 2005-10-11 8:54 | 2008-02-09 13:41 | MySQL Server: Optimizer | No Feedback (5892 days) | S5 | 5.0.14-rc, 5.0.27 | Linux (Linux, RedHat AS 3) | Any | 5.0 is slower than 4.1 on many queries |
26943 | 2007-03-07 23:57 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (5241 days) | S2 | 5.0.27, 5.0.22, 5.0.68 | Linux (linux(centos 4.4 server)) | Any | 64bit mysql 5 hangs on removing duplicate after query distinct,group by,order by |
9523 | 2005-03-31 13:15 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (5187 days) | S2 | 5.0.9-beta, 4.1.10a | Windows (Windows XP) | Any | abuse of index in simple query |
64043 | 2012-01-16 16:31 | 2012-02-19 1:00 | MySQL Server: Optimizer | No Feedback (4422 days) | S1 | 5.5.19 | Linux (EL6) | Any | After version upgrade form 5.0.26 to mysql server 5.5.19 performance degraded |
79547 | 2015-12-07 13:59 | 2019-06-03 1:00 | MySQL Server: Optimizer | No Feedback (1761 days) | S3 | 5.6 | Debian | Any | bad performance query on mysql 5.6 |
83152 | 2016-09-26 15:03 | 2016-10-28 1:00 | MySQL Server: Optimizer | No Feedback (2709 days) | S3 | 5.7.14 | Red Hat (CentOS 7) | Any | Badly optimized query with VIEWs (regression) |
43067 | 2009-02-20 21:22 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (5270 days) | S5 | 6.0.9-alpha-community | Windows | Any | Bug on index query |
72242 | 2014-04-04 18:34 | 2014-07-11 1:00 | MySQL Server: Optimizer | No Feedback (3549 days) | S5 | 5.6.16, 5.6.17 | Any (tested on linux) | Any | Bug query optimizer when multiple conditions are included in ON section |
75818 | 2015-02-07 15:11 | 2015-03-11 1:00 | MySQL Server: Optimizer | No Feedback (3306 days) | S5 | 5.6.17, 5.6.20 | Linux (CentOS 5.7) | Any | can't utilize more keyparts |
72834 | 2014-06-02 14:10 | 2014-07-04 1:00 | MySQL Server: Optimizer | No Feedback (3556 days) | S2 | 5.6.12 | Windows (Microsoft build 9200, 64-bit) | Any | Cannot query for a date column using time specification with unique index |
100346 | 2020-07-28 6:10 | 2021-10-30 1:00 | MySQL Server: Optimizer | No Feedback (881 days) | S2 | 8.0.16-7 | Any | x86 | crash |
70086 | 2013-08-19 16:06 | 2013-11-03 1:00 | MySQL Server: Optimizer | No Feedback (3799 days) | S2 | 5.6.13-log | Linux (2.6.16.33-xenU x86_64) | Any | Degraded performance for index_merge updates |
30883 | 2007-09-07 5:28 | 2012-05-18 20:19 | MySQL Server: Optimizer | No Feedback (5611 days) | S5 | 5.0.27 | Linux (CentOS 4.3) | Any | Dependent Sub Queries Very Slow |
70012 | 2013-08-13 11:12 | 2014-01-10 1:00 | MySQL Server: Optimizer | No Feedback (3731 days) | S2 | 5.6.12 | Solaris (SunOS db-stage02.fmk.netic.dk 5.10 Generic_147441-27 i86pc i386 i86pc) | Any | Different Optimizer (slower) for Query in 5.6 compared to 5.1 |
11606 | 2005-06-28 9:53 | 2005-07-28 17:10 | MySQL Server: Optimizer | No Feedback (6818 days) | S2 | 4.1.11-standard-log | Linux (Fedora Core 2) | Any | Duplicate key error in SELECT query |
60317 | 2011-03-03 16:20 | 2011-04-03 23:00 | MySQL Server: Optimizer | No Feedback (4743 days) | S3 | 5.1.30-community-log | Linux (centos) | Any | equivalent queries give different results |
49092 | 2009-11-25 9:37 | 2011-02-16 23:44 | MySQL Server: Optimizer | No Feedback (5207 days) | S5 | 5.0.26 | Linux | Any | EXISTS clause optimization |
11608 | 2005-06-28 10:58 | 2005-08-01 15:44 | MySQL Server: Optimizer | No Feedback (6814 days) | S2 | 4.0.17 | Linux (Linux Kernal 2.24) | Any | Explain select gives two different output, which makes optimisation difficult |
45226 | 2009-05-31 22:42 | 2011-02-16 23:44 | MySQL Server: Optimizer | No Feedback (5269 days) | S3 | 5.4 | Any | Any | extra rows returned for queries using IN,GROUP BY and HAVING clauses |
42282 | 2009-01-22 22:23 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (5513 days) | S3 | 5.0.67 | Any | Any | Failure to use index for group-by |
63727 | 2011-12-12 22:39 | 2012-01-14 1:00 | MySQL Server: Optimizer | No Feedback (4458 days) | S2 | 14.12 | Linux (CentOS) | Any | Full Table Scan when joining table multiple times with in clause |
30180 | 2007-08-01 14:49 | 2007-09-01 23:29 | MySQL Server: Optimizer | No Feedback (6053 days) | S2 | 5.0.37-community | Any | Any | Getting broken tmp key file on complex query |
47906 | 2009-10-08 4:56 | 2011-02-16 23:44 | MySQL Server: Optimizer | No Feedback (5254 days) | S1 | 5.0.85, 5.1.37, 5.1.39, 6.0.9 | Any | Any | Having an extra field in a table changes optimizer index choice for other column |
59950 | 2011-02-04 16:23 | 2018-09-09 20:45 | MySQL Server: Optimizer | No Feedback (4373 days) | S5 | 5.5.8 | Linux (centos 5.5 64bit) | Any | Identical query taking longer on 5.5.8 compared to 5.1 |
49360 | 2009-12-02 17:53 | 2013-02-03 19:22 | MySQL Server: Optimizer | No Feedback (4743 days) | S3 | 5.0.66 , 5.0.84 , 5.0.84 , 5.1.41, 5.1.43 | Any | Any | In some circumstances, GROUP BY WITH ROLLUP is faster then GROUP BY |
30686 | 2007-08-29 9:37 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (5412 days) | S2 | 5.1.20-beta-community-nt-debug, 5.1.30 | Windows ((via TCP/IP)) | Any | inappropriate LIMIT behavior on partitioned single-table query sorted by PK |
Showing 1-30 of 99 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |