wp_options > option_name length

[akshay_raje]

In the structure of wp_options, the option_name length is varchar(64).

It makes sense to change this to varchar(255) for the following reasons:

• To make it inline with wp_postmeta and wp_usermeta schema
• As the table is also used to store transient data (in absence of object cache plugins etc), 64 characters is often less for md5 hash based keys leading to cache misses.

[nofearinc]

Related: #29879

[nofearinc]

Uploading the PHP file is not considered a legitimate patch, please consider creating a proper patch with SVN or Git following the ​Submitting a Patch guide from the handbook :)

Also, changing the schema could be quite dangerous for various reasons (locking, performance and data volume issues for large projects etc) so it should be inspected carefully.

[jdgrimes]

This is a duplicate of #13310.