Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
1 5
Impact
~8k people reached

  • 0 posts edited
  • 0 helpful flags
  • 2 votes cast
Aug
27
comment How To Optimize and Repair InnoDB tables? ALTER and OPTIMIZE table failed
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
comment How To Optimize and Repair InnoDB tables? ALTER and OPTIMIZE table failed
The first table I tested have 1.89% fragmentation. But OPTIMIZE TABLE won't reduce it
Aug
27
comment How To Optimize and Repair InnoDB tables? ALTER and OPTIMIZE table failed
Performed the cleanup and it did a big change :) But still, mysqltuner show 5 more fragmented tables. How to check this?
Aug
27
comment How To Optimize and Repair InnoDB tables? ALTER and OPTIMIZE table failed
Perfect thanks a lot... Im going to clean it now :)
Aug
27
comment How To Optimize and Repair InnoDB tables? ALTER and OPTIMIZE table failed
Do I have to drop even the performance_schema and the mysql databases?
Aug
27
comment How To Optimize and Repair InnoDB tables? ALTER and OPTIMIZE table failed
@ypercube ok :) I'll wait for his comment.. I hsve file per table off.. is it ok?
Aug
27
comment How To Optimize and Repair InnoDB tables? ALTER and OPTIMIZE table failed
@RolandoMySQLDBA innodb_file_per_table | OFF
Aug
27
comment How To Optimize and Repair InnoDB tables? ALTER and OPTIMIZE table failed
@ypercube No I can't see any problems in the site... The sql dump of the database is 32MB (A small database)