[mythtv-users] mysql consuming 100% CPU - help, please
Stephen Worthington
stephen_agent at jsw.gen.nz
Fri Jul 28 14:21:45 UTC 2017
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.
More information about the mythtv-users
mailing list