MariaDB 中的索引键大小限制是多少? [英] What is the index key size limit in MariaDB?

问题描述

在 MySQL 中单列索引的索引键最长可达 767 字节.相同的长度限制适用于任何索引键前缀."

查看和搜索 MariaDB 文档我找不到对此限制或类似限制的引用.

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?

推荐答案

有点隐蔽，但是例如

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

说:

INDEX 的最大长度因引擎而异.[...] MyISAM 允许 1000 个字节；InnoDB 允许 767 字节 [...]

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

所以限制是特定于引擎的，但 MySQL 和 MariaDB 之间的限制没有区别.

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

PS:如果有疑问 MySQL 和 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

这篇关于MariaDB 中的索引键大小限制是多少?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！