← Back to team overview

mythbuntu-bugs team mailing list archive

[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