Not the answer you need?
Register and ask your own question!

InnoDB internal behaviour

antoniofernandezantoniofernandez EntrantCurrent User Role Beginner
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.

Comments

  • mirfanmirfan Database Administrator Inactive User Role Beginner
    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/en/show-table-status.html
  • antoniofernandezantoniofernandez Entrant Current User Role Beginner
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.