Define the data column last in cache tables in order to support memory tables on percona MySQL 5.5+

Created on 12 June 2014, about 10 years ago
Updated 26 January 2023, over 1 year ago

Columns used in an index must be before any BLOB/TEXT columns. Currently the data column is 2nd; I propose to make the data column last so that the memory table could be used for the cache_* tables.

http://www.mysqlperformanceblog.com/2011/09/06/dynamic-row-format-for-me...
http://www.percona.com/doc/percona-server/5.5/flexibility/improved_memor...

✨ Feature request
Status

Needs work

Version

10.1 ✨

Component
CacheΒ  β†’

Last updated about 10 hours ago

Created by

πŸ‡ΊπŸ‡ΈUnited States mikeytown2

Live updates comments and jobs are added and updated live.
  • Performance

    It affects performance. It is often combined with the Needs profiling tag.

  • Needs tests

    The change is currently missing an automated test that fails when run with the original code, and succeeds when the bug has been fixed.

  • Needs subsystem maintainer review

    It is used to alert the maintainer(s) of a particular core subsystem that an issue significantly impacts their subsystem, and their signoff is needed (see the governance policy draft for more information). Also, if you use this tag, make sure the issue component is set to the correct subsystem. If an issue significantly impacts more than one subsystem, use needs framework manager review instead.

Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • πŸ‡ΊπŸ‡ΈUnited States smustgrave

    This issue is being reviewed by the kind folks in Slack, #needs-review-queue-initiative. We are working to keep the size of Needs Review queue [2700+ issues] to around 400 (1 month or less), following Review a patch or merge request β†’ as a guide.

    Tagging for tests
    As mentioned in #17 this would need a path forward, some kind of update hook I imagine.
    Tagging for subsystem review for their thoughts on this change also.

Production build 0.69.0 2024