WordPress.org
Get WordPress

Make WordPress Core

Changes between Version 1 and Version 2 of Ticket #53958, comment 4


Ignore:
Timestamp:
08/25/2021 02:15:20 PM (4 years ago)
Author:
wishe
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #53958, comment 4

    v1 v2  
    2323''The default row format for InnoDB tables is defined by innodb_default_row_format variable, which has a default value of DYNAMIC.''
    2424
    25 So according to the MySQL manual, with default settings MySQL actually supports index sizes up to 768(3072/4) characters.
     25So according to the MySQL manual, with default settings MySQL actually supports index sizes up to 768(3072/4) characters assuming utf8mb4.
    2626
    2727**So this for me raises the question further, why are we limiting the index sizes to 191 characters? Is this to support more database setups? Older database setups? Or is there something that I am missing in my interpretation of the problem?**