I need some information on when the values returned by
SHOW TABLE STATUS are updated. At least while using
InnoDB, the Rows and Avg_row_length fields update
constantly (even though they are inaccurate), while
the Data_length and Index_length seem to be updated
sluggishly.
If you run "SHOW TABLE STATUS LIKE 'mytable'"
repeatedly (at least with InnoDB), the Rows and
Avg_row_length values change constantly. On the other
hand, I have a loop (in java) where the
Data_length+Index_length are captured, then a bulk
delete statement is run (delete from mytable where id
in (....)), and the Data_lenght+Index_length is
recaptured! The problem is, I get the same values at
the same value at the start and end of the loop. A
few moments/seconds/???? the value is changed, but by
then it's too late.
So, could someone please shed light on how the
Data_length and Index_length fields are calculated,
and more importantly, how often or what event causes
them to be updated?
Thanks!
The only "dumb question" is the one you were too afraid to ask.
________________________________________
Check out RouteRuler - Free software for runners, cyclists, walkers, etc.
http://routeruler.sourceforge.net
________________________________________
Get a handle on your data with "pocOLAP", the "little" OLAP project
http://pocolap.sourceforge.net
________________________________________
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
