I was wondering if someone could help advise me on calculating
database size estimations. Assume the following table:
Field Type Null Default
type enum('user','group') No user
id smallint(6) No 0
action smallint(6) No 0
flag enum('Y','N') No N
Keyname Unique Field
PRIMARY Yes id
PRIMARY Yes action
PRIMARY Yes type
Say I want to size this table for 20,000 entries, I would estimate
that the data would consume (5 * 20,000 + 2 * 20,000 + 2 * 20,000 +
1 * 20,000) = 200,000 bytes. Right?
But how do I estimate the amount of disk space the indexes (keys)
will consume? The table is MyISAM.
Thanks in advance,
Adam
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
