[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:  Awaiting Review
Component:  Database      |     Version:  2.8
 Severity:  major         |  Resolution:
 Keywords:                |     Focuses:  multisite, performance
--------------------------+-------------------------------------

Comment (by vsamoletov):

 Hi all!

 Just faced the same issue!

 Mine is smaller, though:

 mysql> SELECT option_name, length(option_value) AS option_value_length
 FROM wp_options WHERE autoload='yes' ORDER BY option_value_length DESC
 LIMIT 200;
 +---------------------------------------------------------------+---------------------+
 | option_name                                                   |
 option_value_length |
 +---------------------------------------------------------------+---------------------+
 | _transient_dirsize_cache                                      |
 515393 |


 However, this is the biggest wp_option!

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