List:General Discussion« Previous MessageNext Message »
From:js Date:October 27 2007 2:25pm
Subject:Re: Table Size
View as plain text  
Have you tried optimize table?

On 10/27/07, Josh <josh2780@stripped> wrote:
> Hello,
>
> I have a database that is growing at a rate of 4-5 MB per day (that number is getting
> larger as well).  Not too bad but I'm trying to clean up the tables to minimize the amount
> of space they take up.
>
> I have one particular table that has 2 columns:
> rolID  int(10) unsigned
> repID  int(10) unsigned
>
> Both are foreign keys to other tables.
>
> A "show table status" shows that this table has a Data_length=1081344 bytes.
> http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html shows that integers
> take up 4 bytes of space.
> There are currently 10472 rows in the table.
>
> 10472 x 4 x 2 = 83776
>
> What am I calculating wrong?  Why is the Data_length value so much larger?
>
> Thanks.
Thread
Table SizeJosh27 Oct
  • Re: Table SizeBaron Schwartz27 Oct
  • Re: Table Sizejs27 Oct
Re: Table SizeJosh27 Oct
  • Re: Table SizeBaron Schwartz27 Oct
    • Re: Table SizeDan Nelson28 Oct
      • Re: Table SizeBaron Schwartz28 Oct
Re: Table SizeJosh27 Oct
Re: Table SizeJosh2 Nov
  • Re: Table SizeBaron Schwartz2 Nov