[mythtv-users] mysql 100% cpu since upgrading to fedora 22 and mythtv-0.27.4 from git

Hika van den Hoven hikavdh at gmail.com
Mon Jun 1 14:27:18 UTC 2015


Hoi Udo,

Monday, June 1, 2015, 3:25:17 PM, you wrote:


> Hello,

> How can I find out why mysqld (mariadb) is eating so much cpu ever since
> upgrading to Fedora 22 and MythTV 0.27.4?

> # mysqladmin processlist -v
> +----+--------+-----------+-------------+---------+------+-------+-----------------------+----------+
> | Id | User   | Host      | db          | Command | Time | State | Info
>                  | Progress |
> +----+--------+-----------+-------------+---------+------+-------+-----------------------+----------+
> | 2  | mythtv | localhost | mythconverg | Sleep   | 58   |       |
>                  | 0.000    |
> | 4  | mythtv | localhost | mythconverg | Sleep   | 70   |       |
>                  | 0.000    |
> | 5  | mythtv | localhost | mythconverg | Sleep   | 70   |       |
>                  | 0.000    |
> | 6  | mythtv | localhost | mythconverg | Sleep   | 2    |       |
>                  | 0.000    |
> | 7  | mythtv | localhost | mythconverg | Sleep   | 34   |       |
>                  | 0.000    |
> | 25 | mythtv | localhost | mythconverg | Sleep   | 4327 |       |
>                  | 0.000    |
> | 26 | mythtv | localhost | mythconverg | Sleep   | 4    |       |
>                  | 0.000    |
> | 28 | mythtv | localhost | mythconverg | Sleep   | 310  |       |
>                  | 0.000    |
> | 30 | mythtv | localhost | mythconverg | Sleep   | 70   |       |
>                  | 0.000    |
> | 31 | mythtv | localhost | mythconverg | Sleep   | 58   |       |
>                  | 0.000    |
> | 32 | mythtv | localhost | mythconverg | Sleep   | 69   |       |
>                  | 0.000    |
> | 36 | mythtv | localhost | mythconverg | Sleep   | 63   |       |
>                  | 0.000    |
> | 57 | mythtv | localhost | mythconverg | Sleep   | 2889 |       |
>                  | 0.000    |
> | 62 | mythtv | localhost | mythconverg | Sleep   | 0    |       |
>                  | 0.000    |
> | 90 | root   | localhost |             | Query   | 0    | init  | show
> full processlist | 0.000    |
> +----+--------+-----------+-------------+---------+------+-------+-----------------------+----------+

> What is actually happening?
> My SQL-limiting Power Search recording schedules are still there.
> Yet still I see this behaviour.

> Any ideas?

> Kind regards,
> Udo

Have you tried if optimize_mythdb.pl solves the problem?
To be save you should first run a backup with mythconverg_backup.pl

Tot mails,
  Hika                            mailto:hikavdh at gmail.com

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens



More information about the mythtv-users mailing list