Re: slave stuck

[Gareth Williams]

I may have hit the 16MB limit since I'm using the default:
mysql> show variables like 'max_heap_table_size';
+---------------------+----------+
| Variable_name | Value |
+---------------------+----------+
| max_heap_table_size | 16777216 |
+---------------------+----------+
1 row in set (0.00 sec)

It seems a bit strange that it worked on the master but failed on the slave - very similar setups except for the non-mysql processes running on the servers.

I believe the table is an optimization for the user and should be in memory.

I'll try not replicating it and report back in case others are interested.