mythbuntu-bugs team mailing list archive

[Launchpad Bug Tracker <997367@xxxxxxxxxxxxxxxxxx>]

This bug was fixed in the package mythtv -
2:0.25.2+fixes.20120802.46cab93-0ubuntu1

---------------
mythtv (2:0.25.2+fixes.20120802.46cab93-0ubuntu1) precise-proposed; urgency=low

  * New upstream fixes branch checkout (46cab93)
  * Updated to 0.25.2 point release. (LP: #1029522)
  * Major fixes:
    - Mythfilldatabase takes hours instead of minutes to run (LP: #997367)
    - A popular tuner card doesn't record in digital cable mode (trac 10712)
  * fix get-orig-source rule's broken tarball fetch from archive.
  * Enable libcec support (LP: #982272)
  * Add missingok to additional mythtv-backend logs. (LP: #982162)
  * Pull an updated snapshot of Mythbuntu theme, to avoid theme
    downloader telling the user there is an updated theme on first
    boot.
  * Update amejia's email on uploaders field.
  * Drop recommends on adept-notifier.
  * Bump standards version.
  * New upstream checkout (25dd4ce)
 -- Mario Limonciello <Mario_Limonciello@xxxxxxxx>   Wed, 08 Aug 2012 20:32:13 -0500

** Changed in: mythtv (Ubuntu Precise)
       Status: Fix Committed => Fix Released

-- 
You received this bug notification because you are a member of Mythbuntu
Bug Team, which is subscribed to mythtv in Ubuntu.
https://bugs.launchpad.net/bugs/997367

Title:
  mythfilldatabase takes hours to complete

Status in “mythtv” package in Ubuntu:
  Fix Released
Status in “mythtv” source package in Precise:
  Fix Released

Bug description:
  Background: 12.04 went to MySQL 5.5, which uses InnoDB by default.  So
  temp tables created by mythfilldatabase are now innodb instead of
  myisam.  These temp tables get written to disk at /var/lib/mysql.
  Because these temp tables are written to disk the ext4 journaler
  constantly runs against these files, causing a massive IO block.

  How to reproduce:
  1. run: mythfilldatabase --refresh all
  2. check iotop

  Example:
  Total DISK READ:       3.80 K/s | Total DISK WRITE:     322.99 K/s
    TID  PRIO  USER     DISK READ  DISK WRITE  SWAPIN     IO>    COMMAND                                                                
    329 be/3 root        0.00 B/s    0.00 B/s  0.00 % 99.50 % [jbd2/sda1-8]
  1091 be/4 mysql       3.80 K/s   83.60 K/s  0.00 %  0.34 % mysqld

  In the past this process would run in a few minutes, with this IO
  blocking going on it takes hours.

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mythtv/+bug/997367/+subscriptions