mythbuntu-bugs team mailing list archive
-
mythbuntu-bugs team
-
Mailing list archive
-
Message #07265
[Bug 997367] Re: mythfilldatabase takes hours to complete
Hello rhpot1991, or anyone else affected,
Accepted mythtv into precise-proposed. The package will build now and be
available at
http://launchpad.net/ubuntu/+source/mythtv/2:0.25.2+fixes.20120802.46cab93-0ubuntu1
in a few hours, and then in the -proposed repository.
Please help us by testing this new package. See
https://wiki.ubuntu.com/Testing/EnableProposed for documentation how to
enable and use -proposed. Your feedback will aid us getting this update
out to other Ubuntu users.
If this package fixes the bug for you, please change the bug tag from
verification-needed to verification-done. If it does not, change the
tag to verification-failed. In either case, details of your testing
will help us make a better decision.
Further information regarding the verification process can be found at
https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in
advance!
** Changed in: mythtv (Ubuntu Precise)
Status: New => Fix Committed
** Tags added: verification-needed
--
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 Committed
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
References