disk space on arbitrary rows

--_560f5012-5b79-46a6-b707-0f07587bce93_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable


Hi!

I need to figure out how much disk space an arbitrary number of rows in a t=
able 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 th=
e output file but i'd like to avoid outputting anything to the filesystem a=
s it's slow.

My underlying db type is InnoDB on Server version: 5.0.75-0ubuntu10.2

Any help would be much appreciated.

-John
=0A=
____________________________________________________________ _____=0A=
Bing=99 brings you maps=2C menus=2C and reviews organized in one place. =
Try it now.=0A=
http://www.bing.com/search?q=3Drestaurants&form=3DMLOGEN&pub l=3DWLHMTAG&cre=
a=3DTEXT_MLOGEN_Core_tagline_local_1x1=

--_560f5012-5b79-46a6-b707-0f07587bce93_--