I had created a Memory table by joining 3 tables together. For some reason
it was giving me only 25% of the rows that I should have been getting and
there were no errors (I checked the error log). So I was missing a few
thousand rows from the memory table. I switched the table to MyISAM and got
all the rows.
My current settings are:
max_heap_table_size=512M and tmp_table_size=512M
When I changed it to:
max_heap_table_size=1024M and tmp_table_size=1024M
and restarted MySQL, the memory table has the correct number of rows.
So why didn't I get some sort of error saying the creation of the memory
table failed?
Or why didn't it write the memory table out to disk?
(There was still plenty of memory on the machine and it wasn't running low
on memory).
Mike
MySQL 5.0.24a
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
