[wp-trac] [WordPress Trac] #24044: Add index to wp_options to aid/improve performance

[WordPress Trac]

#24044: Add index to wp_options to aid/improve performance
--------------------------------+------------------------------
 Reporter:  DanBUK              |       Owner:
     Type:  enhancement         |      Status:  reopened
 Priority:  normal              |   Milestone:  Awaiting Review
Component:  Options, Meta APIs  |     Version:
 Severity:  major               |  Resolution:
 Keywords:  has-patch           |     Focuses:  performance
--------------------------------+------------------------------

Comment (by jkhongusc):

 @jeichorn -
 I was implying that there may be a flaw in the logic when all options are
 loaded; essentially when calling wp_load_alloptions() .  wp_options is
 site-wide data.  IMO autoloading data should optimally occur once per
 server instance, across all instances pseudo-simultaneously.

 I submit that in a high traffic environment, like ours having 100
 (dynamic) requests per second, could result in a similar database CPU
 lockup even with the autoload index.  When the 'alloption' cache is
 deleted, WP will attempt to refresh the cache for every single request
 until that cache is added. If there are lots of transients (thousands) the
 query could take too long to fulfill before the next set of requests come
 in.  Then a cascading issue occurs and the database CPU locked at 100%.
 Sounds like a design flaw that will only hit high traffic sites.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/24044#comment:64>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform