Showing all 804 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version OS CPU Summary
915892018-07-10
9:44
2018-07-10
9:51
MySQL ServerClosed
(1012 days)
S35.6.33-79.0CentOS (6.3)x86Invalid primary key improves query performance
603452011-03-04
17:11
2013-01-15
15:25
MySQL ServerVerified
(3014 days)
S55.1.55 6.0.11AnyAnytrim trailing spaces processes data only byte wise (the continue of bug14637)
20502003-12-08
16:07
2004-07-09
20:54
MySQL ServerClosed
(6126 days)
S24.1.1alphaMicrosoft Windows (w2k)Any10 to 1 performance drop with server 4.1.1
39042004-05-27
2:07
2004-06-09
23:37
MySQL ServerClosed
(6156 days)
S24.1.2Linux (Linux)AnyCOUNT DISTINCT performance anomaly in 4.1
41142004-06-12
2:27
2004-08-24
6:49
MySQL ServerClosed
(6080 days)
S24.1.2Any (all)Anyorder by - limit optimization is broken for "range" access type.
66352004-11-15
12:47
2005-03-08
18:36
MySQL ServerClosed
(5884 days)
S24.1.7Linux (Linux x86)Anybug in full-text search
71032004-12-08
12:58
2004-12-08
13:09
MySQL ServerDuplicate
(5974 days)
S15.0.2Microsoft Windows (Windows 98 SE)Anymysql 5.0.2 mysqld crashes on describe any_table;
167002006-01-21
13:13
2006-01-21
13:51
MySQL ServerDuplicate
(5565 days)
S35.0.18FreeBSD (FreeBSD 6.0-RELEASE-p3)Anyoptimizer marks subquery DEPENDENT though it's not
229432006-10-03
15:10
2007-02-21
3:26
MySQL ServerClosed
(5169 days)
S2allMicrosoft Windows (Windows)Anysyscall pruning in libmysql
252322006-12-21
13:24
2007-01-16
8:44
MySQL ServerClosed
(5205 days)
S25.0.30Linux (Linux AMD64 - SLES9-SP3 2.6.17)AnyMySQL hangs in FUTEX_WAIT
290312007-06-11
21:42
2020-05-03
20:45
MySQL ServerDuplicate
(5023 days)
S25.0.44-BK, 5.0.42LinuxAnyComparison of DATE with DATETIME not using indexes correctly
339482008-01-20
15:16
2011-02-16
23:43
MySQL ServerClosed
(4278 days)
S55.1.22Linux (rhas5)Anyperformance issue when using sysbench benchmark on a multiple-core system.
471262009-09-04
9:18
2011-02-16
23:44
MySQL ServerClosed
(4059 days)
S35.1AnyAnyequal flag values causing unexpected behaviour
587662010-12-06
22:48
2014-01-29
0:51
MySQL ServerClosed
(2635 days)
S25.5.8Any (Linux)AnyServer binary was compiled without fast-mutexes
610602011-05-04
16:43
2011-05-04
19:48
MySQL ServerDuplicate
(3636 days)
S3AllAnyAnyMixed direction indexes
651572012-04-30
17:39
2012-05-03
8:13
MySQL ServerDuplicate
(3271 days)
S55.1.53AnyAnyset read_only=1|0 kills performance
815612016-05-24
7:22
2016-05-28
5:46
MySQL ServerClosed
(1785 days)
S15.7.12AnyAnyMySQL 5.7 is 11% to 37% slower then 5.6 when using 4 threads
182152006-03-14
8:52
2006-04-22
4:17
MySQL ServerClosed
(5474 days)
S24.1.18Linux (Linux)AnyLong latency in connection establish
799512016-01-13
12:58
2017-06-04
11:35
MySQL ServerClosed
(1413 days)
S25.7.10Microsoft WindowsAnyLarge table queries are very slow compared to 5.6
84752005-02-12
14:19
2005-03-08
0:35
MySQL ServerClosed
(5884 days)
S34.1Any (all)AnyIf multi-query: query does not get into slow query log if it's not last
142752005-10-24
21:41
2005-10-24
23:53
MySQL ServerClosed
(5654 days)
S34.0.25Linux (Fedora Core 4 64bit)Anyspitting out the wrong slow logs
603482011-03-04
20:14
2013-01-15
15:25
MySQL ServerVerified
(3014 days)
S55.1.55AnyAnytrim trailing spaces processes data only byte wise (continue of bug14637 (2))
375362008-06-19
22:34
2011-02-16
23:43
MySQL ServerClosed
(3957 days)
S55.1.24Solaris (Nevada Bld 87 on X86)AnyThread scheduling causes performance degradation at low thread count
147802005-11-09
8:44
2005-12-09
0:23
MySQL ServerClosed
(5608 days)
S34.1Linux (linux)Anymemory leak for mysql 4.1.14 with openssl enabled
389002008-08-19
20:14
2011-02-16
23:43
MySQL ServerDuplicate
(4622 days)
S25.0.66aAnyAnymysql_insert_id() and possibly last_insert_id() incorrect
231352006-10-10
12:10
2006-10-10
13:39
MySQL ServerDuplicate
(5303 days)
S55.0.19Linux (Linux)AnySlow views performance
233702006-10-17
13:32
2006-10-20
9:11
MySQL ServerDuplicate
(5293 days)
S1mysql-5.1.11-beta-win32 and 5.1.26Linux (Linux and Win)AnyBad nested group by performance
241692006-11-10
7:41
2007-02-28
7:26
MySQL ServerClosed
(5162 days)
S15.1.12, 5.1.14Linux (Linux (Debian/Sarge))AnyDramatic speed loss when going from 5.1.11 to 5.1.12 (or to 5.0.26)
877562017-09-14
12:55
2017-10-02
11:17
MySQL ServerClosed
(1293 days)
S55.6AnyAnyJOINS and SUBQUERIES: huge performance difference between MySQL 5.5 and 5.6
26832004-02-09
6:48
2004-02-10
14:42
MySQL ServerClosed
(6276 days)
S34.1.1aNT 4 Server SP 6aAnyPoor Performance on a Multi-Homed System
137622005-10-05
7:37
2007-12-04
21:17
MySQL ServerClosed
(4883 days)
S34.1.14Linux (linux)AnySHOW CREATE TABLE slowdown with InnoDB
359182008-04-08
23:17
2014-02-25
19:54
MySQL ServerDuplicate
(2608 days)
S55.1.24LinuxAnymysql-bench: slowdown for create table in 5.1.24 vs 5.0.58&5.1.23
83672005-02-08
9:46
2005-06-22
0:05
MySQL ServerClosed
(5778 days)
S3AllAny (All)Anyslow log doesn't gives complete information about prepared statements
107372005-05-19
11:38
2005-05-19
13:57
MySQL ServerDuplicate
(5812 days)
S24.1.12Linux (Linux)AnyPS API queries in --log-slow-queries are unusable
164932006-01-13
19:21
2012-05-18
20:19
MySQL ServerDuplicate
(5408 days)
S35.0.19-BKprobably allAnySlow query log logs SHOW statements
173682006-02-14
10:04
2006-05-04
15:49
MySQL ServerClosed
(5462 days)
S25.1.6/5.1.7 BKMicrosoft Windows (Windows XP)AnyGeneral log and slow query log don't work
402632008-10-22
18:41
2008-10-22
18:47
MySQL ServerDuplicate
(4560 days)
S35.0+AnyAnyServer default log filenames do not use hostname
104802005-05-09
15:11
2005-06-16
7:44
MySQL ServerClosed
(5784 days)
S24.1.11-standard-logLinux (Linux Redhat Fedora Core 1)AnySlow queries
609612011-04-23
18:59
2014-03-28
19:39
MySQL ServerClosed
(3257 days)
S25.6, 5.5, 5.1AnyAnyshow tables very slow when not in system disk cache
7962003-07-06
7:35
2003-07-06
12:36
MySQL ServerClosed
(6495 days)
S34.1Any (any)Anymemory leak in group_concat
26132004-02-02
8:20
2004-06-16
16:18
MySQL ServerClosed
(6149 days)
S34.0 Anymemory leak in drop database with raid
476232009-09-24
16:20
2011-02-16
23:44
MySQL ServerDuplicate
(4014 days)
S15.0.44, 5.0.85Linux (Centos)AnySuspected memory/temporary file leak
563822010-08-30
19:11
2011-02-16
23:44
MySQL ServerClosed
(3839 days)
S25.1.50AnyAnyvalgrind leak warning from main.loaddata
1001142020-07-05
8:03
2020-07-13
12:47
MySQL ServerClosed
(280 days)
S25.7.25CentOS (7.6)Anybluk_insert may lead to memory leak
603492011-03-04
21:20
2013-01-15
15:25
MySQL ServerVerified
(3014 days)
S55.1.55AnyAnytrim beginning spaces processes data only byte wise (continue of bug14637 (3))
603512011-03-04
22:15
2013-01-15
15:27
MySQL ServerVerified
(3014 days)
S55.1.55AnyAnytrim same character processes data only byte wise (continue of bug14637 (4))
35312004-04-21
19:09
2004-04-22
8:20
MySQL ServerClosed
(6204 days)
S25.0.0 & 4.1.1a-alphaMicrosoft Windows (Windows XP)AnyPrepared statement memory leak while connection is open
19522003-11-25
13:49
2003-12-11
17:26
MySQL ServerClosed
(6337 days)
S3AnyAny (Any)AnySHOW TABLE STATUS very slow w/large number of tables
44972004-07-10
1:21
2004-08-09
23:15
MySQL ServerClosed
(6095 days)
S34.0.21Linux (linux)AnySerious regression if disk based TMP table is used.
99682005-04-18
9:31
2005-08-06
23:23
MySQL ServerClosed
(5733 days)
S15.0Any (all)Anyslow query log contains useless entries
122402005-07-28
14:04
2006-10-20
17:46
MySQL ServerClosed
(5293 days)
S34.1.13Microsoft Windows (Windows\Linux)AnyRows Examined in Slow Log showing incorrect number?
128312005-08-26
13:21
2008-04-02
13:50
MySQL ServerClosed
(4763 days)
S34.1.13/BK 4.1 sourceAny (5.4)Anylong_query_time is flawed because it is an integer
157742005-12-15
13:39
2005-12-16
10:18
MySQL ServerClosed
(5601 days)
S15.0Microsoft Windows (Windows XP PRO Sp2)Anyslow / increase memory / crashing / OS freezing
186692006-03-30
22:22
2006-05-31
1:18
MySQL ServerClosed
(5435 days)
S35.0,5.1Linux (Linux)AnySession COM_STATISTICS breaks mysqladmin status
394612008-09-15
20:54
2008-10-20
13:05
MySQL ServerClosed
(4562 days)
S35.0.60LinuxAnySlow Query
618182011-07-11
8:22
2011-07-11
9:03
MySQL ServerClosed
(3568 days)
S25.1.57Linux (debian 6 64 bit)Anydebian 6 64 bit + mysql 5.1.57 insert innodb very very slow
765852015-04-03
10:07
2018-02-19
14:36
MySQL ServerClosed
(1153 days)
S35.6.27, 5.7.21AnyAnyRuntime changes to `long_query_time` are ignored.
963402019-07-26
12:13
2020-05-16
3:32
MySQL ServerClosed
(507 days)
S38.0.17AnyAnySlow startup for mysql 8.0 with many tables due to the tablespace files scan
16972003-10-29
3:45
2003-12-13
3:36
MySQL ServerClosed
(6335 days)
S24.0.16Any (all)AnyDELETE ... WHERE ... ORDER BY ... wrong execution leads to very bad performance
4852003-05-23
12:38
2003-06-05
10:38
MySQL ServerDuplicate
(6526 days)
S24.1Microsoft Windows (Windows ONLY)AnyRemote Performance Issue Windows in 4.1
59692004-10-08
5:49
2004-10-10
10:52
MySQL ServerClosed
(6033 days)
S15.0.2Linux (Linux)AnyPerformance Problem with updatable VIEW
126622005-08-19
2:20
2005-08-19
2:41
MySQL ServerDuplicate
(5720 days)
S25.0.9FreeBSD (FreeBSD 5.4)AnyPoor View Performance
400062008-10-13
15:04
2008-10-22
10:56
MySQL ServerClosed
(4560 days)
S55.0.18AnyAnyPerformance depends on functions used?
429082009-02-17
1:20
2011-02-16
23:43
MySQL ServerClosed
(3814 days)
S55.0.74, 5.0.76, 5.0.77Linux (SLES 10)AnyPerformance degradation on SELECT_DISTINCT_RANGES (as in Sysbench)
460852009-07-09
13:49
2011-02-16
23:44
MySQL ServerDuplicate
(4238 days)
S35.4.2 (summit), mysql-trunkLinuxAnyValgrind warnings (InnoDB code) in test rpl_trigger
545182010-06-15
14:25
2012-10-15
13:31
MySQL ServerClosed
(3106 days)
S55.0.22Microsoft Windows (Vista)AnyVery bad performance with subselect
668652012-09-19
3:18
2017-01-25
14:20
MySQL ServerClosed
(1543 days)
S35.6AnyAnyPerformance degradation in MySQL 5.6
710412013-11-29
18:39
2017-09-05
1:11
MySQL ServerClosed
(1320 days)
S35.6AnyAnyPlease, document every instrument in P_S.setup_instruments in details
751082014-12-04
19:35
2015-01-15
19:26
MySQL ServerClosed
(2284 days)
S26.2.3Microsoft Windows (Microsoft Windows 7 Home Premium Service Pack 1)AnyNo Connection to MySQL server. Port 3306 not available.
761172015-03-03
6:56
2015-03-04
7:40
MySQL ServerDuplicate
(2236 days)
S55.6.16-logMicrosoft WindowsAnyIndex cardinality not being updated when the data is changed
100642005-04-21
15:39
2007-11-09
9:27
MySQL ServerClosed
(4908 days)
S13.1Linux (RedHat 4)Anyudf deinit not called when using PreparedStatements
101072005-04-23
0:53
2005-04-28
15:29
MySQL ServerClosed
(5833 days)
S35.0-bk AnyMemory leak in view over subquery
112472005-06-10
15:14
2005-08-18
21:01
MySQL ServerClosed
(5721 days)
S35.0Any (Any)AnyStored procedures: Function calls in long loops leak memory
134712005-09-25
17:13
2005-09-26
9:52
MySQL ServerClosed
(5682 days)
S25.0.14-rc, tadays pullLinux (Linux)AnyMemory leak in ha_tina
181742006-03-13
0:29
2006-03-13
5:56
MySQL ServerDuplicate
(5514 days)
S25.0.19-standard-log/Oficial tarballLinux (Debian/Gnu ia32/2.4.32)AnyMemory leak on update with big NOT IN ().
197392006-05-11
20:10
2006-05-18
23:28
MySQL ServerClosed
(5448 days)
S35.0.20Microsoft Windows (Windows XP)Anystored function call in primary select causes memory leak
197982006-05-14
0:16
2006-05-23
8:02
MySQL ServerClosed
(5443 days)
S25.1.10-preLinux (Red Hat RHAS4 x86 x86_64)AnyTest 'func_encrypt' leaks memory when using yaSSL
253962007-01-03
20:26
2007-01-24
20:28
MySQL ServerClosed
(5197 days)
S15.1 AnyValgrind leak in closecon_handlerton
267502007-03-01
14:52
2007-03-07
21:37
MySQL ServerClosed
(5155 days)
S15.0 Anyvalgrind leak in sp_head
4162003-05-11
12:47
2003-05-28
4:18
MySQL ServerDuplicate
(6534 days)
S24.1.0-alphaMicrosoft Windows (Windows XP and NT)AnyServer slow if client not on localhost
4762003-05-22
2:51
2003-07-01
5:11
MySQL ServerClosed
(6500 days)
S33.23.56Linux (linux)Any"myisamchk -r" results in loss of index "repair table" restores index
33412004-03-30
21:47
2004-05-10
10:46
MySQL ServerClosed
(6186 days)
S33.23.58; 4.0.18FreeBSD (Free BSD, Windows)AnyNot Optimized Min()
33962004-04-05
16:57
2011-03-29
18:22
MySQL ServerClosed
(3672 days)
S24.1.1Linux (LINUX)AnyA SUB-QUERY IN MYSQL 4.1.1.max.log MAKE SERVER DOWN :_(
37992004-05-17
15:23
2008-09-14
2:34
MySQL ServerClosed
(4598 days)
S34.0.18Microsoft Windows (Windows XP Pro)AnyWinMySQLAdmin shows no server info
58792004-10-04
13:04
2019-11-14
14:00
MySQL ServerClosed
(6038 days)
S34.0Any (Any)AnyFix for Examined_rows in UNION's with 4.0
64832004-11-07
16:36
2004-12-03
3:53
MySQL ServerClosed
(5979 days)
S35.0.2Linux (linux)Anyignored character-set and collation
79392005-01-16
16:33
2005-02-17
17:36
MySQL ServerClosed
(5903 days)
S34.1.9 Any --log-queries-not-using-indexes doesnt apply with 0 or 1 row OR quuery cache
93472005-03-23
4:32
2005-03-24
3:16
MySQL ServerDuplicate
(5868 days)
S11.1.6Microsoft Windows (Windows 2003 Server)AnyCrashes with MySQL server 5.0.2
100312005-04-20
14:11
2005-06-29
20:24
MySQL ServerClosed
(5771 days)
S15.0.5Any (all)AnyView doesn't use index
109312005-05-27
20:54
2005-06-21
11:00
MySQL ServerClosed
(5779 days)
S24.1.xAny (All)AnyHostname cache completely broken in 4.1
146372005-11-04
12:51
2011-02-16
23:43
MySQL ServerClosed
(4060 days)
S55.0-BKAny (any)Anytrim trailing spaces processes data only byte wise
165042006-01-14
13:53
2006-06-02
21:48
MySQL ServerClosed
(5433 days)
S35.0.21Any (*)AnySome of the simplest SELECTs are 1000 times slower in v5 compared to v4
177922006-02-28
16:31
2006-03-01
13:10
MySQL ServerDuplicate
(5526 days)
S15.0.18Linux (RHEL 4)AnySelect with long IN clause cause server to run out of memory.
184162006-03-22
10:48
2006-03-22
12:18
MySQL ServerClosed
(5505 days)
S35.0.18Linux (Linux)AnyRenaming a table looses all triggers
186562006-03-30
16:30
2011-02-16
23:43
MySQL ServerDuplicate
(3765 days)
S55.0.15Linux (Suse 10)AnyUser variable in where subquery causes long delay
198362006-05-16
2:03
2012-05-18
20:19
MySQL ServerDuplicate
(5238 days)
S2allAny (all)AnyDependent subquery in on clause is not optimized effectively.
209862006-07-12
9:01
2008-09-27
11:01
MySQL ServerClosed
(4585 days)
S55.0.21-community-ntMicrosoft Windows (Windows XP)Anyrenaming a column very slow on large tables
210512006-07-13
23:07
2006-08-31
19:29
MySQL ServerClosed
(5343 days)
S35.0.22 AnyRESET QUERY CACHE very slow when query_cache_type=0
245562006-11-23
20:05
2006-12-05
22:51
MySQL ServerClosed
(5247 days)
S25.0.27 Microsoft Windows (Win 2003 server)Anymysqldump --all-databases does not dump all databases
257852007-01-23
15:15
2011-03-29
18:52
MySQL ServerClosed
(3672 days)
S25.1.11 and higherLinux (linux)Anyset timestamp get 5 seconds to return
257862007-01-23
15:20
2011-03-29
18:51
MySQL ServerClosed
(3672 days)
S25.1.11Linux (linux)Anyselect with limit 0 get row scan
292782007-06-21
18:51
2012-05-18
20:19
MySQL ServerDuplicate
(5016 days)
S3AnyAnylog-output should default to FILE for backwards compliance.
412932008-12-08
10:21
2011-02-16
23:43
MySQL ServerVerified
(4386 days)
S25.0 bzr, 5.1AnyAnyuser variables from remote hosts can be considerably slow
413902008-12-11
10:55
2011-02-16
23:43
MySQL ServerVerified
(4510 days)
S23.2, 4.1, 5.0, 5.1, 6.0 bzrLinux (pc-linux-gnu i486)Anymysqlbinlog doesn't properly handle local slow IO
511532010-02-12
21:55
2011-02-16
23:44
MySQL ServerDuplicate
(4062 days)
S25.1.43-0.dotdeb.1Linux (2.6.31-19-generic #56-Ubuntu)Anymysqld/I_S takes hours to finish after boot/restart
214612006-08-06
1:28
2007-07-13
0:37
MySQL Server: Archive storage engineClosed
(5027 days)
S55.0Any (all)AnyLong Varchars created unneeded waste in compression in Archive
267732007-03-01
22:16
2013-03-03
20:45
MySQL Server: Archive storage engineDuplicate
(4020 days)
S15.0.27-maxLinux (Debian 3.1 (kernel 2.6.14.2))AnyPossible Memory Leak with Archive Tables
996942020-05-26
13:06
2020-06-01
15:23
MySQL Server: CharsetsVerified
(320 days)
S58.0AnyAnyImproving performance of my_hash_sort_utf8(mb4)/my_strnncollsp*utf8(mb4)
556062010-07-28
15:25
2015-08-30
17:21
MySQL Server: CharsetsVerified
(2900 days)
S55.1.47, 5.1.50-bzr, 5.5.23, 5.6.11LinuxAnyCharset on ENUMS influencing performance too much
853312017-03-06
19:46
2017-09-27
2:00
MySQL Server: CharsetsClosed
(1298 days)
S35.6, 5.7, etc, 5.6.35AnyAny_characterset specifications have lousy performance for some character sets
387202008-08-11
14:07
2018-01-18
13:11
MySQL Server: CharsetsClosed
(1185 days)
S25.0, 5.1, 6.0 bzrLinux (Etch 4.0(am64 and x86))AnySELECT DISTINCT on multiple attributes containing spaces in UTF8 are slow.
437072009-03-17
16:29
2011-02-16
23:43
MySQL Server: CharsetsVerifiedS36.0.10, 5.6Linux (2.6.9-34.ELsmp #1 SMP Fri Feb 24 16:56:28 EST 2006 x86_64 x86_64 x86_64 GNU/Linux)AnyColumns in general_log and slow_log changed to "longtext" during upgrade
991902020-04-06
11:51
2020-04-06
14:06
MySQL Server: CharsetsVerified
(376 days)
S58.0AnyAnymy_tosort_unicode: unnecessary max_char check while utf8-mb3 processing
607262011-04-01
21:01
2011-04-03
11:54
MySQL Server: CharsetsDuplicate
(3667 days)
S25.5.10Linux (Debian Lenny, Arch Linux, adm64 and x86)AnyFunctions doing implicit int to string conversion called repeatedly slow down
687952013-03-27
12:22
2013-07-30
13:47
MySQL Server: CharsetsClosed
(2818 days)
S35.5.30AnyAnyDatetime field comparisons do not work properly with utf8_unicode_ci collation
845772017-01-20
8:49
2017-08-21
19:47
MySQL Server: CharsetsClosed
(1531 days)
S3AnyAnystrnxfrm runs slower when tailoring rule contains contraction
683662013-02-13
16:03
2018-01-18
13:19
MySQL Server: CharsetsClosed
(1185 days)
S5 5.5.29-0ubuntu0.12.10.1-log for debian-Linux (Ubuntu 12.10)Anyregression: >=mysql-5.4 utf8 collations are marked as not ascii compatible
727152014-05-21
22:39
2014-05-22
8:02
MySQL Server: CharsetsVerified
(2522 days)
S35.6.17AnyAnycharacter set code endianness dependent on CPU type rather than endianness of CP
833192016-10-10
12:44
2017-07-05
15:37
MySQL Server: CharsetsClosed
(1615 days)
S38.0.1AnyAnyPerformance regression when changing character set to utf8mb4
351652008-03-08
17:48
2011-02-16
23:43
MySQL Server: CSVVerified
(4784 days)
S55.1AnyAnyLogging to table is slow for large queries
933942018-11-29
5:46
2018-11-29
14:55
MySQL Server: CSVVerified
(870 days)
S35.7.21AnyAnymemory leak when csv engine has no permission to meta file
984492020-01-31
12:25
2020-03-16
15:02
MySQL Server: Data DictionaryVerified
(439 days)
S58.0.19AnyAnySELECT from I_S.INNODB_COLUMNS is slow in 8.0
1031952021-04-02
9:48
2021-04-13
13:23
MySQL Server: Data DictionaryVerified
(5 days)
S58.0Linux (rhel-7.4)Any (x86-64)it gets very slow to access an empty table after drop a big database
957922019-06-13
15:21
2019-07-10
18:39
MySQL Server: Data DictionaryClosed
(647 days)
S28.0.18AnyAnyDD function for fetching tables in engine
914202018-06-26
10:03
2018-08-14
17:43
MySQL Server: Data DictionaryClosed
(977 days)
S38.0.11AnyAnyAllocate DD auto releaser maps on demand
878272017-09-21
14:09
2018-01-19
20:28
MySQL Server: DDLClosed
(1184 days)
S58.0.3AnyAnyPerformance regression in "create table" speed and scalability in 8.0.3
85652005-02-17
11:50
2017-05-07
20:45
MySQL Server: DDLDuplicate
(3200 days)
S25.0.30Any (*)AnyALTER TABLE MODIFY adds duplicate keys which slow down SELECTs
744872014-10-21
19:07
2015-02-16
20:38
MySQL Server: DDLClosed
(2252 days)
S35.7.5-labs-previewAnyAnyprimary key missing for query_rewrite.rewrite_rules
516802010-03-03
8:36
2011-02-16
23:44
MySQL Server: DDLDuplicate
(4063 days)
S35.1.43IBM AIXAny"ALTER TABLE ... DELAY_KEY_WRITE=1" causes a full table copy
224872006-09-19
17:57
2020-05-03
20:45
MySQL Server: DDLVerified
(5148 days)
S55.0.26AnyAnymysql performs extremely slow when creating unique indexes on huge table
946102019-03-08
19:09
2020-08-05
0:00
MySQL Server: DDLVerified
(255 days)
S55.6.41CentOS (7.5)x86Server stalls because ALTER TABLE on partitioned table holds dict mutex
244952006-11-22
3:37
2008-09-27
10:42
MySQL Server: DDLClosed
(4585 days)
S55.1.14-BK, 5.1.12-beta,5.0.24aLinux (Linux, Windows Server 2003 x64)Any"create index" gets slower the more indexes there are
826312016-08-18
11:45
2016-11-29
1:59
MySQL Server: DDLClosed
(1699 days)
S38.0.1AnyAnystd::basic_string instantiation w/ PFS instrumentation for the DD
758072015-02-06
10:00
2015-02-20
9:54
MySQL Server: DMLVerified
(2250 days)
S55.6.22LinuxAnySlow Query in MySQL 5.6
693682013-05-31
20:36
2013-10-11
16:23
MySQL Server: DMLClosed
(2745 days)
S55.6.6AnyAnyperformance regression in 5.6.6+ for insert into .... select ... from
702022013-08-30
15:36
2013-09-02
11:53
MySQL Server: DMLVerified
(2784 days)
S35.5, 5.6AnyAnyREPLACE working differently for a table having PK or UK only versus both PK+UK
422592009-01-22
6:36
2012-07-31
12:15
MySQL Server: DMLClosed
(3182 days)
S25.5.25Linux (Ubuntu 12.04 x86_64)AnyUtilizing a SELECT within a WHERE IN performs poorly (slow)
403742008-10-28
17:32
2008-11-29
15:56
MySQL Server: DMLClosed
(4522 days)
S35.0.51aLinux (Debian Lenny amd64)AnyLOAD DATA with CONVERT_TZ causes memory leak
459622009-07-06
8:39
2011-02-16
23:44
MySQL Server: DMLClosed
(4231 days)
S25.0.84, 5.1.37, 6.0.12AnyAnymemory leak after 'sort aborted' errors
507742010-02-01
2:23
2011-05-13
14:21
MySQL Server: DMLClosed
(3627 days)
S15.1.44, 5.1.49, 5.5.99, 5.5.6rcAnyAnyWrong resultset when timestamp values are appended with .0
876372017-09-01
8:44
2017-12-18
8:46
MySQL Server: DMLVerified
(1216 days)
S55.7.17LinuxAnyHigh CPU occupancy rate
1031332021-03-27
14:15
2021-04-13
20:00
MySQL Server: DMLVerified
(9 days)
S28.0.23Microsoft Windows (Microsoft Windows 10 Pro)x86memory leak when accessing view
1021502021-01-05
11:53
2021-01-06
8:16
MySQL Server: DMLVerified
(101 days)
S5MySQL 8.0.22AnyAnyPerformance of repeat() function need to be optimized
1027742021-03-02
0:37
2021-03-06
7:15
MySQL Server: DMLVerified
(42 days)
S35.7.31,8.0.22, 5.7.33AnyAnyA scenario that result in memory leak
678922012-12-13
2:37
2012-12-14
13:18
MySQL Server: ErrorsClosed
(3046 days)
S35.5.28, 5.6.9AnyAnyWarning recommends to use a deprecated or non-existing option
609682011-04-24
18:40
2011-04-25
19:50
MySQL Server: ErrorsVerified
(3645 days)
S35.1.43sp1-enterprise-gpl-advanced-logAnyAnyCancelled queries not reported in slow query log
704022013-09-23
21:35
2013-11-12
1:47
MySQL Server: ErrorsClosed
(2713 days)
S55.7.2AnyAnynew deprecation warnings introduce unwanted performance degradation side-effect
266972007-02-27
21:53
2013-03-03
20:45
MySQL Server: Federated storage engineVerified
(5147 days)
S25.0.38-BK, 5.0.27, 5.1Linux (Linux, Windows 2000)AnyEvery query to a federated table results in a full scan of MyISAM table.
408752008-11-20
7:10
2011-02-16
23:43
MySQL Server: Federated storage engineClosed
(4518 days)
S25.0AnyAnyMemory leak in FEDERATED handler
214722006-08-07
7:13
2006-08-26
12:46
MySQL Server: Federated storage engineDuplicate
(5348 days)
S55.1.12Linux (linux)Anyquestion about the query against to the federated engine tables
685722013-03-05
10:57
2014-02-19
16:19
MySQL Server: Federated storage engineVerified
(2964 days)
S35.5.25a, 5.5.31AnyAnyFEDERATED using SHOW TABLE STATUS causes performance problems for InnoDB tables
347892008-02-24
13:49
2008-04-22
14:15
MySQL Server: Federated storage engineClosed
(4743 days)
S35.1.23, 5.1.24-rcAnyAnydrop server/create server leaks memory !
757632015-02-04
13:29
2015-02-05
8:19
MySQL Server: FULLTEXT searchVerified
(2263 days)
S25.6.21, 5.6.24AnyAnyInnoDB FULLTEXT index reduces insert performance by up to 6x on JSON docs
1022492021-01-14
15:56
2021-01-27
17:40
MySQL Server: Group ReplicationVerified
(89 days)
S38.0.22AnyAnySlow query log filling up with performance_schema queries
991332020-03-31
15:08
2020-06-11
11:45
MySQL Server: Group ReplicationVerified
(375 days)
S38.0.19AnyAnyGroup Replication Performance Degradation with partial network outage
847732017-02-01
14:29
2017-10-04
14:14
MySQL Server: Group ReplicationClosed
(1291 days)
S55.7.17LinuxAnyFlow control slows down throughput while a node join the cluster
847742017-02-01
14:53
2019-01-31
17:42
MySQL Server: Group ReplicationVerified
(1535 days)
S55.7.17AnyAnyPerformance drop every 60 seconds
911512018-06-05
17:12
2019-05-06
3:33
MySQL Server: Group ReplicationVerified
(1046 days)
S38.0.11AnyAnyAdd a Learner/Observer role to leverage it in WAN setup
891952018-01-11
19:15
2019-07-25
14:45
MySQL Server: Group ReplicationClosed
(632 days)
S25.7.20, 8.0.3AnyAnyTotal ordering of transactions is not respected in Group Replication.
866262017-06-08
16:42
2017-11-08
10:28
MySQL Server: Group ReplicationClosed
(1307 days)
S35.7.19AnyAnyGroup replication partition handling thread is not instrumented on perf schema
421582009-01-16
13:48
2011-02-16
23:43
MySQL Server: GeneralClosed
(4314 days)
S24.1, 5.0, 5.1, 6.0AnyAnyleak: SSL_get_peer_certificate() doesn't have matching X509_free()
252222006-12-20
19:15
2007-03-13
19:10
MySQL Server: GeneralClosed
(5149 days)
S35.0Microsoft Windows (windows)AnyWin32 HANDLE leak in my_sopen()
526292010-04-06
18:54
2011-02-16
23:44
MySQL Server: GeneralClosed
(3956 days)
S35.1.45, 5.1 bzrAnyAnymemory leak from sys_var_thd_dbug in binlog.binlog_write_error
479372009-10-09
9:11
2011-02-16
23:44
MySQL Server: GeneralVerified
(4208 days)
S5AnyAnyAppending to fields using CONCAT gets very slow
377032008-06-27
21:20
2015-04-29
0:09
MySQL Server: GeneralClosed
(2180 days)
S5MYSQL 6.0.4 (Source Distribution)Linux (EL5.1)AnyMySQL performance with and without Fast Mutexes using Sysbench Workload
426082009-02-04
21:42
2011-02-16
23:43
MySQL Server: GeneralClosed
(4439 days)
S3Summit v0.2.0AnyAnySummit may need changes to default config parameters for optimal performance
503672010-01-15
14:12
2011-02-16
23:44
MySQL Server: GeneralVerified
(4048 days)
S55.1.42, 5.1 bzrAny (MS Windows 32 bits, Mac)AnyREPLACE has quadradic computational complexity on windows server (but not linux)
272712007-03-19
18:38
2007-03-25
13:23
MySQL Server: GeneralClosed
(5137 days)
S35.0.32-Debian_7-logLinux (Debian Etch 64bit)AnyRepeating a query slows it down
279242007-04-18
10:36
2007-05-21
10:27
MySQL Server: GeneralClosed
(5080 days)
S25.0.24-Debian_1~bpo.1-logLinux (Debian 3.1 i386)AnyFLUSH LOGS crashes database
524102010-03-27
18:43
2011-02-16
23:44
MySQL Server: GeneralClosed
(3985 days)
S35.5.3-m3AnyAnyTest "mysqld--help-*": further output differences
612042011-05-17
15:24
2011-05-18
9:35
MySQL Server: GeneralClosed
(3622 days)
S35.0.51aLinux (mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (x86_64))AnyInacurate statistics on a server with 50% persistent connections
570582010-09-28
9:57
2011-02-16
23:44
MySQL Server: GeneralClosed
(3754 days)
S35.5.6AnyAnySERVER_QUERY_WAS_SLOW not wired up.
608112011-04-08
23:41
2020-08-15
10:10
MySQL Server: GeneralVerified
(3660 days)
S55.0.93, 5.5.12, 5.0.77-4.el5_5.4Any (RHEL 5.5, Mac OS X)Anyslow timezone functions
616212011-06-23
22:51
2011-06-24
4:06
MySQL Server: GeneralDuplicate
(3585 days)
S35.5.13Linux (Ubuntu)AnyALTER TABLE very slow on empy partitioned table
245092006-11-22
15:09
2011-02-16
23:43
MySQL Server: GeneralClosed
(3959 days)
S35.0,5.1Microsoft Windows (Windows)Any2048 file descriptor limit on windows needs increasing
283822007-05-11
15:48
2007-05-11
18:30
MySQL Server: GeneralDuplicate
(5090 days)
S3SeveralAnyAnyQuery cache considered harmful
304392007-08-15
14:45
2007-08-16
5:14
MySQL Server: GeneralDuplicate
(4993 days)
S35.0.45LinuxAnytmpdir is not followed for temporary tables in group by
394922008-09-17
0:58
2011-02-16
23:43
MySQL Server: GeneralClosed
(4505 days)
S55.0.51aSolarisAnysolaris should use a separate alarm thread
427052009-02-09
16:37
2011-02-16
23:43
MySQL Server: GeneralVerified
(4408 days)
S35.1.30AnyAnyReduce malloc/free during query lifecycle.
434272009-03-05
17:17
2012-03-18
18:41
MySQL Server: GeneralVerified
(4423 days)
S55.0AnyAnyDon't limit table_cache_size as a function of max_connections
472862009-09-12
11:22
2011-11-28
15:40
MySQL Server: GeneralClosed
(3428 days)
S35.1.38AnyAny'have_federated' variable not implemented
494912009-12-06
23:14
2011-02-16
23:44
MySQL Server: GeneralClosed
(4054 days)
S55.1.38 and aboveAnyAnyMuch overhead for MD5() and SHA1() on short strings
547902010-06-25
3:58
2011-06-03
2:10
MySQL Server: GeneralClosed
(3606 days)
S35.1.47AnyAnyUse of non-blocking mode for sockets limits performance
342542008-02-02
20:26
2008-02-04
2:23
MySQL Server: GeneralClosed
(4821 days)
S25.1.22 RC (x64)Microsoft Windows (XP x64 AMD DC)AnyVery slow queries when using functions in SELECT statements
229472006-10-03
16:16
2006-10-03
16:20
MySQL Server: GeneralDuplicate
(5310 days)
S24.1.21 Linux 2.4.18 SMP kernelAnyPerformance regression in C API 4.1 versus 4.0
512862010-02-18
15:56
2011-02-16
23:44
MySQL Server: GeneralVerified
(4076 days)
S3anyAnyAnyRequest to add performance regression to release acceptance tests
217982006-08-23
17:36
2006-10-25
19:21
MySQL Server: GeneralClosed
(5288 days)
S25.0.24Linux (Linux 2.6.15 (Ubuntu 6.06 LTS))Anymemory leak during query execution with subquery in column list using a function
256592007-01-16
22:38
2007-05-24
7:27
MySQL Server: GeneralClosed
(5077 days)
S35.1AnyAnymemory leak via "plugins" test
424122009-01-28
10:53
2011-02-16
23:43
MySQL Server: GeneralClosed
(4246 days)
S36.0,5.4AnyAnyIPv6 connection handling code bugs
269672007-03-08
18:00
2014-12-21
11:15
MySQL Server: GeneralVerified
(5150 days)
S35.0.37Any (all)AnySHOW PROFILE: Inconsistent output capitalization
348202008-02-25
21:03
2008-10-05
16:43
MySQL Server: GeneralClosed
(4577 days)
S35.1AnyAnylog_output can be set to illegal value
831662016-09-27
10:09
2016-11-21
17:45
MySQL Server: GISClosed
(1618 days)
S55.7.15AnyAnyQuery execution involving spatial and non-spatial data very slow
749492014-11-21
6:30
2015-04-06
18:53
MySQL Server: GISClosed
(2273 days)
S35.7.6AnyAnyGIS performance issue: too many reallocs
743712014-10-14
11:32
2014-10-31
15:18
MySQL Server: GISClosed
(2360 days)
S35.7.6AnyAnyValgrind: Memory leak when doing spatial operations on geometrycollections
354142008-03-18
19:16
2012-08-08
11:01
MySQL Server: GISDuplicate
(3174 days)
S35.0.51 and 5.0.51aOther (Linux / Solaris)AnyMBRContains fails to select records when using index
1025992021-02-15
12:11
2021-02-16
12:51
MySQL Server: GISVerified
(60 days)
S58.0.22Microsoft Windows (Win 10)x86 (NVMe RAM)Slow performance of MySQL 8 compared with 5.7 on geographical SELECT
963112019-07-24
9:02
2020-02-19
17:38
MySQL Server: GISDuplicate
(423 days)
S58.0.17AnyAnyST_Intersects() is very slow on MySQL 8.0
794062015-11-25
9:49
2017-12-23
10:50
MySQL Server: GISClosed
(1261 days)
S25.7.9 GA, 5.7.11AnyAnyExtremely poor selection performance compared to MySQL 5.6.27 on InnoDB & MyISAM
891222018-01-05
16:47
2018-03-19
17:49
MySQL Server: GISClosed
(1187 days)
S38.0.5AnyAnySevere performance regression in server bootstrap
591112010-12-22
10:40
2011-02-16
23:44
MySQL Server: GISClosed
(3720 days)
S35.6+AnyAnygis crashes when server is compiled without performance schema
779602015-08-06
11:21
2016-02-04
19:18
MySQL Server: GISClosed
(2059 days)
S3AnyAnyUpgrade to Boost 1.59.0
793802015-11-23
8:11
2016-06-18
21:34
MySQL Server: GISClosed
(1912 days)
S38.0.0AnyAnyUpgrade to Boost 1.60.0
818652016-06-15
12:20
2016-06-20
9:46
MySQL Server: Information schemaVerified
(1762 days)
S35.6.2x, 5.6.31LinuxAnySHOW FULL TABLES significant slow
328372007-11-29
5:33
2007-11-29
12:00
MySQL Server: Information schemaDuplicate
(4888 days)
S55.0.50Microsoft Windows (Vista)AnyI_S Querys take too long
778612015-07-28
17:30
2015-07-29
6:58
MySQL Server: Information schemaVerified
(2089 days)
S35.6, 5.6.26AnyAny"SHOW PROCESSLIST" needs higher resolution time
982382020-01-15
12:26
2020-05-07
12:32
MySQL Server: Information schemaClosed
(346 days)
S58AnyAnyI_S.KEY_COLUMN_USAGE is very slow
403672008-10-28
8:55
2011-02-16
23:43
MySQL Server: Information schemaVerified
(4468 days)
S35.1.28, 5.1.29, 5.0, 5.1 bzrAnyAnySHOW on a broad view is taking too long
843052016-12-22
1:22
2017-03-24
14:43
MySQL Server: Information schemaClosed
(1485 days)
S25.6.35AnyAnyThe fix for Bug#78777 has different behavior with perf. schema vs. without it
389182008-08-20
15:44
2008-11-13
3:29
MySQL Server: Information schemaClosed
(4538 days)
S35.1.26,6.0.6AnyAnyselecting from information_schema.columns is disproportionately slow
399902008-10-12
16:19
2008-10-13
9:00
MySQL Server: Information schemaDuplicate
(4569 days)
S35.1.23, 5.1.28AnyAnypoor performace of "SHOW VARIABLES"
422482009-01-21
18:27
2011-02-16
23:43
MySQL Server: Information schemaDuplicate
(4469 days)
S56.0.0-alpha-community-nt-debugMicrosoft WindowsAnyInformation schema has no indexes
520862010-03-16
12:03
2011-02-16
23:44
MySQL Server: Information schemaDuplicate
(4050 days)
S35.1.44Microsoft Windows (Server 2003)Anyshow function status
195882006-05-06
23:47
2020-08-25
11:03
MySQL Server: Information schemaClosed
(4875 days)
S55.0, 5.1Any (all)AnyINFORMATION_SCHEMA performs much too slow on large servers
292632007-06-21
9:46
2011-02-16
23:43
MySQL Server: Information schemaClosed
(4461 days)
S35.1AnyAnydisabled storage engines omitted in SHOW ENGINES
479612009-10-09
21:51
2011-02-16
23:44
MySQL Server: Information schemaVerified
(4208 days)
S35.1.39-community,5.5+Linux (only tested on CentOS 5.3)Anymetadata leak from information_schema.routines via privs on mysql.proc table
512082010-02-16
14:29
2018-04-12
9:57
MySQL Server: Information schemaClosed
(3801 days)
S35.1AnyAnyExtra string allocation from thd->mem_root in sql_show.cc, find_files()
419252009-01-07
15:43
2017-07-19
0:01
MySQL Server: Information schemaVerified
(4482 days)
S35.6.30, 5.7.12, 8.0.0AnyAnyWarning 1366 Incorrect string value: ... for column processlist.info
438182009-03-24
4:05
2011-02-27
3:11
MySQL Server: Information schemaClosed
(3702 days)
S55.1.32Any (MS Windows, Linux)AnyLOJ on I_S too slow
987502020-02-26
20:11
2020-05-21
12:09
MySQL Server: Information schemaClosed
(332 days)
S58.0, 8.0.19AnyAnySHOW FIELDS command regression on MySQL 8.0
918372018-07-31
4:35
2018-07-31
12:43
MySQL Server: InnoDB storage engineVerified
(991 days)
S38.0.11, 8.0.12, 5.7.23AnyAnyIS.innodb_trx results filtered by trx_started depends on timezone
895512018-02-06
9:27
2020-02-12
14:10
MySQL Server: InnoDB storage engineVerified
(1166 days)
S35.7.21, 8.0.4AnyAnySpatial index query time performance scales linearly
884222017-11-09
12:20
2017-11-14
14:42
MySQL Server: InnoDB storage engineVerified
(1250 days)
S25.7.19AnyAnyMySQL 5.7 innodb purge thread get oldest readview could block other transaction
879332017-10-02
4:06
2018-12-12
21:04
MySQL Server: InnoDB storage engineVerified
(857 days)
S25.7.19CentOSARMScalibility issue on Arm platform with the current UT_RELAX_CPU () code.
943702019-02-18
3:19
2019-02-27
10:16
MySQL Server: InnoDB storage engineVerified
(789 days)
S38.0AnyAnyPerformance regression of btr_cur_prefetch_siblings
953902019-05-16
9:57
2019-05-16
13:53
MySQL Server: InnoDB storage engineVerified
(702 days)
S58.0.16AnyAnywake up log_closer background thread in log_wait_for_space_in_log_recent_closed
954912019-05-23
11:23
2019-06-05
11:48
MySQL Server: InnoDB storage engineVerified
(685 days)
S5ALLAnyAnyThe unused wake up in simulator AIO of function reserve_slot
1008112020-09-11
9:22
2020-09-11
13:25
MySQL Server: InnoDB storage engineDuplicate
(218 days)
S58.0.20Oracle LinuxAnyperformance degradation in MySQL-8.0 vs MySQL-5.7 in simple DML operations.
859992017-04-19
9:14
2017-04-19
9:56
MySQL Server: InnoDB storage engineVerified
(1459 days)
S55.7.17AnyAnyOptimize zlib 's fill_window with SIMD instructions
994322020-05-04
8:09
2020-05-05
12:04
MySQL Server: InnoDB storage engineVerified
(348 days)
S58.0.20AnyARMImproving memory barrier during rseg allocation
853042017-03-04
8:26
2017-09-02
12:52
MySQL Server: InnoDB storage engineVerified
(1323 days)
S35.7AnyAnyReduce mutex contention of fil_system->mutex
867052017-06-15
2:25
2018-08-30
11:04
MySQL Server: InnoDB storage engineVerified
(1395 days)
S25.5.45, 5.5.56Linux (MySQL OOM because of memory leak)AnyMemory leak of Innodb
180542006-03-08
2:04
2007-01-16
16:08
MySQL Server: InnoDB storage engineClosed
(5205 days)
S15.0.18Miracle Linux ver4 (kernel 2.6)AnySevere performance degradation when Hyperthreading is on
931652018-11-12
15:11
2018-11-26
21:02
MySQL Server: InnoDB storage engineVerified
(873 days)
S35.7.23, 5.7.24AnyAnyMemory leak in sync_latch_meta_init() after mysqld shutdown detected by ASan
71502004-12-10
0:18
2005-01-14
13:52
MySQL Server: InnoDB storage engineClosed
(5937 days)
S34.1Linux (Linux)AnyInnoDB TRUNCATE can get very slow
1030342021-03-18
9:29
2021-03-18
13:35
MySQL Server: InnoDB storage engineVerified
(30 days)
S58.0AnyAnynew undo log purge strategy purge record too slow on single table
835322016-10-25
14:11
2018-02-18
18:29
MySQL Server: InnoDB storage engineVerified
(1601 days)
S38.0AnyARMInnoDB mutex bs: memory barriers
902092018-03-24
21:19
2019-08-28
11:36
MySQL Server: InnoDB storage engineVerified
(599 days)
S58.0, 8.0.17AnyAnyPerformance regression with > 15K tables in MySQL 8.0 (with general tablespaces)
996382020-05-20
0:53
2020-12-04
12:54
MySQL Server: InnoDB storage engineClosed
(135 days)
S58.0.18AnyAnyxa transaction with low performance
381532008-07-15
22:13
2014-02-28
18:58
MySQL Server: InnoDB storage engineVerified
(2605 days)
S55.0.66, 5.1.34, 5.6.16AnyAnymysql-bench: slowdown for update_of_primary_key_many_keys test
556812010-08-02
10:43
2011-02-16
23:44
MySQL Server: InnoDB storage engineClosed
(3777 days)
S2trunkAnyAnyMTR slowdown after default storage engine was changed to InnoDB
680772013-01-14
3:37
2013-04-03
11:33
MySQL Server: InnoDB storage engineClosed
(2936 days)
S55.6AnyAnyMixing 4K/16K blocks increases 8K free blocks and holds buf pool mutex longer
876212017-08-31
9:45
2017-09-28
9:11
MySQL Server: InnoDB storage engineVerified
(1321 days)
S35.6.37, 5.7.19AnyAny Huge InnoDB slowdown when selecting strings without indexes
611882011-05-16
16:43
2011-11-02
16:32
MySQL Server: InnoDB storage engineClosed
(3454 days)
S35.5.12-logLinux (CentOS release 5.3 (Final))AnyDROP TABLE extremely slow
955822019-05-31
5:02
2019-06-21
13:41
MySQL Server: InnoDB storage engineVerified
(666 days)
S38.0.16, 5.7.26AnyAnyDDL using bulk load is very slow under long flush_list
1019002020-12-08
3:21
2020-12-08
23:18
MySQL Server: InnoDB storage engineVerified
(130 days)
S28.0.21Linux (7.6)AnyAdd partition is slow
978222019-11-27
23:58
2020-01-28
2:23
MySQL Server: InnoDB storage engineClosed
(445 days)
S55.7.28Linux (Centos7)Anybuf_page_get_gen buf_pool->stat.n_page_gets++ is a cpu waste
183842006-03-21
8:14
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(3955 days)
S25.0.3 and laterAny (All)AnyInnoDB memory leak on duplicate key errors in 5.0 if row has many columns
574802010-10-15
11:19
2014-09-13
16:19
MySQL Server: InnoDB storage engineClosed
(3390 days)
S25.1, 5.0AnyAnyMemory leak when having 256+ tables
649872012-04-15
20:13
2014-08-15
20:09
MySQL Server: InnoDB storage engineDuplicate
(3256 days)
S35.6.6AnyAnyMemory leak in mysql-5.6.6-labs-april-2012
918602018-08-01
20:51
2018-08-02
6:28
MySQL Server: InnoDB storage engineDuplicate
(989 days)
S25.7.22AnyAnyThe buf_LRU_free_page function may leak some memory in a particular scenario
545632010-06-16
19:19
2011-02-16
23:44
MySQL Server: InnoDB storage engineClosed
(3957 days)
S35.5.5preAnyAnyInnoDB: Performance drop in varios sysbench tests
563322010-08-27
18:17
2013-07-07
11:39
MySQL Server: InnoDB storage engineClosed
(2841 days)
S35.0.87, 5.0.91AnyAnyPerformance regression in DROP TABLE performance post 5.0.77
579812010-11-04
14:57
2012-02-13
3:42
MySQL Server: InnoDB storage engineClosed
(3351 days)
S35.5.7-m3SolarisAnyUNIV_DEBUG causes big performance degradation for some operations on Solaris
807372016-03-14
21:24
2016-03-17
0:14
MySQL Server: InnoDB storage engineClosed
(1858 days)
S35.7AnyAny"How MySQL Uses Memory" is myisam centric
1005122020-08-13
9:17
2020-08-25
12:13
MySQL Server: InnoDB storage engineVerified
(235 days)
S55.7.31,8.0.21Linux (3.10.107)x86 (96 cores)adaptive hash index(AHI) building causing contention on btr_search_latches
818042016-06-10
12:35
2019-07-02
10:59
MySQL Server: InnoDB storage engineVerified
(1769 days)
S25.7.13AnyAnyMemory leak or bug in P_S instrumentation for InnoDB threads
19422003-11-25
1:13
2004-03-17
9:43
MySQL Server: InnoDB storage engineClosed
(6240 days)
S24.0.16Linux (Linux)AnySlow queries with "order by"
688142013-03-29
15:33
2015-04-23
6:14
MySQL Server: InnoDB storage engineVerified
(2186 days)
S35.6.10Any (Centos 6.3)AnyMySQL optimizer consider few rows to examine but it is not really obvious why
715072014-01-29
12:51
2020-07-21
7:31
MySQL Server: InnoDB storage engineVerifiedS55.7AnyAnyinnodb is excessively slow to replace duplicate values in a table
782622015-08-28
15:19
2015-12-07
18:51
MySQL Server: InnoDB storage engineClosed
(1958 days)
S55.6.26Any (CentOS release 6.6)AnyAdding indexes on empty table is slow with large innodb_sort_buffer_size.
937342018-12-24
18:44
2020-12-22
21:25
MySQL Server: InnoDB storage engineDuplicate
(319 days)
S5Ubuntu (18.04)x86MySQL 8.0 is 36 times slower than MySQL 5.7
547282010-06-23
9:50
2011-02-16
23:44
MySQL Server: InnoDB storage engineClosed
(3889 days)
S33.23, 4.0, 4.1, 5.0, 5.1, 5.5AnyAnyUnnecessary overhead in the 64-bit "dulint" struct type
582342010-11-16
16:26
2014-02-26
12:47
MySQL Server: InnoDB storage engineVerified
(3408 days)
S55.1.49-r1, 5.5.20AnyAnyLENGTH() / OCTET_LENGTH() on BLOB field very slow
596832011-01-23
21:58
2012-02-13
3:40
MySQL Server: InnoDB storage engineClosed
(3351 days)
S35.5+AnyAnyInnoDB latch deadlock detector/violation debug code is very slow
671752012-10-10
9:08
2013-01-14
17:18
MySQL Server: InnoDB storage engineDuplicate
(3015 days)
S35.6.7 AnyAnyrecovery is very very slow in buf_flush_single_page_from_LRU
687252013-03-20
8:30
2016-03-24
11:28
MySQL Server: InnoDB storage engineVerified
(1850 days)
S5allAnyAnyUNIV_MEM_DEBUG needlessly slow, especially with UNIV_ZIP_DEBUG
744722014-10-21
6:45
2015-04-29
12:33
MySQL Server: InnoDB storage engineClosed
(2180 days)
S55.7.5AnyAnyddl like add index is very slow in 5.7.5
761822015-03-05
21:42
2015-06-04
18:34
MySQL Server: InnoDB storage engineClosed
(2146 days)
S25.7.6, 5.7.7LinuxAnyThe new created tablespace is not reported in the INFORMATION_SCHEMA
767502015-04-20
8:34
2018-02-12
15:46
MySQL Server: InnoDB storage engineVerifiedS35.5.44AnyAnyinnodb History list length (trx_rseg_history_len) never reaches 0
935302018-12-08
20:23
2020-12-06
17:24
MySQL Server: InnoDB storage engineDuplicate
(135 days)
S35.7.23, 5.7.24AnyAnyALTER TABLE DROP INDEX is very slow
997172020-05-28
7:47
2021-04-07
13:04
MySQL Server: InnoDB storage engineVerified
(11 days)
S58.0AnyAnyPeformance regression of parallel count
1009662020-09-27
3:46
2020-11-16
15:35
MySQL Server: InnoDB storage engineClosed
(152 days)
S2MySQL8.0.18, 8.0.21Any (rhel-7.4)Any (intel x86)select count(*) works very slow for uncommitted data
158152005-12-16
23:18
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(3955 days)
S24.0.27,4.1, 5.0, 5.1Linux (Linux x86_64)AnyVery poor performance with multiple queries running concurrently
243862006-11-17
10:53
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(3955 days)
S25.0, 5.1Any (all)AnyPerformance degradation caused by instrumentation in mutex_struct
421012009-01-14
9:27
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(3954 days)
S35.1AnyAnyRace condition in innodb_commit_concurrency
532042010-04-27
14:17
2011-02-16
23:44
MySQL Server: InnoDB storage engineClosed
(3889 days)
S35.1+Microsoft WindowsAnyos_fastmutex_trylock is implemented incorrectly on Windows
557162010-08-03
15:02
2011-02-16
23:44
MySQL Server: InnoDB storage engineClosed
(3837 days)
S5AnyAnyCHECK TABLES should not perform check on entire adaptive hash index
569332010-09-22
13:26
2011-02-16
23:44
MySQL Server: InnoDB storage engineClosed
(3782 days)
S25.5AnyAnyInnoDB does more writes in 5.5 than in 5.1 on buffer pool challenged workloads
589122010-12-14
9:15
2011-02-16
23:44
MySQL Server: InnoDB storage engineClosed
(3749 days)
S3allAnyAnyInnoDB unnecessarily avoids update-in-place on column prefix indexes
589742010-12-16
13:43
2011-02-16
23:44
MySQL Server: InnoDB storage engineClosed
(3741 days)
S5mysql-5.5-innodbAnyAnyha_innobase:info() tries to lock some latches even if HA_STATUS_NO_LOCK is given
601282011-02-15
7:22
2018-09-23
20:45
MySQL Server: InnoDB storage enginePatch queued
(3714 days)
S3AnyAnyAdd performance schema instrumentation on os_fast_mutex
617352011-07-04
11:30
2011-07-08
6:02
MySQL Server: InnoDB storage engineVerified
(3571 days)
S35.1, etcAnyAnyindex->lock held while preads are done
653592012-05-18
12:41
2012-05-30
17:01
MySQL Server: InnoDB storage engineDuplicate
(3244 days)
S25.1.62LinuxAnybad select performance
681712013-01-24
15:33
2013-07-08
13:18
MySQL Server: InnoDB storage engineClosed
(2840 days)
S35.6.9-rcAnyAnyImprove documentation of how InnoDB tables can be copied between instances
685442013-03-01
19:52
2013-03-02
14:36
MySQL Server: InnoDB storage engineVerified
(2968 days)
S35.5AnyAnyAbility to support multiple buffer pools with per-table assignment
685742013-03-05
13:42
2017-10-03
7:47
MySQL Server: InnoDB storage engineVerified
(2610 days)
S35.5.30, 5.6.16Microsoft Windows (win7 sp1 ent)AnyNo instrumentation for InnoDB files in P_S on windows
685882013-03-06
22:00
2019-08-27
15:11
MySQL Server: InnoDB storage engineClosed
(2917 days)
S55.6.10AnyAnyremove most calls to os_thread_sleep from innodb
691792013-05-09
4:22
2013-09-23
15:08
MySQL Server: InnoDB storage engineDuplicate
(2763 days)
S25.6.11, 5.5.31, 5.6.13AnyAnyaccessing information_schema.partitions causes plans to change
692362013-05-14
22:12
2016-03-31
12:22
MySQL Server: InnoDB storage engineVerified
(2055 days)
S55.6.11AnyAnyperformance regressions for single-threaded workloads, part 2
694222013-06-07
9:18
2014-02-03
11:41
MySQL Server: InnoDB storage engineClosed
(2679 days)
S55.6.12AnyAnysmall performance impact with heap block debugging info in release builds
710142013-11-26
14:25
2014-05-31
13:52
MySQL Server: InnoDB storage engineClosed
(2573 days)
S3All VersionAnyAnytwo many times of memset decreate the performance under heavy insert
721232014-03-25
14:12
2017-10-04
3:52
MySQL Server: InnoDB storage engineVerified
(2578 days)
S35.6, 5.6.18AnyAnySpurious lock_wait_timeout_thread wakeup in lock_wait_suspend_thread()
729482014-06-11
3:44
2018-07-30
17:32
MySQL Server: InnoDB storage engineClosed
(992 days)
S35.6AnyAnylock_table can be optimized if updating the same table concurrently
742802014-10-08
16:41
2014-10-10
13:50
MySQL Server: InnoDB storage engineVerified
(2381 days)
S55.7.5AnyAnycovering secondary scans worse than PK scan at high concurrency
742832014-10-08
17:00
2020-11-23
7:43
MySQL Server: InnoDB storage engineVerified
(1419 days)
S55.7.5AnyAnyNon-covering secondary index scans degrade more in 5.7 than 5.6
743252014-10-10
19:26
2015-05-22
13:02
MySQL Server: InnoDB storage engineClosed
(2157 days)
S55.7.5AnyAnyupdates to indexed column much slower in 5.7.5
744082014-10-15
19:52
2018-07-04
15:16
MySQL Server: InnoDB storage engineVerified
(1018 days)
S55.6, 5.7, 8.0AnyAnysrv_conc_enter_innodb() is not optimal
748322014-11-13
5:54
2017-10-01
13:59
MySQL Server: InnoDB storage engineClosed
(1929 days)
S35.7.7AnyAnyut_delay missing compiler barrier, UT_RELAX_CPU isn't at all relaxing
759812015-02-20
13:56
2017-11-05
7:12
MySQL Server: InnoDB storage engineVerified
(2200 days)
S55.7.6AnyAnyMySQL 5.7.5 30% slower than 5.6.23 for 1 thread write
770942015-05-19
13:13
2018-10-09
14:11
MySQL Server: InnoDB storage engineClosed
(1698 days)
S35.7.7AnyAnyReduce log_sys->mutex contention by allowing concurrent mtr commit and log write
835282016-10-25
13:06
2016-12-02
14:58
MySQL Server: InnoDB storage engineDuplicate
(1597 days)
S38.0AnyAnyInnoDB mutex bs: periodic waiters wakeup
835682016-10-27
9:54
2018-02-23
0:44
MySQL Server: InnoDB storage engineVerified
(1601 days)
S58.0AnyARMInnoDB memory barriers bs
981322020-01-06
10:55
2020-01-07
12:21
MySQL Server: InnoDB storage engineVerified
(466 days)
S25.6, 5.7, 8.0, 5.7.28, 8.0.18AnyAnyAnalyze table leads to empty statistics during online rebuild DDL
1032132021-04-06
5:13
2021-04-06
13:00
MySQL Server: InnoDB storage engineDuplicate
(11 days)
S58.0.17 - 8.0.23AnyAnyPoor performance while executing 'select count(*)' on a table
54362004-09-06
19:10
2005-05-06
8:58
MySQL Server: InnoDB storage engineClosed
(5825 days)
S3allAny (all)AnySHOW INNODB STATUS is unusable with a lot of concurrent connections
121252005-07-22
22:59
2005-07-26
21:40
MySQL Server: InnoDB storage engineClosed
(5744 days)
S14.1.13Mac OS X (OS X 10.4.2)AnyMassive Disk I/O Degradation under 4.1.13 in OS X
201132006-05-28
15:51
2016-01-03
20:45
MySQL Server: InnoDB storage engineDuplicate
(5435 days)
S55.0.21Linux (Fedora Core5)AnyPerformance degredation on 8 way system ( 4x Opteron 875's )
369412008-05-25
11:58
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(3954 days)
S35.0-bk, 5.1-bkAnyAnyPerformance problem in ha_print_info (SHOW INNODB STATUS)
369422008-05-25
12:28
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(3954 days)
S35.0,5.1AnyAnyPerformance problem in lock_get_n_rec_locks (SHOW INNODB STATUS)
549142010-06-30
13:08
2011-02-16
23:44
MySQL Server: InnoDB storage engineClosed
(3826 days)
S55.5.5AnyAnyInnoDB: performance drop with innodb_change_buffering=all
591632010-12-24
17:20
2012-01-05
0:37
MySQL Server: InnoDB storage engineClosed
(3390 days)
S25.5.8AnyAnySingle user session performance in InnoDB
665872012-08-28
23:04
2013-05-23
16:55
MySQL Server: InnoDB storage engineClosed
(2886 days)
S35.6.7AnyAnyBehavior of read-only transactions differs from documentation
690292013-04-22
3:04
2013-04-25
4:55
MySQL Server: InnoDB storage engineClosed
(2914 days)
S55.6.12AnyAnyArbitrary flushing performance limitation is bad
727032014-05-21
6:46
2014-08-06
14:57
MySQL Server: InnoDB storage engineClosed
(2452 days)
S3AnyAnypage cleaner should be multi-threaded also for recovery and shutdown
737632014-08-28
21:47
2016-10-26
15:20
MySQL Server: InnoDB storage engineIn progress
(1634 days)
S55.7AnyAnyNew futex-mutex in InnoDB needs perf attention
766272015-04-09
3:44
2018-12-03
3:24
MySQL Server: InnoDB storage engineClosed
(2154 days)
S55.5.24, 5.6.24Linux (CentOS6.5)AnyMySQL/InnoDB mix buffered and direct IO
767282015-04-17
4:48
2016-06-07
8:56
MySQL Server: InnoDB storage engineClosed
(1779 days)
S35.7.7AnyAnyreduce lock_sys->mutex contention for transaction that only contains SELECT
770922015-05-19
12:16
2016-02-04
18:41
MySQL Server: InnoDB storage engineClosed
(2138 days)
S35.7.6AnyAnyDocument potential benefits of InnoDB General Tablespaces
825242016-08-10
8:36
2016-08-25
8:22
MySQL Server: InnoDB storage engineVerified
(1696 days)
S55.6, 5.6.32, 5.7.14Ubuntu (16.04)AnySignificant innodb load performance regression since version 5.5
906042018-04-24
13:50
2018-04-25
4:41
MySQL Server: InnoDB storage engineVerified
(1088 days)
S55.7CentOSAnyut_rnd_ulint_counter () : Default delay for spin wait gives better performance
914852018-06-29
6:32
2018-07-20
17:10
MySQL Server: InnoDB storage engineClosed
(1002 days)
S55.7.22, 8.0.11AnyAnyut_crc32_hw() checks ut_crc32_cpu_enabled on each call
959342019-06-23
17:13
2019-07-05
8:17
MySQL Server: InnoDB storage engineAnalyzing
(652 days)
S58.0.*AnyAnyinnodb_flush_log_at_trx_commit = 0 get performance regression on 8 core machine
960712019-07-02
10:43
2020-06-10
12:30
MySQL Server: InnoDB storage engineVerified
(311 days)
S38.0.16AnyAnyTempTable engine uses much more memory than MEMORY engine for temporary table
965042019-08-12
4:42
2019-08-12
18:21
MySQL Server: InnoDB storage engineVerified
(614 days)
S58.0AnyARMRefine atomics and barriers for weak memory order platform
985462020-02-11
6:38
2020-02-12
15:20
MySQL Server: InnoDB storage engineVerified
(430 days)
S58, 5.7AnyAnyTransient indexes statistics are updated in foreground causing performance issue
991182020-03-31
5:20
2020-11-04
15:43
MySQL Server: InnoDB storage engineClosed
(164 days)
S58.0.19LinuxARMARM CRC32 intrinsic call to accelerate table-checksum (not crc32c but crc32)
995932020-05-15
16:05
2020-05-25
11:17
MySQL Server: InnoDB storage engineClosed
(327 days)
S58.0.20Ubuntu (20.04)AnyPerformance issues in 8.0.20
999662020-06-24
8:12
2020-06-30
12:45
MySQL Server: InnoDB storage engineVerified
(291 days)
S58.0.20AnyARMSwitching to use NUMA-SMART Counter for statistical counters
1001822020-07-10
13:35
2020-07-13
12:40
MySQL Server: InnoDB storage engineVerified
(281 days)
S58.0.20AnyARMImproving performance of 'row_mysql_store_col_in_innobase_format'
1022892021-01-19
6:06
2021-01-20
13:32
MySQL Server: InnoDB storage engineVerified
(87 days)
S55.7, 8.0AnyAnybuf_flush_or_remove_pages causes large tps fluctuation with write-heavy workload
182522006-03-15
10:36
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(3955 days)
S25.0.3 and laterAny (all)AnyDisk space leak in updates of InnoDB BLOB rows in 5.0 and 5.1
366132008-05-09
5:33
2016-01-03
20:45
MySQL Server: InnoDB storage engineDuplicate
(4708 days)
S25.1.24AnyAnyCreating many tables with many columns in innodb leads to out of memory
459922009-07-07
8:15
2011-02-16
23:44
MySQL Server: InnoDB storage engineClosed
(3954 days)
S35.4.2-debugLinux (32-bit fc8)Anyinnodb memory not freed after shutdown
547642010-06-24
8:19
2011-02-16
23:44
MySQL Server: InnoDB storage engineClosed
(3868 days)
S35.5.5, innodb 1.1.1AnyAnymemory allocated in os_aio_array_create is not freed at shutdown
803012016-02-08
11:23
2016-02-19
16:50
MySQL Server: InnoDB storage engineClosed
(1886 days)
S3AnyAnyleaksanitizer detects memory leaks in tde tests
807722016-03-17
1:34
2016-06-18
21:36
MySQL Server: InnoDB storage engineClosed
(1788 days)
S25.7.8+,8.0.0, 5.7.11, 5.7.13AnyAnyExcessive memory used in memory/innodb/os0file starting 5.7.8
156532005-12-10
11:24
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(3956 days)
S24.1, 5.0Any (All)AnySlow inserts to InnoDB if many thousands of .ibd files
211122006-07-18
12:47
2006-09-13
17:57
MySQL Server: InnoDB storage engineClosed
(5330 days)
S35.0Any (All)AnyInnoDB slow with > 100,000 .ibd files
259562007-01-30
21:57
2007-02-05
14:30
MySQL Server: InnoDB storage engineClosed
(5185 days)
S35.0.27-community-ntMicrosoft Windows (Win 2000 SP 4)AnyCreate Table with Multiple keys are not created
399392008-10-08
18:38
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(3955 days)
S25.xAnyAnyDROP TABLE/DISCARD TABLESPACE takes long time in buf_LRU_invalidate_tablespace()
455592009-06-17
15:59
2011-02-16
23:44
MySQL Server: InnoDB storage engineDuplicate
(4320 days)
S35.1.32, 5.1.35AnyAnyInnoDB Query not using indexes properly?
531652010-04-26
15:15
2011-02-16
23:44
MySQL Server: InnoDB Plugin storage engineClosed
(3916 days)
S3mysql-5.5AnyAnySetting innodb_change_buffering=DEFAULT produces incorrect result
538522010-05-20
11:14
2011-02-16
23:44
MySQL Server: InnoDB Plugin storage engineClosed
(3783 days)
S35.1.47/plugin1.0.8AnyAnyInnoDB: Performance drop in SELECT_SUM_RANGES test at higher number of threads
545382010-06-16
1:23
2011-02-16
23:44
MySQL Server: InnoDB Plugin storage engineClosed
(3777 days)
S35.1.47AnyAnyuse of exclusive innodb dictionary lock limits performance
643402012-02-15
14:07
2013-06-14
15:35
MySQL Server: InnoDB Plugin storage engineVerified
(2864 days)
S55.1.52, 5.1.61AnyAnyrace on no_flush event during buf_flush_free_margin
646732012-03-16
23:14
2012-03-18
17:15
MySQL Server: InnoDB Plugin storage engineVerified
(3318 days)
S55.1AnyAnyInnoDB allocates too many empty pages in ibd files
466562009-08-11
16:13
2011-02-16
23:44
MySQL Server: InnoDB Plugin storage engineClosed
(3955 days)
S35.1Linux (64bit)AnyInnoDB plugin: memory leaks (Valgrind)
350772008-03-05
12:13
2011-02-16
23:43
MySQL Server: InnoDB Plugin storage engineClosed
(3955 days)
S35.1.42AnyAnyVery slow DROP TABLE (ALTER TABLE, OPTIMIZE TABLE) on compressed tables
535722010-05-11
16:09
2011-02-16
23:44
MySQL Server: InnoDB Plugin storage engineClosed
(3950 days)
S11.1.0AnyAnyslow shutdown does not wait for the purge thread to purge everything
536542010-05-14
16:12
2011-02-16
23:44
MySQL Server: InnoDB Plugin storage engineClosed
(3932 days)
S21.0, 1.1AnyAnyafter 2nd shutdown innodb_file_format_check attains strange values
591432010-12-24
0:13
2017-05-14
20:45
MySQL Server: InnoDB Plugin storage engineDuplicate
(3739 days)
S25.1.52, 5.5, 5.6AnyAnyvalgrind leak warning from innodb_plugin.innodb-index for mysql 5.1.52
632762011-11-16
0:19
2013-07-30
14:25
MySQL Server: InnoDB Plugin storage engineClosed
(2818 days)
S55.1.52, 5.1.60AnyAnyskip sleep in srv_master_thread when shutdown is in progress
521022010-03-16
16:20
2011-02-16
23:44
MySQL Server: InnoDB Plugin storage engineClosed
(3776 days)
S55.0, 5.1, 5.5.5m3Microsoft Windows (Any)AnyInnoDB Plugin shows performance drop compared to InnoDB (Windows)
680222013-01-03
18:00
2013-07-07
11:28
MySQL Server: InnoDB Plugin storage engineClosed
(2841 days)
S15.1,5.5AnyAnyDROP TABLE slow when it decompress compressed-only pages
858192017-04-06
3:04
2018-02-18
18:29
MySQL Server: InnoDB Plugin storage engineVerified
(1471 days)
S55.7LinuxARMOptimize AARCH64 CRC32c implementation
641812012-01-31
14:41
2012-02-09
12:20
MySQL Server: InnoDB Plugin storage engineVerified
(3360 days)
S55.1.52, 5.1.61AnyAnyunzip_LRU length management might need to be updated for SSD
491692009-11-27
16:09
2013-02-28
13:27
MySQL Server: InnoDB Plugin storage engineClosed
(2970 days)
S55.0,5.1,5.1 pluginAnyAnyread_view_open_now is inefficient with many concurrent sessions
525882010-04-05
2:45
2011-02-16
23:44
MySQL Server: InnoDB Plugin storage engineClosed
(3937 days)
S25.5.4/iplugin1.1AnyAnyInnoDB: performance regression in sysbench OLTP_RW test
528062010-04-14
6:32
2016-12-04
20:45
MySQL Server: InnoDB Plugin storage enginePatch pending
(3104 days)
S55.1AnyAnyMake InnoDB mutexes green
592142010-12-29
15:45
2011-05-05
23:48
MySQL Server: InnoDB Plugin storage engineClosed
(3635 days)
S55.1,5.5AnyAnyincrease rate limit for insert buffer prefetch reads
613412011-05-28
15:37
2012-01-05
20:15
MySQL Server: InnoDB Plugin storage engineClosed
(3390 days)
S55.1.52AnyAnybuf_LRU_insert_zip_clean can be O(N) on LRU length
614562011-06-09
7:40
2012-10-18
22:40
MySQL Server: InnoDB Plugin storage engineClosed
(3103 days)
S55.1.52AnyAnyOptimistic Insert/Update uses wrong heuristics for compressed page size
658862012-07-12
19:24
2012-12-24
19:11
MySQL Server: InnoDB Plugin storage engineClosed
(3036 days)
S55.1.52, 5.1.64AnyAnyis the call to ibuf_merge_or_delete_for_page from buf_page_get_gen redundant?
701392013-08-23
16:03
2014-06-23
9:17
MySQL Server: InnoDB Plugin storage engineClosed
(2490 days)
S55.1.72Microsoft WindowsAnyPerformance of "ALTER TABLE..." queries
822102016-07-13
6:50
2016-11-19
1:57
MySQL Server: JSONClosed
(1731 days)
S38.0.0AnyAnyJSON memory usage missing from the memory summary tables
429302009-02-17
11:44
2012-10-05
16:42
MySQL Server: LockingClosed
(3116 days)
S55.0, 5.1, 6.0AnyAny'show global status' causes lock contention on LOCK_thread_count
530452010-04-22
4:58
2011-02-16
23:44
MySQL Server: LockingVerified
(4013 days)
S55.1.45, 5.5AnyAnyLOCK_thread_count locked when per connection threads created
664732012-08-21
1:49
2016-08-04
0:38
MySQL Server: LockingClosed
(2973 days)
S55.6.6-m9AnyAnyMySQL 5.6.6-m9 has more mutex contention than MySQL 5.1
488322009-11-17
11:00
2011-02-16
23:44
MySQL Server: LockingClosed
(4012 days)
S55.0+AnyAnyDisconnection is slow when using non-persistent mysql connections
690302013-04-22
12:55
2013-04-24
11:23
MySQL Server: LockingClosed
(2915 days)
S15.1.66AnyAnyOptimize table locks whole database
586892010-12-03
6:02
2012-07-31
1:44
MySQL Server: LockingClosed
(3182 days)
S35.0, 5.1, 5.6.1AnyAnyMyISAM Selects locks inserts inside procedure only
522892010-03-23
2:04
2011-02-16
23:44
MySQL Server: LockingClosed
(3929 days)
S25.5.3pre/5.5.4preAnyAnyperformance regression for MyISAM in sysbench OLTP_RW test
614012011-06-03
17:47
2011-06-16
19:49
MySQL Server: LockingClosed
(3593 days)
S5MySQL 5.5.3+AnyAnyUPDATE performance degrades gradually if a trigger exists
851912017-02-27
6:40
2017-02-28
12:30
MySQL Server: LockingVerified
(1509 days)
S35.7, 5.7.17AnyAnyperformance regression with HANDLER READ syntax
530962010-04-23
7:32
2012-08-13
16:18
MySQL Server: LockingClosed
(3169 days)
S55.1.44AnyAnyDisconnection is slow when using non-persistent mysql connections
307122007-08-30
0:00
2007-10-09
0:43
MySQL Server: LoggingClosed
(4939 days)
S25.1AnyAnyopen_performance_schema_table() cause an open table leak on failures
276382007-04-04
7:28
2007-04-07
18:29
MySQL Server: LoggingClosed
(5124 days)
S35.1.18-bkAnyAnyslow logging to CSV table inserts bad query_time and lock_time values
300002007-07-24
8:11
2007-08-03
2:23
MySQL Server: LoggingClosed
(5006 days)
S35.1.20LinuxAnySHOW commands once again ends up in the slow query log
317002007-10-18
19:44
2007-11-26
18:50
MySQL Server: LoggingClosed
(4891 days)
S35.0, 5.1, 4.1, 5.2 bkAnyAnythd->examined_row_count not incremented for 'const' type queries
327482007-11-27
1:54
2008-05-20
23:15
MySQL Server: LoggingClosed
(4715 days)
S35.1AnyAnyInconsistent handling of assignments to general_log_file/slow_query_log_file
388892008-08-19
11:14
2011-02-16
23:43
MySQL Server: LoggingDuplicate
(4517 days)
S36.0.7-alpha-debugLinux (suse-linux-gnu on i686)AnyAssignment of a variable to "slow_query_log_file" failed.
497562009-12-17
4:39
2011-02-16
23:44
MySQL Server: LoggingClosed
(3838 days)
S35.0.44, 5.1.43AnyAnyRows_examined is always 0 in the slow query log for update statements
327382007-11-26
20:05
2011-02-16
23:43
MySQL Server: LoggingClosed
(4174 days)
S35.1, 6.0AnyAnymysqld: Two slow log option/variable descriptions are inaccurate
967222019-09-03
3:19
2019-12-10
6:37
MySQL Server: LoggingVerified
(494 days)
S35.6.28, 5.6.45, 5.7.27AnyAnyEvent does't record slow insert in slow log
304142007-08-14
17:09
2013-04-23
19:01
MySQL Server: LoggingClosed
(2916 days)
S55.1AnyAnySlowdown (related to logging) in 5.1.21 vs. 5.1.20
980462019-12-21
8:14
2020-01-21
21:34
MySQL Server: LoggingVerified
(481 days)
S3AllLinuxAnyInconsistent behavior while logging a killed query in the slow query log
232252006-10-12
18:20
2007-03-08
3:16
MySQL Server: LoggingClosed
(5154 days)
S35.1 bkLinux (Linux)AnySlow query log: settiing slow_query_log_file writes to wrong file
896372018-02-13
1:38
2018-11-20
22:16
MySQL Server: LoggingClosed
(915 days)
S38.0.4AnyAnyContribution by Facebook: Slow Query Log Changes
288082007-05-31
14:00
2007-07-10
22:14
MySQL Server: LoggingClosed
(5030 days)
S35.0.44-BK, 5.0.40, 5.0.34, 5.0.24aLinuxAnylog_queries_not_using_indexes variable dynamic change is ignored
479052009-10-07
23:43
2011-02-16
23:44
MySQL Server: LoggingClosed
(3956 days)
S35.1.39AnyAnystored procedures with multiple statements not being logged to slow query log
718922014-02-28
22:00
2015-03-24
21:40
MySQL Server: LoggingClosed
(2216 days)
S25.5,5.6,5.7AnyAnyMissing information in slow query log for slow HANDLER statements
804672016-02-22
9:26
2016-03-31
10:32
MySQL Server: LoggingVerified
(1843 days)
S35.7.11CentOSAnylog_queries_not_using_indexes is not working as expected in 5.7
981032020-01-01
5:14
2020-01-13
11:21
MySQL Server: LoggingVerified
(460 days)
S3All, 8.0.18AnyAnyunexpected behavior while logging an aborted query in the slow query log
722432014-04-04
18:48
2014-04-04
19:33
MySQL Server: LoggingVerified
(2570 days)
S35.7.4AnyAnyQueries where execution time exceeds 'MAX_STATEMENT_TIME' should go to slow log
725292014-05-04
10:13
2014-05-04
11:22
MySQL Server: LoggingVerified
(2540 days)
S55.5AnyAnyrm a large slow log file and then flush slow logs, the mysqld will hang
766392015-04-09
10:49
2015-04-09
10:53
MySQL Server: LoggingVerifiedS35.6.20AnyAnyIndex Merge (sort_union) plan gets picked up by log_queries_not_using_indexes=1
598612011-02-01
1:50
2011-03-07
23:18
MySQL Server: LoggingClosed
(3694 days)
S35.1, 5.5, trunkAnyAnywhy does log_slow_statement call thd_proc_info twice?
686262013-03-10
16:11
2014-03-11
21:25
MySQL Server: LoggingClosed
(2594 days)
S35.6.10AnyAnyGRANT statements logged twice in slow query log
914962018-06-29
11:40
2019-08-26
15:53
MySQL Server: LoggingClosed
(600 days)
S35.7.3AnyAnyRegression: Slow_queries status variable isn't incremented if slow query is off
939632019-01-17
12:56
2019-02-21
3:08
MySQL Server: LoggingClosed
(786 days)
S38.0.13AnyAnySlow query log doesn't log a slow CREATE INDEX with admin statements enabled
196992006-05-10
21:43
2006-05-10
22:05
MySQL Server: LoggingDuplicate
(5456 days)
S3*Any (*)AnyCannot enable/disable general query log or slow query log at runtime
197642006-05-12
10:28
2006-11-09
14:55
MySQL Server: LoggingClosed
(5273 days)
S35.0.15Any (*)AnySHOW commands end up in the slow log as table scans
353962008-03-18
14:15
2011-12-01
20:37
MySQL Server: LoggingClosed
(3425 days)
S35.0.50sp1a, 5.0 bzrAnyAnyAbnormal / impossible / large Query_time and Lock_time values in slow query log
396182008-09-23
21:56
2011-02-16
23:43
MySQL Server: LoggingVerified
(4525 days)
S35.0.27, 5.0.67Microsoft Windows (XP)AnyUsing log-short-format does not change what is logged
509542010-02-05
19:46
2011-02-16
23:44
MySQL Server: LoggingVerified
(4088 days)
S3MySQL 5.1.32, 5.1, 5.5.99Linux (Red Hat 4.1.2-44)Anystart_time in slow query log is recording the query end time, not start time
531912010-04-27
9:10
2011-02-16
23:44
MySQL Server: LoggingClosed
(3838 days)
S15.1.45, 5.1.46Any (linux, windows)AnyLock_time in slow log is negative when logging stored routines
648222012-03-31
1:33
2013-03-26
22:27
MySQL Server: LoggingClosed
(2944 days)
S35.1.61, 5.5.20AnyAnyALTER TABLE does not appear in the slow query log
657152012-06-22
19:51
2012-08-23
16:27
MySQL Server: LoggingClosed
(3159 days)
S35.5.25Any (x86_64)AnyWrong connection ID (thread ID) in the general and slow query logs
828702016-09-06
10:07
2018-10-25
12:54
MySQL Server: LoggingVerified
(1191 days)
S35.7.14AnyAnymysqld opens too many descriptors for slow query log
828992016-09-08
3:14
2016-09-08
6:31
MySQL Server: LoggingVerified
(1682 days)
S35.7.14, 5.7.15AnyAnyTrying to turn-off slow_query_log with an active thrd logging slow query ASSERTs
635482011-12-02
19:13
2011-12-05
8:06
MySQL Server: LoggingVerified
(3424 days)
S3anyAnyAnydisable logging to slow log session-wise
694202013-06-07
7:18
2013-10-16
15:02
MySQL Server: LoggingClosed
(2740 days)
S55.6.12AnyAnylog_slow_statement could bail out earlier if slow logging is disabled
739742014-09-18
21:41
2015-09-28
19:08
MySQL Server: LoggingClosed
(2028 days)
S35.7.6Microsoft WindowsAnytrunk - slow query log shows some bogus SET timestamp=4294966218; value
739782014-09-19
10:14
2014-12-01
7:23
MySQL Server: LoggingClosed
(2341 days)
S35.6.15, 5.6.20AnyAnyslow_log table doesn't store fractional time part
889372017-12-15
11:27
2017-12-19
11:51
MySQL Server: LoggingVerified
(1215 days)
S35.6.38, 5.7.20AnyAnymysql client history file grows without bounds, slows down connecting to server
957752019-06-13
2:13
2019-06-13
5:59
MySQL Server: LoggingVerified
(674 days)
S35.6AnyAnyVersion 5.6 has the wrong format for slow logging time
685302013-02-28
21:32
2013-08-22
15:44
MySQL Server: MemcachedClosed
(2795 days)
S15.6.10 GALinux (Centos 5)Anymemory leak with innodb memcached plugin for stale connection
300902007-07-27
6:23
2012-05-18
20:19
MySQL Server: Memory storage engineDuplicate
(4883 days)
S35.0.44AnyAnyDELETE from MEMORY table with BTREE primary key extremely slow
737772014-08-31
11:00
2015-08-24
13:24
MySQL Server: Memory storage engineVerified
(2420 days)
S35.6, 5.6.21, 5.5.40LinuxAnyDELETE query takes a long time and examines more rows than exist in the table
237642006-10-30
10:16
2006-11-28
12:28
MySQL Server: Memory storage engineClosed
(5254 days)
S25.0.26 5.0.27Linux (FC5)AnyBTREE index deletes only 1 item on memory table
690662013-04-25
9:38
2013-05-07
18:11
MySQL Server: Memory storage engineDuplicate
(2902 days)
S35.6.11AnyAnyMemory leak slave_parallel_workers
690752013-04-26
3:07
2014-02-19
10:39
MySQL Server: Memory storage engineDuplicate
(2614 days)
S35.6.11, 5.6.15AnyAnyMemory leak slave_parallel_workers
293492007-06-26
1:01
2014-02-02
14:12
MySQL Server: Memory storage engineVerified
(5043 days)
S35.0.27AnyAnydropping MEMORY table very slow
307432007-08-31
8:05
2013-03-03
20:45
MySQL Server: Merge storage engineVerified
(4374 days)
S35.0.37-community/5.1/6.0AnyAnyDelete from MERGE-table is slow
481532009-10-19
15:09
2014-03-13
18:38
MySQL Server: MyISAM storage engineVerified
(2592 days)
S35.1.40, 5.6.17AnyAnySlowdown in test-connect
985112020-02-07
10:11
2020-06-30
17:34
MySQL Server: MyISAM storage engineClosed
(291 days)
S58.0.19, 8.0.20Microsoft WindowsAnyOPTIMIZE TABLE on myisam can increase table size (~2x) and reduce performance
26432004-02-04
13:21
2004-02-04
18:10
MySQL Server: MyISAM storage engineClosed
(6282 days)
S24.0.16Linux (linux)Any4.0.16 selects different index than 4.0.14
26152004-02-02
11:03
2012-05-18
20:19
MySQL Server: MyISAM storage engineDuplicate
(5113 days)
S24.1Linux (Red Hat 9.0)AnyPerformance problem when joining NULLs
447232009-05-07
15:34
2018-04-01
11:47
MySQL Server: MyISAM storage engineClosed
(4229 days)
S55.0/5.1LinuxAnyLarger read_buffer_size values can cause performance decrease for INSERTs
434012009-03-05
8:00
2011-02-16
23:43
MySQL Server: MyISAM storage engineClosed
(4426 days)
S35.1.30FreeBSDAnyQuery spends too much time in ``sending data'' state
1000172020-06-27
14:02
2020-06-29
7:30
MySQL Server: MyISAM storage engineDuplicate
(292 days)
S58.0.20AnyAnyExtremely slow queries after database repair
38352004-05-20
10:51
2004-05-24
11:03
MySQL Server: MyISAM storage engineClosed
(6172 days)
S14.1.2Microsoft Windows (Win 2000/XP)Anyalter table enable/disable keys corrupts database
418712009-01-05
15:47
2018-09-09
20:45
MySQL Server: MyISAM storage engineVerified
(4215 days)
S55.1.30Any (MS Windows, Mac OS X)AnySelect + Index + Limit + offset on large MyIsam tables give very bad performance
565232010-09-03
1:12
2011-02-16
23:44
MySQL Server: MyISAM storage engineClosed
(3801 days)
S25.6AnyAnyInstrumentation regression in myisam/mi_rprev.c
315512007-10-11
22:30
2013-06-13
19:31
MySQL Server: MyISAM storage engineVerified
(4694 days)
S25.0.45, 5.0 BK, 5.1 BKLinux (CentOS 4.5)AnyMyISAM poor performance with multiple queries running concurrently
406342008-11-11
11:30
2011-02-16
23:43
MySQL Server: MyISAM storage engineClosed
(4408 days)
S55.1.29, 6.0.xAnyAnytable scan temporary table is 4x slower due to mmap instead instead of caching
7122003-06-24
10:33
2003-08-27
4:43
MySQL Server: MyISAM storage engineClosed
(6443 days)
S3 Anyslow indexes in 4.0.13 vs. 3.23
24202004-01-16
1:58
2012-05-18
20:19
MySQL Server: MyISAM storage engineDuplicate
(6299 days)
S24.1.2-dev latestLinux (Linux 2.4.21)AnyFulltext index corrups table
171642006-02-06
18:29
2006-04-14
18:39
MySQL Server: OptimizerClosed
(5482 days)
S25.0.19-BK, 5.0.18Linux (Linux)AnyLEFT JOIN with OR clause not optimized correctly
256582007-01-16
19:34
2011-02-16
23:43
MySQL Server: OptimizerClosed
(4493 days)
S15.2.0 falcon-alpha and now 5.2.3Linux (Linux Fedora Core 6)AnyGroup by Performance is slow
478392009-10-05
17:52
2020-05-03
20:45
MySQL Server: OptimizerDuplicate
(4173 days)
S55.1.39AnyAnyUNIX_TIMESTAMP() is not treated as a const
731362014-06-27
16:34
2015-05-20
15:16
MySQL Server: OptimizerVerified
(2483 days)
S35.6.12,5.6.19,5.5, 5.5.38, 5.5.20AnyAnyIndex scan incorrectly selected over ref+sort leading to x1000 worse performance
274522007-03-26
17:35
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4534 days)
S35.0.40-BK, 5.0.24a-debian-log, 5.1.31-bzr, 6.0.7-alpha, 6.0.9-bzrLinuxAnyCorrelated subquery produces inefficient optimizer plan for INFORMATION_SCHEMA
275312007-03-29
18:00
2016-02-25
12:24
MySQL Server: OptimizerClosed
(5090 days)
S24.1.22 5.0AnyAnyQuery performance degredation in 4.1.22 and greater
343642008-02-06
21:17
2012-07-30
17:14
MySQL Server: OptimizerClosed
(3183 days)
S15.1.22Solaris (SunOS clapton.nms.fnc.fujitsu.com 5.10 Generic_118833-36 sun4u sparc SUNW,Ultra-4)AnyLEFT JOIN with subquery takes very long time
348692008-02-27
2:00
2012-05-18
20:19
MySQL Server: OptimizerDuplicate
(4684 days)
S35.0AnyAnyAlmost 300% regression in index merge intersect performance
358502008-04-05
4:09
2011-02-16
23:43
MySQL Server: OptimizerClosed
(3954 days)
S55.1.23Any (Tested w/ SUSE)AnyPerformance regression in 5.1.23/5.1.24
466482009-08-11
11:41
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4261 days)
S35.1.32, 4.1, 5.0, 5.1, azalea bzrLinux (2.6.28.7)AnySQL_CALC_FOUND_ROWS kills performance with ORDER BY and LIMIT
508432010-02-02
18:12
2011-02-16
23:44
MySQL Server: OptimizerClosed
(3954 days)
S25.1.42AnyAnyOptimizer ignores clustered index for GROUP BY even when it improves performance
537372010-05-18
9:30
2011-02-16
23:44
MySQL Server: OptimizerClosed
(3915 days)
S2mysql-next-mrAnyAnyPerformance regressions after applying patch for bug 36569
545312010-06-15
21:39
2011-02-16
23:44
MySQL Server: OptimizerClosed
(3958 days)
S25.1.46, 5.1.47AnyAnyPerformance regression with many joins
570242010-09-26
4:44
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3853 days)
S25.1AnyAnySerious performance issue with an outer join
582252010-11-16
11:21
2011-07-27
17:07
MySQL Server: OptimizerClosed
(3552 days)
S25.1.49, 5.1.54, 5.5.7Microsoft Windows (Server 2003)AnyExtreme performance degradation with joins
659572012-07-20
7:00
2013-06-21
19:41
MySQL Server: OptimizerDuplicate
(2857 days)
S35.1.62, 5.5.27, 5.6.6LinuxAnyPoor correlated subquery performance with order by and limit
674322012-10-31
5:46
2012-12-11
1:49
MySQL Server: OptimizerClosed
(3049 days)
S55.6.7AnyAnySerious performance degradation for the query with ORDER BY ... LIMIT n
678992012-12-13
18:26
2013-02-24
19:43
MySQL Server: OptimizerClosed
(2974 days)
S55.5.27Linux (CentOS 6.3)AnyAdding LIMIT to query increases time from 2 seconds to 42 minutes
688252013-04-01
16:28
2018-07-11
15:09
MySQL Server: OptimizerVerified
(2055 days)
S55.6.10AnyAnyperformance regressions for single-threaded workloads
689192013-04-10
14:25
2013-04-10
14:33
MySQL Server: OptimizerVerified
(2929 days)
S55.6.10AnyAnyPerformance regression when DS-MRR is used for query with small limit
693502013-05-30
5:44
2014-02-20
5:48
MySQL Server: OptimizerVerifiedS55.6AnyAnyperformance regression between 5.5 and 5.6 for simple statement in routine loop
700022013-08-12
19:23
2013-08-19
7:38
MySQL Server: OptimizerDuplicate
(2798 days)
S25.6.13, 5.5, 5.1AnyAnyvery low performance join - eq_ref and ref access broken for compound indexes
700212013-08-13
20:52
2013-10-03
13:38
MySQL Server: OptimizerClosed
(2753 days)
S55.6.13AnyAnyPoor execution of a plan with unnecessary "range checked for each record"
774142015-06-19
9:36
2016-02-04
20:01
MySQL Server: OptimizerClosed
(2025 days)
S35.7.7AnyAnyQuery digest does not reflect new optimizer hints
818032016-06-10
12:35
2016-06-15
16:58
MySQL Server: OptimizerVerified
(1767 days)
S5>=5.1AnyAnyMysql 5.1 and later Update performance regression
886712017-11-28
0:16
2017-12-04
15:41
MySQL Server: OptimizerVerified
(1230 days)
S55.7.19AnyAnyALL + BNL chosen over REF in query plan with a simple SELECT + JOIN
992442020-04-14
3:22
2020-04-22
12:45
MySQL Server: OptimizerVerified
(361 days)
S18.0.19AnyAnybad performance in hash join because join with no join condition between tables
994142020-04-30
17:48
2020-05-20
12:20
MySQL Server: OptimizerVerified
(348 days)
S38.0.20AnyAnyWhere exists performance 8.0.16 onwards
277322007-04-10
13:18
2008-03-30
8:34
MySQL Server: OptimizerClosed
(4766 days)
S15.0.56,5.1.22Any (windows, linux)AnyPossible memory leak with index_merge
591102010-12-22
9:49
2011-03-02
3:21
MySQL Server: OptimizerClosed
(3699 days)
S25.6.99, 5.5, 5.1 ->AnyAnyMemory leak of QUICK_SELECT_I allocated memory
593082011-01-05
11:46
2011-02-28
20:57
MySQL Server: OptimizerClosed
(3701 days)
S25.6.99, 5.5, 5.1 ->AnyAnyIncorrect result for SELECT DISTINCT <col>... ORDER BY <col> DESC
81392005-01-26
7:49
2012-05-18
20:19
MySQL Server: OptimizerDuplicate
(4549 days)
S34.1.8Linux (Linux)Anysubselect index not used for "in" but used for "="
90212005-03-07
13:23
2012-03-26
19:37
MySQL Server: OptimizerClosed
(3309 days)
S14.1.7, 5.6.4FreeBSD (FreeBSD)AnyQuery with subquery does not use index in outer query
142952005-10-25
14:06
2012-08-31
16:06
MySQL Server: OptimizerClosed
(3151 days)
S34.1 and aboveLinux (linux)Anyvery slow 'explain'
160812005-12-30
0:19
2011-06-16
16:21
MySQL Server: OptimizerClosed
(3593 days)
S55.0.19-BK, 5.0.15Linux (LINUX)AnySLOW SELECT
172122006-02-07
23:09
2007-04-24
16:40
MySQL Server: OptimizerClosed
(5107 days)
S14.1.18, 5.0.18, 4.0.26Linux (linux)Anyresults not sorted correctly by ORDER BY when using index
175602006-02-19
20:36
2011-02-16
23:43
MySQL Server: OptimizerClosed
(3957 days)
S35.0.18Linux (Linux)Anyselect with subselect does not use indexed key
195792006-05-06
10:59
2006-10-23
14:10
MySQL Server: OptimizerClosed
(5290 days)
S55.0.24-BK, 5.0.16-log, 5.0.18, 5.0.21-log, 5.1.7-logLinux (Linux)AnyOptimizer does not choose right index and thus query is slow.
247702006-12-02
0:37
2018-09-09
20:45
MySQL Server: OptimizerIn progress
(3680 days)
S55.1Any (all)Anyupdate with subquery slow
285542007-05-21
9:32
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4348 days)
S34.1.22, 5.0.42-BKAnyAnyOptimizer wrongly prefers index for (col = value) over (PK <= value)
343102008-02-05
14:51
2018-09-09
20:45
MySQL Server: OptimizerVerified
(2677 days)
S55.0.51a-log, 5.0.54, 5.6.14LinuxAnyOptimizer is inefficient by using ORDER BY function() and LIMIT
366602008-05-12
4:45
2011-03-21
4:14
MySQL Server: OptimizerClosed
(3680 days)
S35.1.20LinuxAnySUBQUERY slow
429482009-02-17
23:02
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4428 days)
S55.0.67-0ubuntu6, 6.0.11Linux (Ubuntu 8.10)AnyMySQL Optimizer does not properly use Indexes on Views with "Group By"
431872009-02-25
13:45
2012-07-30
17:42
MySQL Server: OptimizerClosed
(3183 days)
S55.0, 5.1, 5.6LinuxAnySELECT ... WHERE (col1, col2) IN ((const, const)) is optimized, non-SELECT not
461352009-07-12
19:03
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3920 days)
S25.0, 5.1, next, 6.0.0, 6.0.2, 5.1.36AnyAnyLIMIT + JOIN problem
559792010-08-13
22:05
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3897 days)
S55.1.39LinuxAnyKey not used if IN() list contains mix of strings and integers
567142010-09-10
12:45
2013-04-02
7:20
MySQL Server: OptimizerClosed
(2937 days)
S55.1.50, 5.1.51-bzrMicrosoft WindowsAnySlow MAX() on primary key retrieved by secondary index in InnoDB
581012010-11-10
0:21
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3810 days)
S55.1.38-community-log, 5.1.54-bzrLinuxAnyOptimizer picks wrong order of queries
592032010-12-29
4:38
2015-02-24
16:10
MySQL Server: OptimizerClosed
(2244 days)
S15.0.91,5.1.39,5.1.55,5.5.8AnyAnySerious optimizer failure when query is encapsulated in additional SELECT/INSERT
615412011-06-16
16:26
2011-06-18
13:35
MySQL Server: OptimizerDuplicate
(3591 days)
S35.5LinuxAnySLOW QUERY - REWRITE
616312011-06-24
14:49
2014-01-03
8:40
MySQL Server: OptimizerClosed
(2661 days)
S55.5.13, 5.5.22Linux (centos 5.5)Anyslow query plans for queries with low cardinality columns in a key
639052012-01-02
23:47
2012-01-16
18:35
MySQL Server: OptimizerVerified
(3379 days)
S55.1.60Microsoft WindowsAnyhandler_read_next is suprisingly high and slows queries
651772012-05-02
9:43
2020-05-03
20:45
MySQL Server: OptimizerVerified
(3267 days)
S55.1,5.5AnyAnyperromance issue of "order by rand()"
679802012-12-27
14:54
2013-01-19
10:52
MySQL Server: OptimizerVerified
(3010 days)
S35.5.28AnyAnyMySQL not utilising full index because of possible bad cardinality stats
680462013-01-07
9:29
2013-02-08
8:49
MySQL Server: OptimizerClosed
(3007 days)
S25.6-rc9Any (Ubuntu 12.04)AnyIN() clause with many constant values does not perform
730462014-06-19
2:42
2016-02-17
11:23
MySQL Server: OptimizerVerified
(2494 days)
S35.6.19AnyAnyOptimizer chooses wrong plan with (const, range) order by range ASC
784072015-09-11
12:45
2015-09-15
7:50
MySQL Server: OptimizerAnalyzing
(2041 days)
S57.4.6/5.6.24LinuxAnywrong index being used in subqueries?
813472016-05-08
16:10
2016-10-13
16:16
MySQL Server: OptimizerClosed
(1647 days)
S35.1.73, 5.5.49, 5.6.30,5.7.12CentOSAnyunnecessary scanned all databases for information_schema
858342017-04-06
13:31
2017-08-01
10:13
MySQL Server: OptimizerDuplicate
(1355 days)
S55.7.17Microsoft WindowsAnyInnoDB: Very slow select query with many tables and IS NULL in where clause
891492018-01-08
23:41
2018-01-16
17:07
MySQL Server: OptimizerVerified
(1187 days)
S55.7.20Red Hat (7.4)AnySELECT DISTINCT on multiple TEXT columns is slow
893672018-01-24
2:52
2018-01-24
9:04
MySQL Server: OptimizerVerified
(1179 days)
S35.7.20, 5.7.21AnyAnyStoring result in a variable(UDV) causes query on a view to use derived tables
933602018-11-27
9:41
2018-12-12
14:48
MySQL Server: OptimizerVerified
(857 days)
S55.6.16,5.7.23Linuxx86mysterious optimizer behavior
939222019-01-14
16:04
2019-05-07
9:43
MySQL Server: OptimizerClosed
(711 days)
S28.0.13Linuxx86UNION ALL very slow with SUM(0)
973392019-10-23
8:06
2019-10-30
6:25
MySQL Server: OptimizerVerified
(536 days)
S25.7.18, 5.7.28, 5.6.46AnyAnybin() function return Incorrect result set
119482005-07-14
18:00
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5736 days)
S35.0AnyAnyMyISAM only, nested JOIN Views, dramatic performance loss
138142005-10-06
19:09
2005-11-09
3:47
MySQL Server: OptimizerClosed
(5638 days)
S24.1.12/4.1 BK sourceLinux (linux)Anyindex including TINYBLOB breaks SELECT functionality
142532005-10-24
9:26
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4125 days)
S35.0, 4.1, 6.0.14-bzrLinux (Linux)AnyOptimizer uses partial indexes for subqueries, where it should not
148162005-11-10
9:40
2005-11-24
0:29
MySQL Server: OptimizerClosed
(5623 days)
S35.0.15, 5.0.16-bkLinux (Linux, Windows)AnyVIEW performs filesort when using ORDER BY but underlying table does not
151352005-11-22
14:28
2011-02-16
23:43
MySQL Server: OptimizerClosed
(4410 days)
S54.1.14Any (NT)AnyDependent subquery performs very badly
196902006-05-10
16:13
2007-02-21
3:17
MySQL Server: OptimizerClosed
(5169 days)
S24.1.19/4.1BKLinux (Gentoo Linux)AnyORDER BY eliminates rows from the result
198952006-05-17
22:41
2013-01-10
13:14
MySQL Server: OptimizerClosed
(3019 days)
S35.0.20, 6.0.7, 6.0.14Microsoft Windows (Windows XP)AnyNo optimization of where clause subqueries rewritable as joins
211742006-07-20
6:17
2007-04-12
21:24
MySQL Server: OptimizerClosed
(5119 days)
S25.0.18, 5.1bkLinux (linux)AnyIndex degrades sort performance and optimizer does not honor IGNORE INDEX
249722006-12-11
21:55
2012-09-05
16:35
MySQL Server: OptimizerClosed
(3146 days)
S55.0.27, 6.0.14Any (Windows)AnyJoin and sub-query execution differences
271992007-03-16
5:03
2013-09-09
9:28
MySQL Server: OptimizerClosed
(2777 days)
S25.0.22, 5.0.37, 4.1 BK, 5.1 BKLinux (linux)AnyPerformance problem when query contains a left join against a subquery
365692008-05-07
15:32
2014-06-19
23:20
MySQL Server: OptimizerClosed
(3915 days)
S55.0.56sp1AnyAnyUPDATE ... WHERE ... ORDER BY... always does a filesort even if not required
375762008-06-23
6:29
2011-12-06
1:00
MySQL Server: OptimizerClosed
(3420 days)
S56.0Linux (SLES10SP1 (2.6.16.46-0.12-smp))AnyMySQL6.0 performance regression compared with MySQL5.1 using Sysbench read test
377592008-07-01
9:41
2008-07-01
19:56
MySQL Server: OptimizerDuplicate
(4673 days)
S15.1.25AnyAnyPerformance/Index problem updating from 5.1.22 to 5.1.25
382132008-07-17
20:46
2011-02-16
23:43
MySQL Server: OptimizerClosed
(4028 days)
S35.1.23-rcAnyAnyMySQL does not seem to execute select count (distinct) efficiently
387452008-08-12
9:44
2011-02-16
23:43
MySQL Server: OptimizerClosed
(3924 days)
S25.1AnyAnyMySQL 5.1 optimizer uses filesort for ORDER BY when it should use index
417402008-12-25
8:51
2011-08-16
1:21
MySQL Server: OptimizerClosed
(3532 days)
S55.1.25,5.1.30AnyAnyMySQL 5.1 optimizer produces inefficient plan for complex queries
426772009-02-08
3:26
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4450 days)
S35.0 and 5.1AnyAnyMySQL Optimizer does not work right with truncation
442012009-04-10
3:04
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3959 days)
S35.1.32, 5.1.35-bzr, 6.0.11-bzr, 5.0, 5.6.99AnyAnyPerformance problem with View
454242009-06-10
6:58
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4329 days)
S25.0.51a, 5.0.77 and 5.1.34, 5.1, 6.0 bzrLinuxAnyUPDATE statement cause full table scan ?
463762009-07-24
17:05
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4280 days)
S55.0.85, 5.1.36, 5.1.38, 5.1.39Microsoft Windows (XP)AnyOptimizer choose wrong index even when where clause and order-by are covered
465082009-08-01
13:27
2011-02-16
23:44
MySQL Server: OptimizerDuplicate
(4273 days)
S35.1.36AnyAnyMySQL 5.1.36 where / order by seems to sort first
491112009-11-25
20:11
2012-08-30
14:32
MySQL Server: OptimizerClosed
(3152 days)
S35.5.0-beta, 5.1AnyAnyChange in execution plan for count_distinct_group_on_key causes peformance drop
502122010-01-10
14:07
2011-02-28
8:36
MySQL Server: OptimizerClosed
(3701 days)
S55.1.37, 5.1.42, 5.1.43-bzrAnyAnyMySQL doesn't use Primary Index for ORDER BY
505712010-01-24
11:09
2011-02-16
23:44
MySQL Server: OptimizerDuplicate
(4101 days)
S55.1.42AnyAnyMySQL not using an index when using tuples in IN clause
574302010-10-13
13:41
2015-11-23
10:42
MySQL Server: OptimizerClosed
(1972 days)
S35.5.6-rc, 5.5.7LinuxAnyquery optimizer does not pick covering index for some "order by" queries
595572011-01-17
15:26
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3743 days)
S25.1, 5.5AnyAnyMySQL uses order of fields in GROUP BY when ORDER BY NULL is specified
602812011-02-28
14:01
2013-01-15
14:37
MySQL Server: OptimizerDuplicate
(3014 days)
S5AnyAnyPerformance suggestion: optimize large and simple "LIMIT" queries
623072011-08-31
1:54
2011-09-01
21:29
MySQL Server: OptimizerVerified
(3516 days)
S35.5.15AnyAnyCondition "TIME = '19:20'" does not use index in sjis
645572012-03-06
0:12
2012-10-08
18:33
MySQL Server: OptimizerClosed
(3113 days)
S25.1.56, 5.5.20, 5.6.4Microsoft Windows (XP Pro SP3)AnyCorrelated subquery performance is degraded in releases alfter 5.0
647912012-03-28
20:17
2015-07-09
8:35
MySQL Server: OptimizerVerified
(3306 days)
S25.1.61, 5.5AnyAnyMixed String/Int values in IN list cause full table scan
657922012-07-03
2:19
2012-07-04
9:54
MySQL Server: OptimizerVerified
(3210 days)
S55.1,5.5AnyAnyan unecessary Using temporary in distinct query
678152012-12-05
8:51
2012-12-06
6:15
MySQL Server: OptimizerVerified
(3054 days)
S35.5.28, 5.6.7LinuxAnyMySQL consistently uses a low cardinality non-referenced column in a index scan
688182013-03-30
5:29
2013-04-01
14:37
MySQL Server: OptimizerDuplicate
(2938 days)
S35.6.10AnyAnyLarge Value List in WHERE Clause Spends Too Much Time in 'statistics' State
700252013-08-14
7:00
2014-02-03
10:42
MySQL Server: OptimizerClosed
(2699 days)
S25.6.13Linux (Oracle Linux 6)AnyUpdate on P_S setup_consumers and threads through JOIN only updates first row
711712013-12-18
10:40
2014-02-04
14:40
MySQL Server: OptimizerVerified
(2629 days)
S25.6.14Linux (Debian 7.1)AnyOptimizer executes inperformant subquery first
725012014-05-01
17:31
2014-05-01
18:12
MySQL Server: OptimizerVerifiedS35.6.17AnyAnyjoining NULLs + different collation is not efficient
725182014-05-02
23:42
2015-08-30
20:59
MySQL Server: OptimizerClosed
(2057 days)
S55.6.16AnyAnyUPDATE ORDER BY does a filesort if updating a column in the index
742562014-10-07
22:43
2015-11-02
6:19
MySQL Server: OptimizerVerified
(2285 days)
S25.6.19, 5.6.22AnyAnyindex_extensions used incorrectly in select cause performance regression
769332015-05-04
17:26
2016-11-16
15:56
MySQL Server: OptimizerClosed
(1613 days)
S55.6.24, 5.6.25LinuxAnyPerformance Regression in 5.6: Update does not use index
794802015-12-01
10:59
2015-12-03
10:42
MySQL Server: OptimizerVerified
(1962 days)
S35.7.9AnyAnySuboptimal query plan in simple join compared to MariaDB 10.1
805052016-02-25
9:43
2016-02-25
14:53
MySQL Server: OptimizerDuplicate
(1878 days)
S55.7.11Microsoft WindowsAnymysql server 5.7.11 view performance issue
818542016-06-15
7:55
2016-11-23
18:58
MySQL Server: OptimizerClosed
(1606 days)
S35.7, 5.7.13AnyAnyForce index is skipped while executing select count(*)
832872016-10-06
12:54
2016-11-19
16:28
MySQL Server: OptimizerClosed
(1613 days)
S35.7AnyAnycreated_tmp_tables statistic is wrong
418902009-01-05
22:53
2011-02-16
23:43
MySQL Server: OptimizerClosed
(4377 days)
S36.0.9-releaseAnyAnyFalcon: New execution plans with MRR cause slowdown for group of queries
473302009-09-15
15:39
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4224 days)
S55.0.77, 5.1.34, 5.1.37Linux (Debian x64)AnySlow query with left join and having.
218492006-08-26
10:07
2011-02-16
23:43
MySQL Server: OptimizerClosed
(4028 days)
S55.0.32-BK, 4 and 5, 5.1.42-bzrLinux (linux)Anyselect count distinct has rotten performance on at least versions 4&5 of mysql.
763492015-03-17
11:35
2015-07-19
21:30
MySQL Server: OptimizerClosed
(2099 days)
S25.6AnyAnymemory leak in add_derived_key()
179522006-03-06
5:22
2012-10-15
13:48
MySQL Server: OptimizerClosed
(3106 days)
S54.1.18Linux (Linux)Anynested query super slow..should not be
814692016-05-17
21:51
2016-05-18
6:54
MySQL Server: OptimizerVerified
(1795 days)
S35.6.30, 5.7.12AnyAnySlow performance for IN subquery and UNION
478842009-10-07
3:24
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4096 days)
S25.1.39, 5.1.44, 5.5.99Linux (Linux web2 2.6.18-92.1.18.el5.028stab060.8 #1 SMP Mon Feb 9 21:44:50 MSK 2009 x86_64)AnyMySQL 5.1.39 failed to use index
689792013-04-17
3:47
2018-07-11
15:11
MySQL Server: OptimizerVerified
(2887 days)
S55.6.10LinuxAnyperformance regression of MySQL 5.6.10?
942962019-02-12
18:17
2019-02-13
19:41
MySQL Server: OptimizerClosed
(794 days)
S58.0.11Ubuntu (Ubuntu 16.04.1 LTS)x86 (x86_64)Poor Optimizer Performance with Composite Index, IN() function, and many Tuples
354682008-03-20
20:01
2011-02-16
23:43
MySQL Server: OptimizerClosed
(3799 days)
S36.0.4AnyAnySlowdown and wrong result for uncorrelated subquery w/o where
364492008-05-01
10:09
2011-02-16
23:43
MySQL Server: OptimizerClosed
(4492 days)
S26.0.6-preAnyAnySignificant slowdown for (ANY|SOME) subqueries processed with semijoin
782132015-08-25
20:03
2015-10-23
12:55
MySQL Server: OptimizerClosed
(2019 days)
S25.6, 5.6.26, 5.5.46, 5.1.77Any (Mac OS X 10.9 and CentOS 6)AnySpatial index causes incorrect cardinality for all non-primary indexes
90172005-03-07
11:02
2005-04-28
15:48
MySQL Server: OptimizerClosed
(5833 days)
S24.1.10Microsoft Windows (WinXP SP2, Linux 2.4.22)AnyRows are omitted from result set when using JOIN, XOR and ISNULL
388422008-08-18
8:17
2011-02-16
23:43
MySQL Server: OptimizerClosed
(4509 days)
S35.0.45, 4.1, 5.0, 5.1, 6.0 bzrAnyAnyFix for 25951 seems incorrect
251302006-12-18
5:46
2012-03-26
19:41
MySQL Server: OptimizerClosed
(3309 days)
S55.0.34-BK, 5.0.27, 5.1, 5.5.0Microsoft Windows (Windows, Sparc & Linux)AnyExtremely Slow "Where in (Select... )" Subqueries GROUP BY / HAVING related
728542014-06-03
20:12
2017-10-05
15:43
MySQL Server: OptimizerClosed
(1290 days)
S25.6.17AnyAnyExtremely slow performance with outer joins and join buffer
480602009-10-14
21:20
2011-02-16
23:44
MySQL Server: OptimizerClosed
(4169 days)
S35.5, 6.0-codebaseAnyAnyMemory leak - Item::val_bool() (item.cc:184) from optimizer_subquery grammar
745902014-10-27
11:16
2014-12-01
16:56
MySQL Server: OptimizerClosed
(2360 days)
S35.7.6AnyAnyMemory leak in unit test CostEstimationTest.MergeManyBuff
240352006-11-07
8:57
2007-02-27
20:23
MySQL Server: OptimizerClosed
(5163 days)
S55.0.34-BK, 5.0.26, 5.0.27Linux (Linux, FREEBSD)Anyperformance of update query difference between 5.0.22-log AND 5.0.27-log
479142009-10-08
9:10
2012-03-26
19:30
MySQL Server: OptimizerClosed
(3309 days)
S24.1 and 5.1Microsoft Windows (Windows Server 2003)AnyPerformance Issue with Subquery
764602015-03-23
13:01
2015-04-08
13:31
MySQL Server: OptimizerClosed
(2201 days)
S35.7.5AnyAnyCost constant cache's mutex not instrumented by performance schema
832472016-10-03
14:02
2016-12-15
15:06
MySQL Server: OptimizerClosed
(1647 days)
S35.6.33AnyAnySevere regression in my_strnxfrm() from mysql-5.5 -> 5.6
196492006-05-09
17:57
2006-10-10
18:58
MySQL Server: OptimizerClosed
(5303 days)
S25.0.25-BK, 5.0.18Solaris (Solaris)AnyExtremely slow join
234102006-10-18
7:47
2012-05-18
20:19
MySQL Server: OptimizerDuplicate
(5149 days)
S55.0.26Any (*)Any"select * from... where .. order by" very slow when 0 rows match the where cond
326652007-11-23
16:26
2011-02-16
23:43
MySQL Server: OptimizerClosed
(3798 days)
S35.1.22-rc-Debian_1-logAnyAnyQuery with dependent subquery is too slow
338332008-01-12
15:31
2008-04-02
17:22
MySQL Server: OptimizerClosed
(4763 days)
S25.0-bk, 5.1-bkAnyAnyNo rows are returned, even though query matches
448022009-05-11
20:35
2011-09-24
17:15
MySQL Server: OptimizerClosed
(3493 days)
S34.1, 5.0, 5.1, 6.0.10-aphaLinuxAnyVery slow EXPLAIN when subqueries are used
687482013-03-22
16:26
2013-04-01
16:14
MySQL Server: OptimizerDuplicate
(2938 days)
S55.6.10Linux (Centos 5)AnySelects with large "IN" conditions are very slow
740782014-09-25
16:15
2014-10-16
19:49
MySQL Server: OptimizerVerified
(2375 days)
S55.6.19/5.5/5.7Linux (Ubuntu 14)Anyjoin of large table to small table is slow if small table has less than 7 rows
827252016-08-25
15:55
2016-09-14
6:28
MySQL Server: OptimizerVerified
(1676 days)
S55.7.14, 5.7.15CentOS (Linux rda-db-rep.ucar.edu 3.10.0-327.28.2.el7.x86_64 #1 SMP Wed Aug 3 11:11:39 UTC 2016 x86_64 x86_6)AnyExtremely slow query when optimizer_switch='derived_merge=ON'
1004792020-08-10
9:04
2020-08-15
12:37
MySQL Server: OptimizerVerified
(247 days)
S58.0AnyAnysearch with in() function runs really slow
987712020-02-28
6:29
2020-03-02
18:39
MySQL Server: OptimizerVerified
(414 days)
S25.7, 5.7.29AnyAnyPerformance impact while selecting data from a JSON type column
942242019-02-06
16:45
2019-11-17
10:39
MySQL Server: OptimizerVerified
(800 days)
S35.6, 5.6.43Any (any)Any (any)[5.6] Optimizer reconsiders index based on index definition order, not value
946552019-03-14
11:04
2020-09-25
9:57
MySQL Server: OptimizerClosed
(406 days)
S28.0AnyAnySome GIS function do not use spatial index anymore
950582019-04-18
18:12
2019-04-25
2:29
MySQL Server: OptimizerVerified
(723 days)
S35.7.21AnyAnyIndex not used for column with IS TRUE or IS FALSE operators
985202020-02-08
9:37
2020-05-05
14:51
MySQL Server: OptimizerVerified
(347 days)
S58.0AnyARMSuboptimal implementations for some load/store functions for little-endian arch
938452019-01-07
21:55
2020-11-18
13:48
MySQL Server: OptimizerVerified
(829 days)
S25.7,8.0.11,8.0.13AnyAnyOptimizer choose wrong index, sorting index instead of filtering index
928502018-10-19
0:46
2018-10-22
5:31
MySQL Server: OptimizerVerified
(908 days)
S35.7.23AnyAnyBad select+order by+limit performance in 5.7
838562016-11-17
4:19
2019-11-15
17:31
MySQL Server: OptimizerVerified
(1581 days)
S35.7.13,5.7.16CentOSAnyIndex ref not used for multi-column IN - type or collation conversion warning
868842017-06-30
12:44
2017-10-24
14:25
MySQL Server: OptimizerClosed
(1384 days)
S38.0.3AnyAnyCreate decimal microbenchmarks
867102017-06-15
8:57
2017-07-28
2:01
MySQL Server: OptimizerClosed
(1359 days)
S28.0.2-dmr-enterprise-commercial-advancedLinuxAnyPerformance issue of explicit COLLATE clause
1012202020-10-18
0:37
2021-02-23
18:44
MySQL Server: OptimizerClosed
(53 days)
S58.0.21AnyAnyFilesort used for ORDER BY ...DESC even when DESCending index available and used
1030102021-03-17
7:33
2021-03-17
11:16
MySQL Server: OptimizerVerified
(31 days)
S58.0.23AnyAnySubquery dependent on const tables gets evaluated for unnecessary multiple times
593932011-01-10
12:47
2011-04-25
13:15
MySQL Server: OptionsClosed
(3645 days)
S25.5.8, 5.5.9-bzrAny (SunOS 5.10 Generic_142910-17 i86pc i386 i86pc)Anyhave_innodb=YES when mysqld started with --skip-innodb
809892016-04-07
8:09
2016-04-08
1:29
MySQL Server: OptionsDuplicate
(1835 days)
S2AnyAnySevere performance degradation from 5.6 to 5.7 with a long query on a larg table
800892016-01-21
1:58
2016-05-09
14:52
MySQL Server: OptionsClosed
(1804 days)
S35.6, 5.6.28LinuxAnyMemory leak from open files limit
598602011-02-01
1:28
2013-02-22
3:49
MySQL Server: OptionsClosed
(2976 days)
S35.1, 5.5, trunkAnyAnylog-slow-admin-statements and log-slow-slave-statements not displayed
967992019-09-10
0:32
2020-10-20
6:52
MySQL Server: OptionsClosed
(255 days)
S38.0.13AnyAnyContribution by Facebook: Periodic fsync in select into outfile controlled ...
694192013-06-07
7:04
2013-08-26
14:08
MySQL Server: OptionsClosed
(2791 days)
S25.6.12AnyAnyUndocumented and untested table_open_cache table_definition_cache default change
581062010-11-10
10:24
2011-02-16
23:44
MySQL Server: OptionsVerified
(3811 days)
S35.1-bugteamAnyAnyWrong directory info in general_log_file/slow_query_log_file.
692952013-05-21
16:22
2013-05-22
9:04
MySQL Server: OptionsVerified
(2887 days)
S35.1.44, 5.6.10AnyAnySlow_queries status variable incremented when it should not
299212007-07-20
3:39
2008-03-04
22:29
MySQL Server: ParserClosed
(4792 days)
S55.0.37AnyAnyMYSQLparse uses 3X more CPU in MySQL 5.0 than yyparse in MySQL 4.0
302372007-08-03
22:10
2007-10-09
17:07
MySQL Server: ParserClosed
(4939 days)
S55.0AnyAnyPerformance regression in boolean expressions
303332007-08-09
14:47
2007-10-09
17:01
MySQL Server: ParserClosed
(4939 days)
S54.0, 4.1, 5.0, 5.1AnyAnyPerformance, expressions lists in the parser
765092015-03-27
14:45
2015-04-06
23:36
MySQL Server: ParserClosed
(2210 days)
S35.7AnyAnyuse atomics to avoid MUTEX CONTENTION ON LOCK_PLUGIN DUE TO QUERY REWRITE FRAMEW
306252007-08-24
15:28
2007-10-09
17:05
MySQL Server: ParserClosed
(4939 days)
S55.0, 5.1AnyAnyPerformance, reduce depth for expressions
372522008-06-06
19:56
2015-02-06
19:01
MySQL Server: PartitionsClosed
(3230 days)
S35.1, 6.0AnyAnyPartitioning performance drops drastically with hundreds of partitions
440592009-04-03
2:26
2011-02-16
23:43
MySQL Server: PartitionsClosed
(4137 days)
S55.1.32, 5.1.35-bzrLinux (CentOS 5 kernel 2.6.18-53.el5 SMP x86_64)AnyIncorrect cardinality of indexes on a partitioned table
482292009-10-22
13:22
2011-02-16
23:44
MySQL Server: PartitionsClosed
(3956 days)
S55.1.37,5.1.38Linux (CentOS 4.4)Anygroup by performance issue of partitioned table
563802010-08-30
18:07
2011-02-16
23:44
MySQL Server: PartitionsClosed
(3734 days)
S25.1.50AnyAnyvalgrind memory leak warning from partition tests
358452008-04-04
20:08
2011-02-16
23:43
MySQL Server: PartitionsClosed
(4137 days)
S55.1.23AnyAnyunneccesary call to ha_start_bulk_insert for not used partitions
265272007-02-21
14:49
2007-10-29
18:41
MySQL Server: PartitionsClosed
(4919 days)
S55.1.14-logLinux (Ubuntu 6.10 x86_64/Windows)AnyLOAD DATA INFILE extremely slow with partitioned table
555062010-07-23
11:45
2011-02-16
23:44
MySQL Server: PartitionsDuplicate
(3919 days)
S35.1AnyAnyMemory leak on partition_error.test
841072016-12-08
11:15
2016-12-21
10:50
MySQL Server: PartitionsClosed
(1580 days)
S35.7.16AnyAnySevere slowdown on partitioned table with simple ORDER BY ASC change to DESC
834702016-10-20
18:24
2017-05-16
2:53
MySQL Server: PartitionsClosed
(1432 days)
S35.7.16-debug-logAnyAnyReverse scan on a partitioned table does ICP check incorrectly, causing slowdown
791452015-11-06
2:42
2016-02-08
12:57
MySQL Server: PartitionsClosed
(1983 days)
S35.7.10AnyAnyMemory Leak in Ha_innopart_share::set_v_templ partitioned on virtual column
673512012-10-24
8:02
2017-05-03
16:04
MySQL Server: PartitionsVerified
(3059 days)
S25.5.27-29.0LinuxAnyCardinality samples of partitioned tables sometimes widely off
721152014-03-24
19:29
2015-07-22
7:17
MySQL Server: PartitionsClosed
(2096 days)
S25.6.16AnyAnyVery slow create/alter table with partitions and STATS_PERSISTENT=1
178942006-03-03
12:00
2006-03-15
12:52
MySQL Server: PartitionsClosed
(5512 days)
S15.1.7Linux (Linux, Windows)AnyComparison with "less than" operator fails with Range partition
524552010-03-30
1:54
2011-02-16
23:44
MySQL Server: PartitionsClosed
(3838 days)
S35.1AnyAnySubpar INSERT ON DUPLICATE KEY UPDATE performance with many partitions
525172010-04-01
3:10
2011-02-16
23:44
MySQL Server: PartitionsClosed
(3838 days)
S35.1.45AnyAnyRegression in ROW level replication performance with partitions
700012013-08-12
18:46
2017-06-23
9:11
MySQL Server: PartitionsClosed
(2719 days)
S15.6.13AnyAnyPartitioned tables do not use ICP - severe performance loss after partitioning
440162009-04-01
17:14
2011-02-16
23:43
MySQL Server: Performance SchemaClosed
(4111 days)
S3mysql-6.0-perfAnyAnyperformance_schema_enabled=0 at server startup has no effect
441902009-04-09
15:17
2011-02-16
23:43
MySQL Server: Performance SchemaClosed
(4111 days)
S3mysql-6.0-perfAnyAnyPerformance schema: nanosecond and ticks timers not implemented on windows
442102009-04-11
2:04
2011-02-16
23:43
MySQL Server: Performance SchemaClosed
(4060 days)
S2mysql-6.0-perfAnyAnyPerformance schema: pool-of-threads threads instrumentation is missing
447102009-05-07
9:07
2011-02-16
23:43
MySQL Server: Performance SchemaClosed
(4111 days)
S36.0-perfschemaLinuxAnyassertion failure in mdl when server starts, related to performance schema
450902009-05-26
7:58
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(4111 days)
S36.0.12-alpha-log-perfschemaAnyAnyperformance schema is enabled at startup
455102009-06-15
22:09
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(4111 days)
S3mysql-6.0-perfschemaAnyAnyPerformance schema: STAT and FSTAT are not generating waits
459562009-07-06
0:03
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(4111 days)
S36.0.12-alphaAnyAnyPerformance schema: exotic mysqld startup, bad results
486312009-11-09
9:26
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(4111 days)
S3mysql-trunk-perfschemaAnyAnyPerformance schema: unit test failures
512952010-02-18
20:27
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(4056 days)
S2mysql-next-mr, 5.5.99-m3AnyAnyBuild warnings in mdl.cc
516122010-03-01
16:22
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(4060 days)
S3mysql-next-mr, 5.5.99-m3AnyAnyUn initialized locker_lost variable in pfs_instr.cc
525022010-03-31
12:56
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(3909 days)
S1mysql-trunk (5.5.3)AnyAnyPerformance schema does not start with large mutex_instance buffers
538742010-05-21
6:56
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(3874 days)
S35.5.3-m3, 5.5.4-m3AnyAnySETUP_INSTRUMENTS.TIMED='NO' should not change TIMER_WAIT in aggregations
563242010-08-27
11:06
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(3817 days)
S3next-mr, next-mr-bugfixingAnyAnyRace Condition while shutting down MySQL: "PSI_server"
571062010-09-29
16:04
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(3780 days)
S35.6AnyAnyRobustness of memcpy calls in the performance schema
597402011-01-26
14:07
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(3719 days)
S35.6FreeBSDAnyPerformance schema test failures on freebsd
670982012-10-05
10:19
2012-12-13
16:57
MySQL Server: Performance SchemaClosed
(3047 days)
S35.6.5, 5.7.0AnyAnyperformance schema shows stray temporray tables
680092013-01-02
9:22
2020-07-15
7:58
MySQL Server: Performance SchemaDuplicate
(3019 days)
S25.5.28, 5.5.29AnyAnyFloating point exception in "insert_events_waits_history_long"
684132013-02-18
2:45
2013-09-25
2:58
MySQL Server: Performance SchemaVerified
(2761 days)
S55.6.10, 5.6.13AnyAnyperformance_schema overhead is at least 10%
700182013-08-13
19:42
2013-10-07
18:18
MySQL Server: Performance SchemaClosed
(2749 days)
S55.6 / 5.7AnyAnyPFS Overhead on frequent connect/disconnect
712982014-01-05
12:31
2014-03-29
18:21
MySQL Server: Performance SchemaClosed
(2626 days)
S35.6.15AnyAny"Waiting to get readlock" stage is not used in 5.6 any more
718082014-02-23
12:38
2018-01-31
14:40
MySQL Server: Performance SchemaClosed
(1172 days)
S35.5, 5.6, 5.7AnyAnyRemove the TICK timer in performance_schema
745462014-10-24
11:31
2014-10-24
11:43
MySQL Server: Performance SchemaClosed
(2367 days)
S3AnyAnyPERFORMANCE SCHEMA QUERY ON EVENTS_STATEMENTS_CURRENT WRONG WITH ORDER BY
757652015-02-04
15:17
2015-03-10
13:30
MySQL Server: Performance SchemaClosed
(2230 days)
S35.6.23AnyAnyPerformance Schema statement digest generation is broken with null values
776202015-07-05
15:29
2018-02-18
18:29
MySQL Server: Performance SchemaClosed
(2024 days)
S35.5, 5.6, 5.7AnyARMNo cycle timer implementation for AArch64
780682015-08-14
12:21
2015-08-18
13:08
MySQL Server: Performance SchemaVerified
(2072 days)
S35.7.8AnyAnyreplication_* tables miss information about binary log position and other
794872015-12-02
6:21
2016-01-15
13:07
MySQL Server: Performance SchemaVerified
(1962 days)
S35.6, 5.7AnyAnyProvide non-Windows implementations for LF_BACKOFF
799342016-01-12
10:48
2016-02-19
17:58
MySQL Server: Performance SchemaClosed
(1886 days)
S35.7.11AnyAnyi_perfschema.table_leak random result failure
826632016-08-20
5:12
2017-06-27
7:40
MySQL Server: Performance SchemaVerified
(1695 days)
S15.7.13, 5.7.14AnyAnymysqld hangs when accessing Performance Schema tables
693822013-06-02
19:42
2013-07-09
14:16
MySQL Server: Performance SchemaClosed
(2839 days)
S35.6.11AnyAnyPerformance schema, degradation under stress when internal buffers are full
773442015-06-14
2:18
2015-08-18
13:08
MySQL Server: Performance SchemaVerified
(2132 days)
S35.6.25AnyAnySlow start up due to performance_schema overhead on MySQL 5.6
547822010-06-24
15:31
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(3909 days)
S35.5.3-m3, 5.5.4-m3AnyAnyPerformance schema per thread accounting and thread cache
550872010-07-08
15:38
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(3915 days)
S5AnyAnyPerformance schema: optimization of the instrumentation interface
554162010-07-20
21:17
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(3872 days)
S1AnyAnyRenaming of performance_schema tables in 5.5
554622010-07-21
23:22
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(3893 days)
S55.5.3-m3AnyAnyPerformance schema: reduce the overhead of PFS_events_waits::m_wait_class
564752010-09-01
23:17
2011-07-22
18:21
MySQL Server: Performance SchemaClosed
(3557 days)
S35.6AnyAnyMissing thread states in performance_schema.THREADS / SHOW PROFILE
597992011-01-28
18:00
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(3719 days)
S35.5.6AnyAnyhandler statistics for the performance schema engine
700282013-08-14
8:08
2013-10-01
16:39
MySQL Server: Performance SchemaClosed
(2755 days)
S25.6.13Linux (Oracle Linux 6)AnyP_S threads.INSTRUMENTED not set according to setup_actors
712782014-01-02
17:22
2014-02-17
18:07
MySQL Server: Performance SchemaClosed
(2616 days)
S35.6AnyAnyNUMBER OF ROWS IN PERFORMANCE SCHEMA TABLES
731122014-06-25
11:47
2016-02-23
15:52
MySQL Server: Performance SchemaVerified
(1880 days)
S35.6.16, 5.6.17, 5.6.20LinuxAnyPerformance Schema - Statement Tables - Stored Procedures Counters are 0
763052015-03-13
0:13
2015-04-08
13:26
MySQL Server: Performance SchemaClosed
(2201 days)
S35.7.6AnyAnyCom_stmt_reprepare missing in Performance Schema implementation of SHOW STATUS
765622015-04-01
15:11
2016-02-03
19:32
MySQL Server: Performance SchemaClosed
(2173 days)
S35.7.8AnyAnySeveral performance schema unit tests fails
783152015-09-03
10:15
2016-02-04
16:23
MySQL Server: Performance SchemaClosed
(2053 days)
S35.7.9AnyAnyDefault value of two options in perf schema is not updated in 5.7
797842015-12-28
6:50
2016-01-21
15:06
MySQL Server: Performance SchemaClosed
(1913 days)
S35.6.24 5.7.10AnyAnyupdate setup_instruments do not affect the global mutex/rwlock/cond
809792016-04-06
14:25
2016-05-04
16:55
MySQL Server: Performance SchemaVerified
(1836 days)
S35.7AnyAnyDoublewrite buffer event waits should be annotated for Performance Schema
925322018-09-21
16:26
2021-01-19
15:13
MySQL Server: Performance SchemaClosed
(89 days)
S38.0.11AnyAnyContribution by Facebook: Performance schema for Query attributes
976002019-11-12
20:05
2019-11-26
3:43
MySQL Server: Performance SchemaClosed
(508 days)
S38.0.17AnyAnyPerfschema socket stats are not captured for SSL connections
1004322020-08-05
7:55
2020-08-05
14:03
MySQL Server: Performance SchemaVerified
(255 days)
S58.0.21AnyARMOptimal memory-barrier for performance-schema counter
955022019-05-23
16:47
2019-05-23
16:52
MySQL Server: Performance SchemaClosed
(695 days)
S25.7.20-logCentOS (CentOS release 6.5 (Final))x86 (Intel(R) Xeon(R) CPU E5-2620 v4 @ 2.10GHz)Memory leak on memory/performance_schema/table_handles
1003362020-07-27
15:58
2020-07-28
13:45
MySQL Server: Performance SchemaVerified
(263 days)
S35.7AnyAnyperformance_schema.status_by_thread table not populating on Linux
999892020-06-26
1:06
2021-01-10
22:04
MySQL Server: Performance SchemaClosed
(97 days)
S38.0.x, 8.0.20AnyAnyInconsistency when joining Perf Schema schema tables when PK is larger than 48 c
1006242020-08-24
15:05
2021-02-03
17:46
MySQL Server: Performance SchemaClosed
(73 days)
S35.7.30, 8.0.21, 5.7.31AnyAnyTotal memory allocation for P_S is different in different sources
1009622020-09-26
5:17
2020-10-26
11:42
MySQL Server: Performance SchemaAnalyzing
(173 days)
S35.7AnyAnymemory_summary_%_by_event_name Have different values
1010182020-10-01
9:28
2020-10-09
15:44
MySQL Server: Performance SchemaClosed
(190 days)
S58.0AnyAnyHigh contention on last_value in my_timer_microseconds
923642018-09-11
12:06
2019-02-28
18:07
MySQL Server: Performance SchemaClosed
(779 days)
S35.7.22, 8.0.12AnyAnyevents_transactions_summary_global_by_event_name not working as expected
985452020-02-10
23:45
2020-02-11
4:55
MySQL Server: Performance SchemaVerified
(431 days)
S38.0.19AnyAnyPerfschema tables are not collation aware
949252019-04-06
0:15
2019-04-24
13:37
MySQL Server: Performance SchemaVerified
(724 days)
S38.0.15AnyAnyWrong Query Sample Text in Performance Query
932812018-11-22
4:03
2018-12-17
23:09
MySQL Server: Performance SchemaClosed
(869 days)
S18.0.12AnyAnyOdd memory load/increase when using --performance-schema-max-digest-length=large
847862017-02-02
8:17
2017-02-03
16:04
MySQL Server: Performance SchemaClosed
(1534 days)
S15.7.17-11AnyAny--performance-schema-digests-size=1 leads to SIGSEGV
844572017-01-10
12:53
2017-02-16
14:10
MySQL Server: Performance SchemaClosed
(1521 days)
S35.6.35LinuxAnyPerformance Schema 5.6.35 unittest pft-t failing
839122016-11-21
15:28
2020-03-09
16:52
MySQL Server: Performance SchemaVerified
(1606 days)
S35.6, 5.7, 5.6.34AnyAnyTime spent sleeping before entering InnoDB is not measured/reported separately
789752015-10-27
8:02
2016-06-18
21:28
MySQL Server: Performance SchemaClosed
(1800 days)
S38.0.0-m17AnyAnySYSSCHEMA.PR_STATEMENT_PERFORMANCE_ANALYZER TEST still FAILING ON PB2 ON WINDOWS
783032015-09-02
10:02
2016-09-22
7:50
MySQL Server: Performance SchemaVerified
(2054 days)
S35.7AnyAnyAdd some DNS latency timings to performance_schema (host_cache?)
893792018-01-24
11:41
2021-03-01
7:11
MySQL Server: Performance SchemaVerified
(1179 days)
S55.7.20, 5.7.21AnyAnysummary_by_user tables get extremely slow with many users.
521342010-03-17
11:08
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(3909 days)
S3mysql-next-mr, 5.6.99-m3AnyAnyperformance schema file io, symlink in path
697272013-07-11
18:41
2016-02-25
12:24
MySQL Server: Performance SchemaClosed
(2745 days)
S35.6.11Microsoft WindowsAny--performance_schema_instrument value quoting is problematic
514472010-02-24
7:08
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(4049 days)
S2mysql-5.5.99 (Celosia)AnyAnyperformance schema evil twin files
778632015-07-28
19:00
2015-07-30
13:05
MySQL Server: Performance SchemaClosed
(2088 days)
S55.6.26AnyAnyslowdown caused by memset in sql_digest_storage.reset()
536962010-05-17
11:07
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(3761 days)
S35.6.99AnyAnyPerformance schema engine violates the PSEA API by calling my_error()
705772013-10-09
21:47
2013-10-15
18:19
MySQL Server: Performance SchemaClosed
(2741 days)
S35.6.14AnyAnyRead/Write mutexes on Binlog delegate classes are not counted on perf schema
775772015-07-01
10:51
2015-07-15
12:18
MySQL Server: Performance SchemaClosed
(2104 days)
S35.5, 5.6, 5.7AnyAnysetup_timers initialization assumes CYCLE timer is always available
779442015-08-05
7:11
2015-08-21
18:43
MySQL Server: Performance SchemaClosed
(2066 days)
S35.7.8-rc, 5.7.9LinuxAnyperformance_schema_instrument='%=OFF', not disable all instruments
807802016-03-17
11:55
2016-04-14
0:45
MySQL Server: Performance SchemaClosed
(1845 days)
S35.7AnyAnyAdd Performance Schema / sys Schema Memory Monitoring Example
1013912020-10-30
3:04
2020-11-19
16:59
MySQL Server: Performance SchemaVerified
(149 days)
S58.0, 8.0.22AnyAnyPerformance Schema storage engine doesn't use index optimizations on group by
730562014-06-19
21:34
2018-03-15
14:17
MySQL Server: Prepared statementsClosed
(1863 days)
S55.7, 5.7.8AnyAnyPrepared Statements ABSURDLY SLOW due to inefficient query creation for logging
676762012-11-22
6:37
2014-07-14
12:23
MySQL Server: Prepared statementsClosed
(2945 days)
S25.6.7AnyAnyprepared statement is very slow while binlog was enabled
296872007-07-10
10:09
2007-07-23
0:47
MySQL Server: Prepared statementsClosed
(5017 days)
S15.1.17, 5.1.20AnyAnymysql_stmt_store_result memory leak in libmysqld
621172011-08-08
19:53
2011-08-10
10:47
MySQL Server: Prepared statementsDuplicate
(3538 days)
S25.1.58-enterpriseSolarisAnyLarge Batch Update causes apparent large memory leaks and crashes server
386262008-08-07
11:28
2008-08-07
12:36
MySQL Server: Prepared statementsDuplicate
(4636 days)
S35.0.66aAnyAnymemory leak with materialized cursor and prepared statement
859332017-04-13
13:25
2017-09-27
1:33
MySQL Server: Prepared statementsClosed
(1298 days)
S58.0.1-dmrAnyAnyPerformance regression with Prepared Statements
608012011-04-08
3:51
2011-05-09
3:59
MySQL Server: Query CacheClosed
(3631 days)
S2mysql Ver 14.12 Distrib 5.0.45Linux (Red Hat Enterprise Linux Server release 5.3 )AnySelect Query is too much slow and taking upto 23 seconds to complete
649242012-04-10
9:03
2015-03-15
20:45
MySQL Server: Query CacheDuplicate
(3263 days)
S35.1.61Linux (2.6.32-5-amd64 #1 SMP)AnyCacheing long SELECT statement does too many prunes
475292009-09-22
22:15
2012-05-18
20:19
MySQL Server: Query CacheDuplicate
(3782 days)
S55.1.38, 5.1.39AnyAnyquery cache performance is bad on multi-core servers
385512008-08-04
22:08
2011-02-16
23:43
MySQL Server: Query CacheClosed
(4155 days)
S55.1, 6.0AnyAnyRBR/MBR + Query Cache + "invalidating query cache entries (table)" => slow slave
991402020-04-01
6:53
2020-05-18
12:10
MySQL Server: Row Based Replication ( RBR )Duplicate
(380 days)
S38.0.19CentOSx868.0 single thread applying performance regression of update_non_index
382072008-07-17
16:56
2012-05-18
20:19
MySQL Server: Row Based Replication ( RBR )Duplicate
(4636 days)
S55.1.25Linux (x86_64)AnyRow-based Replication (RBR) is CPU bound (invalidating query cache)
201982006-06-01
12:39
2016-10-16
20:45
MySQL Server: Row Based Replication ( RBR )Duplicate
(5432 days)
S35.1 source AnyRBR injector is too slow
358432008-04-04
19:56
2008-10-17
17:23
MySQL Server: Row Based Replication ( RBR )Closed
(4565 days)
S35.1.23AnyAnySlow replication slave when using partitioned myisam table
736482014-08-19
22:10
2018-07-06
3:09
MySQL Server: Row Based Replication ( RBR )Verified
(1163 days)
S2Server version: 5.6.16-log MySQL Communi, 5.6.39LinuxAnyinnodb table replication is very slow with some of the partioned table
820032016-06-25
16:15
2016-08-18
11:12
MySQL Server: Row Based Replication ( RBR )Closed
(1703 days)
S35.7.13AnyAnyRows event are decoded one byte at a time
391062008-08-28
20:09
2011-02-16
23:43
MySQL Server: Row Based Replication ( RBR )Closed
(4564 days)
S35.1AnyAnySUPER is not required to change binlog format for session
465542009-08-04
19:50
2011-02-16
23:44
MySQL Server: Row Based Replication ( RBR )Closed
(3792 days)
S36.0-codebase, mysql-next-mr-wl5092AnyAnyRBR: pending rows event can be flushed too soon sometimes.
815002016-05-19
9:10
2018-04-30
11:20
MySQL Server: Row Based Replication ( RBR )Closed
(1083 days)
S35.7+AnyAnydead branch in search_key_in_table()
645032012-03-01
5:27
2012-05-02
11:21
MySQL Server: ReplicationClosed
(3321 days)
S25.1AnyAnymysql frequently ignores --relay-log-space-limit
693412013-05-29
0:55
2016-04-07
5:46
MySQL Server: ReplicationClosed
(2843 days)
S55.6.11AnyAnysemi-sync replication is very slow with many clients
742332014-10-06
10:40
2017-07-26
22:46
MySQL Server: ReplicationClosed
(1366 days)
S35.6.22,5.5 5.6AnyAnySlave's slow log has empty BEGINs for RBR events
746072014-10-28
16:25
2015-09-14
15:43
MySQL Server: ReplicationClosed
(2220 days)
S25.6.21AnyAnyslave io_thread may get stuck when using GTID and low slave_net_timeouts
755252015-01-16
8:59
2015-07-01
15:11
MySQL Server: ReplicationClosed
(2117 days)
S25.6.22AnyAnyMTS STOP SLAVE takes way too long (when worker threads are slow)
757672015-02-04
15:33
2015-05-21
22:39
MySQL Server: ReplicationClosed
(2159 days)
S25.7AnyAnyset gtid_purged should not rotate binlog
887202017-11-30
14:52
2018-02-24
10:49
MySQL Server: ReplicationVerified
(1233 days)
S35.6, 5.7, 8.0.3, 5.6.38, 5.7.20AnyAnyInconsistent and unsafe FLUSH behavior in terms of replication
990062020-03-20
11:45
2020-04-16
10:01
MySQL Server: ReplicationVerified
(368 days)
S35.7 and 8.0AnyAnyGTID Synchronisation speed when doing START SLAVE
427572009-02-11
12:01
2011-02-16
23:43
MySQL Server: ReplicationClosed
(4079 days)
S3AnyAnyRedundant use of LOCK_log in MYSQL_BIN_LOG::write(Log_event*)
434262009-03-05
16:59
2014-01-15
15:39
MySQL Server: ReplicationClosed
(2649 days)
S55.0AnyAnySimple performance changes for replication
451082009-05-26
21:26
2011-02-16
23:44
MySQL Server: ReplicationClosed
(4314 days)
S36.0.11AnyAnySlave skip counter not working as expected on debian platform
479722009-10-10
21:36
2016-10-16
20:45
MySQL Server: ReplicationDuplicate
(3551 days)
S25.1.40AnyAnyChange in MBR algorithm causes replication performance degradation
522242010-03-19
15:17
2016-10-16
20:45
MySQL Server: ReplicationVerified
(4044 days)
S3AnyAnyreplication of CREATE TEMPOARARY TABLE should be optional
572752010-10-06
8:53
2011-02-16
23:44
MySQL Server: ReplicationClosed
(3755 days)
S35.5, next-mrAnyAnybinlog_cache_size affects trx- and stmt-cache and gets twice the expected memory
726402014-05-14
6:05
2014-07-21
15:34
MySQL Server: ReplicationClosed
(2475 days)
S35.7AnyAnyrpl.rpl_circular_for_4_hosts fails with result mismatch nondeterministic results
726802014-05-19
12:39
2014-05-20
8:36
MySQL Server: ReplicationVerified
(2524 days)
S35.6.17AnyAnyMake changing MASTER_AUTO_POSITION = 0 user-friendly and document behaviour
742782014-10-08
15:38
2015-08-21
9:31
MySQL Server: ReplicationVerified
(2066 days)
S35.6.17, 5.6.26AnyAnytĥread_id title in binary log output is wrong. Should be process(list)_id
743282014-10-11
4:54
2016-12-12
4:38
MySQL Server: ReplicationClosed
(2238 days)
S35.7.5AnyAnyserious tps decline if gtid is enabled in 5.7
744232014-10-16
22:36
2016-02-02
19:15
MySQL Server: ReplicationClosed
(2137 days)
S35.7+AnyAny RECEIVED_TRANSACTION_SET field on replication_connection_status shows garbage
752992014-12-23
15:45
2017-03-23
12:11
MySQL Server: ReplicationDuplicate
(1542 days)
S35.6AnyAnygroup commit with GTID enabled need more optimization
755702015-01-21
7:52
2016-02-20
17:43
MySQL Server: ReplicationClosed
(2182 days)
S25.6.20LinuxAnysemi-sync replication performance degrades with a high number of threads
760492015-02-25
15:13
2015-02-25
21:50
MySQL Server: ReplicationVerifiedS35.6.22AnyAnyFiltered replication events do not reset the System lock thread state
782642015-08-28
16:11
2016-04-27
15:05
MySQL Server: ReplicationClosed
(2046 days)
S35.7.6AnyAnyDO NOT ALLOCATE MEMORY ON GR PLUGIN P_S INTERFACE IMPLEMENTATION
819102016-06-17
16:35
2016-11-02
13:34
MySQL Server: ReplicationClosed
(1695 days)
S35.7.14AnyAnyWRITE SET HASHES SHOULD HAVE A 64BITS OPTION TO REDUCE WRITE CONFLICTS
824222016-08-03
11:27
2017-01-26
19:15
MySQL Server: ReplicationClosed
(1583 days)
S35.7.14AnyAnyGTIDS REDUCE PERFORMANCE ON WORKLOADS WITH MANY SMALL TRANSACTIONS
403372008-10-27
3:05
2011-02-16
23:43
MySQL Server: ReplicationClosed
(4174 days)
S55.0, 5.1, 6.0AnyAnyFsyncing master and relay log to disk after every event is too slow
777782015-07-19
5:57
2017-03-31
17:24
MySQL Server: ReplicationClosed
(1478 days)
S35.6.25AnyAnytuning the log_lock contention for IO_THREAD and SQL_THREAD in rpl_slave.cc
233352006-10-16
14:16
2007-09-05
20:45
MySQL Server: ReplicationClosed
(4973 days)
S25.1.12Linux (Linux 32 Bit)AnyInnoDB hangs if BLOBS and BINLOG are used during new performance test
806512016-03-08
3:45
2016-04-07
5:46
MySQL Server: ReplicationDuplicate
(1836 days)
S35.5 5.6AnyAnylarget rpl_semi_sync_master_timeout will affect performance
969852019-09-24
7:17
2019-10-24
18:05
MySQL Server: ReplicationVerified
(541 days)
S55.7.22;8.0.11AnyAnyMySQL group replication pipeline memory reuse
980702019-12-25
12:33
2020-01-06
8:51
MySQL Server: ReplicationVerified
(478 days)
S58.0.18AnyAnyOptimize write performance when group commit
1017172020-11-23
12:03
2020-12-15
12:53
MySQL Server: ReplicationVerified
(127 days)
S28.0, 8.0.22AnyAnyPoor performance on a GTID slave when log_slave_updates is disabled
151322005-11-22
12:55
2005-11-22
14:20
MySQL Server: ReplicationClosed
(5625 days)
S35.0-wl1012Linux (linux)AnyRBR: memory leak when updating large rows
161752006-01-04
7:43
2006-03-02
15:13
MySQL Server: ReplicationClosed
(5525 days)
S35.0 Anymemory leak in rpl_trigger.test
485422009-11-04
18:43
2016-10-16
20:45
MySQL Server: ReplicationDuplicate
(4054 days)
S35.1.39, 5.1.40, 5.1.41AnyAnyImplicit drops on temporary tables aren't always replicated to slaves
489932009-11-23
13:27
2011-02-16
23:44
MySQL Server: ReplicationClosed
(3953 days)
S35.1.41, 5.1.44-bzr,mysql-5.5.99-m3Linux (32-bit, Mac OS X)Anyvalgrind errors in mysqlbinlog
566492010-09-08
13:56
2011-02-16
23:44
MySQL Server: ReplicationClosed
(3777 days)
S2trunk, 5.6AnyAnyValgrind warnings for memory leak in semisync plugin (Delegate class)
566502010-09-08
13:56
2011-02-16
23:44
MySQL Server: ReplicationClosed
(3777 days)
S2trunk, 5.6AnyAnyValgrind warnings for memory leak in semisync plugin (MYSQL object not freed)
728852014-06-05
7:50
2018-08-26
20:45
MySQL Server: ReplicationDuplicate
(2208 days)
S15.6.17Linux (Red Hat Enterprise Linux Server release 6.3)AnyMySQL 5.6 memory leak
1912003-03-25
14:24
2003-04-18
13:56
MySQL Server: ReplicationClosed
(6574 days)
S33.23Linux (Linux at least)AnyMany connections from the slave to the master cause "alarm queue is full"
182802006-03-16
13:27
2006-03-18
18:03
MySQL Server: ReplicationClosed
(5509 days)
S35.1.8Any (ALL)AnyRBR: Extreneous table maps when writing to slow_log and general_log
307032007-08-29
17:26
2011-02-16
23:43
MySQL Server: ReplicationClosed
(4174 days)
S35.0 (all)AnyAnySHOW STATUS LIKE 'Slave_running' is not compatible with `SHOW SLAVE STATUS'
375782008-06-23
7:00
2016-10-16
20:45
MySQL Server: ReplicationVerified
(4679 days)
S35.1, 5.0, 6.0AnyAnyExecute Stored Functions Without Prelocks
486322009-11-09
9:38
2011-02-16
23:44
MySQL Server: ReplicationClosed
(3953 days)
S3AllAnyAnyFix for Bug #23300 Has Not Been Backported To 5.x Release
872492017-07-30
0:44
2019-01-14
9:20
MySQL Server: ReplicationVerified
(1206 days)
S2AnyAnyRelay logs shouldn't be purged if options unrelated in CHANGE MASTER is executed
813302016-05-05
19:41
2020-02-04
17:19
MySQL Server: ReplicationVerified
(576 days)
S25.6.29, 5.7.17, 8.0.16AnyAnycircular semisync replication fails on msr (and slow without msr)
852512017-03-01
13:16
2017-10-27
8:22
MySQL Server: ReplicationClosed
(1296 days)
S25.7.17, 8.0.0AnyAnyMemory leak in master-master GTID replication with sync_relay_log_info
679832012-12-28
16:39
2013-01-31
9:00
MySQL Server: ReplicationClosed
(2998 days)
S15.5.25aAnyAnyMemory leak on filtered slave
91412005-03-12
9:11
2005-07-26
13:47
MySQL Server: ReplicationClosed
(5744 days)
S34.1.10Any (any)Any4.1 does not log into slow log ALTER, OPTIMIZE and ANALYZE statements
264892007-02-20
6:14
2010-12-31
12:40
MySQL Server: ReplicationClosed
(4819 days)
S25.0.27 & 5.0.37, 5.1.22Any (Linux, Win32)AnyCorruption in relay logs
711972013-12-21
8:48
2015-01-05
2:17
MySQL Server: ReplicationClosed
(2614 days)
S25.6.15, 5.6.14, 5.6.13, 5.6.16, 5.7.3LinuxAnymysql slave sql thread memory leak
714252014-01-20
14:46
2014-07-14
16:32
MySQL Server: ReplicationDuplicate
(2641 days)
S15.6AnyAnyMySQL 5.6 memory leak
853712017-03-08
10:46
2018-01-18
10:36
MySQL Server: ReplicationClosed
(1240 days)
S25.7.17AnyAnyMemory leak in multi-source replication when binlog_rows_query_log_events=1
870082017-07-11
9:23
2017-07-14
10:20
MySQL Server: ReplicationDuplicate
(1373 days)
S35.7.18AnyAnyBecuse using "xa commit one phase" in master DB, slave have memory leak
895962018-02-09
4:17
2018-02-09
12:55
MySQL Server: ReplicationVerified
(1163 days)
S38.0.4Ubuntu (17.10)Any__tls_get_addr leak on Ubuntu 17.10
730182014-06-17
3:20
2015-06-22
10:02
MySQL Server: ReplicationVerified
(2126 days)
S55.6AnyAny improve performance when binlog_order_commits=0 and sync_binlog >1
832702016-10-05
14:13
2017-04-11
7:25
MySQL Server: ReplicationClosed
(1467 days)
S55.7.15AnyAnyPerformance degradation when the server has many gtids
816302016-05-28
5:46
2016-08-31
6:30
MySQL Server: ReplicationVerified
(1690 days)
S55.7.12AnyAnyMySQL 5.7 is 37-45% slower then 5.6 when using binlogging due to defaults change
816942016-06-02
16:42
2016-11-02
13:31
MySQL Server: ReplicationClosed
(1713 days)
S3AnyAnyCHANNEL SERVICE INTERFACE HAS NO FUNCTION TO GET RETRIEVED GTID SET
853522017-03-08
0:44
2017-08-14
12:36
MySQL Server: ReplicationClosed
(1342 days)
S55.6, 5.7, 5.6.35AnyAnyReplication regression with RBR and partitioned tables
929642018-10-26
11:57
2020-09-18
19:38
MySQL Server: ReplicationClosed
(211 days)
S55.7.23Debian (8.0, 9.0)x86Slave performance degrades over time
233002006-10-15
6:00
2011-02-16
23:43
MySQL Server: ReplicationClosed
(3953 days)
S34.1+Any (*)AnySlow query log on slave does not log slow replicated statements
274922007-03-28
9:05
2017-05-21
20:45
MySQL Server: ReplicationDuplicate
(4559 days)
S35.0.40-BK, 5.0.37AnyAnyReplication queries are not logged in slow query log
345822008-02-15
10:35
2011-02-16
23:43
MySQL Server: ReplicationClosed
(4137 days)
S25.0.46-enterprise-gpl-logAnyAnyFLUSH LOGS does not close and reopen the binlog index file
450142009-05-21
17:57
2016-10-16
20:45
MySQL Server: ReplicationDuplicate
(4336 days)
S35.1.34-logAnyAnylog-slow-slave-statements does not work in in 5.1.34
451362009-05-27
15:18
2016-10-16
20:45
MySQL Server: ReplicationDuplicate
(4343 days)
S35.1.34-logAnyAnylog-slow-slave-statements doesn't work in 5.1.34
506202010-01-26
11:36
2011-02-16
23:44
MySQL Server: ReplicationClosed
(3953 days)
S35.5.99, next-mr, 5.1AnyAnyAdding an index to a table prevents slave from logging into slow log
578992010-11-01
15:46
2011-02-16
23:44
MySQL Server: ReplicationClosed
(3754 days)
S35.5Linux (SUSE 11 64-bit)AnyCertain reserved words should not be reserved
949942019-04-12
3:06
2019-07-25
11:25
MySQL Server: Storage EnginesClosed
(632 days)
S28.0.15Linuxx86Memory leak detect on temptable storage engine
987392020-02-25
18:27
2020-06-11
17:21
MySQL Server: Storage EnginesClosed
(310 days)
S38.0.19AnyAnyTempTable storage engine slow if mmap is required
909872018-05-23
10:03
2018-06-05
14:50
MySQL Server: Storage EnginesVerified
(1051 days)
S55.7.17AnyAnypartition table index next same scan ineffective
816992016-06-03
4:35
2016-06-14
7:49
MySQL Server: SYS SchemaVerified
(1768 days)
S35.7.12, 5.7.13AnyAnyps_statement_avg_latency_histogram often fails to draw the point of max(avg_us)
1005372020-08-15
8:11
2020-08-17
12:02
MySQL Server: SYS SchemaVerified
(243 days)
S58.0.21Ubuntu (18.04 LTS)x86Performance degradation caused by monitoring sys.innodb_lock_waits in MySQL 8.0
805692016-03-01
5:03
2016-07-18
12:59
MySQL Server: SYS SchemaClosed
(1752 days)
S35.7.11AnyAnymax_latency is not correct for sys.host_summary_by_statement_latency view
837162016-11-07
9:31
2016-11-08
6:46
MySQL Server: SYS SchemaVerified
(1621 days)
S25.7.14, 5.7.16AnyAnyMySQL performance-schema doesn't store (analyze) queries to views
815642016-05-24
8:23
2016-08-01
12:35
MySQL Server: SYS SchemaClosed
(1752 days)
S35.7.12AnyAnyps_setup_show_enabled and ps_setup_show_disabled and company issues
984352020-01-30
4:03
2020-01-30
6:34
MySQL Server: SYS SchemaVerified
(443 days)
S38.0.19AnyAnyschema_table_statistics io statistics does not work with partitioned tables
866602017-06-12
16:02
2017-06-12
16:35
MySQL Server: SYS SchemaVerified
(1405 days)
S31.5.1AnyAnyschema_redundant_indexes says longer but non-unique index is redundant
823072016-07-21
13:41
2016-12-02
20:12
MySQL Server: TestsClosed
(1597 days)
S35.6,5.7, 5.7.13AnyAnyMemory leaks in unit tests
276342007-04-04
5:36
2007-06-15
13:45
MySQL Server: TestsClosed
(5055 days)
S35.1-bkLinuxAnygroup_by test fails
287422007-05-29
10:30
2007-06-22
18:42
MySQL Server: TestsClosed
(5048 days)
S35.1-BKLinux (Fedora Core 6)Anymysql-test-run is very slow on "Stopping All Servers" step
332172007-12-13
15:23
2008-02-18
21:38
MySQL Server: TestsClosed
(4807 days)
S35.1.23Mac OS X (10.5 Leopard - Intel)Anytest suite fails on Mac OS X Leopard
814672016-05-17
14:33
2016-05-18
9:43
MySQL Server: TestsVerified
(1795 days)
S35.7, 5.7.12AnyAnyinnodb_fts.sync_block test unstable due to slow query log nondeterminism
895972018-02-09
4:41
2018-03-21
16:34
MySQL Server: TestsClosed
(1123 days)
S38.0.4AnyAnyValgrind reporting memory leak on MTR test main.validate_password_component
288302007-06-01
10:26
2007-08-09
13:27
MySQL Server: TestsClosed
(5000 days)
S3AnyAnyTest case log_state fails on VMWare Windows clone due to loaded system
594432011-01-12
12:03
2011-05-31
19:23
MySQL Server: TestsClosed
(3609 days)
S35.5+AnyAnyquery_cache_debug.test is occasionally very slow
688202013-03-30
20:27
2013-04-16
15:07
MySQL Server: TestsClosed
(2923 days)
S35.6LinuxAnyincorrect value of bogomips in mysqltest
433832009-03-04
16:43
2011-02-16
23:43
MySQL Server: TestsClosed
(4364 days)
S35.0,5.1,6.0AnyAnymain.variables-big : Weak testing code and result
321982007-11-08
21:03
2007-12-19
5:19
MySQL Server: Data TypesClosed
(4868 days)
S25.0.50, 5.0.52-BKLinuxAnyComparison of DATE with DATETIME still not using indexes correctly
698012013-07-20
8:38
2019-11-15
11:10
MySQL Server: Data TypesVerifiedS55.6.12AnyAnyperformance regression between 5.5 and 5.6 for str_to_date function
983052020-01-21
10:57
2020-08-04
12:41
MySQL Server: Data TypesVerified
(444 days)
S55.7, 8.0LinuxAnyhp_rec_key_cmp suboptimal comparison
690232013-04-21
12:39
2013-04-21
12:40
MySQL Server: Data TypesVerifiedS35.6.12Microsoft WindowsAny"Questions" output in COM_STATISTICS wraps at 2^32
565852010-09-06
9:38
2011-02-16
23:44
MySQL Server: WindowsClosed
(3790 days)
S55.5.5Microsoft WindowsAnySlowdown of readonly sysbench benchmarks (e.g point_select) on Windows 5.5
688272013-04-01
18:47
2013-04-24
8:37
MySQL Server: WindowsVerified
(2915 days)
S25.6.11Microsoft Windows (window7 64bit)Anymultiple connections using Shared Memory interfering
272872007-03-20
12:29
2018-04-03
2:35
MySQL Server: XML functionsClosed
(4890 days)
S55.1.16Microsoft Windows (WinXP SP2)Anyextractvalue() (and updatexml()) extremely slow for large XML
Showing all 804 (Edit, Save, CSV, Feed)