|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
analyze table
From: Ananda Kumar (anandkl
gmail.com)
Date: Thu Jun 05 2008 - 04:11:34 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]