0

The official MySQL documentation the the MEMORY storage engine covers maximum table size (in MB) but the maximum number of columns that can be defined on a table is not specified.

This question is specifically about the MEMORY storage engine - not InnoDB or MySQL in general.

Rasmus B
  • 3
  • 2

1 Answers1

0

From This MySQL link

There is a hard limit of 4096 columns per table, but the effective maximum may be less for a given table. The exact limit depends on several interacting factors.

  • Every table (regardless of storage engine) has a maximum row size of 65,535 bytes. Storage engines may place additional constraints on this limit, reducing the effective maximum row size.

...

These are engine-independent MySQL limits. As you say the MEMORY engine specific manual pages do not seem to specify any additional restrictions for size or count.

Shanky
  • 19,148
  • 4
  • 37
  • 58
jkavalik
  • 5,249
  • 1
  • 15
  • 20