[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:  closed
 Priority:  normal        |   Milestone:  Future Release
Component:  Database      |     Version:
 Severity:  normal        |  Resolution:  wontfix
 Keywords:  dev-feedback  |
--------------------------+-----------------------------
Changes (by pento):

 * status:  new => closed
 * resolution:   => wontfix


Comment:

 Adding an index won't improve performance for this. If a query going
 through an index reads more than 30% of the rows, MySQL will revert to a
 table scan.

 There would be no benefit to switching to enum. Even assuming a
 ludicrously massive wp_options table of 5000 rows, the space saving would
 still be less than a single InnoDB page.

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