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.
Thanks
kats
Subject
Views
Written By
Posted
Table Deleted Automatically Under No Replication
5486
November 22, 2014 01:46AM
1909
November 23, 2014 10:17PM
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.