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 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 problems ( if any ).
So it would be helpful if i could know about
1) what exactly I have to look for in the tables.
2) Index management. Which fields are to be indexed and which not
3) How big can a table be? We have tables which have more than 50 lakhs of
rows. Any select queries, insert queries or update queries are taking more time
to execute. So what is a preferable table size.
4) Any other suggestions
Thanks,
Ratheesh Bhat K J
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
