InnoDB internal behaviour

MySQL & MariaDB Other MySQL® Questions
1

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.

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 [url]http://dev.mysql.com/doc/refman/5.5/en/show-table-status.html[/url]

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.