Sample Header Ad - 728x90

Tables with engines of "MEMORY" does not get dropped when server is restarted

1 vote
1 answer
365 views
I read a description from When to Use MEMORY or NDB Cluster from the MySQL website. > Operations involving transient, non-critical data such as session > management or caching. When the MySQL server halts or restarts, the > data in MEMORY tables is lost. but my created tables with ENGINES = MEMORY were not dropped upon mysql server restart. CREATE TABLE MY_TEMPORARY_TABLE ( COLUMN_1 varchar(255) DEFAULT NULL, COLUMN_2 varchar(255) DEFAULT NULL, COLUMN_3 varchar(255) DEFAULT NULL ) ENGINE=MEMORY DEFAULT CHARSET=utf8;
Asked by Robin Joaquin (13 rep)
Jun 20, 2019, 01:11 AM
Last activity: Jun 20, 2019, 04:39 AM