network profile
| bio | website | techhamlet.com |
|---|---|---|
| location | Sri Lanka | |
| age | ||
| visits | member for | 9 months |
| seen | Aug 28 '12 at 4:30 | |
| stats | profile views | 2 |
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.
|
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 |
