[mythtv-users] Mythfilldatabase is REALLY slow.

linux guy linuxguy123 at gmail.com
Sat Oct 8 20:25:51 UTC 2011


How long should it take for mythfilldatabase to run ?

My setup has 1 receiver and thus one guide to download.

It starts out fast and then stalls in the 280 KB range.

By really slow, I mean its been running for nearly an hour.

# mythfilldatabase
2011-10-08 13:21:50.266 Using runtime prefix = /usr
2011-10-08 13:21:50.266 Using configuration directory = /root/.mythtv
2011-10-08 13:21:50.266 Empty LocalHostName.
2011-10-08 13:21:50.266 Using localhost value of server.localdomain
2011-10-08 13:21:50.269 New DB connection, total: 1
2011-10-08 13:21:50.271 Connected to database 'mythconverg' at host:
127.0.0.1
2011-10-08 13:21:50.274 Closing DB connection named 'DBManager0'
2011-10-08 13:21:50.274 Connected to database 'mythconverg' at host:
127.0.0.1
2011-10-08 13:21:50.276 Current locale en_CA
2011-10-08 13:21:50.276 Reading locale defaults from
/usr/share/mythtv//locales/en_ca.xml
2011-10-08 13:21:50.286 Loading en_ca translation for module mythfrontend
2011-10-08 13:21:50.287 Current MythTV Schema Version (DBSchemaVer): 1264
2011-10-08 13:21:50.289 New DB connection, total: 2
2011-10-08 13:21:50.290 Connected to database 'mythconverg' at host:
127.0.0.1
2011-10-08 13:21:50.333 Updating source #1 (Receiver1) with grabber
schedulesdirect1
2011-10-08 13:21:50.334 Found 539 channels for source 1 which use grabber
2011-10-08 13:21:50.334
2011-10-08 13:21:50.334 Checking day @ offset 0, date: Sat Oct 8 2011
2011-10-08 13:21:50.402 Data is already present for Sat Oct 8 2011, skipping
2011-10-08 13:21:50.402
2011-10-08 13:21:50.402 Checking day @ offset 1, date: Sun Oct 9 2011
2011-10-08 13:21:50.402 Data Refresh always needed for tomorrow
2011-10-08 13:21:50.402 Refreshing data for Sun Oct 9 2011
2011-10-08 13:21:50.403 New DB DataDirect connection
2011-10-08 13:21:50.403 Connected to database 'mythconverg' at host:
127.0.0.1
2011-10-08 13:21:50.444 Retrieving datadirect data.
2011-10-08 13:21:50.444 Grabbing data for Sat Oct 8 2011 offset 1
2011-10-08 13:21:50.444 From Sun Oct 9 06:00:00 2011 to Mon Oct 10 06:00:00
2011 (UTC)
2011-10-08 13:21:50.444 Grabbing listing data
--2011-10-08 13:21:50--
http://webservices.schedulesdirect.tmsdatadirect.com/schedulesdirect/tvlistings/xtvdService
Resolving webservices.schedulesdirect.tmsdatadirect.com... 144.142.232.53
Connecting to webservices.schedulesdirect.tmsdatadirect.com|144.142.232.53|:80...
connected.
HTTP request sent, awaiting response... 401 Unauthorized
Connecting to webservices.schedulesdirect.tmsdatadirect.com|144.142.232.53|:80...
connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/xml]
Saving to: “STDOUT”

    [
<=>
] 30,484      7.59K/s              2011-10-08 13:21:55.361 New DB
connection, total: 3
2011-10-08 13:21:55.362 Connected to database 'mythconverg' at host:
127.0.0.1
2011-10-08 13:21:55.363 DataDirect: Your subscription expires on Monday Oct
15 (2012) 10:42 AM
    [
<=>                                                                      ]
61,298      8.95K/s              2011-10-08 13:22:28.879 sourceid 1 has
lineup type: Satellite
    [
<=>                                                            ]
563,204      734B/s   in 12m 47s

2011-10-08 13:36:30 (734 B/s) - written to stdout [563204]

