ha_innobase.h:

  Lower max key len to 3500 bytes because a secondary index record must also contain the primary key value


sql/ha_innobase.h:
  Lower max key len to 3500 bytes because a secondary index record must also contain the primary key value

1 files changed, 6 insertions, 4 deletions

diff --git a/sql/ha_innobase.h b/sql/ha_innobase.h
index 83e43b1d662..84698a9114b 100644
--- a/sql/ha_innobase.h
+++ b/sql/ha_innobase.h
@@ -96,10 +96,12 @@ class ha_innobase: public handler
   	uint max_record_length() const { return HA_MAX_REC_LENGTH; }
   	uint max_keys()          const { return MAX_KEY; }
   	uint max_key_parts()     const { return MAX_REF_PARTS; }
-				/* An InnoDB page must store >= 2 keys:
-				max key length is therefore set to 7000
-				bytes */
-  	uint max_key_length()    const { return 7000; }
+				/* An InnoDB page must store >= 2 keys;
+				a secondary key record must also contain the
+				primary key value:
+				max key length is therefore set to slightly
+				less than 1 / 4 of page size which is 16 kB */
+  	uint max_key_length()    const { return 3500; }
   	bool fast_key_read()	 { return 1;}
 	key_map keys_to_use_for_scanning() { return ~(key_map) 0; }
   	bool has_transactions()  { return 1;}