GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

InnoDB internal behaviour

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • InnoDB internal behaviour

    Hi everybody, my name is Antonio and I have a question about InnoDB internal works.

    Sorry in advance if this topic is out of the correct forum.

    I would like to know what is InnoDB's behaviour when I define an index over one column that will contains the reference to the row and the column's data. Column's data is also stored in RAM (Already it's stored in the index)?
    I think that yes but my office partner cause me a doubt. We would like to know the meaning of data lenght and index lenght for a table and what implies.

    Thanks in advance for your help.

    Regards,

    Antonio.
    Learning and learning and learning ...

  • #2
    data length is total size of data file while index length implies to total index size of that particular table. You can find further details on MySQL manual page here http://dev.mysql.com/doc/refman/5.5/...le-status.html

    Comment


    • #3
      Thanks for your reply.

      I have clear this concept but, when I define an index that index stores the reference to the row and ¿the value of the column?

      Thanks in advance.

      Regards,

      Antonio.
      Learning and learning and learning ...

      Comment

      Working...
      X