Timeline for How To Optimize and Repair InnoDB tables? ALTER and OPTIMIZE table failed
Current License: CC BY-SA 3.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S Sep 19, 2012 at 12:45 | history | suggested | Hannah Vernon♦ | CC BY-SA 3.0 | improved formatting |
| Sep 19, 2012 at 3:38 | review | Suggested edits | |||
| S Sep 19, 2012 at 12:45 | |||||
| Sep 13, 2012 at 22:04 | review | First posts | |||
| Sep 19, 2012 at 3:38 | |||||
| Aug 28, 2012 at 2:18 | vote | accept | THpubs | ||
| Aug 27, 2012 at 15:47 | answer | added | RolandoMySQLDBA | timeline score: 4 | |
| Aug 27, 2012 at 15:43 | comment | added | THpubs | @ypercube ok :) I'll wait for his comment.. I hsve file per table off.. is it ok? | |
| Aug 27, 2012 at 15:36 | comment | added | ypercubeᵀᴹ | With such a tiny database, I don't think you should worry at all. Rolando should comment really, on when and if you should run OPTIMIZE and REPAIR on InnoDB tables (or provide links to his previous answers). | |
| Aug 27, 2012 at 15:35 | comment | added | THpubs | @RolandoMySQLDBA innodb_file_per_table | OFF | |
| Aug 27, 2012 at 15:33 | comment | added | THpubs | @ypercube No I can't see any problems in the site... The sql dump of the database is 32MB (A small database) | |
| Aug 27, 2012 at 15:31 | comment | added | RolandoMySQLDBA | Please run SHOW VARIABLES LIKE 'innodb_file_per_table'; and tell me, is it enabled or disabled ??? | |
| Aug 27, 2012 at 15:22 | comment | added | ypercubeᵀᴹ | Is the fragmentation causing problems? How big are the tables we are talking about? | |
| Aug 27, 2012 at 15:06 | history | asked | THpubs | CC BY-SA 3.0 |