James Harvard wrote:
I suppose this is an inherent limitation of transactional tables - you might
see x rows, but at the same time a use who has just inserted some rows will see
x+y rows.
However I don't see that the numbers are going to be hugely inaccurate. After
all, if the table was MyISAM and you get an exact number of rows someone could
still add another 20 rows in the second after you run SHOW TABLE STATUS.
James Harvard
At 5:54 pm -0700 1/2/06, Dan Trainor wrote:
So, now this has made me think here. If 'SHOW TABLE STATUS' only shows an
"estimate" of the number of rows contained in a table, how accurate is the rest
of the data in 'SHOW TABLE STATUS'?
What I'm looking for is to try to find some exact numbers, such as physical data size on
disk, queries/second, etc etc. An "estimate" would not give me a very good
idea of what I'm looking at.
Is there a more accurate way of getting table information, aside from 'SHOW
TABLE STATUS'?
Thanks for the response, James -
Well, doing these two calculations happens maybe 10 minutes after the
last person has sent any data to the db.
Is there any way to show the physical disk space used by a table, or
even a column? Maybe there's a whole list of functions which I'm
overseeing here that might explain this.
Thanks!
-dant
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]