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.
Fixed here (for 5.5): https:/ /github. com/percona/ percona- server/ pull/439