At 07:07 PM 7/31/2004, you wrote:
Hi Marc,

Thanks for you response.  In answer to your questions, there are no
embedded newlines and I did look at index issues.  I did not try
rebuilding the index, which would be easy to do in this case since
the tables are small (unlike a couple of my other tables that have
125+ million rows and changing indexes is measured in days instead
of minutes).

I forgot to mention in my first message that the "select count(*)..."
is the one that is wrong.  Counting all returned elements isn't too
high, the count(*) is too low.  Doing the count(*) on the same exact
table on a 4.0.17 system (the replication master) gives the correct
count.

-keith

Keith, Try doing a "Check Table tablename". See http://dev.mysql.com/doc/mysql/en/CHECK_TABLE.html

Mike


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to