Hi!
I need to figure out how much disk space an arbitrary number of rows in a table
take up. For example
SELECT DISK_SPACE(*) FROM ORDERS WHERE CREATED_AT BETWEEN x AND y
I know i could do something like a mysqldump with conditions and analyze the
output file but i'd like to avoid outputting anything to the filesystem as it's
slow.
My underlying db type is InnoDB on Server version: 5.0.75-0ubuntu10.2
Any help would be much appreciated.
-John
_________________________________________________________________
Bing™ brings you maps, menus, and reviews organized in one place. Try it now.
http://www.bing.com/search?q=restaurants&form=MLOGEN&publ=WLHMTAG&crea=TEXT_MLOGEN_Core_tagline_local_1x1
