Hello,

I'm trying to estimate which disks to buy  for an mySQL DB for my clienst.....

May biggest table is around 700GB  and has following format:


TECHLOG table
        
ARDKey                          4                       Integer
TIMESTAMP                       8                       DATETIME
TECHDATA                        52                      CHAR(52)


The searches will be done by ARDKEY and TIMESTAMP...  Both of them are not 
UNIQUE.
There will be around 100000 different valuese for ARDKEY

I'll have 12 Millions of these records

I need to estimate the storeage requirements for the index files....


What is the rule of thumb to use?


Thanks
Vadim





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to