Re: slave crash

[Rick James]

A "temporary table" and the "tmp directory" are unrelated animals.

tmpdir is used for certain things, like ALTER TABLE.

A temp table is created in the same place a regular table is created. It goes away when the thread that created it goes away. In particular, if the slave crashes, any temp table that came through replication is lost. This means that subsequent references to the table will get the error you encountered.

> key_buffer_size=4294967296
This is unreasonably large, unless you have more than 16GB of RAM. If you are using only MyISAM (not InnoDB), then set it to about 20% of RAM.

More on memory usage:
http://mysql.rjweb.org/doc.php/memory