Re: MYSQL5.7:OPTIMIZER Contradict Explain
Posted by:
yijie fu
Date: September 07, 2022 05:26AM
key_len (JSON name: key_length)
The key_len column indicates the length of the key that MySQL decided to use. The value of key_len enables you to determine how many parts of a multiple-part key MySQL actually uses. If the key column says NULL, the key_len column also says NULL.
Due to the key storage format, the key length is one greater for a column that can be NULL than for a NOT NULL column.
This explanation may have some ambiguities，not The key_len column indicates the length of the key that MySQL decided to use. Memory alignment may not be included? i cant understand it.
Subject
Views
Written By
Posted
242
September 07, 2022 05:02AM
Re: MYSQL5.7:OPTIMIZER Contradict Explain
139
September 07, 2022 05:26AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.