K
K
khodos_dmitry2019-08-18 19:58:31
MySQL
khodos_dmitry, 2019-08-18 19:58:31

#1071 - The specified key is too long. The maximum key length is 767 bytes. How to decide?

The table is copied normally, but without keys.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
D
Dmitry Derepko, 2019-08-18
@xEpozZ

And what is the field? text? What is the key in this field?

M
Melkij, 2019-08-19
@melkij

See settings in parts innodb_large_prefix, innodb_page_size, innodb_file_format
https://mariadb.com/kb/en/library/innodb-limitations/
https://dev.mysql.com/doc/refman/8.0/en/innodb-res. ..
Some of the conditions were not met and the base is limited to 767 bytes per element length in the index.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question