var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: InnoDB Table Size
I have a table that seems WAY larger then it should and I'm not sure why. Here is my table layout:
id (int) PRIMARY KEY
fc_id (int) FOREIGN KEY
topic_id (int) FOREIGN KEY
xref_id (int) FOREIGN KEY
time_id (int) FOREIGN KEY
All of the foreign keys are indexed and I have 242559 rows and the space usage is:
Data 13,840 KB
Index 22,592 KB
Total 36,432 KB
If I add up the field sizes and multiple that by rows its about half the size its reports for Data. If anyone can help explain the size of my table I would greatly appreciate it.
Could you give use your index definition ?