[mythtv-users] Mysql taking 100% CPU

[Darren]

On Sun, 2 Jul 2006 10:41 pm, Rod wrote:
>     Hi, I have a little mysql problem, but all I can see is that its
> mythtv related (its the only database thats in use)
>
>     I have a Dual core Pentium, so with MySQL running 100% (I'm not sure
> how it runs 101% but it says it does sometimes...)
>
>     I just into MySQL and do a command with the following result
>
> mysql> show processlist;
> +----+--------+-------------------------+-------------+---------+----------
>--+----------+--------------------------------------------------------------
>----------------------------------------+
>
> | Id | User   | Host                    | db          | Command |
>
> Time       | State    |
> Info
>
> +----+--------+-------------------------+-------------+---------+----------
>--+----------+--------------------------------------------------------------
>----------------------------------------+
>
> |  1 | mythtv | localhost               | mythconverg | Query   |
>
> 4294948932 | Updating | UPDATE recorded SET basename = CONCAT(chanid,
> '_', DATE_FORMAT(starttime, '%Y%m%d%H%i00'), '_', DATE |
>
> |  2 | mythtv | localhost               | mythconverg | Query   |
>
> 17625 | Locked   | SELECT j.id, j.chanid, j.starttime, j.inserttime,
> j.type, j.cmds, j.flags, j.status, j.statustime, j |
>
> |  3 | mythtv | localhost               | mythconverg | Sleep   |
>
> 17625 | NULL     |
> NULL
>
> |  4 | mythtv | shadow.rods.id.au:43269 | mythconverg | Query   |
>
> 6582 | Locked   | SELECT DISTINCT recgroup from
> recorded                                                               |
>
> |  5 | root   | localhost               | NULL        | Query
> |          0 | NULL     | show
>
> processlist
>
> +----+--------+-------------------------+-------------+---------+----------
>--+----------+--------------------------------------------------------------
>----------------------------------------+ 5 rows in set (0.00 sec)
>
>     For some reason there is a Update query that I don't know how it
> started, or how it will stop, or when it will stop
>
>     Can someone enlighten me as to whats happening please.
>
>     Shutting down MySQL and restarting it doesn't change the problem,
> shutting down and restarting mythbackend also doesn't fix the problem,
> rebooting the computer only stops it when the power is off...
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
> !DSPAM:44a7c0b9124201185481320!

kill mythbackend and then try  mysql> show processlist;
It appears mythbackend is having some difficulty with mythconverg, it maybe 
corrupt. I have locked up mythconverg when I have edited the database via 
webmin by inadvertently using the same 'chanid' twice.
-- 
Peace Bro