| Showing 1-90 of 777 (Edit, Save, CSV, Feed) | Show Next 90 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 59819 | 2011-01-30 11:03 | 2019-12-06 3:50 | MySQL Server: Views | Analyzing (4111 days) | S5 | 5.1,5.5 | Any | Any | TEMPTABLE Views are Extremely Slow |
| 24251 | 2006-11-13 10:58 | 2018-09-09 20:45 | MySQL Server: Optimizer | In progress (5260 days) | S5 | 5.0.30-BK, 5.1.12 | Linux (Linux, Win XP SP2) | Any | Non-optimal choice of indexes for queries |
| 24770 | 2006-12-02 0:37 | 2018-09-09 20:45 | MySQL Server: Optimizer | In progress (4777 days) | S5 | 5.1 | Any (all) | Any | update with subquery slow |
| 8113 | 2005-01-24 15:43 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5357 days) | S5 | 5.0, 5.1, azalea bzr | Any | Any | Select with between optimization |
| 8662 | 2005-02-21 21:31 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5253 days) | S5 | 6.0.14, 5.1.12-BK, 4.1.10 | Any | Any | optimizer, query takes 3 to 10 times as long when using index |
| 14638 | 2005-11-04 13:10 | 2012-05-18 20:19 | MySQL Server: General | Verified (5241 days) | S5 | 5.0-BK, 5.1.43-bzr | Any (any) | Any | ptr_compare processes data only byte wise |
| 14668 | 2005-11-05 8:19 | 2022-12-04 20:45 | MySQL Server | Verified (5447 days) | S5 | 5.0.16-BK, 5.1.34 | Any (any) | Any | funktions storing in machine independent format not optimized for PPC |
| 33381 | 2007-12-19 19:27 | 2018-09-09 20:45 | MySQL Server: Data Types | Verified (5308 days) | S5 | 5.0.45, 5.0.52, 5.1.40 | Linux | Any | Temporary table created on disk when it should be in ram |
| 36229 | 2008-04-21 13:35 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (5840 days) | S5 | 5.0.51a, 5.1.24 | Any | Any | Execution overhead of stored function/procedure differs with cross-database call |
| 36817 | 2008-05-20 13:19 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5401 days) | S5 | 5.0.54a,5.1.19, 5.1.25, 5.0.60, 5.5 | Any | Any | Non optimal index choice, depending on index creation order |
| 37264 | 2008-06-07 22:35 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5663 days) | S5 | 5.1.24-rc 5.1.29-rc 5.1.30 | Any | Any | MySQL wrongly uses filesort |
| 38153 | 2008-07-15 22:13 | 2014-02-28 18:58 | MySQL Server: InnoDB storage engine | Verified (3702 days) | S5 | 5.0.66, 5.1.34, 5.6.16 | Any | Any | mysql-bench: slowdown for update_of_primary_key_many_keys test |
| 38550 | 2008-08-04 21:47 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5663 days) | S5 | 5.0.60, 5.1 | Any | Any | multiple optimizer bugs for queries with references from preceding table |
| 39833 | 2008-10-03 9:23 | 2022-12-04 20:45 | MySQL Server: DDL | Verified (5652 days) | S5 | 5.1 | Any | Any | CREATE INDEX does full table copy on TEMPORARY table |
| 41220 | 2008-12-04 9:59 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5357 days) | S5 | 5.1.30, 5.0, 5.1, azalea bzr | Any | Any | LEFT JOIN with compound clause uses table scan, while INNER JOIN uses indexes |
| 42808 | 2009-02-12 22:17 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5543 days) | S5 | 4.1, 5.0, 5.1 | Any | Any | Execution Plan Cache |
| 43889 | 2009-03-26 16:07 | 2011-02-16 23:43 | MySQL Server: General | Verified (5502 days) | S5 | 5.1 | Linux | Any | closing half-read resultset causes is O(n) instead of O(1) |
| 45776 | 2009-06-26 7:17 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5410 days) | S5 | mysql-5.1.35 | Linux | Any | "OR" condition on SPATIAL index not optimized |
| 46376 | 2009-07-24 17:05 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5377 days) | S5 | 5.0.85, 5.1.36, 5.1.38, 5.1.39 | Windows (XP) | Any | Optimizer choose wrong index even when where clause and order-by are covered |
| 46717 | 2009-08-14 11:14 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5351 days) | S5 | 5.1.32 | Any | Any | Unnecessary joins are not optimized away |
| 47330 | 2009-09-15 15:39 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5321 days) | S5 | 5.0.77, 5.1.34, 5.1.37 | Linux (Debian x64) | Any | Slow query with left join and having. |
| 48886 | 2009-11-19 0:38 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5264 days) | S5 | 5.1+ | Any | Any | MySQL doesn't seem to optimize "less than empty string" |
| 49276 | 2009-12-01 17:03 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5252 days) | S5 | 5.0.85-community-log, 5.0.89, 5.1.42 | Linux | Any | Optimization for IN (on InnoDB tables) depends on number of set elements |
| 50367 | 2010-01-15 14:12 | 2011-02-16 23:44 | MySQL Server: General | Verified (5145 days) | S5 | 5.1.42, 5.1 bzr | Any (MS Windows 32 bits, Mac) | Any | REPLACE has quadradic computational complexity on windows server (but not linux) |
| 52029 | 2010-03-13 12:26 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5141 days) | S5 | 5.1.44 | Any | Any | GROUP BY results in much slower query |
| 52170 | 2010-03-18 9:57 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5141 days) | S5 | 5.1.44, mysql-next-mt | Linux (fc12) | Any | innodb query optimizer fails (null possible_keys) with multicolumn key |
| 53045 | 2010-04-22 4:58 | 2022-12-04 20:45 | MySQL Server: Locking | Verified (5110 days) | S5 | 5.1.45, 5.5 | Any | Any | LOCK_thread_count locked when per connection threads created |
| 55248 | 2010-07-14 9:22 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5027 days) | S5 | 5.1.43, 5.1.48 | Windows | Any | constant WHERE inefficient |
| 55606 | 2010-07-28 15:25 | 2015-08-30 17:21 | MySQL Server: Charsets | Verified (3997 days) | S5 | 5.1.47, 5.1.50-bzr, 5.5.23, 5.6.11 | Linux | Any | Charset on ENUMS influencing performance too much |
| 55979 | 2010-08-13 22:05 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4994 days) | S5 | 5.1.39 | Linux | Any | Key not used if IN() list contains mix of strings and integers |
| 57354 | 2010-10-10 19:52 | 2013-03-03 20:45 | MySQL Server: FULLTEXT search | Verified (4862 days) | S5 | 5.1.41, 5.1.55 | Any (CentOS and Win7 tested) | Any | Using "=" operator with FULL-TEXT search decrease the speed |
| 58101 | 2010-11-10 0:21 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4907 days) | S5 | 5.1.38-community-log, 5.1.54-bzr | Linux | Any | Optimizer picks wrong order of queries |
| 58234 | 2010-11-16 16:26 | 2014-02-26 12:47 | MySQL Server: InnoDB storage engine | Verified (4505 days) | S5 | 5.1.49-r1, 5.5.20 | Any | Any | LENGTH() / OCTET_LENGTH() on BLOB field very slow |
| 60197 | 2011-02-22 7:48 | 2011-04-17 13:47 | MySQL Server: Command-line Clients | Verified (4753 days) | S5 | 5.1.55 | Windows | Any | random used in a multithreaded context |
| 60345 | 2011-03-04 17:11 | 2013-01-15 15:25 | MySQL Server | Verified (4111 days) | S5 | 5.1.55 6.0.11 | Any | Any | trim trailing spaces processes data only byte wise (the continue of bug14637) |
| 60348 | 2011-03-04 20:14 | 2013-01-15 15:25 | MySQL Server | Verified (4111 days) | S5 | 5.1.55 | Any | Any | trim trailing spaces processes data only byte wise (continue of bug14637 (2)) |
| 60349 | 2011-03-04 21:20 | 2013-01-15 15:25 | MySQL Server | Verified (4111 days) | S5 | 5.1.55 | Any | Any | trim beginning spaces processes data only byte wise (continue of bug14637 (3)) |
| 60351 | 2011-03-04 22:15 | 2013-01-15 15:27 | MySQL Server | Verified (4111 days) | S5 | 5.1.55 | Any | Any | trim same character processes data only byte wise (continue of bug14637 (4)) |
| 60702 | 2011-03-30 23:25 | 2011-04-05 14:55 | MySQL Server: Optimizer | Verified (4767 days) | S5 | 5.1.57 | Any | Any | GROUP BY orders when used inside a UNION query, though it should not |
| 60811 | 2011-04-08 23:41 | 2020-08-15 10:10 | MySQL Server: General | Verified (4757 days) | S5 | 5.0.93, 5.5.12, 5.0.77-4.el5_5.4 | Any (RHEL 5.5, Mac OS X) | Any | slow timezone functions |
| 62286 | 2011-08-28 22:02 | 2011-09-06 9:56 | MySQL Server: Locking | Verified (4616 days) | S5 | 5.1, 5.5, ... | Any | Any | call multiple accepts per poll |
| 63905 | 2012-01-02 23:47 | 2012-01-16 18:35 | MySQL Server: Optimizer | Verified (4476 days) | S5 | 5.1.60 | Windows | Any | handler_read_next is suprisingly high and slows queries |
| 64116 | 2012-01-23 20:05 | 2012-05-25 7:35 | MySQL Server: InnoDB Plugin storage engine | Verified (4468 days) | S5 | 5.1,5.5,5.6 | Any | Any | fil_space_get_size called too frequently |
| 64181 | 2012-01-31 14:41 | 2012-02-09 12:20 | MySQL Server: InnoDB Plugin storage engine | Verified (4457 days) | S5 | 5.1.52, 5.1.61 | Any | Any | unzip_LRU length management might need to be updated for SSD |
| 64340 | 2012-02-15 14:07 | 2013-06-14 15:35 | MySQL Server: InnoDB Plugin storage engine | Verified (3961 days) | S5 | 5.1.52, 5.1.61 | Any | Any | race on no_flush event during buf_flush_free_margin |
| 64344 | 2012-02-15 17:00 | 2015-01-16 19:40 | MySQL Server: InnoDB Plugin storage engine | Verified (4423 days) | S5 | 5.1.52 | Any | Any | malloc, free done for compressed pages when buffer pool mutex locked |
| 64673 | 2012-03-16 23:14 | 2012-03-18 17:15 | MySQL Server: InnoDB Plugin storage engine | Verified (4415 days) | S5 | 5.1 | Any | Any | InnoDB allocates too many empty pages in ibd files |
| 64715 | 2012-03-21 4:24 | 2012-03-21 20:00 | MySQL Server: InnoDB Plugin storage engine | Verified (4411 days) | S5 | 5.1.52, 5.1.63 | Any | Any | buf_LRU_free_block() calls page_zip_calc_checksum() unnecessarily. |
| 65177 | 2012-05-02 9:43 | 2020-05-03 20:45 | MySQL Server: Optimizer | Verified (4364 days) | S5 | 5.1,5.5 | Any | Any | perromance issue of "order by rand()" |
| 65286 | 2012-05-11 16:28 | 2015-01-15 14:43 | MySQL Server: Partitions | Verified (4359 days) | S5 | mysql 5.1, 5.5 | Any | Any | Avoid copying on REORGANIZE PARTITION where possible |
| 65792 | 2012-07-03 2:19 | 2012-07-04 9:54 | MySQL Server: Optimizer | Verified (4307 days) | S5 | 5.1,5.5 | Any | Any | an unecessary Using temporary in distinct query |
| 66563 | 2012-08-28 5:37 | 2012-08-28 6:55 | MySQL Server: InnoDB Plugin storage engine | Verified (4251 days) | S5 | 5.1,5.6 | Any | Any | reduce the number of redundant calls to btr_cur_optimistic_insert() |
| 71804 | 2014-02-22 22:29 | 2020-09-13 20:45 | MySQL Server: Optimizer | Verified (3468 days) | S5 | 5.6.6 m9, 5.5.32, 5.1.61 | Any (sqlfiddle.com) | Any | Unnecessary filesort when joining on unique column using group by. |
| 72815 | 2014-05-30 11:06 | 2014-05-31 14:24 | MySQL Server: Optimizer | Verified (3611 days) | S5 | 5.1, 5.5, 5.6, 5.7 | Any | Any | UPDATE ... WHERE ... ORDER BY... always does a filesort even if not required |
| 81024 | 2016-04-09 19:53 | 2016-04-09 21:45 | MySQL Server: DML | Verified (2931 days) | S5 | 5.0/5.1/5.5/5.6/5.7 | Windows (Microsoft Windows 7 Enterprise Service Pack 1) | Any | HAVING without GROUP BY should imply an aggregation of a single group |
| 81803 | 2016-06-10 12:35 | 2016-06-15 16:58 | MySQL Server: Optimizer | Verified (2864 days) | S5 | >=5.1 | Any | Any | Mysql 5.1 and later Update performance regression |
| 49456 | 2009-12-04 12:04 | 2018-04-08 20:45 | MySQL Server | Analyzing (5249 days) | S3 | mysql-5.1-rep+3 | Any | Any | replication out of sync |
| 23327 | 2006-10-16 9:15 | 2012-05-18 20:19 | MySQL Server | In progress (6040 days) | S3 | 4.1 BK, 5.0 BK, 5.1 BK | Windows (XP) | Any | Strange mapping of certain values for system variable |
| 32571 | 2007-11-21 13:03 | 2022-12-04 20:45 | MySQL Server: DDL | In progress (2566 days) | S3 | 5.0.37, 5.1, 5.6, 5.7 | Linux (Windows, Ubuntu) | Any | CREATE TABLE options are dependant on the order of specification |
| 44791 | 2009-05-11 13:52 | 2016-05-29 20:45 | Connector / J | In progress (3983 days) | S3 | 5.1.7 | Windows | Any | Setting/getting holdability on connection does not work properly |
| 39049 | 2008-08-26 16:18 | 2018-09-09 20:45 | MySQL Server: Data Types | Patch pending (5608 days) | S3 | 5.0, 5.1, 6.0 | Any | Any | Wrong warning when comparing some decimal values to NULL |
| 45780 | 2009-06-26 8:44 | 2018-09-09 20:45 | MySQL Server: Data Types | Patch pending (5399 days) | S3 | 5.1.35 | Any | Any | CONCAT(CASE(numeric)) returns wrong length |
| 57339 | 2010-10-08 13:11 | 2012-05-18 20:19 | MySQL Server: Data Types | Patch pending (4770 days) | S3 | MySQL Server 5.1.51 | Windows (Windows XP, 2003, 7) | Any | Max Double value out of range in select and dump |
| 1956 | 2003-11-25 16:23 | 2022-12-04 20:45 | MySQL Server: Parser | Verified (5682 days) | S3 | 4.0.12, 4.1.0, 5.1.52 | Any (Any) | Any | Parser allows naming of PRIMARY KEY |
| 3052 | 2004-03-03 2:46 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6569 days) | S3 | 5.1 | Linux (SuSE 8.2) | Any | Rollback in stored procedure doesn't close cursor |
| 3329 | 2004-03-29 22:23 | 2011-02-16 23:42 | MySQL Server | Verified (5447 days) | S3 | 4.0.18/4.0.19 Source, 5.0, 5.1, 6.0 bzr | Any (Windows, MacOSX) | Any | Incomplete lower_case_table_names=2 implementation |
| 6442 | 2004-11-04 20:33 | 2018-09-09 20:45 | MySQL Server: Views | Verified (5676 days) | S3 | 5.0.2, 5.1.28 | Any | Any | Views: updatability not established at view creation time |
| 8036 | 2005-01-20 10:12 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (7019 days) | S3 | 4.0.18, 4.1.10, 5.1.52 | FreeBSD (Free BSD 4.5, Linux) | Any | Bad optimization of ORDER BY ... LIMIT 1 if one table is MyISAM, another InnoDB |
| 10992 | 2005-05-31 16:17 | 2017-11-13 0:44 | MySQL Server: DDL | Verified (6259 days) | S3 | 4.1.13, 5.1.52 | Any | Any | MyISAM foreign key definitions create indexes |
| 12671 | 2005-08-19 10:32 | 2017-11-13 20:42 | MySQL Server: General | Verified (4873 days) | S3 | 5.0.10, 5.0.91, 5.1.53 | Any (Linux) | Any | SHOW CREATE DATABASE shows versioned CHARACTER SET specification |
| 12719 | 2005-08-22 10:51 | 2017-11-13 20:47 | MySQL Server: Stored Routines | Verified (5447 days) | S3 | 5.0.12, 5.0.14-rc, 5.1.34 | Linux (Linux) | Any | SHOW CREATE PROCEDURE/FUNCTION does obey sql_quote_show_create |
| 16402 | 2006-01-12 3:44 | 2012-05-18 20:19 | MySQL Server: Stored Routines | Verified (6633 days) | S3 | 5.1.6-alpha-debug | Linux (linux) | Any | Events: SHOW EVENT STATUS doesn't work |
| 17597 | 2006-02-20 20:20 | 2014-01-22 14:26 | MySQL Server: Stored Routines | Verified (3739 days) | S3 | 5.1 | Any | Any | CREATE TRIGGER does not check privileges the standard way |
| 17598 | 2006-02-20 20:26 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (5287 days) | S3 | 5.1 | Any | Any | privilege checks when trigger is executed |
| 20040 | 2006-05-24 10:46 | 2017-01-12 15:32 | MySQL Server: Options | Verified (6259 days) | S3 | 5.1-bk, 5.0.38 | Any (*) | Any | SSL connections do not affect SSL statistics in STATUS output |
| 20353 | 2006-06-09 11:12 | 2012-05-18 20:19 | MySQL Server: Charsets | Verified (5624 days) | S3 | 4.1, 5.0, 5.1 | Any | Any | Prefix key search return incorrect results for ignorable characters |
| 21094 | 2006-07-17 14:50 | 2022-12-18 8:21 | MySQL Server: DDL | Verified (6485 days) | S3 | 5.1-BK, 5.0-BK, 5.0.19 | Linux (linux) | Any | ALTER TABLE ... ROW_FORMAT=compressed does not lead into error |
| 21326 | 2006-07-28 9:26 | 2022-12-04 20:45 | MySQL Server: DML | Verified (5404 days) | S3 | 5.0.25-BK, 5.0.22/5.1BK | Any (any) | Any | Can SELECT from table being updated in a stored function, but can't in subquery |
| 22034 | 2006-09-05 23:10 | 2014-01-22 14:27 | MySQL Server: Stored Routines | Verified (3739 days) | S3 | 5.1.12-beta-debug | Linux (SUSE 10.0 / 64-bit) | Any | Events: U and ΓΌ are the same name |
| 22222 | 2006-09-10 9:12 | 2019-03-18 13:57 | MySQL Server: Command-line Clients | Verified (5979 days) | S3 | 4.0, 4.1, 5.0, 5.1 | Windows (Windows) | Any | stream buffers not always flushed |
| 22246 | 2006-09-11 21:37 | 2022-12-04 20:45 | MySQL Server: Locking | Verified (5241 days) | S3 | 4.1.22, 5.0.45, 5.1.43, 6.0.14 | Linux (Linux) | Any | Allow LOCK TABLE WRITE lock a non-existent table. |
| 22632 | 2006-09-23 20:45 | 2022-12-04 20:45 | MySQL Server: DDL | Verified (6399 days) | S3 | 5.1.11-beta | Linux (linux) | Any | SHOW CREATE TABLE is inconsistent in showing unsupported options |
| 22644 | 2006-09-24 19:41 | 2012-05-18 20:19 | MySQL Server: Charsets | Verified (6399 days) | S3 | 5.1.12-beta-debug | Linux (SUSE 10.0 / 64-bit) | Any | LC_TIME_NAMES: Some names are doubtful |
| 23164 | 2006-10-11 6:08 | 2016-10-04 8:10 | MySQL Server: C API (client library) | Verified (5124 days) | S3 | 5.1.42, 4.1, 5.0, 5.1, 5.6.99 | Any (Mac OS X 10.6.3, Linux) | Any | Query summary Warnings count capped at 65535 |
| 24455 | 2006-11-21 8:40 | 2022-12-04 20:45 | MySQL Server: Security: Privileges | Verified (6345 days) | S3 | 5.1.12-beta-community-nt, 5.0 BK | Linux (linux, window 2000) | Any | procs_priv shows error user after granting procedure's privilege to special user |
| 24489 | 2006-11-21 22:16 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6344 days) | S3 | 5.0 BK, 5.1 BK | Linux (Linux) | Any | @@sql_select_limit applies to stored functions, triggers, events |
| 24697 | 2006-11-29 15:13 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4856 days) | S3 | 5.0.24a-community-nt-log/4.1BK/5.0BK/5.1BK | Windows (Windows 2000 and Linux) | Any | insert .. select ....ON DUPLICATE KEY UPDATE fails with ambiguous column name |
| 24754 | 2006-12-01 13:34 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5243 days) | S3 | 5.1.14, 5.1.43-bzr | Linux (Linux) | Any | Index is not used when joining two tables |
| 24758 | 2006-12-01 18:08 | 2012-05-18 20:19 | MySQL Server: Options | Verified (5979 days) | S3 | 5.0.27, 4.1 BK, 5.1 BK | Linux (Fedora Core6) | Any | max_user_connections=0 doesn't work had to set a value to make it work |
| 24761 | 2006-12-01 20:50 | 2022-12-04 20:45 | MySQL Server: General | Verified (5680 days) | S3 | 5.0.36-BK, 5.0.27, 5.1, 6.0.7 | Linux (Linux (Fedora)) | Any | dropped TCP connections not logged as errors but result in blocked host |
| Showing 1-90 of 777 (Edit, Save, CSV, Feed) | Show Next 90 Entries » |
