disk space on arbitrary rows

2009-09-30 Thread John Dove
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 outp

disk space on arbitrary rows

2009-09-30 Thread John Dove
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 outputtin