Helo all,

Just wanted to know when should a Table be considered for partitioning ( or 
should it be archiving ).

Almost all of our tables are of Innodb type. I am looking for an estimate 
rather than a "Depends on situation" kind of an answer.

We have few of our table swhich are very huge ( in terms of number of rows ), > 
70 lac rows. Should this be a factor for table partitioning or should the 
actual data size be a factor. 

1) In that case for a system with 80 GB reserved for MySQL when should we worry 
about Table sizes?

2) We have 3 specific tables which are of size 5GB, 3GB and 1.7GB respectively. 
The first two of them have more than 70 lakh rows. As a preventive measure what 
could     be the best way to optimize these tables?


Thanks,

Ratheesh Bhat K J

Reply via email to