List:General Discussion« Previous MessageNext Message »
From:Keith Ivey Date:March 17 2005 9:37pm
Subject:Re: ROW_SIZE or something alike
View as plain text  
Marco Neves wrote:

>> I'm looking for some way to know the size each row of a table uses in my
>>database (phisical - real disk space allocated or logical - datasize
>>ignoring compression and any control data, don't mind, anything is better
>>than nothing).

You might try using the Data_length and Index_length values from 
SHOW TABLE STATUS, divided by the number of rows.

http://dev.mysql.com/doc/mysql/en/show-table-status.html

-- 
Keith Ivey <keith@stripped>
Smokefree DC
http://www.smokefreedc.org
Washington, DC
Thread
ROW_SIZE or something alikeMarco Neves16 Mar
  • Re: ROW_SIZE or something alikeMarco Neves17 Mar
    • Re: ROW_SIZE or something alikegerald_clark17 Mar
    • Re: ROW_SIZE or something alikeKeith Ivey17 Mar
      • Re: ROW_SIZE or something alikethe Mage Merlin17 Mar