Teflon Ted
Reputation: 8846
Is MySQL index_length in bytes?
The MySQL documentation defines index_length as "The length of the index file" but doesn't specify the unit. Is it bytes?
http://dev.mysql.com/doc/refman/5.1/en/show-table-status.html
Upvotes: 14
Views: 3914
Answers (1)
Ike Walker
Reputation: 65537
Yes, it is bytes. The same holds true for the other lengths in show table status. They are all in bytes:
Avg_row_length
Data_length
Max_data_length
Index_length
Upvotes: 18
Related Questions
- What is MySQL "index_block_length"?
- INDEX LENGTH IN MYSQL
- MySQL varchar index length
- Indexed VARCHAR's key_len
- MySQL Indexes: What is Size field in Indexes?
- MySQL: Why is my index length 0.0 bytes?
- MySQL Index Length Explained
- Mysql byte length
- Does the amount of space an index on varchar(100) takes up depend on the length of the value stored?
- How do I determine the size of an index in MySQL 5.1?