[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 annemaciver):

 Question:

 (NOT using Multisite; YES using object cache)

 Is there a downside to disabling the _transient_dirsize_cache autoload?

 I'm getting a caution in Site Health that I have 1293 autoloaded options
 (size: 1 MB) in the options table, which could slow my site. The largest
 (though under 800KB) is _transient_dirsize_cache. I do have Redis/ object
 cache.

 What is the potential consequence of disabling that autoload? Any reason
 not to?

 Thanks!

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