[wp-trac] [WordPress Trac] #14258: wp_options and MySQL's "log-queries-not-using-indexes" config

[WordPress Trac]

#14258: wp_options and MySQL's "log-queries-not-using-indexes" config
--------------------------+-----------------------------
 Reporter:  pkirk         |       Owner:
     Type:  enhancement   |      Status:  new
 Priority:  normal        |   Milestone:  Future Release
Component:  Database      |     Version:
 Severity:  normal        |  Resolution:
 Keywords:  dev-feedback  |
--------------------------+-----------------------------

Comment (by goatherd):

 What got me irritated too is the fact that autoload seems to be a boolean
 type (yes/no) yet is defined as varchar(20) of default database charset
 wasting up to 7 Bytes per row (for utf8_*).

 It could be just as well defined as enum('yes', 'no') for single-byte
 storage and smaller index.

 Also in some cases (slow machine, many options) the query reached well
 above 0.1 seconds without index.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/14258#comment:2>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software