mythbuntu-bugs team mailing list archive

[rhpot1991 <rhpot1991@xxxxxxxxxx>]

Versions:


john@ultramagnus:~$ dpkg -l |grep mythtv
ii  libmythtv-perl                         2:0.25.0+fixes.20120508.b9e60ff-0ubuntu0mythbuntu4 A PERL library to access some MythTV features
ii  mythtv                                 2:0.25.0+fixes.20120508.b9e60ff-0ubuntu0mythbuntu4 A personal video recorder application (client and server)
ii  mythtv-backend                         2:0.25.0+fixes.20120508.b9e60ff-0ubuntu0mythbuntu4 A personal video recorder application (server)
ii  mythtv-backend-master                  2:0.25.0+fixes.20120508.b9e60ff-0ubuntu0mythbuntu4 Metapackage to setup and configure a "Master Backend" profile of MythTV.
ii  mythtv-common                          2:0.25.0+fixes.20120508.b9e60ff-0ubuntu0mythbuntu4 A personal video recorder application (common data)
ii  mythtv-database                        2:0.25.0+fixes.20120508.b9e60ff-0ubuntu0mythbuntu4 A personal video recorder application (database)
ii  mythtv-frontend                        2:0.25.0+fixes.20120508.b9e60ff-0ubuntu0mythbuntu4 A personal video recorder application (client)
ii  mythtv-status                          0.9.3-1                                            Show the status of a MythTV backend
ii  mythtv-theme-mythbuntu                 2:0.25.0+fixes.20120508.b9e60ff-0ubuntu0mythbuntu4 The mythbuntu MythTV Theme
ii  mythtv-transcode-utils                 2:0.25.0+fixes.20120508.b9e60ff-0ubuntu0mythbuntu4 Utilities used for transcoding MythTV tasks
ii  php-mythtv                             2:0.25.0+fixes.20120508.b9e60ff-0ubuntu0mythbuntu4 PHP Bindings for MythTV

-- 
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:
  New

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