Public bug reported:
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.
** Affects: mythtv (Ubuntu)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/997367
Title:
mythfilldatabase takes hours to complete
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mythtv/+bug/997367/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
