Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Unanswered: InnoDB Table Size


    I have a table that seems WAY larger then it should and I'm not sure why. Here is my table layout:

    table data,
    id (int) PRIMARY KEY
    fc_id (int) FOREIGN KEY
    topic_id (int) FOREIGN KEY
    xref_id (int) FOREIGN KEY
    time_id (int) FOREIGN KEY
    data (float)

    All of the foreign keys are indexed and I have 242559 rows and the space usage is:

    Data 13,840 KB
    Index 22,592 KB
    Total 36,432 KB

    If I add up the field sizes and multiple that by rows its about half the size its reports for Data. If anyone can help explain the size of my table I would greatly appreciate it.

  2. #2
    Join Date
    Jan 2003
    Paris, France
    Could you give use your index definition ?
    Olivier Miossec

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts