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/27452 #27452: Correlated subquery produces inefficient optimizer plan for INFORMATION_SCHEMA http://bugs.mysql.com/bug.php?id=27452 Submitted by: Jay Pipes
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux
Version: 5.0.40-BK, 5.0.24a-debian-log, 5.1.31-bzr, 6.0.7-alpha, 6.0.9-bzr
]]> Mon, 26 Mar 2007 17:35:17 +0000 Server: Optimizer http://bugs.mysql.com/35165 #35165: Logging to table is slow for large queries http://bugs.mysql.com/bug.php?id=35165 Submitted by: Davi Arnaut
Category: Server: CSV
Status: Verified
Severity: 5
OS: Any
Version: 5.1
]]> Sat, 08 Mar 2008 17:48:33 +0000 Server: CSV http://bugs.mysql.com/38397 #38397: select distinct + order by desc is executed inefficiently http://bugs.mysql.com/bug.php?id=38397 Submitted by: Vladimir Kolesnikov
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.1.26, 5.0.62
]]> Sun, 27 Jul 2008 20:13:19 +0000 Server: Optimizer http://bugs.mysql.com/40367 #40367: SHOW on a broad view is taking too long http://bugs.mysql.com/bug.php?id=40367 Submitted by: Andreas Streichardt
Category: Server: I_S
Status: Verified
Severity: 3
OS: Any
Version: 5.1.28, 5.1.29, 5.0, 5.1 bzr
]]> Tue, 28 Oct 2008 08:55:00 +0000 Server: I_S http://bugs.mysql.com/42705 #42705: Reduce malloc/free during query lifecycle. http://bugs.mysql.com/bug.php?id=42705 Submitted by: Neel Nadgir
Category: Server: General
Status: Verified
Severity: 3
OS: Any
Version: 5.1.30
]]> Mon, 09 Feb 2009 16:37:22 +0000 Server: General http://bugs.mysql.com/44201 #44201: Performance problem with View http://bugs.mysql.com/bug.php?id=44201 Submitted by: Akiko Marti
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.1.32, 5.1.35-bzr, 6.0.11-bzr, 5.0, 5.6.99
]]> Fri, 10 Apr 2009 03:04:52 +0000 Server: Optimizer http://bugs.mysql.com/45424 #45424: UPDATE statement cause full table scan ? http://bugs.mysql.com/bug.php?id=45424 Submitted by: Lance Li
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Linux
Version: 5.0.51a, 5.0.77 and 5.1.34, 5.1, 6.0 bzr
]]> Wed, 10 Jun 2009 06:58:00 +0000 Server: Optimizer http://bugs.mysql.com/46376 #46376: Optimizer choose wrong index even when where clause and order-by are covered http://bugs.mysql.com/bug.php?id=46376 Submitted by: T C
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Windows (XP)
Version: 5.0.85, 5.1.36, 5.1.38, 5.1.39
]]> Fri, 24 Jul 2009 17:05:25 +0000 Server: Optimizer http://bugs.mysql.com/46648 #46648: SQL_CALC_FOUND_ROWS kills performance with ORDER BY and LIMIT http://bugs.mysql.com/bug.php?id=46648 Submitted by: Jille Timmermans
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (2.6.28.7)
Version: 5.1.32, 4.1, 5.0, 5.1, azalea bzr
]]> Tue, 11 Aug 2009 11:41:04 +0000 Server: Optimizer http://bugs.mysql.com/48359 #48359: ALTER TABLE xx COMMENT - locks large tables http://bugs.mysql.com/bug.php?id=48359 Submitted by: Colin Mutter
Category: Server: Cluster
Status: In progress
Severity: 3
OS: Linux (RHEL 4)
Version: mysql-5.1-telco-7.1
]]> Tue, 27 Oct 2009 19:24:18 +0000 Server: Cluster http://bugs.mysql.com/47884 #47884: MySQL 5.1.39 failed to use index http://bugs.mysql.com/bug.php?id=47884 Submitted by: Dinh Pham
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Linux (Linux web2 2.6.18-92.1.18.el5.028stab060.8 #1 SMP Mon Feb 9 21:44:50 MSK 2009 x86_64)
Version: 5.1.39, 5.1.44, 5.5.99
]]> Wed, 07 Oct 2009 03:24:19 +0000 Server: Optimizer http://bugs.mysql.com/21978 #21978: 'flush_time' value set for 1800 sec. on Non Win9x/Me installs by default http://bugs.mysql.com/bug.php?id=21978 Submitted by: Matthew Montgomery
Category: Server: Options
Status: Verified
Severity: 3
OS: Windows (Windows 2000)
Version: 4.0.18, 5.0, 6.0.10, 5.5
]]> Fri, 01 Sep 2006 22:13:27 +0000 Server: Options http://bugs.mysql.com/50367 #50367: REPLACE has quadradic computational complexity on windows server (but not linux) http://bugs.mysql.com/bug.php?id=50367 Submitted by: Morten Kloster
Category: Server: General
Status: Verified
Severity: 5
OS: Any (MS Windows 32 bits, Mac)
Version: 5.1.42, 5.1 bzr
]]> Fri, 15 Jan 2010 14:12:01 +0000 Server: General http://bugs.mysql.com/55979 #55979: Key not used if IN() list contains mix of strings and integers http://bugs.mysql.com/bug.php?id=55979 Submitted by: Bruno Barberi Gnecco
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Linux
Version: 5.1.39
]]> Fri, 13 Aug 2010 22:05:55 +0000 Server: Optimizer http://bugs.mysql.com/56924 #56924: Memory leak? Possibly not a bug. http://bugs.mysql.com/bug.php?id=56924 Submitted by: gediminas gedusenka
Category: MySQL Workbench: SQL Editor
Status: Verified
Severity: 2
OS: Linux (Ubuntu 10.04)
Version: 5.2.28
]]> Wed, 22 Sep 2010 11:26:35 +0000 MySQL Workbench: SQL Editor http://bugs.mysql.com/56965 #56965: mysqldump poor performance with large number of tables http://bugs.mysql.com/bug.php?id=56965 Submitted by: Peter Surda
Category: Client: mysqldump
Status: Verified
Severity: 3
OS: Linux (2.6.18-164.6.1.el5 #1 SMP, CentOS 5.5)
Version: 5.1.44
]]> Thu, 23 Sep 2010 09:22:41 +0000 Client: mysqldump http://bugs.mysql.com/58008 #58008: wrong datatype (blob) in the resultset if the string is larger than 512 bytes http://bugs.mysql.com/bug.php?id=58008 Submitted by: Alexander Rubin
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.1, 5.0
]]> Fri, 05 Nov 2010 09:38:09 +0000 Server: Optimizer http://bugs.mysql.com/58928 #58928: "not exists" optimization not applied if relevant table is not single inner one http://bugs.mysql.com/bug.php?id=58928 Submitted by: Guilhem Bichot
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.1-bugteam
]]> Tue, 14 Dec 2010 20:58:53 +0000 Server: Optimizer http://bugs.mysql.com/59727 #59727: LRU search can be inefficient with compression http://bugs.mysql.com/bug.php?id=59727 Submitted by: Inaam Rana
Category: Server: InnoDB
Status: Verified
Severity: 5
OS: Any
Version: 5.1 plugin, 5.5, 5.6
]]> Tue, 25 Jan 2011 21:36:11 +0000 Server: InnoDB http://bugs.mysql.com/59557 #59557: MySQL uses order of fields in GROUP BY when ORDER BY NULL is specified http://bugs.mysql.com/bug.php?id=59557 Submitted by: Shlomo Priymak
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 5.1, 5.5
]]> Mon, 17 Jan 2011 15:26:08 +0000 Server: Optimizer http://bugs.mysql.com/60087 #60087: Patch: Minimize InnoDB I/O load by adding a prefetch stage http://bugs.mysql.com/bug.php?id=60087 Submitted by: Lenz Grimmer
Category: Server: InnoDB
Status: Verified
Severity: 3
OS: Any
Version: 5.5
]]> Thu, 10 Feb 2011 13:14:51 +0000 Server: InnoDB http://bugs.mysql.com/60345 #60345: trim trailing spaces processes data only byte wise (the continue of bug14637) http://bugs.mysql.com/bug.php?id=60345 Submitted by: Linhai Song
Category: Server
Status: Verified
Severity: 5
OS: Any
Version: 5.1.55 6.0.11
]]> Fri, 04 Mar 2011 17:11:45 +0000 Server http://bugs.mysql.com/60348 #60348: trim trailing spaces processes data only byte wise (continue of bug14637 (2)) http://bugs.mysql.com/bug.php?id=60348 Submitted by: Linhai Song
Category: Server
Status: Verified
Severity: 5
OS: Any
Version: 5.1.55
]]> Fri, 04 Mar 2011 20:14:41 +0000 Server http://bugs.mysql.com/60349 #60349: trim beginning spaces processes data only byte wise (continue of bug14637 (3)) http://bugs.mysql.com/bug.php?id=60349 Submitted by: Linhai Song
Category: Server
Status: Verified
Severity: 5
OS: Any
Version: 5.1.55
]]> Fri, 04 Mar 2011 21:20:06 +0000 Server http://bugs.mysql.com/60351 #60351: trim same character processes data only byte wise (continue of bug14637 (4)) http://bugs.mysql.com/bug.php?id=60351 Submitted by: Linhai Song
Category: Server
Status: Verified
Severity: 5
OS: Any
Version: 5.1.55
]]> Fri, 04 Mar 2011 22:15:10 +0000 Server http://bugs.mysql.com/66563 #66563: reduce the number of redundant calls to btr_cur_optimistic_insert() http://bugs.mysql.com/bug.php?id=66563 Submitted by: Nizameddin Ordulu
Category: Server: InnoDB Plugin
Status: Verified
Severity: 5
OS: Any
Version: 5.1,5.6
]]> Tue, 28 Aug 2012 05:37:03 +0000 Server: InnoDB Plugin http://bugs.mysql.com/69118 #69118: Wasted work in method get_table_structure() http://bugs.mysql.com/bug.php?id=69118 Submitted by: Po-Chun Chang
Category: Client
Status: Verified
Severity: 5
OS: Any
Version: 5.6, 5.7
]]> Thu, 02 May 2013 02:28:15 +0000 Client http://bugs.mysql.com/68572 #68572: FEDERATED using SHOW TABLE STATUS causes performance problems for InnoDB tables http://bugs.mysql.com/bug.php?id=68572 Submitted by: Przemysław Ołtarzewski
Category: Server: Federated
Status: Verified
Severity: 3
OS: Any
Version: 5.5.25a, 5.5.31
]]> Tue, 05 Mar 2013 10:57:18 +0000 Server: Federated http://bugs.mysql.com/64340 #64340: race on no_flush event during buf_flush_free_margin http://bugs.mysql.com/bug.php?id=64340 Submitted by: Mark Callaghan
Category: Server: InnoDB Plugin
Status: Verified
Severity: 5
OS: Any
Version: 5.1.52, 5.1.61
]]> Wed, 15 Feb 2012 14:07:03 +0000 Server: InnoDB Plugin http://bugs.mysql.com/75504 #75504: btr_search_guess_on_hash makes found block young twice? http://bugs.mysql.com/bug.php?id=75504 Submitted by: Laurynas Biveinis
Category: Server: InnoDB
Status: Verified
Severity: 5
OS: Any
]]> Wed, 14 Jan 2015 12:52:54 +0000 Server: InnoDB