MySQL Forums
Forum List  »  Memory Storage Engine

Table Deleted Automatically Under No Replication
Posted by: Kats Sato
Date: November 22, 2014 01:46AM

Hi community,
Heap tables are deleted automatically under the following condition.

0. MySQL 5.6.16 on Windows 7
1. No replication, single database.
2. Setup collecting binary log, then MySQL server restarted.
3. Application updated non-heap tables, some heap tables were deleted automatically.

According to 5.6 reference manual, Sec 15.3 "MEMORY Tables and Replication... DELETE statement is written to the master's binary log, to empty the table on the slaves also."

My database is not replicate configuration, using just standalone.

Your suggestion would be appreciated.


Options: ReplyQuote

Written By
Table Deleted Automatically Under No Replication
November 22, 2014 01:46AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.