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_limoncie...@dell.com> 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
_______________________________________________
Mailing list: https://launchpad.net/~mythbuntu-bugs
Post to : mythbuntu-bugs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~mythbuntu-bugs
More help : https://help.launchpad.net/ListHelp
