[wp-hackers] Options table' varchar 64.

Morgan Tocker 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:

- Morgan

Morgan Tocker
MySQL Community Manager
Oracle Canada - Hardware and Software, Engineered to Work Together.
Office: Toronto, Canada

More information about the wp-hackers mailing list