oix ppl, Nobody have any sugestion that can me help with this issue?
thanks mpneves On Wednesday 16 March 2005 14:09, Marco Neves wrote: > 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 -- Marco Paulo Neves MySQL Core Certified Linux Certified Professional http://themage.bliker.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
