Hello all,
I am required to analyze all the tables of our system. I need to know the key
parameters that should be taken into consideration for analysis. I am not
speaking about ANALYZE TABLE tbl name. I am required to manually look into
all table structures and pin point problems ( if any ).
If i was you i'd start reading the manual. Look under the optimization
chapter. Also, brush up on database normalization and look into how
exactly the tables are being used - run explains on the sql statements
that are used with the tables and see how you can optimize index usage.
Ratheesh K
Ratheesh K J wrote:
Hello all,
I am required to analyze all the tables of our system. I need to know the key
parameters that should be taken into consideration for analysis. I am not speaking
about ANALYZE TABLE tbl name. I am required to manually look into all table
structures and pin point
. 6 months).
So how large can a table be? As large as you want.
- Original Message -
From: Ratheesh K J [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, August 03, 2006 2:42 AM
Subject: Table analysis - Help required urgently
Hello all,
I am required to analyze all
