Mysql consumes 100% of CPU in Op5.6
Hi ,
I'm evaluating Op5.6 on Xeon 2.2GHz dual CPUs + 4GB Memory. Op always suspends for 10 or 30 mins. During that period we get no response from web client including unable to logon as i had post this problem to this discussion board. After check with command "mysqladmin -P 13306 -S /opt/AdventNet/ME/OpManager/mysql/mysql.socket -uroot processlist", it returns us as below,
--------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+----------------------+-------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| 4 | root | hostname:40612 | OpManagerDB | Sleep | 121 | | |
| 5 | root | hostname:40613 | OpManagerDB | Sleep | 121 | | |
| 6 | root | hostname:40614 | OpManagerDB | Sleep | 121 | | |
| 7 | root | hostname:40615 | OpManagerDB | Query | 769 | Copying to tmp table | Select p.NAME, AGENT, DISPLAYNAME, CATEGORY, ifDescr as INSTANCE, TTIME, avg(VAL) as AVG from STATSD |
| 8 | root | hostname:40616 | OpManagerDB | Sleep | 150 | | |
| 9 | root | hostname:40617 | OpManagerDB | Sleep | 150 | | |
| 10 | root | hostname:40618 | OpManagerDB | Sleep | 3757 | | |
| 11 | root | hostname:40623 | OpManagerDB | Sleep | 3749 | | |
| 24 | root | localhost | | Query | 0 | | show processlist
The upper text may be messy word, please check out the attachment for the real output.
How do i solve this problem?? This problem makes us so confuse with your software. We had solved this problem by apply patch with Op5.5 but why we still see it in Op5.6.
Thank you.
I'm evaluating Op5.6 on Xeon 2.2GHz dual CPUs + 4GB Memory. Op always suspends for 10 or 30 mins. During that period we get no response from web client including unable to logon as i had post this problem to this discussion board. After check with command "mysqladmin -P 13306 -S /opt/AdventNet/ME/OpManager/mysql/mysql.socket -uroot processlist", it returns us as below,
--------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+----------------------+-------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| 4 | root | hostname:40612 | OpManagerDB | Sleep | 121 | | |
| 5 | root | hostname:40613 | OpManagerDB | Sleep | 121 | | |
| 6 | root | hostname:40614 | OpManagerDB | Sleep | 121 | | |
| 7 | root | hostname:40615 | OpManagerDB | Query | 769 | Copying to tmp table | Select p.NAME, AGENT, DISPLAYNAME, CATEGORY, ifDescr as INSTANCE, TTIME, avg(VAL) as AVG from STATSD |
| 8 | root | hostname:40616 | OpManagerDB | Sleep | 150 | | |
| 9 | root | hostname:40617 | OpManagerDB | Sleep | 150 | | |
| 10 | root | hostname:40618 | OpManagerDB | Sleep | 3757 | | |
| 11 | root | hostname:40623 | OpManagerDB | Sleep | 3749 | | |
| 24 | root | localhost | | Query | 0 | | show processlist
The upper text may be messy word, please check out the attachment for the real output.
How do i solve this problem?? This problem makes us so confuse with your software. We had solved this problem by apply patch with Op5.5 but why we still see it in Op5.6.
Thank you.