2011-10-08 13:42:38.652 Grab complete.  Actual data from Sun Oct 9 06:00:00
2011 to Mon Oct 10 06:00:00 2011 (UTC)
2011-10-08 13:42:38.793 Main temp tables populated.
2011-10-08 13:42:38.793 Updating MythTV channels.
2011-10-08 13:42:39.032 IconData: Updating icons for sourceid: 1
2011-10-08 13:42:39.033 Channels updated.
2011-10-08 13:42:39.420 Clearing data for source.
2011-10-08 13:42:39.420 Clearing from Sun Oct 9 00:00:00 2011 to Mon Oct 10
00:00:00 2011 (localtime)
2011-10-08 13:42:59.323 Data for source cleared.
2011-10-08 13:42:59.323 Updating programs.
2011-10-08 13:43:07.821 Program table update complete.
2011-10-08 13:43:07.821
2011-10-08 13:43:07.822 Checking day @ offset 2, date: Mon Oct 10 2011
2011-10-08 13:43:07.947 Data refresh needed because only 0 out of 539
channels have at least one program listed for day @ offset 2 from 8PM -
midnight.  Previous day had 537 channels with data in that time period.
2011-10-08 13:43:07.947 Refreshing data for Mon Oct 10 2011
2011-10-08 13:43:07.980 Retrieving datadirect data.
2011-10-08 13:43:07.980 Grabbing data for Sat Oct 8 2011 offset 2
2011-10-08 13:43:07.980 From Mon Oct 10 06:00:00 2011 to Tue Oct 11 06:00:00
2011 (UTC)
2011-10-08 13:43:07.980 Grabbing listing data
--2011-10-08 13:43:07--
http://webservices.schedulesdirect.tmsdatadirect.com/schedulesdirect/tvlistings/xtvdService
Resolving webservices.schedulesdirect.tmsdatadirect.com... 144.142.232.53
Connecting to webservices.schedulesdirect.tmsdatadirect.com|144.142.232.53|:80...
connected.
HTTP request sent, awaiting response... 401 Unauthorized
Connecting to webservices.schedulesdirect.tmsdatadirect.com|144.142.232.53|:80...
connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/xml]
Saving to: “STDOUT”

    [
<=>
] 30,760      8.33K/s              2011-10-08 13:43:12.733 DataDirect: Your
subscription expires on Monday Oct 15 (2012) 10:42 AM
    [
<=>                                                             ]
563,093      706B/s   in 13m 18s

2011-10-08 13:58:15 (706 B/s) - written to stdout [563093]

2011-10-08 14:04:31.235 Grab complete.  Actual data from Mon Oct 10 06:00:00
2011 to Tue Oct 11 06:00:00 2011 (UTC)
2011-10-08 14:04:31.260 Main temp tables populated.
2011-10-08 14:04:31.762 Clearing data for source.
2011-10-08 14:04:31.762 Clearing from Mon Oct 10 00:00:00 2011 to Tue Oct 11
00:00:00 2011 (localtime)
2011-10-08 14:04:59.999 Data for source cleared.
2011-10-08 14:04:59.999 Updating programs.
2011-10-08 14:05:12.289 Program table update complete.
2011-10-08 14:05:12.289
2011-10-08 14:05:12.289 Checking day @ offset 3, date: Tue Oct 11 2011
2011-10-08 14:05:12.474 Data refresh needed because only 0 out of 539
channels have at least one program listed for day @ offset 3 from 8PM -
midnight.  Previous day had 537 channels with data in that time period.
2011-10-08 14:05:12.474 Refreshing data for Tue Oct 11 2011
2011-10-08 14:05:12.553 Retrieving datadirect data.
2011-10-08 14:05:12.553 Grabbing data for Sat Oct 8 2011 offset 3
2011-10-08 14:05:12.553 From Tue Oct 11 06:00:00 2011 to Wed Oct 12 06:00:00
2011 (UTC)
2011-10-08 14:05:12.553 Grabbing listing data
--2011-10-08 14:05:12--
http://webservices.schedulesdirect.tmsdatadirect.com/schedulesdirect/tvlistings/xtvdService
Resolving webservices.schedulesdirect.tmsdatadirect.com... 144.142.232.53
Connecting to webservices.schedulesdirect.tmsdatadirect.com|144.142.232.53|:80...
connected.
HTTP request sent, awaiting response... 401 Unauthorized
Connecting to webservices.schedulesdirect.tmsdatadirect.com|144.142.232.53|:80...
connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/xml]
Saving to: “STDOUT”

    [
<=>
] 32,086      6.97K/s              2011-10-08 14:05:17.856 DataDirect: Your
subscription expires on Monday Oct 15 (2012) 10:42 AM
    [
<=>                                                      ] 279,434
--.-K/s
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.mythtv.org/pipermail/mythtv-users/attachments/20111008/6953bdf4/attachment.html 


More information about the mythtv-users mailing list