Hi All, We have proc which create around 7 table, inserts data , creates indexes and then run analyze table command.
The analyze table command on 7 tables are taking around 18 hrs. They are myisam table. The db server has 8 cpu, 16gb RAM, with both innodb and myisam. Is there a way we can improve the analyze table command. regards anandkl
