CODEWITHSUNDEEP
indexingkeylimitmariadb
MichaelRpdx
MichaelRpdx

Reputation: 233

What is the index key size limit in MariaDB?

In MySQL "An index key for a single-column index can be up to 767 bytes. The same length limit applies to any index key prefix."

Reviewing and searching the MariaDB documentation I cannot find a reference to this, or a similar, limit.

What is this limit?
What is the link to the documentation page I didn't find?

Upvotes: 3

Views: 8344

Answers (1)

Hartmut Holzgraefe
Hartmut Holzgraefe

Reputation: 2765

It is a bit hidden, but e.g.

https://mariadb.com/kb/en/mariadb/documentation/storage-engines/converting-tables-from-myisam-to-innodb/

says:

The maximum length of an INDEX is different between the Engines. [...] MyISAM allows 1000 bytes; InnoDB allows 767 bytes [...]

So the limit is engine specific, but the limits are not different between MySQL and MariaDB.

PS: if in doubt MySQL and MariaDB are still similar enough that anything that is not explicitly documented as being different is still the same

Upvotes: 3

Related Questions