Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Ananda Kumar (anandklgmail.com)
Date: Thu Jun 05 2008 - 04:11:34 CDT
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
The db server has 8 cpu, 16gb RAM, with both innodb and myisam.
Is there a way we can improve the analyze table command.