the improved memory engine documentation doesn't mention that temp tables don't use this optimization completely

Bug #1190983 reported by Kenny Gryp on 2013-06-14
6
This bug affects 1 person
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://www.mysqlperformanceblog.com/2011/09/06/dynamic-row-format-for-memory-tables/
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://www.percona.com/doc/percona-server/5.5/flexibility/improved_memory_engine.html) that this is true or false.

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

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1384

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers