[mythtv-users] Slow MySQL query after delete

David Rees drees76 at gmail.com
Wed Sep 5 21:39:56 UTC 2007

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.


More information about the mythtv-users mailing list