MySQL Bugs MySQL AB Bugs Database http://bugs.mysql.com/ MySQL Bugs http://bugs.mysql.com/images/mysql_100x52-64.gif http://bugs.mysql.com/ http://bugs.mysql.com/9523 #9523: abuse of index in simple query http://bugs.mysql.com/bug.php?id=9523 Submitted by: Vadim Tkachenko
Category: Server: Optimizer
Status: No Feedback
Severity: 2
OS: Windows (Windows XP)
Version: 5.0.9-beta, 4.1.10a
]]> Thu, 31 Mar 2005 13:15:53 +0000 Server: Optimizer http://bugs.mysql.com/9868 #9868: mysql_performance http://bugs.mysql.com/bug.php?id=9868 Submitted by: moemen mira
Category: Server: Optimizer
Status: No Feedback
Severity: 1
OS: Linux (linux redhat 9)
Version: mysql 5
]]> Wed, 13 Apr 2005 12:46:55 +0000 Server: Optimizer http://bugs.mysql.com/11413 #11413: Merge Tables, Analize Table and Optomizer http://bugs.mysql.com/bug.php?id=11413 Submitted by: Nick Meanley
Category: Server: Optimizer
Status: No Feedback
Severity: 3
OS: Linix
Version: 4.1.10
]]> Fri, 17 Jun 2005 11:48:45 +0000 Server: Optimizer http://bugs.mysql.com/11606 #11606: Duplicate key error in SELECT query http://bugs.mysql.com/bug.php?id=11606 Submitted by: Aron Steg
Category: Server: Optimizer
Status: No Feedback
Severity: 2
OS: Linux (Fedora Core 2)
Version: 4.1.11-standard-log
]]> Tue, 28 Jun 2005 09:53:51 +0000 Server: Optimizer http://bugs.mysql.com/11608 #11608: Explain select gives two different output, which makes optimisation difficult http://bugs.mysql.com/bug.php?id=11608 Submitted by: Sumit Kumar Roy
Category: Server: Optimizer
Status: No Feedback
Severity: 2
OS: Linux (Linux Kernal 2.24)
Version: 4.0.17
]]> Tue, 28 Jun 2005 10:58:58 +0000 Server: Optimizer http://bugs.mysql.com/11945 #11945: Index not used in 'OUTER JOIN b ON (a.a = b.a OR a.a = b.b)' http://bugs.mysql.com/bug.php?id=11945 Submitted by: Ken Johanson
Category: Server: Optimizer
Status: No Feedback
Severity: 2
OS: Linux (Linux /Fedora 3)
Version: 5.0.7
]]> Thu, 14 Jul 2005 16:23:17 +0000 Server: Optimizer http://bugs.mysql.com/13798 #13798: incorrect type for an astext(linestring) result set column http://bugs.mysql.com/bug.php?id=13798 Submitted by: Vladimir Kolesnikov
Category: Server: Optimizer
Status: No Feedback
Severity: 3
OS: Linux (Linux)
Version: 5.0.16-BK
]]> Thu, 06 Oct 2005 10:44:44 +0000 Server: Optimizer http://bugs.mysql.com/13917 #13917: 5.0 is slower than 4.1 on many queries http://bugs.mysql.com/bug.php?id=13917 Submitted by: Vadim Tkachenko
Category: Server: Optimizer
Status: No Feedback
Severity: 5
OS: Linux (Linux, RedHat AS 3)
Version: 5.0.14-rc, 5.0.27
]]> Tue, 11 Oct 2005 08:54:38 +0000 Server: Optimizer http://bugs.mysql.com/15076 #15076: index handeled incorrectly if part of a composite index is used http://bugs.mysql.com/bug.php?id=15076 Submitted by: Daniel Kinzler
Category: Server: Optimizer
Status: No Feedback
Severity: 3
OS: pc-solaris2.10 (i386)
Version: 5.0.15-GA
]]> Sun, 20 Nov 2005 01:39:37 +0000 Server: Optimizer http://bugs.mysql.com/21348 #21348: Memory storage engine poor performance relative to 4.1.20 and HASH vs BTREE http://bugs.mysql.com/bug.php?id=21348 Submitted by: Edgar Scrase
Category: Server: Optimizer
Status: No Feedback
Severity: 5
OS: Windows (Windows)
Version: 5.0.21
]]> Sun, 30 Jul 2006 10:37:09 +0000 Server: Optimizer http://bugs.mysql.com/21486 #21486: No index merge for ENUM columns http://bugs.mysql.com/bug.php?id=21486 Submitted by: Thomas Auge
Category: Server: Optimizer
Status: No Feedback
Severity: 2
OS: Linux (Linux)
Version: 5.0.22
]]> Mon, 07 Aug 2006 16:57:34 +0000 Server: Optimizer http://bugs.mysql.com/22779 #22779: "order by" clause performance.. http://bugs.mysql.com/bug.php?id=22779 Submitted by: Dorin Manoli
Category: Server: Optimizer
Status: No Feedback
Severity: 5
OS: Windows (Windows 2000 server)
Version: Ver 14.12 Distrib 5.0.24a
]]> Thu, 28 Sep 2006 12:18:58 +0000 Server: Optimizer http://bugs.mysql.com/25459 #25459: InnoDB prefers table scan over using primary key http://bugs.mysql.com/bug.php?id=25459 Submitted by: Arjen Lentz
Category: Server: Optimizer
Status: No Feedback
Severity: 3
OS: Any (any)
Version: 5.0
]]> Mon, 08 Jan 2007 02:39:29 +0000 Server: Optimizer http://bugs.mysql.com/25744 #25744: Nested Selects Crashing MySQL http://bugs.mysql.com/bug.php?id=25744 Submitted by: Sean Gum
Category: Server: Optimizer
Status: No Feedback
Severity: 1
OS: Linux (CentOs 4.4)
Version: 5.0.22
]]> Mon, 22 Jan 2007 00:33:58 +0000 Server: Optimizer http://bugs.mysql.com/26224 #26224: optimizer ignores keys in stored procedures http://bugs.mysql.com/bug.php?id=26224 Submitted by: Mark Kubacki
Category: Server: Optimizer
Status: No Feedback
Severity: 2
OS: Linux (GNU/Linux)
Version: 5.1.22_rc
]]> Fri, 09 Feb 2007 15:21:26 +0000 Server: Optimizer http://bugs.mysql.com/26339 #26339: Query hangs / State: statistics http://bugs.mysql.com/bug.php?id=26339 Submitted by: Dimitri Roschkowski
Category: Server: Optimizer
Status: No Feedback
Severity: 2
OS: Any (2.6.19.2-grsec Linux)
Version: 5.0.26, 5.0.41
]]> Tue, 13 Feb 2007 19:45:26 +0000 Server: Optimizer http://bugs.mysql.com/26915 #26915: Slow quering due to optimizer choosing incorrect index utilisation http://bugs.mysql.com/bug.php?id=26915 Submitted by: Jacques
Category: Server: Optimizer
Status: No Feedback
Severity: 5
OS: Linux (Redhat Linux RHEL4)
Version: 5.0.27
]]> Wed, 07 Mar 2007 11:54:17 +0000 Server: Optimizer http://bugs.mysql.com/26943 #26943: 64bit mysql 5 hangs on removing duplicate after query distinct,group by,order by http://bugs.mysql.com/bug.php?id=26943 Submitted by: Vic Parat
Category: Server: Optimizer
Status: No Feedback
Severity: 2
OS: Linux (linux(centos 4.4 server))
Version: 5.0.27, 5.0.22, 5.0.68
]]> Wed, 07 Mar 2007 23:57:43 +0000 Server: Optimizer http://bugs.mysql.com/27043 #27043: Slow Response when many people select one table in same time http://bugs.mysql.com/bug.php?id=27043 Submitted by: hady ginanjar
Category: Server: Optimizer
Status: No Feedback
Severity: 3
OS: Windows (windows)
Version: 4.0.13
]]> Mon, 12 Mar 2007 11:45:22 +0000 Server: Optimizer http://bugs.mysql.com/27316 #27316: LEFT JOIN fails to use INDEX in 4.1.2 (used to work in 3.23) http://bugs.mysql.com/bug.php?id=27316 Submitted by: Dobromir Radichkov
Category: Server: Optimizer
Status: No Feedback
Severity: 3
OS: Linux (Linux)
Version: 4.1.2
]]> Wed, 21 Mar 2007 04:20:15 +0000 Server: Optimizer http://bugs.mysql.com/27467 #27467: MAX don't optimized. http://bugs.mysql.com/bug.php?id=27467 Submitted by: Mikhail Strizhov
Category: Server: Optimizer
Status: No Feedback
Severity: 3
OS: Any
Version: 5.1.16-beta-log
]]> Tue, 27 Mar 2007 10:37:15 +0000 Server: Optimizer http://bugs.mysql.com/27479 #27479: ORDER BY performance regression http://bugs.mysql.com/bug.php?id=27479 Submitted by: Steven Wagner
Category: Server: Optimizer
Status: No Feedback
Severity: 5
OS: Linux (Linux 2.6)
Version: 5.0.37
]]> Tue, 27 Mar 2007 18:12:51 +0000 Server: Optimizer http://bugs.mysql.com/28612 #28612: Optimizer does not use index for BETWEEN in a JOIN condition http://bugs.mysql.com/bug.php?id=28612 Submitted by: Ondra Zizka
Category: Server: Optimizer
Status: No Feedback
Severity: 5
OS: Any
Version: 5.0.37
]]> Wed, 23 May 2007 07:30:34 +0000 Server: Optimizer http://bugs.mysql.com/29011 #29011: Query optimizaion error with NDB Engine http://bugs.mysql.com/bug.php?id=29011 Submitted by: Brian Moon
Category: Server: Optimizer
Status: No Feedback
Severity: 2
OS: Linux (Genroo)
Version: 5.0.38, 5.1
]]> Mon, 11 Jun 2007 02:57:32 +0000 Server: Optimizer http://bugs.mysql.com/29286 #29286: Problems with index when using concat function for joining http://bugs.mysql.com/bug.php?id=29286 Submitted by: Eugen Borshch
Category: Server: Optimizer
Status: No Feedback
Severity: 3
OS: Linux
Version: >=4.1
]]> Thu, 21 Jun 2007 21:02:41 +0000 Server: Optimizer http://bugs.mysql.com/29857 #29857: Optimizer is getting confused by extra WHERE condition http://bugs.mysql.com/bug.php?id=29857 Submitted by: Gabriel Tataranu
Category: Server: Optimizer
Status: No Feedback
Severity: 3
OS: Linux (64 bit, gcc 4.1.1)
Version: 5.0.41, 5.0.45, 5.0.67
]]> Tue, 17 Jul 2007 21:11:34 +0000 Server: Optimizer http://bugs.mysql.com/30180 #30180: Getting broken tmp key file on complex query http://bugs.mysql.com/bug.php?id=30180 Submitted by: Christian Vest Hansen
Category: Server: Optimizer
Status: No Feedback
Severity: 2
OS: Any
Version: 5.0.37-community
]]> Wed, 01 Aug 2007 14:49:04 +0000 Server: Optimizer http://bugs.mysql.com/30330 #30330: NOT IN faster than equals(=) http://bugs.mysql.com/bug.php?id=30330 Submitted by: Naveen JP
Category: Server: Optimizer
Status: No Feedback
Severity: 5
OS: Linux (Gentoo)
Version: 4.1.12-log
]]> Thu, 09 Aug 2007 11:35:36 +0000 Server: Optimizer http://bugs.mysql.com/30686 #30686: inappropriate LIMIT behavior on partitioned single-table query sorted by PK http://bugs.mysql.com/bug.php?id=30686 Submitted by: Theodore Dubro
Category: Server: Optimizer
Status: No Feedback
Severity: 2
OS: Windows ((via TCP/IP))
Version: 5.1.20-beta-community-nt-debug, 5.1.30
]]> Wed, 29 Aug 2007 09:37:38 +0000 Server: Optimizer http://bugs.mysql.com/30883 #30883: Dependent Sub Queries Very Slow http://bugs.mysql.com/bug.php?id=30883 Submitted by: Eugene Lee
Category: Server: Optimizer
Status: No Feedback
Severity: 5
OS: Linux (CentOS 4.3)
Version: 5.0.27
]]> Fri, 07 Sep 2007 05:28:41 +0000 Server: Optimizer