472,110 Members | 2,207 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,110 software developers and data experts.

Administrator Rows vs actual number of records

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.

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

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

Bill K.
Apr 27 '06 #2

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 Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.