89498

Safe slave shutdown when using temporary tables. Temporary tables are replicated except

in the case where you stop the slave server (not just the slave threads) and you have replicated

temporary tables that are open for use in updates that have not yet been executed on the slave. If you

stop the slave server, the temporary tables needed by those updates are no longer available when

the slave is restarted. To avoid this problem, do not shut down the slave while it has temporary tables

open. Instead, use thefollowing procedurę:

1.    Issue a stop slave SQL_THREAD statement.

2.    Use SHOW STATUS to check the value of the Slave_open_temp_tables [613] variable.

3.    If the value is not 0, restart the slave SQL thread with START SLAVE SQL_THREAD and repeat the

procedurę later.

4.    When the value is 0, issue a mysqladmin shutdown command to stop the slave.