Showing all 915 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version OS CPU Summary
678152012-12-05
8:51
2012-12-06
6:15
MySQL Server: OptimizerVerified
(4130 days)
S35.5.28, 5.6.7LinuxAnyMySQL consistently uses a low cardinality non-referenced column in a index scan
681712013-01-24
15:33
2013-07-08
13:18
MySQL Server: InnoDB storage engineClosed
(3916 days)
S35.6.9-rcAnyAnyImprove documentation of how InnoDB tables can be copied between instances
683662013-02-13
16:03
2018-01-18
13:19
MySQL Server: CharsetsClosed
(2261 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
684132013-02-18
2:45
2013-09-25
2:58
MySQL Server: Performance SchemaVerified
(3837 days)
S55.6.10, 5.6.13AnyAnyperformance_schema overhead is at least 10%
685442013-03-01
19:52
2013-03-02
14:36
MySQL Server: InnoDB storage engineVerified
(4044 days)
S35.5AnyAnyAbility to support multiple buffer pools with per-table assignment
688182013-03-30
5:29
2013-04-01
14:37
MySQL Server: OptimizerDuplicate
(4014 days)
S35.6.10AnyAnyLarge Value List in WHERE Clause Spends Too Much Time in 'statistics' State
691792013-05-09
4:22
2013-09-23
15:08
MySQL Server: InnoDB storage engineDuplicate
(3839 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
(3131 days)
S55.6.11AnyAnyperformance regressions for single-threaded workloads, part 2
693682013-05-31
20:36
2013-10-11
16:23
MySQL Server: DMLClosed
(3821 days)
S55.6.6AnyAnyperformance regression in 5.6.6+ for insert into .... select ... from
694222013-06-07
9:18
2014-02-03
11:41
MySQL Server: InnoDB storage engineClosed
(3755 days)
S55.6.12AnyAnysmall performance impact with heap block debugging info in release builds
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
700012013-08-12
18:46
2017-06-23
9:11
MySQL Server: PartitionsClosed
(3795 days)
S15.6.13AnyAnyPartitioned tables do not use ICP - severe performance loss after partitioning
700252013-08-14
7:00
2014-02-03
10:42
MySQL Server: OptimizerClosed
(3775 days)
S25.6.13Linux (Oracle Linux 6)AnyUpdate on P_S setup_consumers and threads through JOIN only updates first row
701392013-08-23
16:03
2014-06-23
9:17
MySQL Server: InnoDB Plugin storage engineClosed
(3566 days)
S55.1.72WindowsAnyPerformance of "ALTER TABLE..." queries
702022013-08-30
15:36
2013-09-02
11:53
MySQL Server: DMLVerified
(3860 days)
S35.5, 5.6AnyAnyREPLACE working differently for a table having PK or UK only versus both PK+UK
704022013-09-23
21:35
2013-11-12
1:47
MySQL Server: ErrorsClosed
(3789 days)
S55.7.2AnyAnynew deprecation warnings introduce unwanted performance degradation side-effect
710142013-11-26
14:25
2014-05-31
13:52
MySQL Server: InnoDB storage engineClosed
(3649 days)
S3All VersionAnyAnytwo many times of memset decreate the performance under heavy insert
711712013-12-18
10:40
2014-02-04
14:40
MySQL Server: OptimizerVerified
(3705 days)
S25.6.14Linux (Debian 7.1)AnyOptimizer executes inperformant subquery first
721232014-03-25
14:12
2017-10-04
3:52
MySQL Server: InnoDB storage engineVerified
(3654 days)
S35.6, 5.6.18AnyAnySpurious lock_wait_timeout_thread wakeup in lock_wait_suspend_thread()
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
(3133 days)
S55.6.16AnyAnyUPDATE ORDER BY does a filesort if updating a column in the index
726402014-05-14
6:05
2014-07-21
15:34
MySQL Server: ReplicationClosed
(3551 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
(3600 days)
S35.6.17AnyAnyMake changing MASTER_AUTO_POSITION = 0 user-friendly and document behaviour
727152014-05-21
22:39
2014-05-22
8:02
MySQL Server: CharsetsVerified
(3598 days)
S35.6.17AnyAnycharacter set code endianness dependent on CPU type rather than endianness of CP
729482014-06-11
3:44
2018-07-30
17:32
MySQL Server: InnoDB storage engineClosed
(2068 days)
S35.6AnyAnylock_table can be optimized if updating the same table concurrently
742562014-10-07
22:43
2015-11-02
6:19
MySQL Server: OptimizerVerified
(3361 days)
S25.6.19, 5.6.22AnyAnyindex_extensions used incorrectly in select cause performance regression
742782014-10-08
15:38
2015-08-21
9:31
MySQL Server: ReplicationVerified
(3142 days)
S35.6.17, 5.6.26AnyAnytĥread_id title in binary log output is wrong. Should be process(list)_id
742802014-10-08
16:41
2014-10-10
13:50
MySQL Server: InnoDB storage engineVerified
(3457 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
(2495 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
(3233 days)
S55.7.5AnyAnyupdates to indexed column much slower in 5.7.5
743282014-10-11
4:54
2016-12-12
4:38
MySQL Server: ReplicationClosed
(3314 days)
S35.7.5AnyAnyserious tps decline if gtid is enabled in 5.7
744082014-10-15
19:52
2018-07-04
15:16
MySQL Server: InnoDB storage engineVerified
(2094 days)
S55.6, 5.7, 8.0AnyAnysrv_conc_enter_innodb() is not optimal
744232014-10-16
22:36
2016-02-02
19:15
MySQL Server: ReplicationClosed
(3213 days)
S35.7+AnyAny RECEIVED_TRANSACTION_SET field on replication_connection_status shows garbage
748322014-11-13
5:54
2017-10-01
13:59
MySQL Server: InnoDB storage engineClosed
(3005 days)
S35.7.7AnyAnyut_delay missing compiler barrier, UT_RELAX_CPU isn't at all relaxing
752992014-12-23
15:45
2017-03-23
12:11
MySQL Server: ReplicationDuplicate
(2618 days)
S35.6AnyAnygroup commit with GTID enabled need more optimization
755702015-01-21
7:52
2016-02-20
17:43
MySQL Server: ReplicationClosed
(3258 days)
S25.6.20LinuxAnysemi-sync replication performance degrades with a high number of threads
759812015-02-20
13:56
2017-11-05
7:12
MySQL Server: InnoDB storage engineVerified
(3276 days)
S55.7.6AnyAnyMySQL 5.7.5 30% slower than 5.6.23 for 1 thread write
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
765092015-03-27
14:45
2015-04-06
23:36
MySQL Server: ParserClosed
(3286 days)
S35.7AnyAnyuse atomics to avoid MUTEX CONTENTION ON LOCK_PLUGIN DUE TO QUERY REWRITE FRAMEW
769332015-05-04
17:26
2016-11-16
15:56
MySQL Server: OptimizerClosed
(2689 days)
S55.6.24, 5.6.25LinuxAnyPerformance Regression in 5.6: Update does not use index
770942015-05-19
13:13
2018-10-09
14:11
MySQL Server: InnoDB storage engineClosed
(2774 days)
S35.7.7AnyAnyReduce log_sys->mutex contention by allowing concurrent mtr commit and log write
778612015-07-28
17:30
2015-07-29
6:58
MySQL Server: Information schemaVerified
(3165 days)
S35.6, 5.6.26AnyAny"SHOW PROCESSLIST" needs higher resolution time
779602015-08-06
11:21
2016-02-04
19:18
MySQL Server: GISClosed
(3135 days)
S3AnyAnyUpgrade to Boost 1.59.0
782642015-08-28
16:11
2016-04-27
15:05
MySQL Server: ReplicationClosed
(3122 days)
S35.7.6AnyAnyDO NOT ALLOCATE MEMORY ON GR PLUGIN P_S INTERFACE IMPLEMENTATION
793802015-11-23
8:11
2016-06-18
21:34
MySQL Server: GISClosed
(2988 days)
S38.0.0AnyAnyUpgrade to Boost 1.60.0
794802015-12-01
10:59
2015-12-03
10:42
MySQL Server: OptimizerVerified
(3038 days)
S35.7.9AnyAnySuboptimal query plan in simple join compared to MariaDB 10.1
799342016-01-12
10:48
2016-02-19
17:58
MySQL Server: Performance SchemaClosed
(2962 days)
S35.7.11AnyAnyi_perfschema.table_leak random result failure
805052016-02-25
9:43
2016-02-25
14:53
MySQL Server: OptimizerDuplicate
(2954 days)
S55.7.11WindowsAnymysql server 5.7.11 view performance issue
815002016-05-19
9:10
2018-04-30
11:20
MySQL Server: Row Based Replication ( RBR )Closed
(2159 days)
S35.7+AnyAnydead branch in search_key_in_table()
815612016-05-24
7:22
2016-05-28
5:46
MySQL ServerClosed
(2861 days)
S15.7.12AnyAnyMySQL 5.7 is 11% to 37% slower then 5.6 when using 4 threads
815642016-05-24
8:23
2016-08-01
12:35
MySQL Server: SYS SchemaClosed
(2828 days)
S35.7.12AnyAnyps_setup_show_enabled and ps_setup_show_disabled and company issues
818542016-06-15
7:55
2016-11-23
18:58
MySQL Server: OptimizerClosed
(2682 days)
S35.7, 5.7.13AnyAnyForce index is skipped while executing select count(*)
819102016-06-17
16:35
2016-11-02
13:34
MySQL Server: ReplicationClosed
(2771 days)
S35.7.14AnyAnyWRITE SET HASHES SHOULD HAVE A 64BITS OPTION TO REDUCE WRITE CONFLICTS
822102016-07-13
6:50
2016-11-19
1:57
MySQL Server: JSONClosed
(2807 days)
S38.0.0AnyAnyJSON memory usage missing from the memory summary tables
824222016-08-03
11:27
2017-01-26
19:15
MySQL Server: ReplicationClosed
(2659 days)
S35.7.14AnyAnyGTIDS REDUCE PERFORMANCE ON WORKLOADS WITH MANY SMALL TRANSACTIONS
826312016-08-18
11:45
2016-11-29
1:59
MySQL Server: DDLClosed
(2775 days)
S38.0.1AnyAnystd::basic_string instantiation w/ PFS instrumentation for the DD
832872016-10-06
12:54
2016-11-19
16:28
MySQL Server: OptimizerClosed
(2689 days)
S35.7AnyAnycreated_tmp_tables statistic is wrong
833192016-10-10
12:44
2017-07-05
15:37
MySQL Server: CharsetsClosed
(2691 days)
S38.0.1AnyAnyPerformance regression when changing character set to utf8mb4
835282016-10-25
13:06
2016-12-02
14:58
MySQL Server: InnoDB storage engineDuplicate
(2673 days)
S38.0AnyAnyInnoDB mutex bs: periodic waiters wakeup
835682016-10-27
9:54
2018-02-23
0:44
MySQL Server: InnoDB storage engineVerified
(2677 days)
S58.0AnyARMInnoDB memory barriers bs
838562016-11-17
4:19
2019-11-15
17:31
MySQL Server: OptimizerVerified
(2657 days)
S35.7.13,5.7.16CentOSAnyIndex ref not used for multi-column IN - type or collation conversion warning
839122016-11-21
15:28
2020-03-09
16:52
MySQL Server: Performance SchemaVerified
(2682 days)
S35.6, 5.7, 5.6.34AnyAnyTime spent sleeping before entering InnoDB is not measured/reported separately
844572017-01-10
12:53
2017-02-16
14:10
MySQL Server: Performance SchemaClosed
(2597 days)
S35.6.35LinuxAnyPerformance Schema 5.6.35 unittest pft-t failing
847732017-02-01
14:29
2017-10-04
14:14
MySQL Server: Group ReplicationClosed
(2367 days)
S55.7.17LinuxAnyFlow control slows down throughput while a node join the cluster
847742017-02-01
14:53
2022-09-13
17:20
MySQL Server: Group ReplicationVerified
(2611 days)
S55.7.17AnyAnyPerformance drop every 60 seconds
847862017-02-02
8:17
2017-02-03
16:04
MySQL Server: Performance SchemaClosed
(2610 days)
S15.7.17-11AnyAny--performance-schema-digests-size=1 leads to SIGSEGV
853042017-03-04
8:26
2017-09-02
12:52
MySQL Server: InnoDB storage engineVerified
(2399 days)
S35.7AnyAnyReduce mutex contention of fil_system->mutex
858192017-04-06
3:04
2018-02-18
18:29
MySQL Server: InnoDB Plugin storage engineVerified
(2547 days)
S55.7LinuxARMOptimize AARCH64 CRC32c implementation
859332017-04-13
13:25
2023-11-02
6:30
MySQL Server: OptimizerClosed
(2374 days)
S58.0.1-dmrAnyAnyPerformance regression with Prepared Statements
859992017-04-19
9:14
2017-04-19
9:56
MySQL Server: InnoDB storage engineVerified
(2535 days)
S55.7.17AnyAnyOptimize zlib 's fill_window with SIMD instructions
866262017-06-08
16:42
2017-11-08
10:28
MySQL Server: Group ReplicationClosed
(2383 days)
S35.7.19AnyAnyGroup replication partition handling thread is not instrumented on perf schema
866602017-06-12
16:02
2017-06-12
16:35
MySQL Server: SYS SchemaVerified
(2481 days)
S31.5.1AnyAnyschema_redundant_indexes says longer but non-unique index is redundant
868842017-06-30
12:44
2017-10-24
14:25
MySQL Server: OptimizerClosed
(2460 days)
S38.0.3AnyAnyCreate decimal microbenchmarks
872492017-07-30
0:44
2019-01-14
9:20
MySQL Server: ReplicationVerified
(2282 days)
S2AnyAnyRelay logs shouldn't be purged if options unrelated in CHANGE MASTER is executed
876372017-09-01
8:44
2017-12-18
8:46
MySQL Server: DMLVerified
(2292 days)
S55.7.17LinuxAnyHigh CPU occupancy rate
878272017-09-21
14:09
2023-11-02
6:39
MySQL Server: InnoDB storage engineClosed
(2260 days)
S58.0.3AnyAnyPerformance regression in "create table" speed and scalability in 8.0.3
879332017-10-02
4:06
2018-12-12
21:04
MySQL Server: InnoDB storage engineVerified
(1933 days)
S25.7.19CentOSARMScalibility issue on Arm platform with the current UT_RELAX_CPU () code.
884222017-11-09
12:20
2017-11-14
14:42
MySQL Server: InnoDB storage engineVerified
(2326 days)
S25.7.19AnyAnyMySQL 5.7 innodb purge thread get oldest readview could block other transaction
891222018-01-05
16:47
2018-03-19
17:49
MySQL Server: GISClosed
(2263 days)
S38.0.5AnyAnySevere performance regression in server bootstrap
891952018-01-11
19:15
2019-07-25
14:45
MySQL Server: Group ReplicationClosed
(1708 days)
S25.7.20, 8.0.3AnyAnyTotal ordering of transactions is not respected in Group Replication.
895512018-02-06
9:27
2020-02-12
14:10
MySQL Server: InnoDB storage engineVerified
(2242 days)
S35.7.21, 8.0.4AnyAnySpatial index query time performance scales linearly
911512018-06-05
17:12
2019-05-06
3:33
MySQL Server: Group ReplicationVerified
(2122 days)
S38.0.11AnyAnyAdd a Learner/Observer role to leverage it in WAN setup
914202018-06-26
10:03
2018-08-14
17:43
MySQL Server: Data DictionaryClosed
(2053 days)
S38.0.11AnyAnyAllocate DD auto releaser maps on demand
915892018-07-10
9:44
2018-07-10
9:51
MySQL ServerClosed
(2088 days)
S35.6.33-79.0CentOS (6.3)x86Invalid primary key improves query performance
918372018-07-31
4:35
2018-07-31
12:43
MySQL Server: InnoDB storage engineVerified
(2067 days)
S38.0.11, 8.0.12, 5.7.23AnyAnyIS.innodb_trx results filtered by trx_started depends on timezone
923642018-09-11
12:06
2019-02-28
18:07
MySQL Server: Performance SchemaClosed
(1855 days)
S35.7.22, 8.0.12AnyAnyevents_transactions_summary_global_by_event_name not working as expected
928502018-10-19
0:46
2018-10-22
5:31
MySQL Server: OptimizerVerified
(1984 days)
S35.7.23AnyAnyBad select+order by+limit performance in 5.7
932812018-11-22
4:03
2018-12-17
23:09
MySQL Server: Performance SchemaClosed
(1945 days)
S18.0.12AnyAnyOdd memory load/increase when using --performance-schema-max-digest-length=large
938452019-01-07
21:55
2021-08-23
12:23
MySQL Server: OptimizerVerified
(1905 days)
S25.7,8.0.11,8.0.13AnyAnyOptimizer choose wrong index, sorting index instead of filtering index
942242019-02-06
16:45
2019-11-17
10:39
MySQL Server: OptimizerVerified
(1876 days)
S35.6, 5.6.43Any (any)Any (any)[5.6] Optimizer reconsiders index based on index definition order, not value
943602019-02-16
4:44
2022-02-16
18:29
MySQL Server: ReplicationClosed
(779 days)
S38.0.13AnyAnyContribution by Facebook: Don't force flush relay log info
943702019-02-18
3:19
2019-02-27
10:16
MySQL Server: InnoDB storage engineVerified
(1865 days)
S38.0AnyAnyPerformance regression of btr_cur_prefetch_siblings
946552019-03-14
11:04
2021-05-17
14:24
MySQL Server: OptimizerClosed
(1482 days)
S28.0AnyAnySome GIS function do not use spatial index anymore
949252019-04-06
0:15
2019-04-24
13:37
MySQL Server: Performance SchemaVerified
(1800 days)
S38.0.15AnyAnyWrong Query Sample Text in Performance Query
950582019-04-18
18:12
2019-04-25
2:29
MySQL Server: OptimizerVerified
(1799 days)
S35.7.21AnyAnyIndex not used for column with IS TRUE or IS FALSE operators
953902019-05-16
9:57
2019-05-16
13:53
MySQL Server: InnoDB storage engineVerified
(1778 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
(1761 days)
S5ALLAnyAnyThe unused wake up in simulator AIO of function reserve_slot
984352020-01-30
4:03
2020-01-30
6:34
MySQL Server: SYS SchemaVerified
(1519 days)
S38.0.19AnyAnyschema_table_statistics io statistics does not work with partitioned tables
985202020-02-08
9:37
2020-05-05
14:51
MySQL Server: OptimizerVerified
(1423 days)
S58.0AnyARMSuboptimal implementations for some load/store functions for little-endian arch
985452020-02-10
23:45
2022-05-02
7:22
MySQL Server: Performance SchemaClosed
(696 days)
S38.0.19AnyAnyPerfschema tables are not collation aware
987502020-02-26
20:11
2020-05-21
12:09
MySQL Server: Information schemaClosed
(1408 days)
S58.0, 8.0.19AnyAnySHOW FIELDS command regression on MySQL 8.0
987712020-02-28
6:29
2020-03-02
18:39
MySQL Server: OptimizerVerified
(1490 days)
S25.7, 5.7.29AnyAnyPerformance impact while selecting data from a JSON type column
991902020-04-06
11:51
2020-04-06
14:06
MySQL Server: CharsetsVerified
(1452 days)
S58.0AnyAnymy_tosort_unicode: unnecessary max_char check while utf8-mb3 processing
994322020-05-04
8:09
2020-05-05
12:04
MySQL Server: InnoDB storage engineVerified
(1424 days)
S58.0.20AnyARMImproving memory barrier during rseg allocation
999892020-06-26
1:06
2021-01-10
22:04
MySQL Server: Performance SchemaClosed
(1173 days)
S38.0.x, 8.0.20AnyAnyInconsistency when joining Perf Schema schema tables when PK is larger than 48 c
1003362020-07-27
15:58
2020-07-28
13:45
MySQL Server: Performance SchemaVerified
(1339 days)
S35.7AnyAnyperformance_schema.status_by_thread table not populating on Linux
1008112020-09-11
9:22
2020-09-11
13:25
MySQL Server: InnoDB storage engineDuplicate
(1294 days)
S58.0.20Oracle LinuxAnyperformance degradation in MySQL-8.0 vs MySQL-5.7 in simple DML operations.
1009622020-09-26
5:17
2020-10-26
11:42
MySQL Server: Performance SchemaAnalyzing
(1249 days)
S35.7AnyAnymemory_summary_%_by_event_name Have different values
1012202020-10-18
0:37
2021-02-23
18:44
MySQL Server: OptimizerClosed
(1129 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
(1107 days)
S58.0.23AnyAnySubquery dependent on const tables gets evaluated for unnecessary multiple times
1041282021-06-28
7:00
2023-08-03
12:33
MySQL ServerDuplicate
(1004 days)
S38.0.25Ubuntu (18.04)x86 (Core i7)Poor performance for queries with tuple comparison
1041862021-07-01
15:04
2022-01-25
17:07
MySQL Server: OptimizerClosed
(919 days)
S58.0AnyAnyToo few chunk files are created for hybrid hash join
1047602021-08-29
19:12
2021-09-20
12:14
MySQL Server: OptimizerVerified
(940 days)
S28.0.26AnyAnyincorrect placement of hash join predicates in a left outer join nest
1052042021-10-13
11:22
2021-11-01
8:41
MySQL Server: PartitionsVerified
(897 days)
S38.0.26AnyAnyha_innopart traverse all partitions instead of only used partitions causing loss
1053032021-10-22
18:55
2021-10-23
6:33
MySQL Server: OptimizerDuplicate
(887 days)
S28.0.20+AnyAnyUnmanageable Sort Buffer Behavior in 8.0.20+
1053042021-10-22
19:00
2021-11-12
22:34
MySQL Server: OptimizerClosed
(867 days)
S28.0.20+AnyAnyUnmanageable Sort Buffer Behavior in 8.0.20+
1059242021-12-16
20:40
2022-07-25
15:16
MySQL Server: ReplicationClosed
(612 days)
S58.0.22, 8.0.27AnyAnySHOW SLAVE STATUS became expensive for Replica->Slave column name conversions
1059262021-12-17
8:41
2021-12-17
10:53
MySQL Server: InnoDB storage engineDuplicate
(832 days)
S58.0.18AnyAnyQuery information_schema.processlist has performance impact on normal queries
1059332021-12-19
8:11
2021-12-21
8:04
MySQL Server: OptionsVerified
(828 days)
S35.7.35, 8.0.27LinuxAnyThe table "general_log" not close when config option general_log set into OFF
1059642021-12-23
1:43
2021-12-23
5:06
MySQL Server: OptionsVerified
(826 days)
S35.7.35, 8.0.27LinuxAnyThe table "general_log/slow_log" not close when config log_output set into NONE
1060392022-01-05
7:08
2022-01-11
6:10
MySQL Server: PartitionsVerified
(807 days)
S58.0.27AnyAnySkip using priority queue and visiting unused partitions when single partition
1061352022-01-11
15:33
2022-01-13
14:49
MySQL Server: OptimizerClosed
(805 days)
S58.0.27AnyAnyREGEXP performance failure
1063992022-02-08
1:55
2022-02-09
4:18
MySQL Server: DDLDuplicate
(779 days)
S38.0.26AnyAnyRegression on DDL statements with big stage/sql/checking permissions
1077002022-06-29
11:18
2022-08-08
22:48
MySQL Server: InnoDB storage engineVerified
(611 days)
S58.0.29AnyAnyPerformance of Temptable is worse than Memory in GROUP BY scenario
1081162022-08-11
8:21
2022-08-11
9:24
MySQL Server: OptimizerVerified
(595 days)
S38.0.29, 8.0.30, 5.7.39Any (rhel-7.4)Any (x86-64)SQL queries with range of Item_row are not optimized
1096012023-01-12
9:00
2023-01-12
9:38
MySQL Server: OptimizerVerified
(441 days)
S38.0AnyAnyApply partition pruning if all insert rows have non-null values on autoinc field
1105552023-03-29
22:22
2024-01-17
17:33
MySQL Server: Performance SchemaClosed
(129 days)
S38.0.32AnyAnySome performance schema tables return invalid rows
1106002023-04-04
8:55
2023-04-04
9:28
MySQL Server: InnoDB storage engineVerified
(359 days)
S58.0.32AnyAnyoptimize for page flush
1106062023-04-04
10:16
2023-04-17
8:24
MySQL Server: InnoDB storage engineVerified
(346 days)
S58.0LinuxARM (aarch64)Improve crc32c code for arm64
1107792023-04-24
11:32
2023-05-12
5:49
MySQL Server: OptimizerVerified
(321 days)
S58.0.33, 5.7.42AnyAnyIN clause cause pick bad performan index
1108892023-05-03
5:41
2023-05-03
6:07
MySQL Server: ReplicationVerified
(330 days)
S58.0.32AnyAnybinlog rotate optimize
1113532023-06-11
22:04
2023-06-13
9:55
MySQL Server: InnoDB storage engineVerified
(289 days)
S28.0, 8.0.33AnyAny3x Performance Regression from 5.7 to 8.0 on ALTER TABLE FORCE.
1118602023-07-24
8:59
2023-09-18
10:17
MySQL Server: Performance SchemaClosed
(205 days)
S3AnyAnyshutdown plugin core when init_events_waits_history_long failed
1119522023-08-02
19:50
2023-08-03
12:35
MySQL Server: OptimizerVerified
(238 days)
S28.0.34, 5.7.43, 8.1.0AnyAnyRow constructor inequality comparison on Primary Key results in full table scan.
1120352023-08-10
19:33
2024-02-21
1:00
MySQL Server: Performance SchemaVerified
(64 days)
S28.0.34AnyAnyMaterializing performance_schema.data_locks can lead to excessive mem usage/OOM
1120802023-08-16
6:30
2023-08-16
8:13
MySQL ServerClosed
(225 days)
S38.0AnyAnyNo need call performance schema interface when open temporary table
1121752023-08-24
13:32
2023-08-24
13:40
MySQL Server: GeneralAnalyzing
(217 days)
S3AnyAnyContribution: [performance optimization]
1123622023-09-15
20:19
2023-09-26
10:34
MySQL Server: OptimizerVerified
(185 days)
S58.1.0, 8.0.34Ubuntu (22.04)x86WHERE NOT IN with subquery is much slower on 8.1 than 5.7
1131872023-11-22
16:24
2023-11-28
21:06
MySQL Server: ReplicationVerified
(123 days)
S58.0 and aboveAnyAnyreplica SQL thread purge applied relay logs blocked commit on source node
1132882023-11-30
6:58
2023-12-01
11:37
MySQL Server: OptimizerVerified
(119 days)
S58.0.33AnyAnyExplain plan shows dynamic range, but bug causes no chance to use for LEFT JOIN
1137502024-01-25
6:50
2024-01-26
10:12
MySQL Server: PartitionsVerified
(62 days)
S28.0.36Any (rhel-7.4)Any (x86-64)stats of partitions could be empty after some kind of alter table DDL statements
1140562024-02-19
23:03
2024-02-22
10:56
MySQL Server: Prepared statementsVerified
(35 days)
S58.0.32, 8.0.22+AnyAnyPerformance degredation using REGEXP in statement with parameters vs query
1143102024-03-12
4:14
2024-03-19
7:24
MySQL Server: ReplicationVerified
(16 days)
S38.0.33AnyAnyMaster_compression_algorithm output is wrong
1144652024-03-24
6:32
2024-03-26
7:32
MySQL Server: DDLVerified
(2 days)
S58.0.36, 8.3.0AnyAnyRegression in 8.0.27+ related to Parallel DDL IO Amplification
1144682024-03-24
21:51
2024-03-28
11:38
MySQL Server: InnoDB storage engineVerified
(3 days)
S58.3.0, 8.0.36AnyAnyInconsistent table performance: fresh data import vs after optimization
177922006-02-28
16:31
2006-03-01
13:10
MySQL ServerDuplicate
(6602 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
(6581 days)
S35.0.18Linux (Linux)AnyRenaming a table looses all triggers
186562006-03-30
16:30
2011-02-16
23:43
MySQL ServerDuplicate
(4841 days)
S55.0.15Linux (Suse 10)AnyUser variable in where subquery causes long delay
209862006-07-12
9:01
2008-09-27
11:01
MySQL ServerClosed
(5661 days)
S55.0.21-community-ntWindows (Windows XP)Anyrenaming a column very slow on large tables
245562006-11-23
20:05
2006-12-05
22:51
MySQL ServerClosed
(6323 days)
S25.0.27 Windows (Win 2003 server)Anymysqldump --all-databases does not dump all databases
257852007-01-23
15:15
2011-03-29
18:52
MySQL ServerClosed
(4748 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
(4748 days)
S25.1.11Linux (linux)Anyselect with limit 0 get row scan
285542007-05-21
9:32
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5424 days)
S34.1.22, 5.0.42-BKAnyAnyOptimizer wrongly prefers index for (col = value) over (PK <= value)
307032007-08-29
17:26
2011-02-16
23:43
MySQL Server: ReplicationClosed
(5250 days)
S35.0 (all)AnyAnySHOW STATUS LIKE 'Slave_running' is not compatible with `SHOW SLAVE STATUS'
332172007-12-13
15:23
2008-02-18
21:38
MySQL Server: TestsClosed
(5883 days)
S35.1.23MacOS (10.5 Leopard - Intel)Anytest suite fails on Mac OS X Leopard
343102008-02-05
14:51
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3753 days)
S55.0.51a-log, 5.0.54, 5.6.14LinuxAnyOptimizer is inefficient by using ORDER BY function() and LIMIT
351652008-03-08
17:48
2022-12-04
20:45
MySQL Server: CSVVerified
(5860 days)
S55.1AnyAnyLogging to table is slow for large queries
382072008-07-17
16:56
2012-05-18
20:19
MySQL Server: Row Based Replication ( RBR )Duplicate
(5712 days)
S55.1.25Linux (x86_64)AnyRow-based Replication (RBR) is CPU bound (invalidating query cache)
412932008-12-08
10:21
2011-02-16
23:43
MySQL ServerVerified
(5462 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
(5586 days)
S23.2, 4.1, 5.0, 5.1, 6.0 bzrLinux (pc-linux-gnu i486)Anymysqlbinlog doesn't properly handle local slow IO
419252009-01-07
15:43
2022-12-04
20:45
MySQL Server: Information schemaVerified
(5558 days)
S35.6.30, 5.7.12, 8.0.0AnyAnyWarning 1366 Incorrect string value: ... for column processlist.info
429482009-02-17
23:02
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5504 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
(4259 days)
S55.0, 5.1, 5.6LinuxAnySELECT ... WHERE (col1, col2) IN ((const, const)) is optimized, non-SELECT not
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
455592009-06-17
15:59
2011-02-16
23:44
MySQL Server: InnoDB storage engineDuplicate
(5396 days)
S35.1.32, 5.1.35AnyAnyInnoDB Query not using indexes properly?
461352009-07-12
19:03
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4996 days)
S25.0, 5.1, next, 6.0.0, 6.0.2, 5.1.36AnyAnyLIMIT + JOIN problem
511532010-02-12
21:55
2011-02-16
23:44
MySQL ServerDuplicate
(5138 days)
S25.1.43-0.dotdeb.1Linux (2.6.31-19-generic #56-Ubuntu)Anymysqld/I_S takes hours to finish after boot/restart
516802010-03-03
8:36
2011-02-16
23:44
MySQL Server: DDLDuplicate
(5139 days)
S35.1.43IBM AIXAny"ALTER TABLE ... DELAY_KEY_WRITE=1" causes a full table copy
530962010-04-23
7:32
2012-08-13
16:18
MySQL Server: LockingClosed
(4245 days)
S55.1.44AnyAnyDisconnection is slow when using non-persistent mysql connections
559792010-08-13
22:05
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4973 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
(4013 days)
S55.1.50, 5.1.51-bzrWindowsAnySlow MAX() on primary key retrieved by secondary index in InnoDB
581012010-11-10
0:21
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4886 days)
S55.1.38-community-log, 5.1.54-bzrLinuxAnyOptimizer picks wrong order of queries
582342010-11-16
16:26
2014-02-26
12:47
MySQL Server: InnoDB storage engineVerified
(4484 days)
S55.1.49-r1, 5.5.20AnyAnyLENGTH() / OCTET_LENGTH() on BLOB field very slow
592032010-12-29
4:38
2015-02-24
16:10
MySQL Server: OptimizerClosed
(3320 days)
S15.0.91,5.1.39,5.1.55,5.5.8AnyAnySerious optimizer failure when query is encapsulated in additional SELECT/INSERT
594432011-01-12
12:03
2011-05-31
19:23
MySQL Server: TestsClosed
(4685 days)
S35.5+AnyAnyquery_cache_debug.test is occasionally very slow
603452011-03-04
17:11
2013-01-15
15:25
MySQL ServerVerified
(4090 days)
S55.1.55 6.0.11AnyAnytrim trailing spaces processes data only byte wise (the continue of bug14637)
607262011-04-01
21:01
2011-04-03
11:54
MySQL Server: CharsetsDuplicate
(4743 days)
S25.5.10Linux (Debian Lenny, Arch Linux, adm64 and x86)AnyFunctions doing implicit int to string conversion called repeatedly slow down
608112011-04-08
23:41
2020-08-15
10:10
MySQL Server: GeneralVerified
(4736 days)
S55.0.93, 5.5.12, 5.0.77-4.el5_5.4Any (RHEL 5.5, Mac OS X)Anyslow timezone functions
615412011-06-16
16:26
2011-06-18
13:35
MySQL Server: OptimizerDuplicate
(4667 days)
S35.5LinuxAnySLOW QUERY - REWRITE
616212011-06-23
22:51
2011-06-24
4:06
MySQL Server: GeneralDuplicate
(4661 days)
S35.5.13Linux (Ubuntu)AnyALTER TABLE very slow on empy partitioned table
616312011-06-24
14:49
2014-01-03
8:40
MySQL Server: OptimizerClosed
(3737 days)
S55.5.13, 5.5.22Linux (centos 5.5)Anyslow query plans for queries with low cardinality columns in a key
635482011-12-02
19:13
2011-12-05
8:06
MySQL Server: LoggingVerified
(4500 days)
S3anyAnyAnydisable logging to slow log session-wise
639052012-01-02
23:47
2012-01-16
18:35
MySQL Server: OptimizerVerified
(4455 days)
S55.1.60WindowsAnyhandler_read_next is suprisingly high and slows queries
641812012-01-31
14:41
2012-02-09
12:20
MySQL Server: InnoDB Plugin storage engineVerified
(4436 days)
S55.1.52, 5.1.61AnyAnyunzip_LRU length management might need to be updated for SSD
645032012-03-01
5:27
2012-05-02
11:21
MySQL Server: ReplicationClosed
(4397 days)
S25.1AnyAnymysql frequently ignores --relay-log-space-limit
671752012-10-10
9:08
2013-01-14
17:18
MySQL Server: InnoDB storage engineDuplicate
(4091 days)
S35.6.7 AnyAnyrecovery is very very slow in buf_flush_single_page_from_LRU
673512012-10-24
8:02
2017-05-03
16:04
MySQL Server: PartitionsVerified
(4135 days)
S25.5.27-29.0LinuxAnyCardinality samples of partitioned tables sometimes widely off
679802012-12-27
14:54
2013-01-19
10:52
MySQL Server: OptimizerVerified
(4086 days)
S35.5.28AnyAnyMySQL not utilising full index because of possible bad cardinality stats
687252013-03-20
8:30
2016-03-24
11:28
MySQL Server: InnoDB storage engineVerified
(2926 days)
S5allAnyAnyUNIV_MEM_DEBUG needlessly slow, especially with UNIV_ZIP_DEBUG
687952013-03-27
12:22
2013-07-30
13:47
MySQL Server: CharsetsClosed
(3894 days)
S35.5.30AnyAnyDatetime field comparisons do not work properly with utf8_unicode_ci collation
688202013-03-30
20:27
2013-04-16
15:07
MySQL Server: TestsClosed
(3999 days)
S35.6LinuxAnyincorrect value of bogomips in mysqltest
693412013-05-29
0:55
2016-04-07
5:46
MySQL Server: ReplicationClosed
(3919 days)
S55.6.11AnyAnysemi-sync replication is very slow with many clients
694202013-06-07
7:18
2013-10-16
15:02
MySQL Server: LoggingClosed
(3816 days)
S55.6.12AnyAnylog_slow_statement could bail out earlier if slow logging is disabled
721152014-03-24
19:29
2015-07-22
7:17
MySQL Server: PartitionsClosed
(3172 days)
S25.6.16AnyAnyVery slow create/alter table with partitions and STATS_PERSISTENT=1
730462014-06-19
2:42
2016-02-17
11:23
MySQL Server: OptimizerVerified
(3570 days)
S35.6.19AnyAnyOptimizer chooses wrong plan with (const, range) order by range ASC
737772014-08-31
11:00
2015-08-24
13:24
MySQL Server: Memory storage engineVerified
(3496 days)
S35.6, 5.6.21, 5.5.40LinuxAnyDELETE query takes a long time and examines more rows than exist in the table
739742014-09-18
21:41
2015-09-28
19:08
MySQL Server: LoggingClosed
(3104 days)
S35.7.6WindowsAnytrunk - slow query log shows some bogus SET timestamp=4294966218; value
739782014-09-19
10:14
2014-12-01
7:23
MySQL Server: LoggingClosed
(3417 days)
S35.6.15, 5.6.20AnyAnyslow_log table doesn't store fractional time part
742332014-10-06
10:40
2017-07-26
22:46
MySQL Server: ReplicationClosed
(2442 days)
S35.6.22,5.5 5.6AnyAnySlave's slow log has empty BEGINs for RBR events
744722014-10-21
6:45
2015-04-29
12:33
MySQL Server: InnoDB storage engineClosed
(3256 days)
S55.7.5AnyAnyddl like add index is very slow in 5.7.5
746072014-10-28
16:25
2015-09-14
15:43
MySQL Server: ReplicationClosed
(3296 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
(3193 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
(3235 days)
S25.7AnyAnyset gtid_purged should not rotate binlog
758072015-02-06
10:00
2015-02-20
9:54
MySQL Server: DMLVerified
(3326 days)
S55.6.22LinuxAnySlow Query in MySQL 5.6
761822015-03-05
21:42
2015-06-04
18:34
MySQL Server: InnoDB storage engineClosed
(3222 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
784072015-09-11
12:45
2022-04-29
5:41
MySQL Server: OptimizerVerified
(699 days)
S57.4.6/5.6.24, 5.7, 8.0LinuxAnywrong index being used in subqueries?
813472016-05-08
16:10
2016-10-13
16:16
MySQL Server: OptimizerClosed
(2723 days)
S35.1.73, 5.5.49, 5.6.30,5.7.12CentOSAnyunnecessary scanned all databases for information_schema
820032016-06-25
16:15
2016-08-18
11:12
MySQL Server: Row Based Replication ( RBR )Closed
(2779 days)
S35.7.13AnyAnyRows event are decoded one byte at a time
845772017-01-20
8:49
2017-08-21
19:47
MySQL Server: CharsetsClosed
(2607 days)
S3AnyAnystrnxfrm runs slower when tailoring rule contains contraction
858342017-04-06
13:31
2017-08-01
10:13
MySQL Server: OptimizerDuplicate
(2431 days)
S55.7.17WindowsAnyInnoDB: Very slow select query with many tables and IS NULL in where clause
887202017-11-30
14:52
2018-02-24
10:49
MySQL Server: ReplicationVerified
(2309 days)
S35.6, 5.7, 8.0.3, 5.6.38, 5.7.20AnyAnyInconsistent and unsafe FLUSH behavior in terms of replication
889372017-12-15
11:27
2017-12-19
11:51
MySQL Server: LoggingVerified
(2291 days)
S35.6.38, 5.7.20AnyAnymysql client history file grows without bounds, slows down connecting to server
891492018-01-08
23:41
2018-01-16
17:07
MySQL Server: OptimizerVerified
(2263 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
(2255 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
(1933 days)
S55.6.16,5.7.23Linuxx86mysterious optimizer behavior
935302018-12-08
20:23
2020-12-06
17:24
MySQL Server: InnoDB storage engineDuplicate
(1211 days)
S35.7.23, 5.7.24AnyAnyALTER TABLE DROP INDEX is very slow
939222019-01-14
16:04
2019-05-07
9:43
MySQL Server: OptimizerClosed
(1787 days)
S28.0.13Linuxx86UNION ALL very slow with SUM(0)
946102019-03-08
19:09
2020-08-05
0:00
MySQL Server: DDLVerified
(1331 days)
S55.6.41CentOS (7.5)x86Server stalls because ALTER TABLE on partitioned table holds dict mutex
957752019-06-13
2:13
2019-06-13
5:59
MySQL Server: LoggingVerified
(1750 days)
S35.6AnyAnyVersion 5.6 has the wrong format for slow logging time
957922019-06-13
15:21
2019-07-10
18:39
MySQL Server: Data DictionaryClosed
(1723 days)
S28.0.18AnyAnyDD function for fetching tables in engine
973392019-10-23
8:06
2021-07-23
13:05
MySQL Server: OptimizerVerified
(1612 days)
S25.7.18, 5.7.28, 5.6.46AnyAnybin() function return Incorrect result set
990062020-03-20
11:45
2020-04-16
10:01
MySQL Server: ReplicationVerified
(1444 days)
S35.7 and 8.0AnyAnyGTID Synchronisation speed when doing START SLAVE
997172020-05-28
7:47
2024-01-08
10:38
MySQL Server: InnoDB storage engineVerified
(1087 days)
S58.0AnyAnyPeformance regression of parallel count
1000172020-06-27
14:02
2023-05-05
8:00
MySQL Server: MyISAM storage engineDuplicate
(1368 days)
S58.0.20AnyAnyExtremely slow queries after database repair
1009662020-09-27
3:46
2020-11-16
15:35
MySQL Server: InnoDB storage engineClosed
(1228 days)
S2MySQL8.0.18, 8.0.21Any (rhel-7.4)Any (intel x86)select count(*) works very slow for uncommitted data
1046192021-08-13
14:45
2022-09-01
5:55
MySQL Server: InnoDB storage engineVerified
(955 days)
S38.0AnyAnylong MVCC snapshots will cause commit stalls via GTID persistor periodic compres
1046592021-08-18
22:19
2023-06-26
20:04
MySQL Server: InnoDB storage engineVerified
(276 days)
S28.0.26, 5.7.35AnyAnySelect * reporting less rows_examined than only fields in an index.
1050682021-09-28
22:06
2021-10-04
12:07
MySQL Server: OptimizerVerified
(910 days)
S35.7AnyAnyType ref instead of range after reconsidering_access_paths_for_index_ordering.
1055402021-11-12
7:10
2023-06-07
15:17
MySQL Server: LoggingVerified
(867 days)
S35.7,8.0AnyAnythe incorrect value of start_time field in the system table 'mysql.slow_log'
1065602022-02-24
14:51
2023-10-19
10:51
MySQL Server: DDLDuplicate
(761 days)
S38.0.28AnyAnyslow DDL in mysql 8.0 as compare to 5.7 taking more time for checking permission
1066042022-03-01
3:43
2022-03-01
8:01
MySQL Server: InnoDB storage engineVerified
(758 days)
S55.7.37LinuxAnyContribution by Tencent Cloud-Native Database team: Purge suspend forever
1070262022-04-14
16:17
2022-04-15
12:13
MySQL Server: DMLClosed
(713 days)
S35.7.36Debianx86Update performs full table scan due to too many indexes
1073522022-05-20
11:00
2022-05-30
8:22
MySQL Server: LoggingVerified
(668 days)
S38.0.28, 8.0.29AnyAnyROWS_EXAMINED confusing in MySQL 8
1075542022-06-13
20:28
2022-06-14
16:02
MySQL Server: OptimizerVerified
(653 days)
S58.0.29-0ubuntu0.20.04.3Ubuntu (20.04.4 LTS)x86regexp_replace in trigger VERY slow when using unicode category \\p{C}
1079032022-07-18
14:42
2022-07-19
11:48
MySQL Server: GeneralAnalyzing
(618 days)
S3AnyAnyContribution: Each slow log prints out the database name
1085862022-09-23
7:51
2023-03-19
16:53
MySQL Server: InnoDB storage engineVerified
(549 days)
S38.0.30Linux (below 3.15)AnyContribution By Tencent: WL#12527 cause slow startup in Linux < 3.15
1123042023-09-09
18:07
2024-01-03
15:22
MySQL Server: OptimizerClosed
(85 days)
S38.0AnyAnyMEM_ROOT::AllocBlock() does not satisfy minimum_length bigger than wanted_length
1124142023-09-21
13:45
2023-09-28
10:12
MySQL Server: LoggingVerified
(184 days)
S38.0AnyAnylog_slow_admin_statements cause store procedure record dml in slow log
1129642023-11-04
1:54
2024-02-15
8:15
MySQL Server: InnoDB storage engineVerified
(143 days)
S58.0, 8.0.35AnyAnySELECT COUNT is slow with O_DIRECT
1134822023-12-21
9:23
2024-01-17
14:25
MySQL Server: InnoDB storage engineVerified
(90 days)
S38.0.35, 8.2.0AnyAnyinnodb_parallel_read_threads>1 makes simple select count more expensive
71032004-12-08
12:58
2004-12-08
13:09
MySQL ServerDuplicate
(7050 days)
S15.0.2Windows (Windows 98 SE)Anymysql 5.0.2 mysqld crashes on describe any_table;
119482005-07-14
18:00
2018-09-09
20:45
MySQL Server: OptimizerVerified
(6812 days)
S35.0AnyAnyMyISAM only, nested JOIN Views, dramatic performance loss
142532005-10-24
9:26
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5201 days)
S35.0, 4.1, 6.0.14-bzrLinux (Linux)AnyOptimizer uses partial indexes for subqueries, where it should not
167002006-01-21
13:13
2006-01-21
13:51
MySQL ServerDuplicate
(6641 days)
S35.0.18FreeBSD (FreeBSD 6.0-RELEASE-p3)Anyoptimizer marks subquery DEPENDENT though it's not
198952006-05-17
22:41
2013-01-10
13:14
MySQL Server: OptimizerClosed
(4095 days)
S35.0.20, 6.0.7, 6.0.14Windows (Windows XP)AnyNo optimization of where clause subqueries rewritable as joins
237642006-10-30
10:16
2006-11-28
12:28
MySQL Server: Memory storage engineClosed
(6330 days)
S25.0.26 5.0.27Linux (FC5)AnyBTREE index deletes only 1 item on memory table
244952006-11-22
3:37
2008-09-27
10:42
MySQL Server: DDLClosed
(5661 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
249722006-12-11
21:55
2012-09-05
16:35
MySQL Server: OptimizerClosed
(4222 days)
S55.0.27, 6.0.14Any (Windows)AnyJoin and sub-query execution differences
252322006-12-21
13:24
2007-01-16
8:44
MySQL ServerClosed
(6281 days)
S25.0.30Linux (Linux AMD64 - SLES9-SP3 2.6.17)AnyMySQL hangs in FUTEX_WAIT
283822007-05-11
15:48
2007-05-11
18:30
MySQL Server: GeneralDuplicate
(6166 days)
S3SeveralAnyAnyQuery cache considered harmful
304392007-08-15
14:45
2007-08-16
5:14
MySQL Server: GeneralDuplicate
(6069 days)
S35.0.45LinuxAnytmpdir is not followed for temporary tables in group by
328372007-11-29
5:33
2007-11-29
12:00
MySQL Server: Information schemaDuplicate
(5964 days)
S55.0.50Windows (Vista)AnyI_S Querys take too long
339482008-01-20
15:16
2011-02-16
23:43
MySQL ServerClosed
(5354 days)
S55.1.22Linux (rhas5)Anyperformance issue when using sysbench benchmark on a multiple-core system.
377592008-07-01
9:41
2008-07-01
19:56
MySQL Server: OptimizerDuplicate
(5749 days)
S15.1.25AnyAnyPerformance/Index problem updating from 5.1.22 to 5.1.25
418712009-01-05
15:47
2018-09-09
20:45
MySQL Server: MyISAM storage engineVerified
(5291 days)
S55.1.30Any (MS Windows, Mac OS X)AnySelect + Index + Limit + offset on large MyIsam tables give very bad performance
427052009-02-09
16:37
2011-02-16
23:43
MySQL Server: GeneralVerified
(5484 days)
S35.1.30AnyAnyReduce malloc/free during query lifecycle.
434272009-03-05
17:17
2012-03-18
18:41
MySQL Server: GeneralVerified
(5499 days)
S55.0AnyAnyDon't limit table_cache_size as a function of max_connections
442012009-04-10
3:04
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5035 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
(5405 days)
S25.0.51a, 5.0.77 and 5.1.34, 5.1, 6.0 bzrLinuxAnyUPDATE statement cause full table scan ?
465082009-08-01
13:27
2011-02-16
23:44
MySQL Server: OptimizerDuplicate
(5349 days)
S35.1.36AnyAnyMySQL 5.1.36 where / order by seems to sort first
472862009-09-12
11:22
2011-11-28
15:40
MySQL Server: GeneralClosed
(4504 days)
S35.1.38AnyAny'have_federated' variable not implemented
491112009-11-25
20:11
2012-08-30
14:32
MySQL Server: OptimizerClosed
(4228 days)
S35.5.0-beta, 5.1AnyAnyChange in execution plan for count_distinct_group_on_key causes peformance drop
505712010-01-24
11:09
2011-02-16
23:44
MySQL Server: OptimizerDuplicate
(5177 days)
S55.1.42AnyAnyMySQL not using an index when using tuples in IN clause
530452010-04-22
4:58
2022-12-04
20:45
MySQL Server: LockingVerified
(5089 days)
S55.1.45, 5.5AnyAnyLOCK_thread_count locked when per connection threads created
574302010-10-13
13:41
2015-11-23
10:42
MySQL Server: OptimizerClosed
(3048 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
(4819 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
(4090 days)
S5AnyAnyPerformance suggestion: optimize large and simple "LIMIT" queries
610602011-05-04
16:43
2011-05-04
19:48
MySQL ServerDuplicate
(4712 days)
S3AllAnyAnyMixed direction indexes
617352011-07-04
11:30
2011-07-08
6:02
MySQL Server: InnoDB storage engineVerified
(4647 days)
S35.1, etcAnyAnyindex->lock held while preads are done
623072011-08-31
1:54
2011-09-01
21:29
MySQL Server: OptimizerVerified
(4592 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
(4189 days)
S25.1.56, 5.5.20, 5.6.4Windows (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
(4382 days)
S25.1.61, 5.5AnyAnyMixed String/Int values in IN list cause full table scan
651572012-04-30
17:39
2012-05-03
8:13
MySQL ServerDuplicate
(4347 days)
S55.1.53AnyAnyset read_only=1|0 kills performance
653592012-05-18
12:41
2012-05-30
17:01
MySQL Server: InnoDB storage engineDuplicate
(4320 days)
S25.1.62LinuxAnybad select performance
657922012-07-03
2:19
2012-07-04
9:54
MySQL Server: OptimizerVerified
(4286 days)
S55.1,5.5AnyAnyan unecessary Using temporary in distinct query
658862012-07-12
19:24
2012-12-24
19:11
MySQL Server: InnoDB Plugin storage engineClosed
(4112 days)
S55.1.52, 5.1.64AnyAnyis the call to ibuf_merge_or_delete_for_page from buf_page_get_gen redundant?
670982012-10-05
10:19
2012-12-13
16:57
MySQL Server: Performance SchemaClosed
(4123 days)
S35.6.5, 5.7.0AnyAnyperformance schema shows stray temporray tables
1126212023-10-04
16:39
2023-11-20
15:30
MySQL Server: Performance SchemaClosed
(129 days)
S58.0.34AnyAnyPerformance degradation from 8.0.30 onwards related to performance_schema
1143312024-03-12
21:53
2024-03-19
9:48
MySQL Server: InnoDB storage engineVerified
(9 days)
S58.0.*, 8.0.36Linuxx86MySQL get high insert latency in low concurrency
967222019-09-03
3:19
2019-12-10
6:37
MySQL Server: LoggingVerified
(1570 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
(3992 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
(1557 days)
S3AllLinuxAnyInconsistent behavior while logging a killed query in the slow query log
996942020-05-26
13:06
2020-06-01
15:23
MySQL Server: CharsetsVerified
(1396 days)
S58.0AnyAnyImproving performance of my_hash_sort_utf8(mb4)/my_strnncollsp*utf8(mb4)
867052017-06-15
2:25
2018-08-30
11:04
MySQL Server: InnoDB storage engineVerified
(2471 days)
S25.5.45, 5.5.56Linux (MySQL OOM because of memory leak)AnyMemory leak of Innodb
1113102023-06-07
6:51
2023-06-08
8:30
MySQL Server: Prepared statementsVerified
(294 days)
S38.0.33Ubuntu (22.04)x86 (x86_64)Prepared statement with CTE memory leak
789752015-10-27
8:02
2016-06-18
21:28
MySQL Server: Performance SchemaClosed
(2876 days)
S38.0.0-m17AnyAnySYSSCHEMA.PR_STATEMENT_PERFORMANCE_ANALYZER TEST still FAILING ON PB2 ON WINDOWS
813302016-05-05
19:41
2020-02-04
17:19
MySQL Server: ReplicationVerified
(1652 days)
S25.6.29, 5.7.17, 8.0.16AnyAnycircular semisync replication fails on msr (and slow without msr)
1084302022-09-08
13:52
2023-01-16
3:10
MySQL Server: InnoDB storage engineVerified
(471 days)
S58.0.29Oracle Linux (Oracle Linux Server release 7.9 3.10.0-1160.76.1.0.1.el7.x86_64)x86 ( Intel(R) Xeon(R) CPU E5-2630 v3 )performance degradation of DML operations comparing with MySQL 5.7
182152006-03-14
8:52
2006-04-22
4:17
MySQL ServerClosed
(6550 days)
S24.1.18Linux (Linux)AnyLong latency in connection establish
473302009-09-15
15:39
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5300 days)
S55.0.77, 5.1.34, 5.1.37Linux (Debian x64)AnySlow query with left join and having.
1100982023-02-16
11:57
2023-02-16
12:33
MySQL Server: LoggingVerified
(406 days)
S3Ver 8.0.32AnyAnyadd database message into slow log file
896372018-02-13
1:38
2018-11-20
22:16
MySQL Server: LoggingClosed
(1991 days)
S38.0.4AnyAnyContribution by Facebook: Slow Query Log Changes
555062010-07-23
11:45
2011-02-16
23:44
MySQL Server: PartitionsDuplicate
(4995 days)
S35.1AnyAnyMemory leak on partition_error.test
690662013-04-25
9:38
2013-05-07
18:11
MySQL Server: Memory storage engineDuplicate
(3978 days)
S35.6.11AnyAnyMemory leak slave_parallel_workers
690752013-04-26
3:07
2014-02-19
10:39
MySQL Server: Memory storage engineDuplicate
(3690 days)
S35.6.11, 5.6.15AnyAnyMemory leak slave_parallel_workers
949942019-04-12
3:06
2019-07-25
11:25
MySQL Server: Storage EnginesClosed
(1708 days)
S28.0.15Linuxx86Memory leak detect on temptable storage engine
852512017-03-01
13:16
2017-10-27
8:22
MySQL Server: ReplicationClosed
(2372 days)
S25.7.17, 8.0.0AnyAnyMemory leak in master-master GTID replication with sync_relay_log_info
799512016-01-13
12:58
2017-06-04
11:35
MySQL ServerClosed
(2489 days)
S25.7.10WindowsAnyLarge table queries are very slow compared to 5.6
142752005-10-24
21:41
2005-10-24
23:53
MySQL ServerClosed
(6730 days)
S34.0.25Linux (Fedora Core 4 64bit)Anyspitting out the wrong slow logs
718922014-02-28
22:00
2015-03-24
21:40
MySQL Server: LoggingClosed
(3292 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
(2919 days)
S35.7.11CentOSAnylog_queries_not_using_indexes is not working as expected in 5.7
981032020-01-01
5:14
2023-09-18
19:09
MySQL Server: LoggingVerified
(1536 days)
S3All, 8.0.18AnyAnyunexpected behavior while logging an aborted query in the slow query log
1037432021-05-19
21:07
2022-01-03
6:51
MySQL Server: InnoDB storage engineClosed
(815 days)
S28.0.18, 8.0.25CentOSx86slow mysql8 start with lots of _encrypted_ tables
1048972021-09-10
6:29
2022-09-28
12:41
MySQL Server: OptimizerVerified
(930 days)
S58.0.26, 8.0.17Anyx86Multi-valued index performance is too slow (Access too many rows than required)
603482011-03-04
20:14
2013-01-15
15:25
MySQL ServerVerified
(4090 days)
S55.1.55AnyAnytrim trailing spaces processes data only byte wise (continue of bug14637 (2))
1095392023-01-05
6:09
2024-03-19
11:01
MySQL Server: InnoDB storage engineClosed
(13 days)
S58.0AnyAnyPerformance of scanning data_lock_waits worse than expected with read-only trx
1045462021-08-05
9:50
2024-01-30
15:57
MySQL Server: Row Based Replication ( RBR )Verified
(58 days)
S58.0.26Ubuntu (18.04.5 LTS)x86 (Skylake-SP)MySQL 8.0.26 single thread replication performance is slower than MySQL 5.7.35.
1050172021-09-23
9:10
2021-09-23
13:47
MySQL Server: OptimizerVerified
(917 days)
S38.0.26AnyAnyExecute a statement with secondary engine, two entries in performance schema
679832012-12-28
16:39
2013-01-31
9:00
MySQL Server: ReplicationClosed
(4074 days)
S15.5.25aAnyAnyMemory leak on filtered slave
763492015-03-17
11:35
2015-07-19
21:30
MySQL Server: OptimizerClosed
(3175 days)
S25.6AnyAnymemory leak in add_derived_key()
931652018-11-12
15:11
2018-11-26
21:02
MySQL Server: InnoDB storage engineVerified
(1949 days)
S35.7.23, 5.7.24AnyAnyMemory leak in sync_latch_meta_init() after mysqld shutdown detected by ASan
841072016-12-08
11:15
2016-12-21
10:50
MySQL Server: PartitionsClosed
(2656 days)
S35.7.16AnyAnySevere slowdown on partitioned table with simple ORDER BY ASC change to DESC
481532009-10-19
15:09
2014-03-13
18:38
MySQL Server: MyISAM storage engineVerified
(3668 days)
S35.1.40, 5.6.17AnyAnySlowdown in test-connect
389002008-08-19
20:14
2011-02-16
23:43
MySQL ServerDuplicate
(5698 days)
S25.0.66aAnyAnymysql_insert_id() and possibly last_insert_id() incorrect
722432014-04-04
18:48
2014-04-04
19:33
MySQL Server: LoggingVerified
(3646 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
(3616 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
1132512023-11-28
11:54
2023-11-29
9:24
MySQL Server: Row Based Replication ( RBR )Verified
(120 days)
S3MySQL8.0AnyAnythe slow log in slave is logged ,when binlog_format is row
816992016-06-03
4:35
2016-06-14
7:49
MySQL Server: SYS SchemaVerified
(2844 days)
S35.7.12, 5.7.13AnyAnyps_statement_avg_latency_histogram often fails to draw the point of max(avg_us)
730562014-06-19
21:34
2018-03-15
14:17
MySQL Server: Prepared statementsClosed
(2939 days)
S55.7, 5.7.8AnyAnyPrepared Statements ABSURDLY SLOW due to inefficient query creation for logging
1046152021-08-13
10:26
2021-08-13
11:36
MySQL Server: LoggingVerified
(958 days)
S58.0Any (rhel7.4)Any (intel-x86)trx commit slow if there are too many binlog files to purge while rotating
231352006-10-10
12:10
2006-10-10
13:39
MySQL ServerDuplicate
(6379 days)
S55.0.19Linux (Linux)AnySlow views performance
233702006-10-17
13:32
2006-10-20
9:11
MySQL ServerDuplicate
(6369 days)
S1mysql-5.1.11-beta-win32 and 5.1.26Linux (Linux and Win)AnyBad nested group by performance
814692016-05-17
21:51
2016-05-18
6:54
MySQL Server: OptimizerVerified
(2871 days)
S35.6.30, 5.7.12AnyAnySlow performance for IN subquery and UNION
1030342021-03-18
9:29
2021-03-18
13:35
MySQL Server: InnoDB storage engineVerified
(1106 days)
S58.0AnyAnynew undo log purge strategy purge record too slow on single table
478842009-10-07
3:24
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5172 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
877562017-09-14
12:55
2017-10-02
11:17
MySQL ServerClosed
(2369 days)
S55.6AnyAnyJOINS and SUBQUERIES: huge performance difference between MySQL 5.5 and 5.6
1125972023-10-03
12:14
2023-10-05
14:13
MySQL Server: OptimizerVerified
(175 days)
S58.0AnyAnySlow performance
1126342023-10-05
12:03
2023-10-05
12:34
MySQL Server: OptimizerDuplicate
(175 days)
S58.0 & 8.1Windowsx86Slow performance Mysql 8.x
26832004-02-09
6:48
2004-02-10
14:42
MySQL ServerClosed
(7352 days)
S34.1.1aNT 4 Server SP 6aAnyPoor Performance on a Multi-Homed System
689792013-04-17
3:47
2018-07-11
15:11
MySQL Server: OptimizerVerified
(3963 days)
S55.6.10LinuxAnyperformance regression of MySQL 5.6.10?
835322016-10-25
14:11
2018-02-18
18:29
MySQL Server: InnoDB storage engineVerified
(2677 days)
S38.0AnyARMInnoDB mutex bs: memory barriers
902092018-03-24
21:19
2023-11-06
11:33
MySQL Server: InnoDB storage engineVerified
(1675 days)
S58.0, 8.0.17AnyAnyPerformance regression with > 15K tables in MySQL 8.0 (with general tablespaces)
942962019-02-12
18:17
2019-02-13
19:41
MySQL Server: OptimizerClosed
(1870 days)
S58.0.11Ubuntu (Ubuntu 16.04.1 LTS)x86 (x86_64)Poor Optimizer Performance with Composite Index, IN() function, and many Tuples
985112020-02-07
10:11
2020-06-30
17:34
MySQL Server: MyISAM storage engineClosed
(1367 days)
S58.0.19, 8.0.20WindowsAnyOPTIMIZE TABLE on myisam can increase table size (~2x) and reduce performance
996382020-05-20
0:53
2020-12-04
12:54
MySQL Server: InnoDB storage engineClosed
(1211 days)
S58.0.18AnyAnyxa transaction with low performance
1005372020-08-15
8:11
2024-03-06
10:29
MySQL Server: InnoDB storage engineVerified
(1319 days)
S58.0.21Ubuntu (18.04 LTS)x86Performance degradation caused by monitoring sys.innodb_lock_waits in MySQL 8.0
1021502021-01-05
11:53
2021-01-06
8:16
MySQL Server: DMLVerified
(1177 days)
S5MySQL 8.0.22AnyAnyPerformance of repeat() function need to be optimized
1059822021-12-27
8:11
2022-01-03
8:02
MySQL Server: Storage EnginesVerified
(815 days)
S5all, 5.7, 8.0LinuxAnyhard-coded libaio API parameter may not helpful to performance
1060062021-12-30
3:10
2022-01-11
14:44
MySQL Server: OptimizerClosed
(807 days)
S58.0.25, 8.0.27, 5.7.36Any (rhel-7.4)Any (x86-64)conditions are not pushed down into subqueries with union all: performance issue
1092902022-12-06
8:28
2023-01-13
6:20
MySQL Server: ReplicationVerified
(440 days)
S55.7.39Ubuntux86WRITESET causing performance issue for replication on a replica
1138002024-01-30
5:30
2024-01-31
8:28
MySQL Server: DMLVerified
(57 days)
S58.0.22, 8.0.36, 8.0.11Linuxx86Performance degradation of Blob operations comparing with MySQL 5.7
1143612024-03-15
1:53
2024-03-19
11:11
MySQL Server: ReplicationVerified
(10 days)
S58.0AnyAnyUnaligned Delegate's lock reduces performance
137622005-10-05
7:37
2007-12-04
21:17
MySQL ServerClosed
(5959 days)
S34.1.14Linux (linux)AnySHOW CREATE TABLE slowdown with InnoDB
359182008-04-08
23:17
2014-02-25
19:54
MySQL ServerDuplicate
(3684 days)
S55.1.24LinuxAnymysql-bench: slowdown for create table in 5.1.24 vs 5.0.58&5.1.23
381532008-07-15
22:13
2014-02-28
18:58
MySQL Server: InnoDB storage engineVerified
(3681 days)
S55.0.66, 5.1.34, 5.6.16AnyAnymysql-bench: slowdown for update_of_primary_key_many_keys test
680772013-01-14
3:37
2013-04-03
11:33
MySQL Server: InnoDB storage engineClosed
(4012 days)
S55.6AnyAnyMixing 4K/16K blocks increases 8K free blocks and holds buf pool mutex longer
782132015-08-25
20:03
2015-10-23
12:55
MySQL Server: OptimizerClosed
(3095 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
834702016-10-20
18:24
2017-05-16
2:53
MySQL Server: PartitionsClosed
(2508 days)
S35.7.16-debug-logAnyAnyReverse scan on a partitioned table does ICP check incorrectly, causing slowdown
876212017-08-31
9:45
2017-09-28
9:11
MySQL Server: InnoDB storage engineVerified
(2397 days)
S35.6.37, 5.7.19AnyAny Huge InnoDB slowdown when selecting strings without indexes
632762011-11-16
0:19
2013-07-30
14:25
MySQL Server: InnoDB Plugin storage engineClosed
(3894 days)
S55.1.52, 5.1.60AnyAnyskip sleep in srv_master_thread when shutdown is in progress
690302013-04-22
12:55
2013-04-24
11:23
MySQL Server: LockingClosed
(3991 days)
S15.1.66AnyAnyOptimize table locks whole database
805692016-03-01
5:03
2016-07-18
12:59
MySQL Server: SYS SchemaClosed
(2828 days)
S35.7.11AnyAnymax_latency is not correct for sys.host_summary_by_statement_latency view
967992019-09-10
0:32
2020-10-20
6:52
MySQL Server: OptionsClosed
(1331 days)
S38.0.13AnyAnyContribution by Facebook: Periodic fsync in select into outfile controlled ...
107372005-05-19
11:38
2005-05-19
13:57
MySQL ServerDuplicate
(6888 days)
S24.1.12Linux (Linux)AnyPS API queries in --log-slow-queries are unusable
402632008-10-22
18:41
2008-10-22
18:47
MySQL ServerDuplicate
(5636 days)
S35.0+AnyAnyServer default log filenames do not use hostname
676762012-11-22
6:37
2014-07-14
12:23
MySQL Server: Prepared statementsClosed
(4021 days)
S25.6.7AnyAnyprepared statement is very slow while binlog was enabled
678922012-12-13
2:37
2012-12-14
13:18
MySQL Server: ErrorsClosed
(4122 days)
S35.5.28, 5.6.9AnyAnyWarning recommends to use a deprecated or non-existing option
686262013-03-10
16:11
2014-03-11
21:25
MySQL Server: LoggingClosed
(3670 days)
S35.6.10AnyAnyGRANT statements logged twice in slow query log
814672016-05-17
14:33
2016-05-18
9:43
MySQL Server: TestsVerified
(2871 days)
S35.7, 5.7.12AnyAnyinnodb_fts.sync_block test unstable due to slow query log nondeterminism
914962018-06-29
11:40
2022-06-07
15:43
MySQL Server: LoggingClosed
(660 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
(1862 days)
S38.0.13AnyAnySlow query log doesn't log a slow CREATE INDEX with admin statements enabled
955822019-05-31
5:02
2019-06-21
13:41
MySQL Server: InnoDB storage engineVerified
(1742 days)
S38.0.16, 5.7.26AnyAnyDDL using bulk load is very slow under long flush_list
963112019-07-24
9:02
2020-02-19
17:38
MySQL Server: GISDuplicate
(1499 days)
S58.0.17AnyAnyST_Intersects() is very slow on MySQL 8.0
982382020-01-15
12:26
2020-05-07
12:32
MySQL Server: Information schemaClosed
(1422 days)
S58AnyAnyI_S.KEY_COLUMN_USAGE is very slow
1019002020-12-08
3:21
2024-01-30
6:39
MySQL Server: InnoDB storage engineVerified
(1206 days)
S28.0.21Linux (7.6)AnyAdd partition is slow
1064102022-02-08
17:16
2022-02-08
19:31
MySQL ServerDuplicate
(779 days)
S35.734AnyAnyUpgraded Mysql 5.6 to Mysql 5.7. All Queries are running damn slow after upgrade
1066102022-03-01
10:32
2022-04-04
11:34
MySQL Server: LockingVerified
(724 days)
S25.7.33Linuxx86Concurrent INSERT IGNORE in InnoDB table may trigger the database to stall
1111802023-05-29
6:19
2023-05-29
12:13
MySQL Server: LoggingVerified
(304 days)
S35.7*, 5.7.42AnyAnybinlog rotate will cause query missing in slow log
104802005-05-09
15:11
2005-06-16
7:44
MySQL ServerClosed
(6860 days)
S24.1.11-standard-logLinux (Linux Redhat Fedora Core 1)AnySlow queries
251302006-12-18
5:46
2012-03-26
19:41
MySQL Server: OptimizerClosed
(4385 days)
S55.0.34-BK, 5.0.27, 5.1, 5.5.0Windows (Windows, Sparc & Linux)AnyExtremely Slow "Where in (Select... )" Subqueries GROUP BY / HAVING related
609612011-04-23
18:59
2014-03-28
19:39
MySQL ServerClosed
(4333 days)
S25.6, 5.5, 5.1AnyAnyshow tables very slow when not in system disk cache
728542014-06-03
20:12
2017-10-05
15:43
MySQL Server: OptimizerClosed
(2366 days)
S25.6.17AnyAnyExtremely slow performance with outer joins and join buffer
978222019-11-27
23:58
2020-01-28
2:23
MySQL Server: InnoDB storage engineClosed
(1521 days)
S55.7.28Linux (Centos7)Anybuf_page_get_gen buf_pool->stat.n_page_gets++ is a cpu waste
1129592023-11-03
17:53
2023-11-07
10:41
MySQL Server: Performance SchemaVerified
(143 days)
S38.0AnyAnyWrong rows examined in P_S and slow log for Index Merge.
267732007-03-01
22:16
2013-03-03
20:45
MySQL Server: Archive storage engineDuplicate
(5096 days)
S15.0.27-maxLinux (Debian 3.1 (kernel 2.6.14.2))AnyPossible Memory Leak with Archive Tables
476232009-09-24
16:20
2011-02-16
23:44
MySQL ServerDuplicate
(5090 days)
S15.0.44, 5.0.85Linux (Centos)AnySuspected memory/temporary file leak
621172011-08-08
19:53
2011-08-10
10:47
MySQL Server: Prepared statementsDuplicate
(4614 days)
S25.1.58-enterpriseSolarisAnyLarge Batch Update causes apparent large memory leaks and crashes server
649872012-04-15
20:13
2014-08-15
20:09
MySQL Server: InnoDB storage engineDuplicate
(4332 days)
S35.6.6AnyAnyMemory leak in mysql-5.6.6-labs-april-2012
711972013-12-21
8:48
2015-01-05
2:17
MySQL Server: ReplicationClosed
(3690 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
(3717 days)
S15.6AnyAnyMySQL 5.6 memory leak
745902014-10-27
11:16
2014-12-01
16:56
MySQL Server: OptimizerClosed
(3436 days)
S35.7.6AnyAnyMemory leak in unit test CostEstimationTest.MergeManyBuff
791452015-11-06
2:42
2016-02-08
12:57
MySQL Server: PartitionsClosed
(3059 days)
S35.7.10AnyAnyMemory Leak in Ha_innopart_share::set_v_templ partitioned on virtual column
853712017-03-08
10:46
2018-01-18
10:36
MySQL Server: ReplicationClosed
(2316 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
(2449 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
(2239 days)
S38.0.4Ubuntu (17.10)Any__tls_get_addr leak on Ubuntu 17.10
895972018-02-09
4:41
2018-03-21
16:34
MySQL Server: TestsClosed
(2199 days)
S38.0.4AnyAnyValgrind reporting memory leak on MTR test main.validate_password_component
918602018-08-01
20:51
2018-08-02
6:28
MySQL Server: InnoDB storage engineDuplicate
(2065 days)
S25.7.22AnyAnyThe buf_LRU_free_page function may leak some memory in a particular scenario
933942018-11-29
5:46
2018-11-29
14:55
MySQL Server: CSVVerified
(1946 days)
S35.7.21AnyAnymemory leak when csv engine has no permission to meta file
1001142020-07-05
8:03
2020-07-13
12:47
MySQL ServerClosed
(1356 days)
S25.7.25CentOS (7.6)Anybluk_insert may lead to memory leak
214722006-08-07
7:13
2006-08-26
12:46
MySQL Server: Federated storage engineDuplicate
(6424 days)
S55.1.12Linux (linux)Anyquestion about the query against to the federated engine tables
403672008-10-28
8:55
2011-02-16
23:43
MySQL Server: Information schemaVerified
(5544 days)
S35.1.28, 5.1.29, 5.0, 5.1 bzrAnyAnySHOW on a broad view is taking too long
479372009-10-09
9:11
2011-02-16
23:44
MySQL Server: GeneralVerified
(5284 days)
S5AnyAnyAppending to fields using CONCAT gets very slow
603492011-03-04
21:20
2013-01-15
15:25
MySQL ServerVerified
(4090 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
(4090 days)
S55.1.55AnyAnytrim same character processes data only byte wise (continue of bug14637 (4))
730182014-06-17
3:20
2015-06-22
10:02
MySQL Server: ReplicationVerified
(3202 days)
S55.6AnyAny improve performance when binlog_order_commits=0 and sync_binlog >1
794062015-11-25
9:49
2017-12-23
10:50
MySQL Server: GISClosed
(2337 days)
S25.7.9 GA, 5.7.11AnyAnyExtremely poor selection performance compared to MySQL 5.6.27 on InnoDB & MyISAM
832702016-10-05
14:13
2017-04-11
7:25
MySQL Server: ReplicationClosed
(2543 days)
S55.7.15AnyAnyPerformance degradation when the server has many gtids
1061162022-01-08
15:54
2022-10-18
0:12
MySQL Server: ReplicationClosed
(527 days)
S58.0AnyAnybinlog rotation impact performance
1115702023-06-26
20:03
2023-06-28
0:31
MySQL Server: InnoDB storage engineVerified
(274 days)
S38.0.33, 5.7.42AnyAnyLooking for inexistent data reports 0 rows examined
377032008-06-27
21:20
2015-04-29
0:09
MySQL Server: GeneralClosed
(3256 days)
S5MYSQL 6.0.4 (Source Distribution)Linux (EL5.1)AnyMySQL performance with and without Fast Mutexes using Sysbench Workload
479142009-10-08
9:10
2012-03-26
19:30
MySQL Server: OptimizerClosed
(4385 days)
S24.1 and 5.1Windows (Windows Server 2003)AnyPerformance Issue with Subquery
503672010-01-15
14:12
2011-02-16
23:44
MySQL Server: GeneralVerified
(5124 days)
S55.1.42, 5.1 bzrAny (MS Windows 32 bits, Mac)AnyREPLACE has quadradic computational complexity on windows server (but not linux)
685722013-03-05
10:57
2014-02-19
16:19
MySQL Server: Federated storage engineVerified
(4040 days)
S35.5.25a, 5.5.31AnyAnyFEDERATED using SHOW TABLE STATUS causes performance problems for InnoDB tables
694192013-06-07
7:04
2013-08-26
14:08
MySQL Server: OptionsClosed
(3867 days)
S25.6.12AnyAnyUndocumented and untested table_open_cache table_definition_cache default change
764602015-03-23
13:01
2015-04-08
13:31
MySQL Server: OptimizerClosed
(3277 days)
S35.7.5AnyAnyCost constant cache's mutex not instrumented by performance schema
775772015-07-01
10:51
2015-07-15
12:18
MySQL Server: Performance SchemaClosed
(3180 days)
S35.5, 5.6, 5.7AnyAnysetup_timers initialization assumes CYCLE timer is always available
807372016-03-14
21:24
2016-03-17
0:14
MySQL Server: InnoDB storage engineClosed
(2934 days)
S35.7AnyAny"How MySQL Uses Memory" is myisam centric
807802016-03-17
11:55
2016-04-14
0:45
MySQL Server: Performance SchemaClosed
(2921 days)
S35.7AnyAnyAdd Performance Schema / sys Schema Memory Monitoring Example
816302016-05-28
5:46
2016-08-31
6:30
MySQL Server: ReplicationVerified
(2766 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
(2789 days)
S3AnyAnyCHANNEL SERVICE INTERFACE HAS NO FUNCTION TO GET RETRIEVED GTID SET
832472016-10-03
14:02
2016-12-15
15:06
MySQL Server: OptimizerClosed
(2723 days)
S35.6.33AnyAnySevere regression in my_strnxfrm() from mysql-5.5 -> 5.6
837162016-11-07
9:31
2016-11-08
6:46
MySQL Server: SYS SchemaVerified
(2697 days)
S25.7.14, 5.7.16AnyAnyMySQL performance-schema doesn't store (analyze) queries to views
843052016-12-22
1:22
2017-03-24
14:43
MySQL Server: Information schemaClosed
(2561 days)
S25.6.35AnyAnyThe fix for Bug#78777 has different behavior with perf. schema vs. without it
853522017-03-08
0:44
2017-08-14
12:36
MySQL Server: ReplicationClosed
(2418 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
(1287 days)
S55.7.23Debian (8.0, 9.0)x86Slave performance degrades over time
1005122020-08-13
9:17
2023-03-03
14:14
MySQL Server: InnoDB storage engineClosed
(681 days)
S55.7.31,8.0.21Linux (3.10.107)x86 (96 cores)adaptive hash index(AHI) building causing contention on btr_search_latches
1063902022-02-07
10:08
2022-07-18
11:45
MySQL ServerDuplicate
(779 days)
S58.0.28DebianAnyCREATE TABLE performance in MySQL 8 is considerably slower than 5.7
1115942023-06-28
8:21
2023-09-20
10:34
MySQL Server: InnoDB storage engineVerified
(190 days)
S38.0AnyAnySome Scalability Issues in Specific Scenarios
1127672023-10-19
6:07
2024-02-16
22:07
MySQL Server: InnoDB storage engineClosed
(41 days)
S58.0.34, 8.0.35AnyAnySELECT COUNT(*) degraded performance on 8.0 compared to 5.7
1027742021-03-02
0:37
2021-03-06
7:15
MySQL Server: DMLVerified
(1118 days)
S35.7.31,8.0.22, 5.7.33AnyAnyA scenario that result in memory leak
1079912022-07-27
2:02
2023-10-23
8:31
MySQL Server: ReplicationVerified
(157 days)
S28.0.25AnyAnyClone_persist_gtid causes memory leak
818042016-06-10
12:35
2019-07-02
10:59
MySQL Server: InnoDB storage engineVerified
(2845 days)
S25.7.13AnyAnyMemory leak or bug in P_S instrumentation for InnoDB threads
128312005-08-26
13:21
2008-04-02
13:50
MySQL ServerClosed
(5839 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
(6677 days)
S15.0Windows (Windows XP PRO Sp2)Anyslow / increase memory / crashing / OS freezing
196992006-05-10
21:43
2006-05-10
22:05
MySQL Server: LoggingDuplicate
(6532 days)
S3*Any (*)AnyCannot enable/disable general query log or slow query log at runtime
272712007-03-19
18:38
2007-03-25
13:23
MySQL Server: GeneralClosed
(6213 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
(6156 days)
S25.0.24-Debian_1~bpo.1-logLinux (Debian 3.1 i386)AnyFLUSH LOGS crashes database
293492007-06-26
1:01
2014-02-02
14:12
MySQL Server: Memory storage engineVerified
(6119 days)
S35.0.27AnyAnydropping MEMORY table very slow
307432007-08-31
8:05
2013-03-03
20:45
MySQL Server: Merge storage engineVerified
(5450 days)
S35.0.37-community/5.1/6.0AnyAnyDelete from MERGE-table is slow
394612008-09-15
20:54
2008-10-20
13:05
MySQL ServerClosed
(5638 days)
S35.0.60LinuxAnySlow Query
396182008-09-23
21:56
2022-12-04
20:45
MySQL Server: LoggingVerified
(5601 days)
S35.0.27, 5.0.67Windows (XP)AnyUsing log-short-format does not change what is logged
422482009-01-21
18:27
2011-02-16
23:43
MySQL Server: Information schemaDuplicate
(5545 days)
S56.0.0-alpha-community-nt-debugWindowsAnyInformation schema has no indexes
434012009-03-05
8:00
2011-02-16
23:43
MySQL Server: MyISAM storage engineClosed
(5502 days)
S35.1.30FreeBSDAnyQuery spends too much time in ``sending data'' state
448022009-05-11
20:35
2011-09-24
17:15
MySQL Server: OptimizerClosed
(4569 days)
S34.1, 5.0, 5.1, 6.0.10-aphaLinuxAnyVery slow EXPLAIN when subqueries are used
450142009-05-21
17:57
2016-10-16
20:45
MySQL Server: ReplicationDuplicate
(5412 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
(5419 days)
S35.1.34-logAnyAnylog-slow-slave-statements doesn't work in 5.1.34
509542010-02-05
19:46
2022-12-04
20:45
MySQL Server: LoggingVerified
(5164 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
520862010-03-16
12:03
2011-02-16
23:44
MySQL Server: Information schemaDuplicate
(5126 days)
S35.1.44Windows (Server 2003)Anyshow function status
581062010-11-10
10:24
2011-02-16
23:44
MySQL Server: OptionsVerified
(4887 days)
S35.1-bugteamAnyAnyWrong directory info in general_log_file/slow_query_log_file.
586892010-12-03
6:02
2012-07-31
1:44
MySQL Server: LockingClosed
(4258 days)
S35.0, 5.1, 5.6.1AnyAnyMyISAM Selects locks inserts inside procedure only
608012011-04-08
3:51
2011-05-09
3:59
MySQL Server: Query CacheClosed
(4707 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
609682011-04-24
18:40
2011-04-25
19:50
MySQL Server: ErrorsVerified
(4721 days)
S35.1.43sp1-enterprise-gpl-advanced-logAnyAnyCancelled queries not reported in slow query log
612042011-05-17
15:24
2011-05-18
9:35
MySQL Server: GeneralClosed
(4698 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
618182011-07-11
8:22
2011-07-11
9:03
MySQL ServerClosed
(4644 days)
S25.1.57Linux (debian 6 64 bit)Anydebian 6 64 bit + mysql 5.1.57 insert innodb very very slow
648222012-03-31
1:33
2013-03-26
22:27
MySQL Server: LoggingClosed
(4020 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
(4235 days)
S35.5.25Any (x86_64)AnyWrong connection ID (thread ID) in the general and slow query logs
680222013-01-03
18:00
2013-07-07
11:28
MySQL Server: InnoDB Plugin storage engineClosed
(3917 days)
S15.1,5.5AnyAnyDROP TABLE slow when it decompress compressed-only pages
687482013-03-22
16:26
2013-04-01
16:14
MySQL Server: OptimizerDuplicate
(4014 days)
S55.6.10Linux (Centos 5)AnySelects with large "IN" conditions are very slow
688142013-03-29
15:33
2015-04-23
6:14
MySQL Server: InnoDB storage engineVerified
(3262 days)
S35.6.10Any (Centos 6.3)AnyMySQL optimizer consider few rows to examine but it is not really obvious why
690232013-04-21
12:39
2013-04-21
12:40
MySQL Server: Data TypesVerifiedS35.6.12WindowsAny"Questions" output in COM_STATISTICS wraps at 2^32
692952013-05-21
16:22
2013-05-22
9:04
MySQL Server: OptionsVerified
(3963 days)
S35.1.44, 5.6.10AnyAnySlow_queries status variable incremented when it should not
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
736482014-08-19
22:10
2018-07-06
3:09
MySQL Server: Row Based Replication ( RBR )Verified
(2239 days)
S2Server version: 5.6.16-log MySQL Communi, 5.6.39LinuxAnyinnodb table replication is very slow with some of the partioned table
740782014-09-25
16:15
2014-10-16
19:49
MySQL Server: OptimizerVerified
(3451 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
765852015-04-03
10:07
2018-02-19
14:36
MySQL ServerClosed
(2229 days)
S35.6.27, 5.7.21AnyAnyRuntime changes to `long_query_time` are ignored.
782622015-08-28
15:19
2015-12-07
18:51
MySQL Server: InnoDB storage engineClosed
(3034 days)
S55.6.26Any (CentOS release 6.6)AnyAdding indexes on empty table is slow with large innodb_sort_buffer_size.
827252016-08-25
15:55
2016-09-14
6:28
MySQL Server: OptimizerVerified
(2752 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'
828702016-09-06
10:07
2018-10-25
12:54
MySQL Server: LoggingVerified
(2267 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
(2758 days)
S35.7.14, 5.7.15AnyAnyTrying to turn-off slow_query_log with an active thrd logging slow query ASSERTs
937342018-12-24
18:44
2024-01-29
11:07
MySQL Server: InnoDB storage engineClosed
(143 days)
S5Ubuntu (18.04)x86MySQL 8.0 is 36 times slower than MySQL 5.7
963402019-07-26
12:13
2023-09-29
7:51
MySQL ServerClosed
(1583 days)
S38.0.17AnyAnySlow startup for mysql 8.0 with many tables due to the tablespace files scan
984492020-01-31
12:25
2023-11-02
6:26
MySQL Server: Data DictionaryClosed
(147 days)
S58.0.19AnyAnySELECT from I_S.INNODB_COLUMNS is slow in 8.0
1004792020-08-10
9:04
2020-08-15
12:37
MySQL Server: OptimizerVerified
(1323 days)
S58.0AnyAnysearch with in() function runs really slow
1022492021-01-14
15:56
2021-01-27
17:40
MySQL Server: Group ReplicationVerified
(1165 days)
S38.0.22AnyAnySlow query log filling up with performance_schema queries
1031952021-04-02
9:48
2021-04-13
13:23
MySQL Server: Data DictionaryVerified
(1081 days)
S58.0Linux (rhel-7.4)Any (x86-64)it gets very slow to access an empty table after drop a big database
1069582022-04-08
9:35
2022-04-11
14:37
MySQL Server: SYS SchemaVerified
(717 days)
S38.0.28CentOS (CentOS Stream release 8)x86 (Intel(R) Xeon(R) CPU E5-2620 v4 @ 2.10GHz)Querying the user_summary views in sys schema is extremely slow
1094822022-12-25
9:33
2022-12-26
4:56
MySQL Server: LoggingVerified
(458 days)
S38.0.27AnyAnyThe mysql slow query log contains invalid content, and the mysql common log file
1108042023-04-25
13:47
2023-04-26
23:03
MySQL Server: LoggingVerified
(337 days)
S38.0.32AnyAnysql as "select count(*) from table" can't be logged in the slow query log.
1113672023-06-12
15:36
2023-08-04
15:11
MySQL Server: OptimizerVerified
(237 days)
S58.0AnyAnyOFFSET 99 LIMIT 1 on a compound PK takes ages to execute.
1121372023-08-22
13:48
2024-03-14
21:47
MySQL Server: InnoDB storage engineClosed
(14 days)
S58.0.33, 8.0.34AnyAnyparallel read is slow when innodb_use_native_aio = off
1141542024-02-28
9:57
2024-02-29
9:53
MySQL Server: InnoDB storage engineVerified
(29 days)
S58.0.36AnyAnyParallel read is slow after parition table is read in parallel
1143002024-03-11
13:45
2024-03-11
14:41
MySQL Server: Performance SchemaVerified
(17 days)
S38.0AnyAnyThe "fake index" of performance_schema.data_lock_waits causes slow sql
342542008-02-02
20:26
2008-02-04
2:23
MySQL Server: GeneralClosed
(5897 days)
S25.1.22 RC (x64)Windows (XP x64 AMD DC)AnyVery slow queries when using functions in SELECT statements
422592009-01-22
6:36
2012-07-31
12:15
MySQL Server: DMLClosed
(4258 days)
S25.5.25Linux (Ubuntu 12.04 x86_64)AnyUtilizing a SELECT within a WHERE IN performs poorly (slow)
731362014-06-27
16:34
2015-05-20
15:16
MySQL Server: OptimizerVerified
(3559 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
777782015-07-19
5:57
2017-03-31
17:24
MySQL Server: ReplicationClosed
(2554 days)
S35.6.25AnyAnytuning the log_lock contention for IO_THREAD and SQL_THREAD in rpl_slave.cc
831662016-09-27
10:09
2016-11-21
17:45
MySQL Server: GISClosed
(2694 days)
S55.7.15AnyAnyQuery execution involving spatial and non-spatial data very slow
981322020-01-06
10:55
2022-01-04
12:51
MySQL Server: InnoDB storage engineVerified
(1542 days)
S25.6, 5.7, 8.0, 5.7.28, 8.0.18AnyAnyAnalyze table leads to empty statistics during online rebuild DDL
987392020-02-25
18:27
2020-06-11
17:21
MySQL Server: Storage EnginesClosed
(1386 days)
S38.0.19AnyAnyTempTable storage engine slow if mmap is required
1032132021-04-06
5:13
2024-01-08
10:39
MySQL Server: InnoDB storage engineDuplicate
(1087 days)
S58.0.17 - 8.0.23AnyAnyPoor performance while executing 'select count(*)' on a table
1059572021-12-22
7:44
2021-12-22
8:01
MySQL Server: OptionsVerified
(827 days)
S35.7.35, 8.0.27LinuxAnyThe table "slow_log" not close when config option slow_query_log set into OFF
1074732022-06-03
3:34
2022-08-24
7:29
MySQL Server: InnoDB storage engineVerified
(582 days)
S38.0.23, 8.0.29CentOSAnyUpdating BLOB column slows down purge and causes high trx_rseg_history_len
1093612022-12-13
12:06
2023-01-11
1:03
MySQL Server: OptimizerClosed
(442 days)
S28.0.29AnyAnyMySQL 8.0.29+ is slower than MySQL 8.0.28 with queries using JOINS
1135052023-12-24
18:23
2024-01-12
9:30
MySQL Server: InnoDB storage engineVerified
(77 days)
S58.0.35AnyAnyPerformance schema counter increments make parallel index create slow
4852003-05-23
12:38
2003-06-05
10:38
MySQL ServerDuplicate
(7602 days)
S24.1Windows (Windows ONLY)AnyRemote Performance Issue Windows in 4.1
126622005-08-19
2:20
2005-08-19
2:41
MySQL ServerDuplicate
(6796 days)
S25.0.9FreeBSD (FreeBSD 5.4)AnyPoor View Performance
229472006-10-03
16:16
2006-10-03
16:20
MySQL Server: GeneralDuplicate
(6386 days)
S24.1.21 Linux 2.4.18 SMP kernelAnyPerformance regression in C API 4.1 versus 4.0
274522007-03-26
17:35
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5610 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
315512007-10-11
22:30
2013-06-13
19:31
MySQL Server: MyISAM storage engineVerified
(5770 days)
S25.0.45, 5.0 BK, 5.1 BKLinux (CentOS 4.5)AnyMyISAM poor performance with multiple queries running concurrently
343642008-02-06
21:17
2012-07-30
17:14
MySQL Server: OptimizerClosed
(4259 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
(5760 days)
S35.0AnyAnyAlmost 300% regression in index merge intersect performance
358502008-04-05
4:09
2011-02-16
23:43
MySQL Server: OptimizerClosed
(5030 days)
S55.1.23Any (Tested w/ SUSE)AnyPerformance regression in 5.1.23/5.1.24
369412008-05-25
11:58
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(5030 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
(5030 days)
S35.0,5.1AnyAnyPerformance problem in lock_get_n_rec_locks (SHOW INNODB STATUS)
400062008-10-13
15:04
2008-10-22
10:56
MySQL ServerClosed
(5636 days)
S55.0.18AnyAnyPerformance depends on functions used?
460852009-07-09
13:49
2011-02-16
23:44
MySQL ServerDuplicate
(5314 days)
S35.4.2 (summit), mysql-trunkLinuxAnyValgrind warnings (InnoDB code) in test rpl_trigger
466482009-08-11
11:41
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5337 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
512862010-02-18
15:56
2011-02-16
23:44
MySQL Server: GeneralVerified
(5152 days)
S3anyAnyAnyRequest to add performance regression to release acceptance tests
545312010-06-15
21:39
2011-02-16
23:44
MySQL Server: OptimizerClosed
(5034 days)
S25.1.46, 5.1.47AnyAnyPerformance regression with many joins
570242010-09-26
4:44
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4929 days)
S25.1AnyAnySerious performance issue with an outer join
582252010-11-16
11:21
2011-07-27
17:07
MySQL Server: OptimizerClosed
(4628 days)
S25.1.49, 5.1.54, 5.5.7Windows (Server 2003)AnyExtreme performance degradation with joins
614012011-06-03
17:47
2011-06-16
19:49
MySQL Server: LockingClosed
(4669 days)
S5MySQL 5.5.3+AnyAnyUPDATE performance degrades gradually if a trigger exists
643402012-02-15
14:07
2013-06-14
15:35
MySQL Server: InnoDB Plugin storage engineVerified
(3940 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
(4394 days)
S55.1AnyAnyInnoDB allocates too many empty pages in ibd files
659572012-07-20
7:00
2013-06-21
19:41
MySQL Server: OptimizerDuplicate
(3933 days)
S35.1.62, 5.5.27, 5.6.6LinuxAnyPoor correlated subquery performance with order by and limit
665872012-08-28
23:04
2013-05-23
16:55
MySQL Server: InnoDB storage engineClosed
(3962 days)
S35.6.7AnyAnyBehavior of read-only transactions differs from documentation
668652012-09-19
3:18
2017-01-25
14:20
MySQL ServerClosed
(2619 days)
S35.6AnyAnyPerformance degradation in MySQL 5.6
678992012-12-13
18:26
2013-02-24
19:43
MySQL Server: OptimizerClosed
(4050 days)
S55.5.27Linux (CentOS 6.3)AnyAdding LIMIT to query increases time from 2 seconds to 42 minutes
689192013-04-10
14:25
2013-04-10
14:33
MySQL Server: OptimizerVerified
(4005 days)
S55.6.10AnyAnyPerformance regression when DS-MRR is used for query with small limit
690292013-04-22
3:04
2013-04-25
4:55
MySQL Server: InnoDB storage engineClosed
(3990 days)
S55.6.12AnyAnyArbitrary flushing performance limitation is bad
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
(3874 days)
S25.6.13, 5.5, 5.1AnyAnyvery low performance join - eq_ref and ref access broken for compound indexes
727032014-05-21
6:46
2014-08-06
14:57
MySQL Server: InnoDB storage engineClosed
(3528 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
(2710 days)
S55.7AnyAnyNew futex-mutex in InnoDB needs perf attention
744872014-10-21
19:07
2015-02-16
20:38
MySQL Server: DDLClosed
(3328 days)
S35.7.5-labs-previewAnyAnyprimary key missing for query_rewrite.rewrite_rules
749492014-11-21
6:30
2015-04-06
18:53
MySQL Server: GISClosed
(3349 days)
S35.7.6AnyAnyGIS performance issue: too many reallocs
751082014-12-04
19:35
2015-01-15
19:26
MySQL ServerClosed
(3360 days)
S26.2.3Windows (Microsoft Windows 7 Home Premium Service Pack 1)AnyNo Connection to MySQL server. Port 3306 not available.
757632015-02-04
13:29
2015-02-05
8:19
MySQL Server: FULLTEXT searchVerified
(3339 days)
S25.6.21, 5.6.24AnyAnyInnoDB FULLTEXT index reduces insert performance by up to 6x on JSON docs
761172015-03-03
6:56
2015-03-04
7:40
MySQL ServerDuplicate
(3312 days)
S55.6.16-logWindowsAnyIndex cardinality not being updated when the data is changed
763052015-03-13
0:13
2015-04-08
13:26
MySQL Server: Performance SchemaClosed
(3277 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
(3249 days)
S35.7.8AnyAnySeveral performance schema unit tests fails
766272015-04-09
3:44
2018-12-03
3:24
MySQL Server: InnoDB storage engineClosed
(3230 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
(2855 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
(3214 days)
S35.7.6AnyAnyDocument potential benefits of InnoDB General Tablespaces
774142015-06-19
9:36
2016-02-04
20:01
MySQL Server: OptimizerClosed
(3101 days)
S35.7.7AnyAnyQuery digest does not reflect new optimizer hints
806512016-03-08
3:45
2016-04-07
5:46
MySQL Server: ReplicationDuplicate
(2912 days)
S35.5 5.6AnyAnylarget rpl_semi_sync_master_timeout will affect performance
809792016-04-06
14:25
2022-01-17
9:31
MySQL Server: InnoDB storage engineVerified
(2912 days)
S35.7AnyAnyDoublewrite buffer event waits should be annotated for Performance Schema
809892016-04-07
8:09
2016-04-08
1:29
MySQL Server: OptionsDuplicate
(2911 days)
S2AnyAnySevere performance degradation from 5.6 to 5.7 with a long query on a larg table
818032016-06-10
12:35
2016-06-15
16:58
MySQL Server: OptimizerVerified
(2843 days)
S5>=5.1AnyAnyMysql 5.1 and later Update performance regression
825242016-08-10
8:36
2016-08-25
8:22
MySQL Server: InnoDB storage engineVerified
(2772 days)
S55.6, 5.6.32, 5.7.14Ubuntu (16.04)AnySignificant innodb load performance regression since version 5.5
851912017-02-27
6:40
2017-02-28
12:30
MySQL Server: LockingVerified
(2585 days)
S35.7, 5.7.17AnyAnyperformance regression with HANDLER READ syntax
853312017-03-06
19:46
2017-09-27
2:00
MySQL Server: CharsetsClosed
(2374 days)
S35.6, 5.7, etc, 5.6.35AnyAny_characterset specifications have lousy performance for some character sets
886712017-11-28
0:16
2017-12-04
15:41
MySQL Server: OptimizerVerified
(2306 days)
S55.7.19AnyAnyALL + BNL chosen over REF in query plan with a simple SELECT + JOIN
906042018-04-24
13:50
2018-04-25
4:41
MySQL Server: InnoDB storage engineVerified
(2164 days)
S55.7CentOSAnyut_rnd_ulint_counter () : Default delay for spin wait gives better performance
909872018-05-23
10:03
2018-06-05
14:50
MySQL Server: Storage EnginesVerified
(2127 days)
S55.7.17AnyAnypartition table index next same scan ineffective
914852018-06-29
6:32
2018-07-20
17:10
MySQL Server: InnoDB storage engineClosed
(2078 days)
S55.7.22, 8.0.11AnyAnyut_crc32_hw() checks ut_crc32_cpu_enabled on each call
925322018-09-21
16:26
2021-01-19
15:13
MySQL Server: Performance SchemaClosed
(1165 days)
S38.0.11AnyAnyContribution by Facebook: Performance schema for Query attributes
959342019-06-23
17:13
2019-07-05
8:17
MySQL Server: InnoDB storage engineAnalyzing
(1728 days)
S58.0.*AnyAnyinnodb_flush_log_at_trx_commit = 0 get performance regression on 8 core machine
960712019-07-02
10:43
2022-07-19
13:12
MySQL Server: InnoDB storage engineVerified
(1387 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
(1690 days)
S58.0AnyARMRefine atomics and barriers for weak memory order platform
969852019-09-24
7:17
2019-10-24
18:05
MySQL Server: ReplicationVerified
(1617 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
(1554 days)
S58.0.18AnyAnyOptimize write performance when group commit
983052020-01-21
10:57
2020-08-04
12:41
MySQL Server: Data TypesVerified
(1520 days)
S55.7, 8.0LinuxAnyhp_rec_key_cmp suboptimal comparison
985462020-02-11
6:38
2020-02-12
15:20
MySQL Server: InnoDB storage engineVerified
(1506 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
(1240 days)
S58.0.19LinuxARMARM CRC32 intrinsic call to accelerate table-checksum (not crc32c but crc32)
991332020-03-31
15:08
2024-01-30
17:50
MySQL Server: Group ReplicationVerified
(1451 days)
S38.0.19AnyAnyGroup Replication Performance Degradation with partial network outage
991402020-04-01
6:53
2020-05-18
12:10
MySQL Server: Row Based Replication ( RBR )Duplicate
(1456 days)
S38.0.19CentOSx868.0 single thread applying performance regression of update_non_index
992442020-04-14
3:22
2020-04-22
12:45
MySQL Server: OptimizerVerified
(1437 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
(1424 days)
S38.0.20AnyAnyWhere exists performance 8.0.16 onwards
995932020-05-15
16:05
2021-10-01
13:05
MySQL Server: InnoDB storage engineClosed
(1403 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
(1367 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
(1357 days)
S58.0.20AnyARMImproving performance of 'row_mysql_store_col_in_innobase_format'
1004322020-08-05
7:55
2020-08-05
14:03
MySQL Server: Performance SchemaVerified
(1331 days)
S58.0.21AnyARMOptimal memory-barrier for performance-schema counter
1017172020-11-23
12:03
2020-12-15
12:53
MySQL Server: ReplicationVerified
(1203 days)
S28.0, 8.0.22AnyAnyPoor performance on a GTID slave when log_slave_updates is disabled
1017642020-11-26
0:38
2022-04-20
16:17
MySQL Server: Performance SchemaClosed
(787 days)
S38.0.20AnyAnyContribution by Facebook: Add CPU time to statement metrics
1022892021-01-19
6:06
2021-01-20
13:32
MySQL Server: InnoDB storage engineVerified
(1163 days)
S55.7, 8.0AnyAnybuf_flush_or_remove_pages causes large tps fluctuation with write-heavy workload
1037102021-05-15
14:26
2023-11-02
6:38
MySQL Server: OptimizerClosed
(1028 days)
S58.0.25Linuxx86Prepared statement performance slower with prefer_ordering_index optimization
1047792021-08-31
9:38
2021-08-31
10:02
MySQL Server: InnoDB storage engineVerified
(940 days)
S58.0.19AnyAnyno need to own sx-latch during the period of page flusing for BUF_FLUSH_LRU
1049672021-09-17
10:04
2021-11-19
19:40
MySQL Server: InnoDB storage engineClosed
(860 days)
S58.0.26 AnyAnyThe fuction buf_validate() affects performance seriously and can be optimized
1054902021-11-08
11:28
2022-01-26
8:45
MySQL Server: PartitionsVerified
(871 days)
S38.0.27AnyAnyEmpty loop brings loss to performance when pruning partitions for INSERT command
1070352022-04-15
9:12
2022-04-15
13:34
MySQL Server: OptimizerVerified
(713 days)
S58.0AnyAnyMRR may cause performance downgrade when multi-range on partition key
1085332022-09-19
12:04
2022-09-20
6:56
MySQL Server: Performance SchemaVerified
(555 days)
S38.0, 8.0.30AnyAnyNULL query text in performance schema after thread killed
1091552022-11-22
5:43
2023-12-13
11:44
MySQL Server: OptimizerVerified
(492 days)
S58.0.18, 8.0.31, 8.0.35AnyAnyInvalid scan on left join tables of which columns not in distinct output fields
1094172022-12-16
23:30
2022-12-17
15:30
MySQL Server: InnoDB storage engineVerified
(467 days)
S58.0.31AnyAnyBad performance by call btr_drop_ahi_for_table within dict sys_mutex protection
1095482023-01-09
7:55
2023-12-20
12:33
MySQL Server: DMLClosed
(99 days)
S58.0.13,8.0.31AnyAnyPoor performance when using HASH field to check unique
1096032023-01-12
12:06
2023-01-12
14:10
MySQL ServerDuplicate
(441 days)
S3AnyAnyMySQL8 write performance degrades compares to MySQL 5.7
1106442023-04-10
6:16
2023-04-13
9:56
MySQL Server: InnoDB storage engineVerified
(350 days)
S58.0LinuxARM (aarch64)innobase: optimize hash_uint64 with hardware crc on Arm
1109982023-05-11
15:33
2023-12-01
6:49
MySQL Server: OptimizerVerified
(316 days)
S58.0.20+, 8.0.33LinuxAnyPerformance regression with SELECT query when sorting on limited fields
1118682023-07-25
2:54
2024-03-21
11:18
MySQL ServerDuplicate
(247 days)
S5AnyAnybenchmarksql performance degradation since 8.0.27
1121982023-08-28
8:21
2024-03-05
6:06
MySQL Server: OptimizerVerified
(213 days)
S18.0, 8.0.34AnyAnyIncorrect multiple equality optimization causes performance degradation
1131782023-11-22
9:09
2024-02-19
11:23
MySQL Server: InnoDB storage engineClosed
(44 days)
S58.0, 8.0.35AnyAnyTemptable engine leads to performance degradation
1136472024-01-16
8:55
2024-03-07
20:37
MySQL Server: OptimizerClosed
(21 days)
S58.0.35,8.2.0AnyAnyidentical tables are checked in HashJoin because of no STOP_AT_MATERIALIZATION
181742006-03-13
0:29
2006-03-13
5:56
MySQL ServerDuplicate
(6590 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
(6524 days)
S35.0.20Windows (Windows XP)Anystored function call in primary select causes memory leak
277322007-04-10
13:18
2008-03-30
8:34
MySQL Server: OptimizerClosed
(5842 days)
S15.0.56,5.1.22Any (windows, linux)AnyPossible memory leak with index_merge
386262008-08-07
11:28
2008-08-07
12:36
MySQL Server: Prepared statementsDuplicate
(5712 days)
S35.0.66aAnyAnymemory leak with materialized cursor and prepared statement
403742008-10-28
17:32
2008-11-29
15:56
MySQL Server: DMLClosed
(5598 days)
S35.0.51aLinux (Debian Lenny amd64)AnyLOAD DATA with CONVERT_TZ causes memory leak
479612009-10-09
21:51
2011-02-16
23:44
MySQL Server: Information schemaVerified
(5284 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
685302013-02-28
21:32
2013-08-22
15:44
MySQL Server: MemcachedClosed
(3871 days)
S15.6.10 GALinux (Centos 5)Anymemory leak with innodb memcached plugin for stale connection
743712014-10-14
11:32
2014-10-31
15:18
MySQL Server: GISClosed
(3436 days)
S35.7.6AnyAnyValgrind: Memory leak when doing spatial operations on geometrycollections
800892016-01-21
1:58
2016-05-09
14:52
MySQL Server: OptionsClosed
(2880 days)
S35.6, 5.6.28LinuxAnyMemory leak from open files limit
803012016-02-08
11:23
2016-02-19
16:50
MySQL Server: InnoDB storage engineClosed
(2962 days)
S3AnyAnyleaksanitizer detects memory leaks in tde tests
807722016-03-17
1:34
2016-06-18
21:36
MySQL Server: InnoDB storage engineClosed
(2864 days)
S25.7.8+,8.0.0, 5.7.11, 5.7.13AnyAnyExcessive memory used in memory/innodb/os0file starting 5.7.8
823072016-07-21
13:41
2016-12-02
20:12
MySQL Server: TestsClosed
(2673 days)
S35.6,5.7, 5.7.13AnyAnyMemory leaks in unit tests
955022019-05-23
16:47
2019-05-23
16:52
MySQL Server: Performance SchemaClosed
(1771 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
1050282021-09-24
4:45
2021-09-24
5:29
MySQL Server: InnoDB storage engineVerified
(916 days)
S38.0.26AnyAnymemory leak caused by recv_sys->saved_recs during recovery
1054422021-11-03
13:05
2021-11-03
14:19
MySQL Server: OptionsVerified
(876 days)
S35.7AnyAnyContribution: Fix memory leak when host_cache_size is 0.
1105182023-03-27
23:53
2023-12-23
13:54
MySQL Server: Group ReplicationClosed
(96 days)
S3all, 8.0AnyAnyMemory leak possible
4162003-05-11
12:47
2003-05-28
4:18
MySQL ServerDuplicate
(7610 days)
S24.1.0-alphaWindows (Windows XP and NT)AnyServer slow if client not on localhost
4762003-05-22
2:51
2003-07-01
5:11
MySQL ServerClosed
(7576 days)
S33.23.56Linux (linux)Any"myisamchk -r" results in loss of index "repair table" restores index
33962004-04-05
16:57
2011-03-29
18:22
MySQL ServerClosed
(4748 days)
S24.1.1Linux (LINUX)AnyA SUB-QUERY IN MYSQL 4.1.1.max.log MAKE SERVER DOWN :_(
58792004-10-04
13:04
2019-11-14
14:00
MySQL ServerClosed
(7114 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
(7055 days)
S35.0.2Linux (linux)Anyignored character-set and collation
93472005-03-23
4:32
2005-03-24
3:16
MySQL ServerDuplicate
(6944 days)
S11.1.6Windows (Windows 2003 Server)AnyCrashes with MySQL server 5.0.2
85652005-02-17
11:50
2022-12-04
20:45
MySQL Server: DDLDuplicate
(4276 days)
S25.0.30Any (*)AnyALTER TABLE MODIFY adds duplicate keys which slow down SELECTs
478392009-10-05
17:52
2020-05-03
20:45
MySQL Server: OptimizerDuplicate
(5249 days)
S55.1.39AnyAnyUNIX_TIMESTAMP() is not treated as a const
201132006-05-28
15:51
2016-01-03
20:45
MySQL Server: InnoDB storage engineDuplicate
(6511 days)
S55.0.21Linux (Fedora Core5)AnyPerformance degredation on 8 way system ( 4x Opteron 875's )
475292009-09-22
22:15
2022-12-04
20:45
MySQL Server: Query CacheDuplicate
(4858 days)
S55.1.38, 5.1.39AnyAnyquery cache performance is bad on multi-core servers
556062010-07-28
15:25
2015-08-30
17:21
MySQL Server: CharsetsVerified
(3976 days)
S55.1.47, 5.1.50-bzr, 5.5.23, 5.6.11LinuxAnyCharset on ENUMS influencing performance too much
366132008-05-09
5:33
2016-01-03
20:45
MySQL Server: InnoDB storage engineDuplicate
(5784 days)
S25.1.24AnyAnyCreating many tables with many columns in innodb leads to out of memory
485422009-11-04
18:43
2016-10-16
20:45
MySQL Server: ReplicationDuplicate
(5130 days)
S35.1.39, 5.1.40, 5.1.41AnyAnyImplicit drops on temporary tables aren't always replicated to slaves
728852014-06-05
7:50
2018-08-26
20:45
MySQL Server: ReplicationDuplicate
(3284 days)
S15.6.17Linux (Red Hat Enterprise Linux Server release 6.3)AnyMySQL 5.6 memory leak
24202004-01-16
1:58
2012-05-18
20:19
MySQL Server: MyISAM storage engineDuplicate
(7375 days)
S24.1.2-dev latestLinux (Linux 2.4.21)AnyFulltext index corrups table
81392005-01-26
7:49
2012-05-18
20:19
MySQL Server: OptimizerDuplicate
(5625 days)
S34.1.8Linux (Linux)Anysubselect index not used for "in" but used for "="
269672007-03-08
18:00
2014-12-21
11:15
MySQL Server: GeneralVerified
(6226 days)
S35.0.37Any (all)AnySHOW PROFILE: Inconsistent output capitalization
300902007-07-27
6:23
2012-05-18
20:19
MySQL Server: Memory storage engineDuplicate
(5959 days)
S35.0.44AnyAnyDELETE from MEMORY table with BTREE primary key extremely slow
354142008-03-18
19:16
2012-08-08
11:01
MySQL Server: GISDuplicate
(4250 days)
S35.0.51 and 5.0.51aOther (Linux / Solaris)AnyMBRContains fails to select records when using index
375782008-06-23
7:00
2016-10-16
20:45
MySQL Server: ReplicationVerified
(5755 days)
S35.1, 5.0, 6.0AnyAnyExecute Stored Functions Without Prelocks
387202008-08-11
14:07
2018-01-18
13:11
MySQL Server: CharsetsClosed
(2261 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.
649242012-04-10
9:03
2015-03-15
20:45
MySQL Server: Query CacheDuplicate
(4339 days)
S35.1.61Linux (2.6.32-5-amd64 #1 SMP)AnyCacheing long SELECT statement does too many prunes
651772012-05-02
9:43
2020-05-03
20:45
MySQL Server: OptimizerVerified
(4343 days)
S55.1,5.5AnyAnyperromance issue of "order by rand()"
271992007-03-16
5:03
2013-09-09
9:28
MySQL Server: OptimizerClosed
(3853 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
290312007-06-11
21:42
2020-05-03
20:45
MySQL ServerDuplicate
(6099 days)
S25.0.44-BK, 5.0.42LinuxAnyComparison of DATE with DATETIME not using indexes correctly
479722009-10-10
21:36
2023-02-12
20:45
MySQL Server: ReplicationDuplicate
(4627 days)
S25.1.40AnyAnyChange in MBR algorithm causes replication performance degradation
522242010-03-19
15:17
2016-10-16
20:45
MySQL Server: ReplicationVerified
(5120 days)
S3AnyAnyreplication of CREATE TEMPOARARY TABLE should be optional
528062010-04-14
6:32
2022-01-26
12:34
MySQL Server: InnoDB Plugin storage engineClosed
(792 days)
S55.1AnyAnyMake InnoDB mutexes green
587662010-12-06
22:48
2014-01-29
0:51
MySQL ServerClosed
(3711 days)
S25.5.8Any (Linux)AnyServer binary was compiled without fast-mutexes
601282011-02-15
7:22
2018-09-23
20:45
MySQL Server: InnoDB storage enginePatch queued
(4790 days)
S3AnyAnyAdd performance schema instrumentation on os_fast_mutex
591432010-12-24
0:13
2017-05-14
20:45
MySQL Server: InnoDB Plugin storage engineDuplicate
(4815 days)
S25.1.52, 5.5, 5.6AnyAnyvalgrind leak warning from innodb_plugin.innodb-index for mysql 5.1.52
164932006-01-13
19:21
2012-05-18
20:19
MySQL ServerDuplicate
(6484 days)
S35.0.19-BKprobably allAnySlow query log logs SHOW statements
201982006-06-01
12:39
2016-10-16
20:45
MySQL Server: Row Based Replication ( RBR )Duplicate
(6508 days)
S35.1 source AnyRBR injector is too slow
266972007-02-27
21:53
2013-03-03
20:45
MySQL Server: Federated storage engineVerified
(6223 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.
224872006-09-19
17:57
2020-05-03
20:45
MySQL Server: DDLVerified
(6224 days)
S55.0.26AnyAnymysql performs extremely slow when creating unique indexes on huge table
26152004-02-02
11:03
2012-05-18
20:19
MySQL Server: MyISAM storage engineDuplicate
(6189 days)
S24.1Linux (Red Hat 9.0)AnyPerformance problem when joining NULLs
563322010-08-27
18:17
2013-07-07
11:39
MySQL Server: InnoDB storage engineClosed
(3917 days)
S35.0.87, 5.0.91AnyAnyPerformance regression in DROP TABLE performance post 5.0.77
234102006-10-18
7:47
2012-05-18
20:19
MySQL Server: OptimizerDuplicate
(6225 days)
S55.0.26Any (*)Any"select * from... where .. order by" very slow when 0 rows match the where cond
274922007-03-28
9:05
2017-05-21
20:45
MySQL Server: ReplicationDuplicate
(5635 days)
S35.0.40-BK, 5.0.37AnyAnyReplication queries are not logged in slow query log
399902008-10-12
16:19
2022-09-04
20:45
MySQL Server: Information schemaDuplicate
(5645 days)
S35.1.23, 5.1.28AnyAnypoor performace of "SHOW VARIABLES"
214612006-08-06
1:28
2007-07-13
0:37
MySQL Server: Archive storage engineClosed
(6103 days)
S55.0Any (all)AnyLong Varchars created unneeded waste in compression in Archive
292782007-06-21
18:51
2012-05-18
20:19
MySQL ServerDuplicate
(6092 days)
S3AnyAnylog-output should default to FILE for backwards compliance.
1069392022-04-07
2:51
2022-05-13
10:28
MySQL Server: Performance SchemaClosed
(685 days)
S35.7.18AnyAnyTRUNCATE performance_schema.accounts causes duplicated counts in global_status
303332007-08-09
14:47
2007-10-09
17:01
MySQL Server: ParserClosed
(6015 days)
S54.0, 4.1, 5.0, 5.1AnyAnyPerformance, expressions lists in the parser
440162009-04-01
17:14
2011-02-16
23:43
MySQL Server: Performance SchemaClosed
(5187 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
(5187 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
(5136 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
(5187 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
(5187 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
(5187 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
(5187 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
(5187 days)
S3mysql-trunk-perfschemaAnyAnyPerformance schema: unit test failures
512952010-02-18
20:27
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(5132 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
(5136 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
(4985 days)
S1mysql-trunk (5.5.3)AnyAnyPerformance schema does not start with large mutex_instance buffers
563242010-08-27
11:06
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(4893 days)
S3next-mr, next-mr-bugfixingAnyAnyRace Condition while shutting down MySQL: "PSI_server"
565232010-09-03
1:12
2011-02-16
23:44
MySQL Server: MyISAM storage engineClosed
(4877 days)
S25.6AnyAnyInstrumentation regression in myisam/mi_rprev.c
571062010-09-29
16:04
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(4856 days)
S35.6AnyAnyRobustness of memcpy calls in the performance schema
597402011-01-26
14:07
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(4795 days)
S35.6FreeBSDAnyPerformance schema test failures on freebsd
693822013-06-02
19:42
2013-07-09
14:16
MySQL Server: Performance SchemaClosed
(3915 days)
S35.6.11AnyAnyPerformance schema, degradation under stress when internal buffers are full
306252007-08-24
15:28
2007-10-09
17:05
MySQL Server: ParserClosed
(6015 days)
S55.0, 5.1AnyAnyPerformance, reduce depth for expressions
547822010-06-24
15:31
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(4985 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
(4991 days)
S5AnyAnyPerformance schema: optimization of the instrumentation interface
554162010-07-20
21:17
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(4948 days)
S1AnyAnyRenaming of performance_schema tables in 5.5
554622010-07-21
23:22
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(4969 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
(4633 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
(4795 days)
S35.5.6AnyAnyhandler statistics for the performance schema engine
700282013-08-14
8:08
2013-10-01
16:39
MySQL Server: Performance SchemaClosed
(3831 days)
S25.6.13Linux (Oracle Linux 6)AnyP_S threads.INSTRUMENTED not set according to setup_actors
710412013-11-29
18:39
2017-09-05
1:11
MySQL ServerClosed
(2396 days)
S35.6AnyAnyPlease, document every instrument in P_S.setup_instruments in details
712782014-01-02
17:22
2014-02-17
18:07
MySQL Server: Performance SchemaClosed
(3692 days)
S35.6AnyAnyNUMBER OF ROWS IN PERFORMANCE SCHEMA TABLES
731122014-06-25
11:47
2016-02-23
15:52
MySQL Server: Performance SchemaVerified
(2956 days)
S35.6.16, 5.6.17, 5.6.20LinuxAnyPerformance Schema - Statement Tables - Stored Procedures Counters are 0
797842015-12-28
6:50
2016-01-21
15:06
MySQL Server: Performance SchemaClosed
(2989 days)
S35.6.24 5.7.10AnyAnyupdate setup_instruments do not affect the global mutex/rwlock/cond
976002019-11-12
20:05
2019-11-26
3:43
MySQL Server: Performance SchemaClosed
(1584 days)
S38.0.17AnyAnyPerfschema socket stats are not captured for SSL connections
307122007-08-30
0:00
2007-10-09
0:43
MySQL Server: LoggingClosed
(6015 days)
S25.1AnyAnyopen_performance_schema_table() cause an open table leak on failures
680092013-01-02
9:22
2022-11-05
12:45
MySQL Server: Performance SchemaDuplicate
(4095 days)
S25.5.28, 5.5.29AnyAnyFloating point exception in "insert_events_waits_history_long"
685742013-03-05
13:42
2021-08-13
10:40
MySQL Server: InnoDB storage engineClosed
(958 days)
S35.5.30, 5.6.16Windows (win7 sp1 ent)AnyNo instrumentation for InnoDB files in P_S on windows
700182013-08-13
19:42
2013-10-07
18:18
MySQL Server: Performance SchemaClosed
(3825 days)
S55.6 / 5.7AnyAnyPFS Overhead on frequent connect/disconnect
712982014-01-05
12:31
2014-03-29
18:21
MySQL Server: Performance SchemaClosed
(3702 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
(2248 days)
S35.5, 5.6, 5.7AnyAnyRemove the TICK timer in performance_schema
757652015-02-04
15:17
2015-03-10
13:30
MySQL Server: Performance SchemaClosed
(3306 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
(3100 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
(3148 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
(3038 days)
S35.6, 5.7AnyAnyProvide non-Windows implementations for LF_BACKOFF
826632016-08-20
5:12
2017-06-27
7:40
MySQL Server: Performance SchemaVerified
(2771 days)
S15.7.13, 5.7.14AnyAnymysqld hangs when accessing Performance Schema tables
1006242020-08-24
15:05
2021-02-03
17:46
MySQL Server: Performance SchemaClosed
(1149 days)
S35.7.30, 8.0.21, 5.7.31AnyAnyTotal memory allocation for P_S is different in different sources
1010182020-10-01
9:28
2020-10-09
15:44
MySQL Server: Performance SchemaClosed
(1266 days)
S58.0AnyAnyHigh contention on last_value in my_timer_microseconds
1046432021-08-17
14:11
2021-10-06
16:24
MySQL Server: Performance SchemaClosed
(904 days)
S38.0.26AnyAnyDefaults in performance schema tables incompatible with sql_mode
1087502022-10-12
10:08
2022-10-14
15:56
MySQL Server: Performance SchemaClosed
(531 days)
S38.0.26AnyAnyTABLE ACCESS SERVICE INDEX READ MAP ISSUES
783032015-09-02
10:02
2016-09-22
7:50
MySQL Server: Performance SchemaVerified
(3130 days)
S35.7AnyAnyAdd some DNS latency timings to performance_schema (host_cache?)
893792018-01-24
11:41
2022-03-31
8:21
MySQL Server: Performance SchemaVerified
(2255 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
(4985 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
(3821 days)
S35.6.11WindowsAny--performance_schema_instrument value quoting is problematic
514472010-02-24
7:08
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(5125 days)
S2mysql-5.5.99 (Celosia)AnyAnyperformance schema evil twin files
299212007-07-20
3:39
2008-03-04
22:29
MySQL Server: ParserClosed
(5868 days)
S55.0.37AnyAnyMYSQLparse uses 3X more CPU in MySQL 5.0 than yyparse in MySQL 4.0
778632015-07-28
19:00
2015-07-30
13:05
MySQL Server: Performance SchemaClosed
(3164 days)
S55.6.26AnyAnyslowdown caused by memset in sql_digest_storage.reset()
302372007-08-03
22:10
2007-10-09
17:07
MySQL Server: ParserClosed
(6015 days)
S55.0AnyAnyPerformance regression in boolean expressions
536962010-05-17
11:07
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(4837 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
(3817 days)
S35.6.14AnyAnyRead/Write mutexes on Binlog delegate classes are not counted on perf schema
779442015-08-05
7:11
2015-08-21
18:43
MySQL Server: Performance SchemaClosed
(3142 days)
S35.7.8-rc, 5.7.9LinuxAnyperformance_schema_instrument='%=OFF', not disable all instruments
1013912020-10-30
3:04
2020-11-19
16:59
MySQL Server: Performance SchemaVerified
(1225 days)
S58.0, 8.0.22AnyAnyPerformance Schema storage engine doesn't use index optimizations on group by
375362008-06-19
22:34
2011-02-16
23:43
MySQL ServerClosed
(5033 days)
S55.1.24Solaris (Nevada Bld 87 on X86)AnyThread scheduling causes performance degradation at low thread count
421582009-01-16
13:48
2011-02-16
23:43
MySQL Server: GeneralClosed
(5390 days)
S24.1, 5.0, 5.1, 6.0AnyAnyleak: SSL_get_peer_certificate() doesn't have matching X509_free()
494912009-12-06
23:14
2011-02-16
23:44
MySQL Server: GeneralClosed
(5130 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
(4682 days)
S35.1.47AnyAnyUse of non-blocking mode for sockets limits performance
417402008-12-25
8:51
2011-08-16
1:21
MySQL Server: OptimizerClosed
(4608 days)
S55.1.25,5.1.30AnyAnyMySQL 5.1 optimizer produces inefficient plan for complex queries
591102010-12-22
9:49
2011-03-02
3:21
MySQL Server: OptimizerClosed
(4775 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
(4777 days)
S25.6.99, 5.5, 5.1 ->AnyAnyIncorrect result for SELECT DISTINCT <col>... ORDER BY <col> DESC
459922009-07-07
8:15
2011-02-16
23:44
MySQL Server: InnoDB storage engineClosed
(5030 days)
S35.4.2-debugLinux (32-bit fc8)Anyinnodb memory not freed after shutdown
466562009-08-11
16:13
2011-02-16
23:44
MySQL Server: InnoDB Plugin storage engineClosed
(5031 days)
S35.1Linux (64bit)AnyInnoDB plugin: memory leaks (Valgrind)
421012009-01-14
9:27
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(5030 days)
S35.1AnyAnyRace condition in innodb_commit_concurrency
165042006-01-14
13:53
2006-06-02
21:48
MySQL ServerClosed
(6509 days)
S35.0.21Any (*)AnySome of the simplest SELECTs are 1000 times slower in v5 compared to v4
195792006-05-06
10:59
2006-10-23
14:10
MySQL Server: OptimizerClosed
(6366 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.
16972003-10-29
3:45
2003-12-13
3:36
MySQL ServerClosed
(7411 days)
S24.0.16Any (all)AnyDELETE ... WHERE ... ORDER BY ... wrong execution leads to very bad performance
171642006-02-06
18:29
2006-04-14
18:39
MySQL Server: OptimizerClosed
(6558 days)
S25.0.19-BK, 5.0.18Linux (Linux)AnyLEFT JOIN with OR clause not optimized correctly
100312005-04-20
14:11
2005-06-29
20:24
MySQL ServerClosed
(6847 days)
S15.0.5Any (all)AnyView doesn't use index
90172005-03-07
11:02
2005-04-28
15:48
MySQL Server: OptimizerClosed
(6909 days)
S24.1.10Windows (WinXP SP2, Linux 2.4.22)AnyRows are omitted from result set when using JOIN, XOR and ISNULL
240352006-11-07
8:57
2007-02-27
20:23
MySQL Server: OptimizerClosed
(6239 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
338332008-01-12
15:31
2008-04-02
17:22
MySQL Server: OptimizerClosed
(5839 days)
S25.0-bk, 5.1-bkAnyAnyNo rows are returned, even though query matches
556812010-08-02
10:43
2011-02-16
23:44
MySQL Server: InnoDB storage engineClosed
(4853 days)
S2trunkAnyAnyMTR slowdown after default storage engine was changed to InnoDB
545632010-06-16
19:19
2011-02-16
23:44
MySQL Server: InnoDB storage engineClosed
(5033 days)
S35.5.5preAnyAnyInnoDB: Performance drop in varios sysbench tests
579812010-11-04
14:57
2012-02-13
3:42
MySQL Server: InnoDB storage engineClosed
(4427 days)
S35.5.7-m3SolarisAnyUNIV_DEBUG causes big performance degradation for some operations on Solaris
545382010-06-16
1:23
2011-02-16
23:44
MySQL Server: InnoDB Plugin storage engineClosed
(4853 days)
S35.1.47AnyAnyuse of exclusive innodb dictionary lock limits performance
535722010-05-11
16:09
2011-02-16
23:44
MySQL Server: InnoDB Plugin storage engineClosed
(5026 days)
S11.1.0AnyAnyslow shutdown does not wait for the purge thread to purge everything
596832011-01-23
21:58
2012-02-13
3:40
MySQL Server: InnoDB storage engineClosed
(4427 days)
S35.5+AnyAnyInnoDB latch deadlock detector/violation debug code is very slow
158152005-12-16
23:18
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(5031 days)
S24.0.27,4.1, 5.0, 5.1Linux (Linux x86_64)AnyVery poor performance with multiple queries running concurrently
491692009-11-27
16:09
2013-02-28
13:27
MySQL Server: InnoDB Plugin storage engineClosed
(4046 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
(5013 days)
S25.5.4/iplugin1.1AnyAnyInnoDB: performance regression in sysbench OLTP_RW test
272872007-03-20
12:29
2018-04-03
2:35
MySQL Server: XML functionsClosed
(5966 days)
S55.1.16Windows (WinXP SP2)Anyextractvalue() (and updatexml()) extremely slow for large XML
451082009-05-26
21:26
2011-02-16
23:44
MySQL Server: ReplicationClosed
(5390 days)
S36.0.11AnyAnySlave skip counter not working as expected on debian platform
688272013-04-01
18:47
2013-04-24
8:37
MySQL Server: WindowsVerified
(3991 days)
S25.6.11Windows (window7 64bit)Anymultiple connections using Shared Memory interfering
151322005-11-22
12:55
2005-11-22
14:20
MySQL Server: ReplicationClosed
(6701 days)
S35.0-wl1012Linux (linux)AnyRBR: memory leak when updating large rows
1912003-03-25
14:24
2003-04-18
13:56
MySQL Server: ReplicationClosed
(7650 days)
S33.23Linux (Linux at least)AnyMany connections from the slave to the master cause "alarm queue is full"
197982006-05-14
0:16
2006-05-23
8:02
MySQL ServerClosed
(6519 days)
S25.1.10-preLinux (Red Hat RHAS4 x86 x86_64)AnyTest 'func_encrypt' leaks memory when using yaSSL
488322009-11-17
11:00
2011-02-16
23:44
MySQL Server: LockingClosed
(5088 days)
S55.0+AnyAnyDisconnection is slow when using non-persistent mysql connections
173682006-02-14
10:04
2006-05-04
15:49
MySQL ServerClosed
(6538 days)
S25.1.6/5.1.7 BKWindows (Windows XP)AnyGeneral log and slow query log don't work
287422007-05-29
10:30
2007-06-22
18:42
MySQL Server: TestsClosed
(6124 days)
S35.1-BKLinux (Fedora Core 6)Anymysql-test-run is very slow on "Stopping All Servers" step
229432006-10-03
15:10
2007-02-21
3:26
MySQL ServerClosed
(6245 days)
S2allWindows (Windows)Anysyscall pruning in libmysql
471262009-09-04
9:18
2011-02-16
23:44
MySQL ServerClosed
(5135 days)
S35.1AnyAnyequal flag values causing unexpected behaviour
406342008-11-11
11:30
2011-02-16
23:43
MySQL Server: MyISAM storage engineClosed
(5484 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
(7519 days)
S3 Anyslow indexes in 4.0.13 vs. 3.23
265272007-02-21
14:49
2007-10-29
18:41
MySQL Server: PartitionsClosed
(5995 days)
S55.1.14-logLinux (Ubuntu 6.10 x86_64/Windows)AnyLOAD DATA INFILE extremely slow with partitioned table
296872007-07-10
10:09
2007-07-23
0:47
MySQL Server: Prepared statementsClosed
(6093 days)
S15.1.17, 5.1.20AnyAnymysql_stmt_store_result memory leak in libmysqld
232252006-10-12
18:20
2007-03-08
3:16
MySQL Server: LoggingClosed
(6230 days)
S35.1 bkLinux (Linux)AnySlow query log: settiing slow_query_log_file writes to wrong file
210512006-07-13
23:07
2006-08-31
19:29
MySQL ServerClosed
(6419 days)
S35.0.22 AnyRESET QUERY CACHE very slow when query_cache_type=0
178942006-03-03
12:00
2006-03-15
12:52
MySQL Server: PartitionsClosed
(6588 days)
S15.1.7Linux (Linux, Windows)AnyComparison with "less than" operator fails with Range partition
7962003-07-06
7:35
2003-07-06
12:36
MySQL ServerClosed
(7571 days)
S34.1Any (any)Anymemory leak in group_concat
59692004-10-08
5:49
2004-10-10
10:52
MySQL ServerClosed
(7109 days)
S15.0.2Linux (Linux)AnyPerformance Problem with updatable VIEW
112472005-06-10
15:14
2005-08-18
21:01
MySQL ServerClosed
(6797 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
(6758 days)
S25.0.14-rc, tadays pullLinux (Linux)AnyMemory leak in ha_tina
424122009-01-28
10:53
2011-02-16
23:43
MySQL Server: GeneralClosed
(5322 days)
S36.0,5.4AnyAnyIPv6 connection handling code bugs
253962007-01-03
20:26
2007-01-24
20:28
MySQL ServerClosed
(6273 days)
S15.1 AnyValgrind leak in closecon_handlerton
463762009-07-24
17:05
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5356 days)
S55.0.85, 5.1.36, 5.1.38, 5.1.39Windows (XP)AnyOptimizer choose wrong index even when where clause and order-by are covered
502122010-01-10
14:07
2011-02-28
8:36
MySQL Server: OptimizerClosed
(4777 days)
S55.1.37, 5.1.42, 5.1.43-bzrAnyAnyMySQL doesn't use Primary Index for ORDER BY
591112010-12-22
10:40
2011-02-16
23:44
MySQL Server: GISClosed
(4796 days)
S35.6+AnyAnygis crashes when server is compiled without performance schema
480602009-10-14
21:20
2011-02-16
23:44
MySQL Server: OptimizerClosed
(5245 days)
S35.5, 6.0-codebaseAnyAnyMemory leak - Item::val_bool() (item.cc:184) from optimizer_subquery grammar
574802010-10-15
11:19
2014-09-13
16:19
MySQL Server: InnoDB storage engineClosed
(4466 days)
S25.1, 5.0AnyAnyMemory leak when having 256+ tables
589742010-12-16
13:43
2011-02-16
23:44
MySQL Server: InnoDB storage engineClosed
(4817 days)
S5mysql-5.5-innodbAnyAnyha_innobase:info() tries to lock some latches even if HA_STATUS_NO_LOCK is given
783152015-09-03
10:15
2016-02-04
16:23
MySQL Server: Performance SchemaClosed
(3129 days)
S35.7.9AnyAnyDefault value of two options in perf schema is not updated in 5.7
233352006-10-16
14:16
2007-09-05
20:45
MySQL Server: ReplicationClosed
(6049 days)
S25.1.12Linux (Linux 32 Bit)AnyInnoDB hangs if BLOBS and BINLOG are used during new performance test
1025992021-02-15
12:11
2023-12-19
10:19
MySQL Server: GISVerified
(1136 days)
S58.0.22Windows (Win 10)x86 (NVMe RAM)Slow performance of MySQL 8 compared with 5.7 on geographical SELECT
252222006-12-20
19:15
2007-03-13
19:10
MySQL Server: GeneralClosed
(6225 days)
S35.0Windows (windows)AnyWin32 HANDLE leak in my_sopen()
186692006-03-30
22:22
2006-05-31
1:18
MySQL ServerClosed
(6511 days)
S35.0,5.1Linux (Linux)AnySession COM_STATISTICS breaks mysqladmin status
147802005-11-09
8:44
2005-12-09
0:23
MySQL ServerClosed
(6684 days)
S34.1Linux (linux)Anymemory leak for mysql 4.1.14 with openssl enabled
389182008-08-20
15:44
2008-11-13
3:29
MySQL Server: Information schemaClosed
(5614 days)
S35.1.26,6.0.6AnyAnyselecting from information_schema.columns is disproportionately slow
195882006-05-06
23:47
2020-08-25
11:03
MySQL Server: Information schemaClosed
(5951 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
(5537 days)
S35.1AnyAnydisabled storage engines omitted in SHOW ENGINES
33412004-03-30
21:47
2004-05-10
10:46
MySQL ServerClosed
(7262 days)
S33.23.58; 4.0.18FreeBSD (Free BSD, Windows)AnyNot Optimized Min()
38352004-05-20
10:51
2004-05-24
11:03
MySQL Server: MyISAM storage engineClosed
(7248 days)
S14.1.2Windows (Win 2000/XP)Anyalter table enable/disable keys corrupts database
66352004-11-15
12:47
2005-03-08
18:36
MySQL ServerClosed
(6960 days)
S24.1.7Linux (Linux x86)Anybug in full-text search
276342007-04-04
5:36
2007-06-15
13:45
MySQL Server: TestsClosed
(6131 days)
S35.1-bkLinuxAnygroup_by test fails
507742010-02-01
2:23
2011-05-13
14:21
MySQL Server: DMLClosed
(4703 days)
S15.1.44, 5.1.49, 5.5.99, 5.5.6rcAnyAnyWrong resultset when timestamp values are appended with .0
664732012-08-21
1:49
2016-08-04
0:38
MySQL Server: LockingClosed
(4049 days)
S55.6.6-m9AnyAnyMySQL 5.6.6-m9 has more mutex contention than MySQL 5.1
598612011-02-01
1:50
2011-03-07
23:18
MySQL Server: LoggingClosed
(4770 days)
S35.1, 5.5, trunkAnyAnywhy does log_slow_statement call thd_proc_info twice?
264892007-02-20
6:14
2022-05-20
12:03
MySQL Server: ReplicationClosed
(5895 days)
S25.0.27 & 5.0.37, 5.1.22Any (Linux, Win32)AnyCorruption in relay logs
358432008-04-04
19:56
2008-10-17
17:23
MySQL Server: Row Based Replication ( RBR )Closed
(5641 days)
S35.1.23AnyAnySlow replication slave when using partitioned myisam table
566492010-09-08
13:56
2011-02-16
23:44
MySQL Server: ReplicationClosed
(4853 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
(4853 days)
S2trunk, 5.6AnyAnyValgrind warnings for memory leak in semisync plugin (MYSQL object not freed)
100642005-04-21
15:39
2007-11-09
9:27
MySQL ServerClosed
(5984 days)
S13.1Linux (RedHat 4)Anyudf deinit not called when using PreparedStatements
429302009-02-17
11:44
2012-10-05
16:42
MySQL Server: LockingClosed
(4192 days)
S55.0, 5.1, 6.0AnyAny'show global status' causes lock contention on LOCK_thread_count
161752006-01-04
7:43
2006-03-02
15:13
MySQL Server: ReplicationClosed
(6601 days)
S35.0 Anymemory leak in rpl_trigger.test
372522008-06-06
19:56
2015-02-06
19:01
MySQL Server: PartitionsClosed
(4306 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
(5213 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
(5032 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
(4810 days)
S25.1.50AnyAnyvalgrind memory leak warning from partition tests
358452008-04-04
20:08
2011-02-16
23:43
MySQL Server: PartitionsClosed
(5213 days)
S55.1.23AnyAnyunneccesary call to ha_start_bulk_insert for not used partitions
524552010-03-30
1:54
2011-02-16
23:44
MySQL Server: PartitionsClosed
(4914 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
(4914 days)
S35.1.45AnyAnyRegression in ROW level replication performance with partitions
572752010-10-06
8:53
2011-02-16
23:44
MySQL Server: ReplicationClosed
(4831 days)
S35.5, next-mrAnyAnybinlog_cache_size affects trx- and stmt-cache and gets twice the expected memory
403372008-10-27
3:05
2011-02-16
23:43
MySQL Server: ReplicationClosed
(5250 days)
S55.0, 5.1, 6.0AnyAnyFsyncing master and relay log to disk after every event is too slow
288082007-05-31
14:00
2007-07-10
22:14
MySQL Server: LoggingClosed
(6106 days)
S35.0.44-BK, 5.0.40, 5.0.34, 5.0.24aLinuxAnylog_queries_not_using_indexes variable dynamic change is ignored
408752008-11-20
7:10
2011-02-16
23:43
MySQL Server: Federated storage engineClosed
(5594 days)
S25.0AnyAnyMemory leak in FEDERATED handler
563822010-08-30
19:11
2011-02-16
23:44
MySQL ServerClosed
(4915 days)
S25.1.50AnyAnyvalgrind leak warning from main.loaddata
196902006-05-10
16:13
2007-02-21
3:17
MySQL Server: OptimizerClosed
(6245 days)
S24.1.19/4.1BKLinux (Gentoo Linux)AnyORDER BY eliminates rows from the result
182802006-03-16
13:27
2006-03-18
18:03
MySQL Server: ReplicationClosed
(6585 days)
S35.1.8Any (ALL)AnyRBR: Extreneous table maps when writing to slow_log and general_log
391062008-08-28
20:09
2011-02-16
23:43
MySQL Server: Row Based Replication ( RBR )Closed
(5640 days)
S35.1AnyAnySUPER is not required to change binlog format for session
427572009-02-11
12:01
2011-02-16
23:43
MySQL Server: ReplicationClosed
(5155 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
(3725 days)
S55.0AnyAnySimple performance changes for replication
172122006-02-07
23:09
2007-04-24
16:40
MySQL Server: OptimizerClosed
(6183 days)
S14.1.18, 5.0.18, 4.0.26Linux (linux)Anyresults not sorted correctly by ORDER BY when using index
198362006-05-16
2:03
2012-05-18
20:19
MySQL ServerDuplicate
(6314 days)
S2allAny (all)AnyDependent subquery in on clause is not optimized effectively.
300002007-07-24
8:11
2007-08-03
2:23
MySQL Server: LoggingClosed
(6082 days)
S35.1.20LinuxAnySHOW commands once again ends up in the slow query log
388892008-08-19
11:14
2011-02-16
23:43
MySQL Server: LoggingDuplicate
(5593 days)
S36.0.7-alpha-debugLinux (suse-linux-gnu on i686)AnyAssignment of a variable to "slow_query_log_file" failed.
211742006-07-20
6:17
2007-04-12
21:24
MySQL Server: OptimizerClosed
(6195 days)
S25.0.18, 5.1bkLinux (linux)AnyIndex degrades sort performance and optimizer does not honor IGNORE INDEX
382132008-07-17
20:46
2011-02-16
23:43
MySQL Server: OptimizerClosed
(5104 days)
S35.1.23-rcAnyAnyMySQL does not seem to execute select count (distinct) efficiently
275312007-03-29
18:00
2016-02-25
12:24
MySQL Server: OptimizerClosed
(6166 days)
S24.1.22 5.0AnyAnyQuery performance degredation in 4.1.22 and greater
217982006-08-23
17:36
2006-10-25
19:21
MySQL Server: GeneralClosed
(6364 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
459622009-07-06
8:39
2011-02-16
23:44
MySQL Server: DMLClosed
(5307 days)
S25.0.84, 5.1.37, 6.0.12AnyAnymemory leak after 'sort aborted' errors
512082010-02-16
14:29
2018-04-12
9:57
MySQL Server: Information schemaClosed
(4877 days)
S35.1AnyAnyExtra string allocation from thd->mem_root in sql_show.cc, find_files()
146372005-11-04
12:51
2011-02-16
23:43
MySQL ServerClosed
(5136 days)
S55.0-BKAny (any)Anytrim trailing spaces processes data only byte wise
218492006-08-26
10:07
2011-02-16
23:43
MySQL Server: OptimizerClosed
(5104 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.
526292010-04-06
18:54
2011-02-16
23:44
MySQL Server: GeneralClosed
(5032 days)
S35.1.45, 5.1 bzrAnyAnymemory leak from sys_var_thd_dbug in binlog.binlog_write_error
353962008-03-18
14:15
2011-12-01
20:37
MySQL Server: LoggingClosed
(4501 days)
S35.0.50sp1a, 5.0 bzrAnyAnyAbnormal / impossible / large Query_time and Lock_time values in slow query log
241692006-11-10
7:41
2007-02-28
7:26
MySQL ServerClosed
(6238 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)
160812005-12-30
0:19
2011-06-16
16:21
MySQL Server: OptimizerClosed
(4669 days)
S55.0.19-BK, 5.0.15Linux (LINUX)AnySLOW SELECT
433832009-03-04
16:43
2011-02-16
23:43
MySQL Server: TestsClosed
(5440 days)
S35.0,5.1,6.0AnyAnymain.variables-big : Weak testing code and result
598602011-02-01
1:28
2013-02-22
3:49
MySQL Server: OptionsClosed
(4052 days)
S35.1, 5.5, trunkAnyAnylog-slow-admin-statements and log-slow-slave-statements not displayed
19522003-11-25
13:49
2003-12-11
17:26
MySQL ServerClosed
(7413 days)
S3AnyAny (Any)AnySHOW TABLE STATUS very slow w/large number of tables
522892010-03-23
2:04
2011-02-16
23:44
MySQL Server: LockingClosed
(5005 days)
S25.5.3pre/5.5.4preAnyAnyperformance regression for MyISAM in sysbench OLTP_RW test
20502003-12-08
16:07
2004-07-09
20:54
MySQL ServerClosed
(7202 days)
S24.1.1alphaWindows (w2k)Any10 to 1 performance drop with server 4.1.1
438182009-03-24
4:05
2011-02-27
3:11
MySQL Server: Information schemaClosed
(4778 days)
S55.1.32Any (MS Windows, Linux)AnyLOJ on I_S too slow
680462013-01-07
9:29
2013-02-08
8:49
MySQL Server: OptimizerClosed
(4083 days)
S25.6-rc9Any (Ubuntu 12.04)AnyIN() clause with many constant values does not perform
674322012-10-31
5:46
2012-12-11
1:49
MySQL Server: OptimizerClosed
(4125 days)
S55.6.7AnyAnySerious performance degradation for the query with ORDER BY ... LIMIT n
700212013-08-13
20:52
2013-10-03
13:38
MySQL Server: OptimizerClosed
(3829 days)
S55.6.13AnyAnyPoor execution of a plan with unnecessary "range checked for each record"
545182010-06-15
14:25
2012-10-15
13:31
MySQL ServerClosed
(4182 days)
S55.0.22Windows (Vista)AnyVery bad performance with subselect
688252013-04-01
16:28
2018-07-11
15:09
MySQL Server: OptimizerVerified
(3131 days)
S55.6.10AnyAnyperformance regressions for single-threaded workloads
179522006-03-06
5:22
2012-10-15
13:48
MySQL Server: OptimizerClosed
(4182 days)
S54.1.18Linux (Linux)Anynested query super slow..should not be
247702006-12-02
0:37
2018-09-09
20:45
MySQL Server: OptimizerIn progress
(4756 days)
S55.1Any (all)Anyupdate with subquery slow
350772008-03-05
12:13
2011-02-16
23:43
MySQL Server: InnoDB Plugin storage engineClosed
(5031 days)
S35.1.42AnyAnyVery slow DROP TABLE (ALTER TABLE, OPTIMIZE TABLE) on compressed tables
547282010-06-23
9:50
2011-02-16
23:44
MySQL Server: InnoDB storage engineClosed
(4965 days)
S33.23, 4.0, 4.1, 5.0, 5.1, 5.5AnyAnyUnnecessary overhead in the 64-bit "dulint" struct type
243862006-11-17
10:53
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(5031 days)
S25.0, 5.1Any (all)AnyPerformance degradation caused by instrumentation in mutex_struct
589122010-12-14
9:15
2011-02-16
23:44
MySQL Server: InnoDB storage engineClosed
(4825 days)
S3allAnyAnyInnoDB unnecessarily avoids update-in-place on column prefix indexes
613412011-05-28
15:37
2012-01-05
20:15
MySQL Server: InnoDB Plugin storage engineClosed
(4466 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
(4179 days)
S55.1.52AnyAnyOptimistic Insert/Update uses wrong heuristics for compressed page size
54362004-09-06
19:10
2005-05-06
8:58
MySQL Server: InnoDB storage engineClosed
(6901 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
(6820 days)
S14.1.13MacOS (OS X 10.4.2)AnyMassive Disk I/O Degradation under 4.1.13 in OS X
549142010-06-30
13:08
2011-02-16
23:44
MySQL Server: InnoDB storage engineClosed
(4902 days)
S55.5.5AnyAnyInnoDB: performance drop with innodb_change_buffering=all
182522006-03-15
10:36
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(5031 days)
S25.0.3 and laterAny (all)AnyDisk space leak in updates of InnoDB BLOB rows in 5.0 and 5.1
71502004-12-10
0:18
2005-01-14
13:52
MySQL Server: InnoDB storage engineClosed
(7013 days)
S34.1Linux (Linux)AnyInnoDB TRUNCATE can get very slow
183842006-03-21
8:14
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(5031 days)
S25.0.3 and laterAny (All)AnyInnoDB memory leak on duplicate key errors in 5.0 if row has many columns
35312004-04-21
19:09
2004-04-22
8:20
MySQL ServerClosed
(7280 days)
S25.0.0 & 4.1.1a-alphaWindows (Windows XP)AnyPrepared statement memory leak while connection is open
91412005-03-12
9:11
2005-07-26
13:47
MySQL Server: ReplicationClosed
(6820 days)
S34.1.10Any (any)Any4.1 does not log into slow log ALTER, OPTIMIZE and ANALYZE statements
327482007-11-27
1:54
2008-05-20
23:15
MySQL Server: LoggingClosed
(5791 days)
S35.1AnyAnyInconsistent handling of assignments to general_log_file/slow_query_log_file
348202008-02-25
21:03
2008-10-05
16:43
MySQL Server: GeneralClosed
(5653 days)
S35.1AnyAnylog_output can be set to illegal value
524102010-03-27
18:43
2011-02-16
23:44
MySQL Server: GeneralClosed
(5061 days)
S35.5.3-m3AnyAnyTest "mysqld--help-*": further output differences
317002007-10-18
19:44
2007-11-26
18:50
MySQL Server: LoggingClosed
(5967 days)
S35.0, 5.1, 4.1, 5.2 bkAnyAnythd->examined_row_count not incremented for 'const' type queries
570582010-09-28
9:57
2011-02-16
23:44
MySQL Server: GeneralClosed
(4830 days)
S35.5.6AnyAnySERVER_QUERY_WAS_SLOW not wired up.
39042004-05-27
2:07
2004-06-09
23:37
MySQL ServerClosed
(7232 days)
S24.1.2Linux (Linux)AnyCOUNT DISTINCT performance anomaly in 4.1
327382007-11-26
20:05
2011-02-16
23:43
MySQL Server: LoggingClosed
(5250 days)
S35.1, 6.0AnyAnymysqld: Two slow log option/variable descriptions are inaccurate
83672005-02-08
9:46
2005-06-22
0:05
MySQL ServerClosed
(6854 days)
S3AllAny (All)Anyslow log doesn't gives complete information about prepared statements
288302007-06-01
10:26
2007-08-09
13:27
MySQL Server: TestsClosed
(6076 days)
S3AnyAnyTest case log_state fails on VMWare Windows clone due to loaded system
267502007-03-01
14:52
2007-03-07
21:37
MySQL ServerClosed
(6231 days)
S15.0 Anyvalgrind leak in sp_head
256582007-01-16
19:34
2011-02-16
23:43
MySQL Server: OptimizerClosed
(5569 days)
S15.2.0 falcon-alpha and now 5.2.3Linux (Linux Fedora Core 6)AnyGroup by Performance is slow
101072005-04-23
0:53
2005-04-28
15:29
MySQL ServerClosed
(6909 days)
S35.0-bk AnyMemory leak in view over subquery
90212005-03-07
13:23
2012-03-26
19:37
MySQL Server: OptimizerClosed
(4385 days)
S14.1.7, 5.6.4FreeBSD (FreeBSD)AnyQuery with subquery does not use index in outer query
41142004-06-12
2:27
2004-08-24
6:49
MySQL ServerClosed
(7156 days)
S24.1.2Any (all)Anyorder by - limit optimization is broken for "range" access type.
138142005-10-06
19:09
2005-11-09
3:47
MySQL Server: OptimizerClosed
(6714 days)
S24.1.12/4.1 BK sourceLinux (linux)Anyindex including TINYBLOB breaks SELECT functionality
151352005-11-22
14:28
2011-02-16
23:43
MySQL Server: OptimizerClosed
(5486 days)
S54.1.14Any (NT)AnyDependent subquery performs very badly
321982007-11-08
21:03
2007-12-19
5:19
MySQL Server: Data TypesClosed
(5944 days)
S25.0.50, 5.0.52-BKLinuxAnyComparison of DATE with DATETIME still not using indexes correctly
418902009-01-05
22:53
2011-02-16
23:43
MySQL Server: OptimizerClosed
(5453 days)
S36.0.9-releaseAnyAnyFalcon: New execution plans with MRR cause slowdown for group of queries
354682008-03-20
20:01
2011-02-16
23:43
MySQL Server: OptimizerClosed
(4875 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
(5568 days)
S26.0.6-preAnyAnySignificant slowdown for (ANY|SOME) subqueries processed with semijoin
196492006-05-09
17:57
2006-10-10
18:58
MySQL Server: OptimizerClosed
(6379 days)
S25.0.25-BK, 5.0.18Solaris (Solaris)AnyExtremely slow join
326652007-11-23
16:26
2011-02-16
23:43
MySQL Server: OptimizerClosed
(4874 days)
S35.1.22-rc-Debian_1-logAnyAnyQuery with dependent subquery is too slow
531912010-04-27
9:10
2011-02-16
23:44
MySQL Server: LoggingClosed
(4914 days)
S15.1.45, 5.1.46Any (linux, windows)AnyLock_time in slow log is negative when logging stored routines
385512008-08-04
22:08
2011-02-16
23:43
MySQL Server: Query CacheClosed
(5231 days)
S55.1, 6.0AnyAnyRBR/MBR + Query Cache + "invalidating query cache entries (table)" => slow slave
593932011-01-10
12:47
2011-04-25
13:15
MySQL Server: OptionsClosed
(4721 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
366602008-05-12
4:45
2011-03-21
4:14
MySQL Server: OptimizerClosed
(4756 days)
S35.1.20LinuxAnySUBQUERY slow
148162005-11-10
9:40
2005-11-24
0:29
MySQL Server: OptimizerClosed
(6699 days)
S35.0.15, 5.0.16-bkLinux (Linux, Windows)AnyVIEW performs filesort when using ORDER BY but underlying table does not
508432010-02-02
18:12
2011-02-16
23:44
MySQL Server: OptimizerClosed
(5030 days)
S25.1.42AnyAnyOptimizer ignores clustered index for GROUP BY even when it improves performance
142952005-10-25
14:06
2012-08-31
16:06
MySQL Server: OptimizerClosed
(4227 days)
S34.1 and aboveLinux (linux)Anyvery slow 'explain'
538742010-05-21
6:56
2011-02-16
23:44
MySQL Server: Performance SchemaClosed
(4950 days)
S35.5.3-m3, 5.5.4-m3AnyAnySETUP_INSTRUMENTS.TIMED='NO' should not change TIMER_WAIT in aggregations
745462014-10-24
11:31
2014-10-24
11:43
MySQL Server: Performance SchemaClosed
(3443 days)
S3AnyAnyPERFORMANCE SCHEMA QUERY ON EVENTS_STATEMENTS_CURRENT WRONG WITH ORDER BY
685882013-03-06
22:00
2019-08-27
15:11
MySQL Server: InnoDB storage engineClosed
(3993 days)
S55.6.10AnyAnyremove most calls to os_thread_sleep from innodb
399392008-10-08
18:38
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(5031 days)
S25.xAnyAnyDROP TABLE/DISCARD TABLESPACE takes long time in buf_LRU_invalidate_tablespace()
557162010-08-03
15:02
2011-02-16
23:44
MySQL Server: InnoDB storage engineClosed
(4913 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
(4858 days)
S25.5AnyAnyInnoDB does more writes in 5.5 than in 5.1 on buffer pool challenged workloads
592142010-12-29
15:45
2011-05-05
23:48
MySQL Server: InnoDB Plugin storage engineClosed
(4711 days)
S55.1,5.5AnyAnyincrease rate limit for insert buffer prefetch reads
611882011-05-16
16:43
2011-11-02
16:32
MySQL Server: InnoDB storage engineClosed
(4530 days)
S35.5.12-logLinux (CentOS release 5.3 (Final))AnyDROP TABLE extremely slow
591632010-12-24
17:20
2012-01-05
0:37
MySQL Server: InnoDB storage engineClosed
(4466 days)
S25.5.8AnyAnySingle user session performance in InnoDB
99682005-04-18
9:31
2005-08-06
23:23
MySQL ServerClosed
(6809 days)
S15.0Any (all)Anyslow query log contains useless entries
426082009-02-04
21:42
2011-02-16
23:43
MySQL Server: GeneralClosed
(5515 days)
S3Summit v0.2.0AnyAnySummit may need changes to default config parameters for optimal performance
211122006-07-18
12:47
2006-09-13
17:57
MySQL Server: InnoDB storage engineClosed
(6406 days)
S35.0Any (All)AnyInnoDB slow with > 100,000 .ibd files
375762008-06-23
6:29
2011-12-06
1:00
MySQL Server: OptimizerClosed
(4496 days)
S56.0Linux (SLES10SP1 (2.6.16.46-0.12-smp))AnyMySQL6.0 performance regression compared with MySQL5.1 using Sysbench read test
1135642024-01-05
10:49
2024-01-25
3:30
MySQL Server: InnoDB storage engineAnalyzing
(63 days)
S58.0Any (>= glibc 2.25 )Anywrite-only mode performance decreases by 15% in heavy workload
537372010-05-18
9:30
2011-02-16
23:44
MySQL Server: OptimizerClosed
(4991 days)
S2mysql-next-mrAnyAnyPerformance regressions after applying patch for bug 36569
365692008-05-07
15:32
2014-06-19
23:20
MySQL Server: OptimizerClosed
(4991 days)
S55.0.56sp1AnyAnyUPDATE ... WHERE ... ORDER BY... always does a filesort even if not required
387452008-08-12
9:44
2011-02-16
23:43
MySQL Server: OptimizerClosed
(5000 days)
S25.1AnyAnyMySQL 5.1 optimizer uses filesort for ORDER BY when it should use index
447232009-05-07
15:34
2018-04-01
11:47
MySQL Server: MyISAM storage engineClosed
(5305 days)
S55.0/5.1LinuxAnyLarger read_buffer_size values can cause performance decrease for INSERTs
479052009-10-07
23:43
2011-02-16
23:44
MySQL Server: LoggingClosed
(5032 days)
S35.1.39AnyAnystored procedures with multiple statements not being logged to slow query log
497562009-12-17
4:39
2011-02-16
23:44
MySQL Server: LoggingClosed
(4914 days)
S35.0.44, 5.1.43AnyAnyRows_examined is always 0 in the slow query log for update statements
259562007-01-30
21:57
2007-02-05
14:30
MySQL Server: InnoDB storage engineClosed
(6261 days)
S35.0.27-community-ntWindows (Win 2000 SP 4)AnyCreate Table with Multiple keys are not created
394922008-09-17
0:58
2011-02-16
23:43
MySQL Server: GeneralClosed
(5581 days)
S55.0.51aSolarisAnysolaris should use a separate alarm thread
276382007-04-04
7:28
2007-04-07
18:29
MySQL Server: LoggingClosed
(6200 days)
S35.1.18-bkAnyAnyslow logging to CSV table inserts bad query_time and lock_time values
197642006-05-12
10:28
2006-11-09
14:55
MySQL Server: LoggingClosed
(6349 days)
S35.0.15Any (*)AnySHOW commands end up in the slow log as table scans
233002006-10-15
6:00
2011-02-16
23:43
MySQL Server: ReplicationClosed
(5029 days)
S34.1+Any (*)AnySlow query log on slave does not log slow replicated statements
345822008-02-15
10:35
2011-02-16
23:43
MySQL Server: ReplicationClosed
(5213 days)
S25.0.46-enterprise-gpl-logAnyAnyFLUSH LOGS does not close and reopen the binlog index file
506202010-01-26
11:36
2011-02-16
23:44
MySQL Server: ReplicationClosed
(5029 days)
S35.5.99, next-mr, 5.1AnyAnyAdding an index to a table prevents slave from logging into slow log
486322009-11-09
9:38
2011-02-16
23:44
MySQL Server: ReplicationClosed
(5029 days)
S3AllAnyAnyFix for Bug #23300 Has Not Been Backported To 5.x Release
465542009-08-04
19:50
2011-02-16
23:44
MySQL Server: Row Based Replication ( RBR )Closed
(4868 days)
S36.0-codebase, mysql-next-mr-wl5092AnyAnyRBR: pending rows event can be flushed too soon sometimes.
578992010-11-01
15:46
2011-02-16
23:44
MySQL Server: ReplicationClosed
(4830 days)
S35.5Linux (SUSE 11 64-bit)AnyCertain reserved words should not be reserved
489932009-11-23
13:27
2011-02-16
23:44
MySQL Server: ReplicationClosed
(5029 days)
S35.1.41, 5.1.44-bzr,mysql-5.5.99-m3Linux (32-bit, Mac OS X)Anyvalgrind errors in mysqlbinlog
37992004-05-17
15:23
2008-09-14
2:34
MySQL ServerClosed
(5674 days)
S34.0.18Windows (Windows XP Pro)AnyWinMySQLAdmin shows no server info
175602006-02-19
20:36
2011-02-16
23:43
MySQL Server: OptimizerClosed
(5033 days)
S35.0.18Linux (Linux)Anyselect with subselect does not use indexed key
429082009-02-17
1:20
2011-02-16
23:43
MySQL ServerClosed
(4890 days)
S55.0.74, 5.0.76, 5.0.77Linux (SLES 10)AnyPerformance degradation on SELECT_DISTINCT_RANGES (as in Sysbench)
538522010-05-20
11:14
2011-02-16
23:44
MySQL Server: InnoDB Plugin storage engineClosed
(4859 days)
S35.1.47/plugin1.0.8AnyAnyInnoDB: Performance drop in SELECT_SUM_RANGES test at higher number of threads
44972004-07-10
1:21
2004-08-09
23:15
MySQL ServerClosed
(7171 days)
S34.0.21Linux (linux)AnySerious regression if disk based TMP table is used.
122402005-07-28
14:04
2006-10-20
17:46
MySQL ServerClosed
(6369 days)
S34.1.13Windows (Windows\Linux)AnyRows Examined in Slow Log showing incorrect number?
521022010-03-16
16:20
2011-02-16
23:44
MySQL Server: InnoDB Plugin storage engineClosed
(4852 days)
S55.0, 5.1, 5.5.5m3Windows (Any)AnyInnoDB Plugin shows performance drop compared to InnoDB (Windows)
532042010-04-27
14:17
2011-02-16
23:44
MySQL Server: InnoDB storage engineClosed
(4965 days)
S35.1+WindowsAnyos_fastmutex_trylock is implemented incorrectly on Windows
156532005-12-10
11:24
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(5032 days)
S24.1, 5.0Any (All)AnySlow inserts to InnoDB if many thousands of .ibd files
180542006-03-08
2:04
2007-01-16
16:08
MySQL Server: InnoDB storage engineClosed
(6281 days)
S15.0.18Miracle Linux ver4 (kernel 2.6)AnySevere performance degradation when Hyperthreading is on
19422003-11-25
1:13
2004-03-17
9:43
MySQL Server: InnoDB storage engineClosed
(7316 days)
S24.0.16Linux (Linux)AnySlow queries with "order by"
565852010-09-06
9:38
2011-02-16
23:44
MySQL Server: WindowsClosed
(4866 days)
S55.5.5WindowsAnySlowdown of readonly sysbench benchmarks (e.g point_select) on Windows 5.5
245092006-11-22
15:09
2011-02-16
23:43
MySQL Server: GeneralClosed
(5035 days)
S35.0,5.1Windows (Windows)Any2048 file descriptor limit on windows needs increasing
388422008-08-18
8:17
2011-02-16
23:43
MySQL Server: OptimizerClosed
(5585 days)
S35.0.45, 4.1, 5.0, 5.1, 6.0 bzrAnyAnyFix for 25951 seems incorrect
256592007-01-16
22:38
2007-05-24
7:27
MySQL Server: GeneralClosed
(6153 days)
S35.1AnyAnymemory leak via "plugins" test
347892008-02-24
13:49
2008-04-22
14:15
MySQL Server: Federated storage engineClosed
(5819 days)
S35.1.23, 5.1.24-rcAnyAnydrop server/create server leaks memory !
26132004-02-02
8:20
2004-06-16
16:18
MySQL ServerClosed
(7225 days)
S34.0 Anymemory leak in drop database with raid
26432004-02-04
13:21
2004-02-04
18:10
MySQL Server: MyISAM storage engineClosed
(7358 days)
S24.0.16Linux (linux)Any4.0.16 selects different index than 4.0.14
84752005-02-12
14:19
2005-03-08
0:35
MySQL ServerClosed
(6960 days)
S34.1Any (all)AnyIf multi-query: query does not get into slow query log if it's not last
79392005-01-16
16:33
2005-02-17
17:36
MySQL ServerClosed
(6979 days)
S34.1.9 Any --log-queries-not-using-indexes doesnt apply with 0 or 1 row OR quuery cache
109312005-05-27
20:54
2005-06-21
11:00
MySQL ServerClosed
(6855 days)
S24.1.xAny (All)AnyHostname cache completely broken in 4.1
531652010-04-26
15:15
2011-02-16
23:44
MySQL Server: InnoDB Plugin storage engineClosed
(4992 days)
S3mysql-5.5AnyAnySetting innodb_change_buffering=DEFAULT produces incorrect result
547642010-06-24
8:19
2011-02-16
23:44
MySQL Server: InnoDB storage engineClosed
(4944 days)
S35.5.5, innodb 1.1.1AnyAnymemory allocated in os_aio_array_create is not freed at shutdown
536542010-05-14
16:12
2011-02-16
23:44
MySQL Server: InnoDB Plugin storage engineClosed
(5008 days)
S21.0, 1.1AnyAnyafter 2nd shutdown innodb_file_format_check attains strange values
867102017-06-15
8:57
2017-07-28
2:01
MySQL Server: OptimizerClosed
(2435 days)
S28.0.2-dmr-enterprise-commercial-advancedLinuxAnyPerformance issue of explicit COLLATE clause
Showing all 915 (Edit, Save, CSV, Feed)