[wp-trac] [WordPress Trac] #10798: _transient_rewrite_rules can get too long causing MySQL error

[WordPress Trac]

#10798: _transient_rewrite_rules can get too long causing MySQL error
--------------------------+-------------------------------------------------
 Reporter:  mark8barnes   |       Owner:                
     Type:  defect (bug)  |      Status:  new           
 Priority:  normal        |   Milestone:  Future Release
Component:  General       |     Version:  2.8.4         
 Severity:  minor         |    Keywords:                
--------------------------+-------------------------------------------------
 On large sites, particularly with the permalink set to /%postname%/
 _transient_rewrite_rules can get too long, causing the "MySQL server has
 gone away" error message.

 `WordPress database error: [MySQL server has gone away]
 INSERT INTO wp_options (option_name,option_value,autoload) VALUES
 ('_transient_rewrite_rules','a:7526:{s:12:\"robots\\.txt$\";s:18:\"index.php?robots=1\
 etc.`

 Once this occurs, functionality is severely disrupted until the permalink
 settings are changed.

 I guess the easiest fix might me be to split the data in two, and store it
 in two rows.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/10798>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software