[mythtv-users] Re: MythTV Database problem - Credits.MYI

[Bruce Markey]

Scott Carr wrote:
> 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.
>>
> Thanks to the person that stated use truncate.  That worked like a 
> charm.  I wonder why that was needed.

Unless you receive between 3,000 and 10,000 channels, there were
way too many rows in your tables. This may have happened do to bad
data in one of your listings grabs that caused it to enter the data
repeatedly or there was memory corruption during the fill or the
DB table was hozed or something else. In any case, mfdb has to
search through all this data for things to remove or replace. These
four tables are all filled with transient data by mfdb and all data
can be replaced with a new grab. Truncate throws away all data for
the table without removing the table definition. The mysqlcheck
was to verify that the DB wasn't still hozed after removing the
data.

--  Anonymous truncate person