<quote who="Owen Taylor"> > I did: > > create index wp_1_options_autoload on wp_1_options (autoload); > > And sure enough 'show processlist' suddenly went from 90+ active > connections to just a couple.
I just mentioned this on a bug report upstream, where the possibility of adding an index on autoload has been discussed (for WordPress 2.9): http://core.trac.wordpress.org/ticket/2699 - Jeff -- linux.conf.au 2010: Wellington, NZ http://www.lca2010.org.nz/ "Basically my philosophy on release management is that it should be like police brutality." - Maciej Stachowiak _______________________________________________ gnome-infrastructure mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-infrastructure
