[mythtv-users] Slow MySQL query after delete

[David Rees]

On 9/5/07, Michael T. Dean <mtdean at thirdcontact.com> wrote:
> In the new optimize_mythdb.pl that's in SVN trunk, we now do an ANALYZE
> TABLE in addition to the REPAIR and OPTIMIZE.

According to the MySQL docs, OPTIMIZE also updates table/index
statistics if necessary (what ANALYZE does), so I would surprised to
see to see if adding an explicity analyze actually improves anything.

-Dave