10. VOLATILE Table Usage
10. VOLATILE Table Usage
VOLATILE tables are in-memory tables shared across the server process. This chapter covers data loss on restart, UPSERT, and cache patterns that can be rebuilt.
Chapter Contents
| Section | Topics |
|---|---|
| Overview and Use Criteria | Characteristics and selection criteria |
| Table Structure and Schema | PRIMARY KEY design, column types, and schema structure |
| Create, Alter, and Drop | CREATE VOLATILE TABLE, DROP, and persistence differences |
| Data Ingestion and Modification | INSERT, ON DUPLICATE KEY UPDATE, and DELETE |
| Queries and Analysis | SELECT, predicate queries, and LIKE |
| Indexes and Performance | Red-black tree indexes and primary key indexes |
| Operations and Data Lifecycle | Operational procedures and data management |
| Constraints, Errors, and Troubleshooting | Feature limitations and error handling |
Last updated on