[wp-hackers] Options table' varchar 64.
morgan.tocker at oracle.com
Tue Jun 24 18:01:26 UTC 2014
On Jun 24, 2014, at 6:42 AM, Haluk Karamete <halukkaramete at gmail.com> wrote:
> Is there a harm to change the options table so that the field names for the
> transients can have varchar 128 as opposed to varchar 64 and if that's
> okay, what's the best way to do this?
It will lock up the table to extend the VARCHAR, while in the background it fills a temporary table to replace the existing table.
I loaded the wp_options table with 104994 dummy records to test how long this would take. On my local machine:
* 1.71 sec using InnoDB
* ~2.84 sec when using MyISAM.
Gist available for anyone wanting to try and reproduce:
In MySQL 5.7 this will be online for InnoDB tables:
MySQL Community Manager
Oracle Canada - Hardware and Software, Engineered to Work Together.
Office: Toronto, Canada
More information about the wp-hackers