From the course: MySQL Installation and Configuration
Join today to access over 24,800 courses taught by industry experts.
Memory - MySQL Tutorial
From the course: MySQL Installation and Configuration
Memory
- [Bill] Hi, I'm Bill Wyman. The memory storage engine stores its contents in temporary memory. Data stored in a memory database is vulnerable to crashes, hardware issues, or power outages. Use these tables only as temporary storage or read-only cache for data pulled from other tables. If your server crashes or is restarted, all data in memory tables will be lost. Memory tables may perform faster than other engines, but performance is constrained by its single thread architecture and table lock overhead. Despite the in-memory architecture, memory tables are not necessarily faster than NoDB tables on a busy server under a heavy read-write workload. Always test your application under load to see if memory provides a real world speed advantage. Memory tables cannot contain blob or text columns. These tables use fixed space columns and are generally constrained by available memory on the server. Do not try to use a memory table for anything larger than a few bytes per column. Memory…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.