Administrator Rows vs actual number of records

[Vadim]

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

[Bill Karwin]

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.

[Vadim]

Ok
Thanks