[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
noreply at wordpress.org
Mon Dec 19 19:36:31 UTC 2022
#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
More information about the wp-trac
mailing list