469,945 Members | 2,361 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,945 developers. It's quick & easy.

Administrator Rows vs actual number of records

Hi!
I imported some table (about 1500 records) using "LOAD DATA LOCAL
INFILE..." (command line console). No warnings, no skipped, no deletes
- all the recored are written to be imported.
However, in MySQL Administrator UI tool I see completely different
number in the "Rows" column. Making a SELECT query shows that the
actual number of records in the table is the correct one (the same
number as in text file table). Command line SHOW TABLE STATUS FROM ...
doesn't show any of these numbers.

I would expect that the "Rows" column doesn't show the actual number of
recored. But, the information about of 100 enteries table is shown
correctly (rows=records=100).

What is going on here ?

Thanks for help.
Vadim

Apr 27 '06 #1
2 1351
Vadim wrote:
I would expect that the "Rows" column doesn't show the actual number of
recored.


Number of rows is a table statistic that is maintained as an estimate.
Believe COUNT(*) over this estimate.

Regards,
Bill K.
Apr 27 '06 #2
Ok
Thanks

Apr 29 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Matthew Kramer | last post: by
4 posts views Thread by cbrichards via SQLMonster.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.