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 <[EMAIL PROTECTED]>
Smokefree DC
http://www.smokefreedc.org
Washington, DC

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to