I have a memory table with a few hundred thousand rows. As soon as I add an
index to the table, it loses 75% of the rows! No error is produced in the
log file or on the client machine. The rows 'A' to 'E' are present, but
rows 'F' to 'Z' are missing.
I have max_heap_table_size=1024M and tmp_table_size=1024M which should be
plenty of RAM.
1) Why does adding an index lose the rows?
2) Why wasn't an error reported?
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]