MySQL Forums
Forum List  »  Oracle

mysqld high cpu utilization on soalris
Posted by: prakash gr
Date: May 15, 2009 04:10AM

Hi,

mysql> show variables like '%version%';
+-------------------------+------------------------------+
| Variable_name | Value |
+-------------------------+------------------------------+
| protocol_version | 10 |
| version | 5.0.77-log |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | sparc |
| version_compile_os | sun-solaris2.9 |
+-------------------------+------------------------------+


once i started the php connection to mysql server the below is the top command.



load averages: 7.82, 7.88, 7.44 12:36:51
112 processes: 108 sleeping, 1 zombie, 1 stopped, 2 on cpu
CPU states: 0.0% idle, 97.1% user, 2.9% kernel, 0.0% iowait, 0.0% swap
Memory: 2048M real, 262M free, 1923M swap in use, 3585M swap free

PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
12850 mysql 30 59 0 0K 0K cpu/1 117:34 98.81% mysqld
372 root 6 59 0 4000K 2464K sleep 51:26 0.09% picld
1619 root 1 59 0 80M 2512K sleep 0:05 0.01% Xsun
643 root 24 59 0 3784K 2448K sleep 0:18 0.00% nscd
723 root 1 59 0 2688K 1256K sleep 0:16 0.00% arraymon
526 root 17 59 0 65M 3584K sleep 0:10 0.00% vxsvc
586 root 1 59 0 2504K 1448K sleep 0:08 0.00% inetd
16 root 1 59 0 9192K 4000K sleep 0:02 0.00% vxconfigd
4344 root 2 49 0 10M 2896K sleep 0:01 0.00% dtsession
4352 root 1 59 0 7520K 2600K sleep 0:01 0.00% sdtperfmeter
1401 root 7 59 0 2624K 1912K sleep 0:01 0.00% mibiisa
1 root 1 59 0 1288K 192K sleep 0:01 0.00% init
13080 oracle 1 59 0 2264K 1336K cpu/0 0:00 0.00% top
10332 oracle 1 60 0 0K 0K stop 0:00 0.00% mysql
5673 root 1 39 10 4400K 1768K sleep 0:00 0.00% dtscreen


what went wrong just 3 or 4 connection making this much high cpu utilization moreever i checked the query and queries are using right index


any inputs greately appreciated.


Thnaks

Prakash GR
surat
gujrat



Edited 3 time(s). Last edit at 05/15/2009 04:34AM by prakash gr.

Options: ReplyQuote


Subject
Views
Written By
Posted
mysqld high cpu utilization on soalris
4821
May 15, 2009 04:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.