136:
In MariaDB and before MySQL 5.6, MEMORY was used for internal temporary tables, e.g. to materialize the intermediate results of a query. However, MEMORY tables don't support BLOB and TEXT types, and the user may limit the total size of MEMORY tables and temporary tables. When an internal temporary
133:
MEMORY is designed to store data that must be accessed quickly, for example caches, or intermediate data that needs to be transformed before storing it to regular tables.
203:
104:
157:
125:
MEMORY writes table data in-memory. While the table structures are persisted on-disk, the rows in MEMORY tables are lost when MySQL stops.
428:
215:
341:
257:
81:
137:
table could not be created with the MEMORY engine, it had to be created on disk, which is slower. For this reason
449:
316:
464:
408:
326:
196:
138:
331:
321:
288:
189:
169:
393:
64:
403:
212:
108:
41:
145:
181:
459:
76:
52:
69:
454:
236:
93:
57:
17:
443:
377:
175:
372:
273:
241:
36:
311:
356:
346:
351:
101:
45:
306:
278:
27:
Storage engine for the MySQL relational database management systems
398:
283:
97:
148:
engine is used in place of MEMORY for internal temporary tables.
111:
and MariaDB. Before the version 4.1 of MySQL it was called Heap.
185:
141:
implemented improvements to MEMORY to support BLOB and TEXT.
120:
Hash based, stored in memory, useful for temporary tables
421:
386:
365:
297:
266:
250:
229:
222:
75:
63:
51:
35:
197:
8:
30:
226:
204:
190:
182:
29:
105:relational database management systems
7:
216:free and open-source software (FOSS)
158:Comparison of MySQL database engines
429:Google LLC v. Oracle America, Inc.
25:
1:
144:In MySQL 8.0, by default the
118:command describes MEMORY as:
178:in the MariaDB KnowledgeBase
481:
172:in the MySQL documentation
82:GNU General Public License
170:The MEMORY Storage Engine
409:Oracle VM Server for x86
327:Java (software platform)
18:MEMORY (storage engine)
332:Maxine Virtual Machine
322:Image Packaging System
289:Oracle NoSQL Database
251:Programming languages
394:Java Desktop System
32:
404:Oracle Grid Engine
437:
436:
417:
416:
366:Operating systems
300:development tools
87:
86:
16:(Redirected from
472:
450:Database engines
227:
206:
199:
192:
183:
117:
53:Operating system
33:
21:
480:
479:
475:
474:
473:
471:
470:
469:
465:Oracle software
440:
439:
438:
433:
413:
382:
361:
299:
293:
262:
246:
218:
210:
166:
154:
131:
115:
107:, developed by
70:Database engine
28:
23:
22:
15:
12:
11:
5:
478:
476:
468:
467:
462:
457:
452:
442:
441:
435:
434:
432:
431:
425:
423:
419:
418:
415:
414:
412:
411:
406:
401:
396:
390:
388:
384:
383:
381:
380:
375:
369:
367:
363:
362:
360:
359:
354:
349:
344:
339:
334:
329:
324:
319:
314:
309:
303:
301:
298:Frameworks and
295:
294:
292:
291:
286:
281:
276:
270:
268:
264:
263:
261:
260:
254:
252:
248:
247:
245:
244:
239:
237:OpenOffice.org
233:
231:
224:
220:
219:
211:
209:
208:
201:
194:
186:
180:
179:
173:
165:
164:External links
162:
161:
160:
153:
150:
139:Percona Server
130:
127:
94:storage engine
85:
84:
79:
73:
72:
67:
61:
60:
58:Cross-platform
55:
49:
48:
39:
26:
24:
14:
13:
10:
9:
6:
4:
3:
2:
477:
466:
463:
461:
458:
456:
453:
451:
448:
447:
445:
430:
427:
426:
424:
420:
410:
407:
405:
402:
400:
397:
395:
392:
391:
389:
385:
379:
376:
374:
371:
370:
368:
364:
358:
355:
353:
350:
348:
345:
343:
340:
338:
335:
333:
330:
328:
325:
323:
320:
318:
315:
313:
310:
308:
305:
304:
302:
296:
290:
287:
285:
282:
280:
277:
275:
272:
271:
269:
265:
259:
256:
255:
253:
249:
243:
240:
238:
235:
234:
232:
228:
225:
221:
217:
214:
207:
202:
200:
195:
193:
188:
187:
184:
177:
174:
171:
168:
167:
163:
159:
156:
155:
151:
149:
147:
142:
140:
134:
128:
126:
123:
121:
112:
110:
106:
103:
99:
95:
91:
83:
80:
78:
74:
71:
68:
66:
62:
59:
56:
54:
50:
47:
43:
40:
38:
34:
19:
378:Oracle Linux
336:
230:Applications
143:
135:
132:
124:
119:
116:SHOW ENGINES
113:
89:
88:
37:Developer(s)
373:OpenSolaris
274:Berkeley DB
444:Categories
242:VirtualBox
312:GlassFish
267:Databases
146:TempTable
129:Use cases
357:VisualVM
347:NetBeans
223:Software
152:See also
460:MariaDB
422:Related
352:OpenJDK
342:Nashorn
317:HotSpot
102:MariaDB
77:License
46:MariaDB
337:Memory
307:DTrace
279:InnoDB
213:Oracle
176:MEMORY
109:Oracle
90:MEMORY
42:Oracle
31:MEMORY
455:MySQL
399:OCFS2
387:Other
284:MySQL
98:MySQL
92:is a
258:Java
114:The
100:and
96:for
65:Type
44:and
446::
122:.
205:e
198:t
191:v
20:)
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.