[mythtv-users] MythTV Database problem - Credits.MYI
bjm at lvcm.com
Fri Jul 1 01:14:02 UTC 2005
Scott Carr wrote:
> I have been having problems with MythFillDatabase taking FOREVER to
> input the records. This process used to take about 5 minutes, now it
> takes close to 24 hours.
> I noticed that my Credits.myi has 14000000 records and my people table
> only has 800000 records. Is there something going on here?
> If I try to list the Credits.myi table it takes forever.
$ mysql -u mythtv -pmythtv mythconverg
mysql> truncate table program;
mysql> truncate table programrating;
mysql> truncate table people;
mysql> truncate table credits;
$ mysqlcheck -r -u mythtv -pmythtv mythconverg
More information about the mythtv-users