mysql rebuild index

1. use force

   전체 데이터를 reorganize

    alter table tablename force

 

2. optimize table

    전체 full text index만 rebuild

    set innodb_optimize_fulltext_onliy=1

    optimize table tablename;