ber 19, 2002 8:44 AM
> To: Andrew Kuebler
> Cc: [EMAIL PROTECTED]
> Subject: Re: Storage Requirements Not Equal to Actual Disk Space
> Used...
>
> mysql needs a few more bytes per record for its internal use.
> Since you use a VARCHAR, you have dynamic length records
mysql needs a few more bytes per record for its internal use.
Since you use a VARCHAR, you have dynamic length records;
this is described in the manual:
http://www.mysql.com/doc/en/Dynamic_format.html
Regards,
Joseph Bueno
Andrew Kuebler wrote:
> I have a table with 17,168,035 records. I have the
Did you optimze the table first?
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 requiremen
