[mythtv-users] mysql consuming 100% CPU - help, please

[Stephen Worthington]

On Fri, 28 Jul 2017 08:13:12 -0500, you wrote:

>Hi Stephen -
>
>Thanks.  I'll look into getting a ticket created.  It'd be good to
>have some limitations on the query.  I can't be the only one with
>problematic recordings.
>
>You were right about the database difference between the two:
>
>mysqldump -uroot -p mythconverg recorded recordedseek recordedrating
>recordedprogram recordedmarkup recordedcredits --where="chanid=1024
>and starttime='2017-07-18 20:30:00'" --no-create-db --no-create-info
>>good.sql
>
>mysqldump -uroot -p mythconverg recorded recordedseek recordedrating
>recordedprogram recordedmarkup recordedcredits --where="chanid=1024
>and starttime='2017-07-18 21:00:00'" --no-create-db --no-create-info
>>bad.sql
>
>[root at testvm tlunde]# cat good.sql | wc -c
>
>85183
>
>[root at testvm tlunde]# cat bad.sql | wc -c
>
>20300732
>
>Look at the size difference!
>
>Thanks
>Thomas

Ouch!  That is a huge difference.  But even with that, the query
should complete eventually, unless something is thrashing, so the
query is probably too big to be executed in the available RAM.