Monthly Archives: February 2014

How to calculate a specific InnoDB index size ?

MySQL provides commands to see the overall index size versus the data size. One of them is “show table status” :

So here, we have these “estimations”, run ANALYZE TABLE before to get more accurate estimates : Data_length: 143310848, … Continue reading

Posted in tip | Leave a comment