Timeline for How To Optimize and Repair InnoDB tables? ALTER and OPTIMIZE table failed
Current License: CC BY-SA 3.0
15 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 23, 2017 at 12:40 | history | edited | CommunityBot | replaced http://stackoverflow.com/ with https://stackoverflow.com/ | |
| Apr 13, 2017 at 12:42 | history | edited | CommunityBot | replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/ | |
| Aug 28, 2012 at 2:18 | vote | accept | THpubs | ||
| Aug 27, 2012 at 17:43 | comment | added | RolandoMySQLDBA | let us continue this discussion in chat | |
| Aug 27, 2012 at 17:41 | comment | added | THpubs | wp_commentmeta ... The 5 tables with fragmentation are : wp_commentmeta wp_comments wp_options wp_postmeta and wp_posts (Its a wordpress site) | |
| Aug 27, 2012 at 17:40 | comment | added | RolandoMySQLDBA | What is the name of that table and what database is it in ??? | |
| Aug 27, 2012 at 17:31 | comment | added | THpubs | The first table I tested have 1.89% fragmentation. But OPTIMIZE TABLE won't reduce it | |
| Aug 27, 2012 at 17:23 | comment | added | RolandoMySQLDBA | Updated my answer... | |
| Aug 27, 2012 at 17:23 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 | added 1455 characters in body |
| Aug 27, 2012 at 16:33 | comment | added | THpubs | Performed the cleanup and it did a big change :) But still, mysqltuner show 5 more fragmented tables. How to check this? | |
| Aug 27, 2012 at 16:00 | comment | added | THpubs | Perfect thanks a lot... Im going to clean it now :) | |
| Aug 27, 2012 at 16:00 | comment | added | RolandoMySQLDBA | You do not have to drop performance_schema and the mysql databases. In fact, please do not touch the mysql schema. | |
| Aug 27, 2012 at 15:58 | comment | added | THpubs | Do I have to drop even the performance_schema and the mysql databases? | |
| Aug 27, 2012 at 15:53 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 | added 428 characters in body; deleted 2 characters in body |
| Aug 27, 2012 at 15:47 | history | answered | RolandoMySQLDBA | CC BY-SA 3.0 |