| Showing 1-30 of 107 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 9523 | 2005-03-31 13:15 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (5995 days) | S2 | 5.0.9-beta, 4.1.10a | Windows (Windows XP) | Any | abuse of index in simple query |
| 9868 | 2005-04-13 12:46 | 2012-05-18 20:19 | MySQL Server: Optimizer | No Feedback (7701 days) | S1 | mysql 5 | Linux (linux redhat 9) | Any | mysql_performance |
| 11413 | 2005-06-17 11:48 | 2005-07-23 13:08 | MySQL Server: Optimizer | No Feedback (7631 days) | S3 | 4.1.10 | Linix | Any | Merge Tables, Analize Table and Optomizer |
| 11606 | 2005-06-28 9:53 | 2005-07-28 17:10 | MySQL Server: Optimizer | No Feedback (7626 days) | S2 | 4.1.11-standard-log | Linux (Fedora Core 2) | Any | Duplicate key error in SELECT query |
| 11608 | 2005-06-28 10:58 | 2005-08-01 15:44 | MySQL Server: Optimizer | No Feedback (7622 days) | S2 | 4.0.17 | Linux (Linux Kernal 2.24) | Any | Explain select gives two different output, which makes optimisation difficult |
| 11945 | 2005-07-14 16:23 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (5994 days) | S2 | 5.0.7 | Linux (Linux /Fedora 3) | Any | Index not used in 'OUTER JOIN b ON (a.a = b.a OR a.a = b.b)' |
| 13798 | 2005-10-06 10:44 | 2020-05-03 20:45 | MySQL Server: Optimizer | No Feedback (7514 days) | S3 | 5.0.16-BK | Linux (Linux) | Any | incorrect type for an astext(linestring) result set column |
| 13917 | 2005-10-11 8:54 | 2008-02-09 13:41 | MySQL Server: Optimizer | No Feedback (6700 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 |
| 15076 | 2005-11-20 1:39 | 2005-12-25 7:27 | MySQL Server: Optimizer | No Feedback (7476 days) | S3 | 5.0.15-GA | pc-solaris2.10 (i386) | Any | index handeled incorrectly if part of a composite index is used |
| 21348 | 2006-07-30 10:37 | 2006-09-30 12:46 | MySQL Server: Optimizer | No Feedback (7197 days) | S5 | 5.0.21 | Windows (Windows) | Any | Memory storage engine poor performance relative to 4.1.20 and HASH vs BTREE |
| 21486 | 2006-08-07 16:57 | 2006-11-01 10:12 | MySQL Server: Optimizer | No Feedback (7165 days) | S2 | 5.0.22 | Linux (Linux) | Any | No index merge for ENUM columns |
| 22779 | 2006-09-28 12:18 | 2011-04-08 22:36 | MySQL Server: Optimizer | No Feedback (5546 days) | S5 | Ver 14.12 Distrib 5.0.24a | Windows (Windows 2000 server) | Any | "order by" clause performance.. |
| 25459 | 2007-01-08 2:39 | 2007-02-28 13:34 | MySQL Server: Optimizer | No Feedback (7046 days) | S3 | 5.0 | Any (any) | Any | InnoDB prefers table scan over using primary key |
| 25744 | 2007-01-22 0:33 | 2007-05-12 16:57 | MySQL Server: Optimizer | No Feedback (6973 days) | S1 | 5.0.22 | Linux (CentOs 4.4) | Any | Nested Selects Crashing MySQL |
| 26224 | 2007-02-09 15:21 | 2008-01-30 20:13 | MySQL Server: Optimizer | No Feedback (6710 days) | S2 | 5.1.22_rc | Linux (GNU/Linux) | Any | optimizer ignores keys in stored procedures |
| 26339 | 2007-02-13 19:45 | 2018-09-09 20:45 | MySQL Server: Optimizer | No Feedback (4866 days) | S2 | 5.0.26, 5.0.41 | Any (2.6.19.2-grsec Linux) | Any | Query hangs / State: statistics |
| 26915 | 2007-03-07 11:54 | 2007-04-21 14:04 | MySQL Server: Optimizer | No Feedback (6994 days) | S5 | 5.0.27 | Linux (Redhat Linux RHEL4) | Any | Slow quering due to optimizer choosing incorrect index utilisation |
| 26943 | 2007-03-07 23:57 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (6049 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 |
| 27043 | 2007-03-12 11:45 | 2011-05-17 23:00 | MySQL Server: Optimizer | No Feedback (5507 days) | S3 | 4.0.13 | Windows (windows) | Any | Slow Response when many people select one table in same time |
| 27316 | 2007-03-21 4:20 | 2012-01-18 1:00 | MySQL Server: Optimizer | No Feedback (5262 days) | S3 | 4.1.2 | Linux (Linux) | Any | LEFT JOIN fails to use INDEX in 4.1.2 (used to work in 3.23) |
| 27467 | 2007-03-27 10:37 | 2007-05-30 7:49 | MySQL Server: Optimizer | No Feedback (6955 days) | S3 | 5.1.16-beta-log | Any | Any | MAX don't optimized. |
| 27479 | 2007-03-27 18:12 | 2007-05-30 7:26 | MySQL Server: Optimizer | No Feedback (6955 days) | S5 | 5.0.37 | Linux (Linux 2.6) | Any | ORDER BY performance regression |
| 28612 | 2007-05-23 7:30 | 2007-06-24 13:27 | MySQL Server: Optimizer | No Feedback (6930 days) | S5 | 5.0.37 | Any | Any | Optimizer does not use index for BETWEEN in a JOIN condition |
| 29011 | 2007-06-11 2:57 | 2012-05-18 20:19 | MySQL Server: Optimizer | No Feedback (6743 days) | S2 | 5.0.38, 5.1 | Linux (Genroo) | Any | Query optimizaion error with NDB Engine |
| 29286 | 2007-06-21 21:02 | 2007-11-21 8:38 | MySQL Server: Optimizer | No Feedback (6780 days) | S3 | >=4.1 | Linux | Any | Problems with index when using concat function for joining |
| 29857 | 2007-07-17 21:11 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (6249 days) | S3 | 5.0.41, 5.0.45, 5.0.67 | Linux (64 bit, gcc 4.1.1) | Any | Optimizer is getting confused by extra WHERE condition |
| 30180 | 2007-08-01 14:49 | 2007-09-01 23:29 | MySQL Server: Optimizer | No Feedback (6861 days) | S2 | 5.0.37-community | Any | Any | Getting broken tmp key file on complex query |
| 30330 | 2007-08-09 11:35 | 2007-09-27 5:20 | MySQL Server: Optimizer | No Feedback (6835 days) | S5 | 4.1.12-log | Linux (Gentoo) | Any | NOT IN faster than equals(=) |
| 30686 | 2007-08-29 9:37 | 2011-02-16 23:43 | MySQL Server: Optimizer | No Feedback (6220 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 |
| 30883 | 2007-09-07 5:28 | 2012-05-18 20:19 | MySQL Server: Optimizer | No Feedback (6419 days) | S5 | 5.0.27 | Linux (CentOS 4.3) | Any | Dependent Sub Queries Very Slow |
| Showing 1-30 of 107 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
