In MySQL 5.1 InnoDB, does the maximum length of a VARCHAR affect secondary index size?
- by e_tothe_ipi
Assuming the data is the same either way, does the maximum length of the VARCHAR affect the space usage of a secondary index? Does InnoDB use fixed length records for indexes?
Assume that we're talking about MySQL 5.1, with the InnoDB COMPRESSED table format and that the field in question is defined as a VARCHAR with some length less than or equal…