[wp-trac] [WordPress Trac] #54221: _transient_dirsize_cache is set to autoload=yes and kills db performance if it grows (20MB in our case)

[WordPress Trac]

#54221: _transient_dirsize_cache is set to autoload=yes and kills db performance if
it grows (20MB in our case)
--------------------------+------------------------------------------
 Reporter:  archon810     |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Future Release
Component:  Database      |     Version:  2.8
 Severity:  major         |  Resolution:
 Keywords:  needs-patch   |     Focuses:  administration, performance
--------------------------+------------------------------------------

Comment (by wpgurudev):

 I think the second approach would be useful because of following reasons.

 1. There can be some other options like `_transient_dirsize_cache` which
 can have performance impacts.

 2. There need to be a general provision to filter out such options from
 `alloptions` query which can hamper the performance.

 3. Changing the transient autoload value to `no` can have some unknown
 side-effects.

 Adding the patch here which adds a function `wp_filter_autoloaded_options`
 and a filter `exlude_autoloaded_options` to filter out the undesirable
 options from `alloptions` query.

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