Showing 1-30 of 31 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
23578 | 2006-10-24 9:42 | 2007-01-16 6:06 | MySQL Server | Closed (6281 days) | S1 | 5.0.25, 5.1-BK, 5.0-BK | Linux (Centos) | Any | Corruption prevents Optimize table from working properly with a spatial index |
102536 | 2021-02-09 2:16 | 2021-02-09 13:50 | MySQL Server | Duplicate (1143 days) | S3 | MySQL 8.0.22 | Linux | Any | MySQL 8.0.22 System view wrong result |
84081 | 2016-12-06 18:38 | 2021-11-09 15:27 | MySQL Server: Options | Verified (2666 days) | S3 | 5.7.14, 5.7.16 | Ubuntu | Any | super_read_only and read_only not allowing OPTIMIZE TABLE on 5.7 |
86460 | 2017-05-25 14:19 | 2017-06-14 3:38 | MySQL Server: InnoDB storage engine | Verified (2493 days) | S3 | 5.6 5.7 | Any | Any | Deleted DOCID are not maintained during OPTIMIZE of InnoDB FULLTEXT tables |
80503 | 2016-02-25 5:29 | 2016-02-25 5:42 | MySQL Server: MyISAM storage engine | Verified (2954 days) | S3 | 5.6.29 | Red Hat | Any | optimize MyISAM leads to corrupted index |
77546 | 2015-06-29 14:38 | 2017-03-24 7:35 | MySQL Server: DDL | No Feedback (3056 days) | S2 | 5.6.25 MySQL Community Server (GPL) | Ubuntu (14.04 64bit) | Any | Lost Connection on DDL Query in a large table (optimize table) |
69683 | 2013-07-06 5:17 | 2015-08-20 5:23 | MySQL Server: MyISAM storage engine | Closed (3144 days) | S1 | 5.6.12 | Windows (7 latest updates) | Any | Optimize after a delete returns error 0 can't get stat of MYD file |
71433 | 2014-01-20 19:10 | 2014-09-25 11:49 | MySQL Server: Locking | Closed (3472 days) | S2 | 5.6 | Any | Any | recreate+analyze OPTIMIZE TABLE T and online ALTER TABLE T may deadlock |
71146 | 2013-12-14 11:34 | 2021-08-08 20:45 | MySQL Server: Documentation | Verified (3755 days) | S3 | any | Any | Any | Manual does not explain when REPAIR or OPTIMIZE TABLE uses repair by sorting |
27199 | 2007-03-16 5:03 | 2013-09-09 9:28 | MySQL Server: Optimizer | Closed (3853 days) | S2 | 5.0.22, 5.0.37, 4.1 BK, 5.1 BK | Linux (linux) | Any | Performance problem when query contains a left join against a subquery |
70096 | 2013-08-20 16:19 | 2013-08-26 17:28 | MySQL Cluster: Cluster (NDB) storage engine | Duplicate (3867 days) | S1 | mysql-5.5.29 ndb-7.2.10 | Linux | Any | ndb cluster failure during an optimize run |
69839 | 2013-07-25 16:32 | 2015-08-19 21:44 | MySQL Server: MyISAM storage engine | Duplicate (3899 days) | S1 | 5.6.12 | Windows (x64) | Any | windows only: Impossible to REPAIR or OPTIMIZE datafiles (.MYD) files > 4GB |
61598 | 2011-06-22 18:04 | 2013-01-12 17:32 | MySQL Server: MyISAM storage engine | Closed (4093 days) | S1 | 5.1.57, 5.5.21, 5.6.5 | Linux | Any | REPAIR and OPTIMIZE lead to table corruption |
58933 | 2010-12-15 1:13 | 2011-02-16 23:44 | MySQL Server: DDL | Closed (4824 days) | S3 | 5.5.9-debug, 5.6.1-m5-debug | Any | Any | Assertion `thd- >is_error()' fails when ongoing OPTIMIZE TABLE is killed |
58551 | 2010-11-29 9:33 | 2011-02-16 23:44 | MySQL Server: Documentation | Closed (4859 days) | S5 | 5.0, 5.1, (probably All) | Any | Any | Optimize table after load or insert into ... select gives 25% speed increase |
45971 | 2009-07-06 13:49 | 2011-02-16 23:44 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5349 days) | S2 | mysql-5.1-telco-6.3 | Linux (Gentoo 2008.0 AMD64) | Any | Optimize on NDB table causes full cluster crash (All API/NDB Storage nodes). |
43543 | 2009-03-10 19:32 | 2011-02-16 23:43 | MySQL Server | No Feedback (5269 days) | S1 | 5.0.77-log | Linux | Any | OPTIMIZE command on ~500meg table crashes MySql |
41373 | 2008-12-10 20:06 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5587 days) | S3 | 5.1.30 | Any | Any | the manual states incorrectly that partitioned tables don't support OPTIMIZE |
40912 | 2008-11-21 3:15 | 2011-02-16 23:43 | MySQL Server: Partitions | No Feedback (5576 days) | S2 | 5.1 | Linux | Any | partition rebuild causes differeces in rowcount |
36671 | 2008-05-12 16:32 | 2008-05-12 19:30 | MySQL Server: Documentation | Not a Bug (5799 days) | S3 | 5.1.24 | Any | Any | OPTIMIZE TABLE causes implicit commit |
31463 | 2007-10-08 19:04 | 2007-11-09 1:11 | MySQL Server: MyISAM storage engine | No Feedback (5984 days) | S2 | 5.1.21-beta-community | Windows (Windows 2003 x64) | Any | Get error Wrong Bytesec error when Optimize Table |
30273 | 2007-08-07 12:48 | 2008-01-14 18:05 | MySQL Server: Merge storage engine | Closed (5918 days) | S2 | 5.0.48BK,5.1.22BK | Windows (XP) | Any | merge tables: Can't lock file (errno: 155) |
26273 | 2007-02-11 21:15 | 2007-02-12 10:37 | MySQL Server | Can't repeat (6254 days) | S3 | 4.1.22 5.0.34 | FreeBSD (freebsd) | Any | optimize, not executed for index, if datafile is gap-free |
25820 | 2007-01-24 11:15 | 2012-05-18 20:19 | MySQL Server: Locking | Duplicate (6254 days) | S3 | 5.0.36BK | Any (*) | Any | CPU pegged at 100% after optimizing table belonging to merge set |
27382 | 2007-03-22 19:01 | 2007-03-23 9:59 | MySQL Server: Documentation | Closed (6215 days) | S3 | all | Any (all) | Any | OPTIMIZE TABLE seems to apply to the ARCHIVE storage engine |
26284 | 2007-02-12 12:32 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5982 days) | S3 | 5.0.bk | Linux (Linux) | Any | bug #26273 / optimize, not executed for index, if datafile is gap-free |
25647 | 2007-01-16 11:54 | 2007-05-08 16:50 | MySQL Server: Documentation | Closed (6169 days) | S3 | * | Any (*) | Any | improve docs: warn that repair, optimize, analyze can corrupt merge base tables |
25521 | 2007-01-10 12:04 | 2007-04-09 19:31 | MySQL Server: MyISAM storage engine | Closed (6198 days) | S2 | 5.0.34 | Windows (w2k3sp1) | Any | optimize table, delete, show table status leads to table losing it's .MYD |
25700 | 2007-01-18 17:32 | 2007-12-03 9:34 | MySQL Server: Merge storage engine | Closed (5960 days) | S2 | 5.0 | Any (*) | Any | merge base tables get corrupted by optimize/analyze/repair table |
23144 | 2006-10-10 15:57 | 2006-11-24 11:34 | MySQL Administrator | Closed (6334 days) | S3 | 1.2.5rc | MacOS (Mac OS X) | Any | Multi-Table Optimize crashes Administrator |
Showing 1-30 of 31 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |