Showing all 29 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version OS CPU Summary
231442006-10-10
15:57
2006-11-24
11:34
MySQL AdministratorClosed
(5174 days)
S31.2.5rcMac OS X (Mac OS X)AnyMulti-Table Optimize crashes Administrator
235782006-10-24
9:42
2007-01-16
6:06
MySQL ServerClosed
(5121 days)
S15.0.25, 5.1-BK, 5.0-BKLinux (Centos)AnyCorruption prevents Optimize table from working properly with a spatial index
255212007-01-10
12:04
2007-04-09
19:31
MySQL Server: MyISAM storage engineClosed
(5038 days)
S25.0.34Microsoft Windows (w2k3sp1)Anyoptimize table, delete, show table status leads to table losing it's .MYD
256472007-01-16
11:54
2007-05-08
16:50
MySQL Server: DocumentationClosed
(5009 days)
S3*Any (*)Anyimprove docs: warn that repair, optimize, analyze can corrupt merge base tables
257002007-01-18
17:32
2007-12-03
9:34
MySQL Server: Merge storage engineClosed
(4800 days)
S25.0Any (*)Anymerge base tables get corrupted by optimize/analyze/repair table
258202007-01-24
11:15
2012-05-18
20:19
MySQL Server: LockingDuplicate
(5094 days)
S35.0.36BKAny (*)AnyCPU pegged at 100% after optimizing table belonging to merge set
262732007-02-11
21:15
2007-02-12
10:37
MySQL ServerCan't repeat
(5094 days)
S34.1.22 5.0.34FreeBSD (freebsd)Anyoptimize, not executed for index, if datafile is gap-free
262842007-02-12
12:32
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4822 days)
S35.0.bkLinux (Linux)Anybug #26273 / optimize, not executed for index, if datafile is gap-free
273822007-03-22
19:01
2007-03-23
9:59
MySQL Server: DocumentationClosed
(5055 days)
S3allAny (all)AnyOPTIMIZE TABLE seems to apply to the ARCHIVE storage engine
302732007-08-07
12:48
2008-01-14
18:05
MySQL Server: Merge storage engineClosed
(4758 days)
S25.0.48BK,5.1.22BKMicrosoft Windows (XP)Anymerge tables: Can't lock file (errno: 155)
314632007-10-08
19:04
2007-11-09
1:11
MySQL Server: MyISAM storage engineNo Feedback
(4824 days)
S25.1.21-beta-communityMicrosoft Windows (Windows 2003 x64)AnyGet error Wrong Bytesec error when Optimize Table
366712008-05-12
16:32
2008-05-12
19:30
MySQL Server: DocumentationNot a Bug
(4639 days)
S35.1.24AnyAnyOPTIMIZE TABLE causes implicit commit
409122008-11-21
3:15
2011-02-16
23:43
MySQL Server: PartitionsNo Feedback
(4416 days)
S25.1LinuxAnypartition rebuild causes differeces in rowcount
413732008-12-10
20:06
2011-02-16
23:43
MySQL Server: DocumentationClosed
(4427 days)
S35.1.30AnyAnythe manual states incorrectly that partitioned tables don't support OPTIMIZE
435432009-03-10
19:32
2011-02-16
23:43
MySQL ServerNo Feedback
(4109 days)
S15.0.77-logLinuxAnyOPTIMIZE command on ~500meg table crashes MySql
459712009-07-06
13:49
2011-02-16
23:44
MySQL Cluster: Cluster (NDB) storage engineClosed
(4189 days)
S2mysql-5.1-telco-6.3Linux (Gentoo 2008.0 AMD64)AnyOptimize on NDB table causes full cluster crash (All API/NDB Storage nodes).
585512010-11-29
9:33
2011-02-16
23:44
MySQL Server: DocumentationClosed
(3699 days)
S55.0, 5.1, (probably All)AnyAnyOptimize table after load or insert into ... select gives 25% speed increase
589332010-12-15
1:13
2011-02-16
23:44
MySQL Server: DDLClosed
(3664 days)
S35.5.9-debug, 5.6.1-m5-debugAnyAnyAssertion `thd- >is_error()' fails when ongoing OPTIMIZE TABLE is killed
615982011-06-22
18:04
2013-01-12
17:32
MySQL Server: MyISAM storage engineClosed
(2933 days)
S15.1.57, 5.5.21, 5.6.5LinuxAnyREPAIR and OPTIMIZE lead to table corruption
698392013-07-25
16:32
2015-08-19
21:44
MySQL Server: MyISAM storage engineDuplicate
(2739 days)
S15.6.12Microsoft Windows (x64)Anywindows only: Impossible to REPAIR or OPTIMIZE datafiles (.MYD) files > 4GB
700962013-08-20
16:19
2013-08-26
17:28
MySQL Cluster: Cluster (NDB) storage engineDuplicate
(2707 days)
S1mysql-5.5.29 ndb-7.2.10LinuxAnyndb cluster failure during an optimize run
271992007-03-16
5:03
2013-09-09
9:28
MySQL Server: OptimizerClosed
(2693 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
711462013-12-14
11:34
2013-12-16
17:22
MySQL Server: DocumentationVerified
(2595 days)
S3anyAnyAnyManual does not explain when REPAIR or OPTIMIZE TABLE uses repair by sorting
714332014-01-20
19:10
2014-09-25
11:49
MySQL Server: LockingClosed
(2312 days)
S25.6AnyAnyrecreate+analyze OPTIMIZE TABLE T and online ALTER TABLE T may deadlock
696832013-07-06
5:17
2015-08-20
5:23
MySQL Server: MyISAM storage engineClosed
(1984 days)
S15.6.12Microsoft Windows (7 latest updates)AnyOptimize after a delete returns error 0 can't get stat of MYD file
775462015-06-29
14:38
2017-03-24
7:35
MySQL Server: DDLNo Feedback
(1896 days)
S25.6.25 MySQL Community Server (GPL)Ubuntu (14.04 64bit)AnyLost Connection on DDL Query in a large table (optimize table)
805032016-02-25
5:29
2016-02-25
5:42
MySQL Server: MyISAM storage engineVerified
(1794 days)
S35.6.29Red HatAnyoptimize MyISAM leads to corrupted index
840812016-12-06
18:38
2017-02-01
23:17
MySQL Server: OptionsVerified
(1506 days)
S35.7.14, 5.7.16UbuntuAnysuper_read_only and read_only not allowing OPTIMIZE TABLE on 5.7
864602017-05-25
14:19
2017-06-14
3:38
MySQL Server: InnoDB storage engineVerified
(1333 days)
S35.6 5.7AnyAnyDeleted DOCID are not maintained during OPTIMIZE of InnoDB FULLTEXT tables
Showing all 29 (Edit, Save, CSV, Feed)