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

 Pretty much like @archon810, we suffered months of bad performance, and
 database bandwidth usage without finding what was the cause.
 I am on a single site, not multisite.

 We had 15Mb of data in `_transient_dirsize_cache`.

 45250 folders in `wp-content/uploads`.

 One of our custom features created many folders in the uploads folder and
 slowly the perf decreased.

 I just put `autoload=no` like many of you.
 Difference is huge, night and day.

 I don't see why is it autoloaded it seems "useful" only in the backend,
 and especially for Multisite.

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