oix ppl,
sorry sending this here, but in the user list nobody seems to have an answer
to this.
Can anyone help me?
thanks
mpneves
---------- Forwarded Message ----------
Subject: ROW_SIZE or something alike
Date: Wednesday 16 March 2005 14:09
From: Marco Neves <mpneves@stripped>
To: mysql@stripped
oix ppl,
sorry for the question, but I looked in the Manual online and didn't find
nothing that do this that I'm looking for, so I'm hopping someone can help
me.
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).
The way I was thinking this could be got was with something like:
SELECT ROW_SIZE(),* FROM tablename WHERE somefield=somevalue;
or
SELECT group__id, SUM(ROW_SIZE()) grpsize FROM tablename GROUP BY group__id;
This is what I thought would be great to have, but any other way to get a
row size would be good enought.
This could be both Data and Index size for each row, but data would be good
enought.
There is anyway to get this information?
Thanks,
mpneves
-----------------------------------------------
--
Marco Paulo Neves
MySQL Core Certified
Linux Certified Professional
http://themage.bliker.com
