Re: DB issues with WPMU

[Jeff Waugh <jdub bethesignal org>]

<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