List:General Discussion« Previous MessageNext Message »
From:Josh Date:October 27 2007 2:09pm
Subject:Table Size
View as plain text  
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