-
Notifications
You must be signed in to change notification settings - Fork 10
Remove and Restore a table
Every table created will be loaded when db starts, and has its own memory and storage cost. In the case that a table is discarded, or replaced by a new designed version, you may want to remove it from the whole list, release its memory but not to delete its data from storage since it may be in future use.
LunarBase exposes two APIs to REMOVE and RESTORE a table.
#Remove
LunarDB l_db = LunarDB.getInstant();
String table_to_be_removed = "test_table";
l_db.removeTable(table_to_be_removed );
After calling this, "test_table" will be closed immediately, all its memory will be released, and it becomes invisible to any other db APIs.
When database restarts, this table will not be loaded. Nothing can be inserted into, updated, or retrieved from this table.
#Remove
LunarDB l_db = LunarDB.getInstant();
String table_is_removed = "test_table";
l_db.restoreTable(table_is_removed);
Then "test_table" works again. You may remember what the table name is when you try to restore it.
1 Home
1.1 summary
1.2 System Preparation
1.3 When LunarBase is your best choice
1.4 Benchmark
1.5 Power consumption
2 Data Model And Process
2.1 Why internal big cache
2.2 Memory Management: LunarMMU
2.3 Garbage Collection
2.4 Transaction Log
2.5 JOIN via materialized view
3 Real Time Computation: LunarMax
3.1 In-Memory File System: Memory Estimation
3.2 Configuration
3.3 Use SSD as a cheaper memory
3.4 Data Safety
3.5 HE Server VS. Cluster
3.6 High Availability
4 Create a database
4.1 Three modes
4.2 creation.conf settings
4.3 Table space
4.4 Multiple Instance
4.5 Database Status
4.6 Remove and Restore a table
5 Insertion
5.1 Insert as normal record
5.2 Insert to search engine
6 Query
6.1 Point Query
6.2 Result Handler: register your own event handler
6.3 Interpreter Pattern: complex query conditions
6.4 Range Query
6.5 Full-text Search
6.6 Algebraic Logical Query
8 Deletion
9 Materialized view
9.1 Eventual consistency
9.2 Update
9.3 MVCC in LunarBase
9.4 Easy JOIN via denormalization
9.5 CRUD in view
10 Distributed integration with
10.1 Kafka
10.2 Storm
10.3 Spark
11 Storage: Lunar Virtual File System
13 Roadmap of LunarBase future
15 FAQ