List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:September 30 2009 3:09pm
Subject:Re: disk space on arbitrary rows
View as plain text  
A very  first thing you should do is to evaluate the storage needed by a
single row.
This can be done by summing up all columns data types  length in bytes and
index lenght as well.
This should be quite accurate.

Just a tip to start:
http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html

2009/9/30 John Dove <mysqlseeker@stripped>

>
>
>
>
>
>
> 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
>
> _________________________________________________________________
> Hotmail® has ever-growing storage! Don’t worry about storage limits.
>
>
> http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tutorial_Storage_062009




-- 
Claudio

Thread
disk space on arbitrary rowsJohn Dove30 Sep
  • Re: disk space on arbitrary rowsClaudio Nanni30 Sep
    • Re: disk space on arbitrary rowsShawn Green2 Oct