oix ppl, thanks a lot for the answers, but if it was this simple I wouldn't ask...
Yes, I am Core Certificate, and yes I did read the show-table-status page. BUT, that don't satisfy my needs. The sugestion to use data_length divided by the number of rows is good if all rows have a fixed length, that don't happen if there is one or more text/blob field in the table, in which case the row size is diferent depending in that field(s) content. Any other ideia? Thanks, mpeves On Thursday 17 March 2005 21:37, Keith Ivey wrote: > 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 -- Merlin, the Mage www.code.online.pt www.cultodavida.online.pt Carpe Vitam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
