Showing 1-30 of 99 (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 (5187 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 (6893 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 (6823 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 (6818 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 (6814 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 (5186 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 (6706 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 (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 |
15076 | 2005-11-20 1:39 | 2005-12-25 7:27 | MySQL Server: Optimizer | No Feedback (6668 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 (6389 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 (6357 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 (4738 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 (6238 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 (6165 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 (5902 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 (4058 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 (6186 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 (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 |
27043 | 2007-03-12 11:45 | 2011-05-17 23:00 | MySQL Server: Optimizer | No Feedback (4699 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 (4454 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 (6147 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 (6147 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 (6122 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 (5935 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 (5972 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 (5441 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 (6053 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 (6027 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 (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 |
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 |
Showing 1-30 of 99 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |