[wp-trac] [WordPress Trac] #4278: OPTIMIZE some TABLES from time to time

WordPress Trac wp-trac at lists.automattic.com
Wed May 16 17:47:39 GMT 2007


#4278: OPTIMIZE some TABLES from time to time
--------------------------+-------------------------------------------------
 Reporter:  ozh           |       Owner:  anonymous     
     Type:  enhancement   |      Status:  new           
 Priority:  normal        |   Milestone:                
Component:  Optimization  |     Version:                
 Severity:  trivial       |    Keywords:  mysql optimize
--------------------------+-------------------------------------------------
 Ola there, I have a (minor & trivial) suggestion : from time to time, like
 when rnd(1,5) == 5, it should do no harm to "`OPTIMIZE TABLE wp_options,
 wp_comments`", since there are often data removed from this table (comment
 spams & rss feeds).



 Same thing could apply if a major delete is detected within other tables
 (posts & categories)

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


More information about the wp-trac mailing list