123 reputation
15
bio website techhamlet.com
location Sri Lanka
age
visits member for 2 years, 2 months
seen Oct 19 at 12:06

Pubudu Kodikara is a writer at Tech Hamlet (www.techhamlet.com), a state of the art tech blog which have a main target of educating people about the latest technology. They post latest tech news, tips on how to resolve problems, tricks and hacks to improve what you do, tutorials to learn new things and many more.


Sep
24
awarded  Autobiographer
Apr
12
awarded  Notable Question
Jan
15
awarded  Popular Question
Sep
19
awarded  Student
Aug
28
awarded  Scholar
Aug
28
accepted How To Optimize and Repair InnoDB tables? ALTER and OPTIMIZE table failed
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
awarded  Supporter
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)
Aug
27
asked How To Optimize and Repair InnoDB tables? ALTER and OPTIMIZE table failed