I need to figure out how much disk space an arbitrary number of rows in a table take up.
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.
Hotmail® has ever-growing storage! Don’t worry about storage limits.