[wp-trac] [WordPress Trac] #10592: Options table overhead leads to 500 server error

[WordPress Trac]

#10592: Options table overhead leads to 500 server error
--------------------------+-------------------------------------------------
 Reporter:  ryan          |       Owner:     
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  2.9
Component:  Optimization  |     Version:  2.9
 Severity:  normal        |    Keywords:     
--------------------------+-------------------------------------------------
Changes (by Mittineague):

 * cc: Mittineague (added)


Comment:

 Options table bloat has been a problem for a while, it's why I wrote the
 Clean Options plugin. AFAIK the main problem is from old rss_[hash] and
 rss_[hash]_ts rows left over from feed caching. Although many
 plugins/themes do not clean up after themselves when they're removed, I
 gather from my plugin users that have left feedback that old plugin/theme
 options are less of a problem.

 It seems with the switch from Magpie to SimplePie the cached feed rows are
 now "transient" and so far, unlike the "rss" rows, they seem to be taking
 care of themselves.

 If this in fact the case, it might be possible to put code in somewhere
 that will remove all the old "rss" rows.

 *Note, if you use regex to remove them, take care not to remove the
 "rss_excerpt_length", "rss_use_excerpt", or "rss_language" options.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/10592#comment:1>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software