Have you tried optimize table? On 10/27/07, Josh <[EMAIL PROTECTED]> 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.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
