mythfilldatabase takes hours to complete
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mythtv (Ubuntu) |
Fix Released
|
Undecided
|
Unassigned | ||
Precise |
Fix Released
|
Undecided
|
Unassigned |
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.
Changed in mythtv (Ubuntu): | |
status: | New → Confirmed |
Versions:
john@ultramagnus:~$ dpkg -l |grep mythtv 0+fixes. 20120508. b9e60ff- 0ubuntu0mythbun tu4 A PERL library to access some MythTV features 0+fixes. 20120508. b9e60ff- 0ubuntu0mythbun tu4 A personal video recorder application (client and server) 0+fixes. 20120508. b9e60ff- 0ubuntu0mythbun tu4 A personal video recorder application (server) backend- master 2:0.25. 0+fixes. 20120508. b9e60ff- 0ubuntu0mythbun tu4 Metapackage to setup and configure a "Master Backend" profile of MythTV. 0+fixes. 20120508. b9e60ff- 0ubuntu0mythbun tu4 A personal video recorder application (common data) 0+fixes. 20120508. b9e60ff- 0ubuntu0mythbun tu4 A personal video recorder application (database) 0+fixes. 20120508. b9e60ff- 0ubuntu0mythbun tu4 A personal video recorder application (client) theme-mythbuntu 2:0.25. 0+fixes. 20120508. b9e60ff- 0ubuntu0mythbun tu4 The mythbuntu MythTV Theme transcode- utils 2:0.25. 0+fixes. 20120508. b9e60ff- 0ubuntu0mythbun tu4 Utilities used for transcoding MythTV tasks 0+fixes. 20120508. b9e60ff- 0ubuntu0mythbun tu4 PHP Bindings for MythTV
ii libmythtv-perl 2:0.25.
ii mythtv 2:0.25.
ii mythtv-backend 2:0.25.
ii mythtv-
ii mythtv-common 2:0.25.
ii mythtv-database 2:0.25.
ii mythtv-frontend 2:0.25.
ii mythtv-status 0.9.3-1 Show the status of a MythTV backend
ii mythtv-
ii mythtv-
ii php-mythtv 2:0.25.