[mythtv-users] HELP*** DB crashed - How long for optimize_mythdb.pl to complete on pretty large DB?

[Another Sillyname]

2009/5/1 Another Sillyname <anothersname at googlemail.com>:
> My DB borked a little while ago and I'm running optimize_mythdb.pl to
> clean it up......
>
> I'm watching the db through Mysql administrator GUI frontend and it
> currently is showing
>
> sorting index | optimize table `mythconverg`.`archiveitems`
>
> How long should this take on a DB with about a years worth of recording data?
>
> It's currently been running for nearly 7000 seconds but htop shows no
> processor load
>
> Is this really running or just hung?
>
> How can I tell from mysql admin what's actually going on?
>
> Thanks in advance
>

Ignore the above......the partition had run out of space and my detect
low space job had crashed

All fixed now