warning optimize could take long (and i think the table is locked while doing it)
Gr,
Wico
At 08:26 19-12-02 -0500, Andrew Kuebler wrote:
I have a table with 17,168,035 records. I have the following column
types and I read about the following storage requirements for each
column:
(1) INT Column - Should take up 4 bytes each
(1) MEDIUMINT Column - Should take up 3 bytes each
(1) DATE Column - Should take up 3 bytes each
(1) VARCHAR Column - Should take up Length + 1 bytes each
The INT Column should take up 4 * 17,168,035 = 68,672,140 bytes
The MEDIUMINT Column should take up 3 * 17,168,035 = 51,504,105 bytes
The DATE Column should take up 3 * 17,168,035 = 51,504,105 bytes
I ran a query for the VARCHAR column and it has a total of 141,485,442
characters plus the additional 17,168,035 characters to store the string
length. I see this column should be taking up 158,653,477 bytes.
Total I would think my table should be somewhere around 330,333,827
byes, but rather it is 444,669,952 bytes. To be over 100 meg off, I must
be doing something wrong. I did try repairing the table also to make
sure I was reading the right file size, but it stays the same. Can
anyone tell me what I am doing wrong?
Thank you in advance,
Andrew
---------------------------------------------------------------------
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
--------------------------------------------------------------------- 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
