the improved memory engine documentation doesn't mention that temp tables don't use this optimization completely
| Affects | Status | Importance | Assigned to | Milestone | ||
|---|---|---|---|---|---|---|
| Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
| 5.1 |
Invalid
|
Undecided
|
Unassigned | |||
| 5.5 |
Fix Released
|
Medium
|
Hrvoje Matijakovic | |||
| 5.6 |
Fix Released
|
Medium
|
Hrvoje Matijakovic | |||
| 5.7 |
Fix Released
|
Medium
|
Hrvoje Matijakovic | |||
Bug Description
As mentioned by Laurynas: http://
One quite important feature is missing from this release however: MyISAM tables are still used for temporary tables where the MEMORY tables with dynamic row format could be used instead: for schemas containing large VARCHARs, BLOB, TEXT. Unfortunately, enabling this feature is not trivial, but we are working on this and expect to deliver it in a future release.
It is not mentioned in the documentation (at http://
I think it's quite confusing as temp tables in memory use the MEMORY storage engine, so if undocumented I would think that this improvement also counts for temp tables.
| tags: | added: doc |
| tags: | added: memory-se |
| Hrvoje Matijakovic (hrvojem) wrote | #1 |
| Hrvoje Matijakovic (hrvojem) wrote | #2 |
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #3 |
Fixed here (for 5.5): https:/