 |
|||
How to find out why mysql using large amount of cpu
By: rekha singh | 07 May 2010 5:38 pm
Can someone help me find out why mysql is using large amount of cpu.
What info do you need? Here's what I know to give....
If I go to cpanel and "show current CPU usage"
This is what the issue is:
/usr/sbin/mysqld --basedir=/ --datadir=/var/ lib/mysql --user=mysql --log-error= /var/lib/ mysql/vps. justmydns. net.err --pid-file=/ var/lib/mysql/ vps.justmydns. net.pid
If I go to trace I am getting this mess:
Process 21960 attached - interrupt to quit
select(5, [4], NULL, NULL, NULL) = 1 (in [4])
fcntl64(4, F_SETFL, O_RDWR|O_NONBLOCK) = 0
accept(4, {sa_family=AF_ FILE, path="\354\277\ 1"...}, [2]) = 294
fcntl64(4, F_SETFL, O_RDWR) = 0
getsockname( 294, {sa_family=AF_ FILE, path="/var/lib/ mysql\1". ..}, [28]) = 0
fcntl64(294, F_SETFL, O_RDONLY) = 0
fcntl64(294, F_GETFL) = 0x2 (flags O_RDWR)
fcntl64(294, F_SETFL, O_RDWR|O_NONBLOCK) = 0
setsockopt(294, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
futex(0x87a12c4, FUTEX_WAKE_OP_ PRIVATE, 1, 1, 0x87a12c0, {FUTEX_OP_SET, 0, FUTEX_OP_CMP_ GT, 1}) = 1
select(5, [4], NULL, NULL, NULL) = 1 (in [4])
fcntl64(4, F_SETFL, O_RDWR|O_NONBLOCK) = 0
accept(4, {sa_family=AF_ FILE, path="\354\277\ 1"...}, [2]) = 294
fcntl64(4, F_SETFL, O_RDWR) = 0
getsockname( 294, {sa_family=AF_ FILE, path="/var/lib/ mysql\1". ..}, [28]) = 0
fcntl64(294, F_SETFL, O_RDONLY) = 0
fcntl64(294, F_GETFL) = 0x2 (flags O_RDWR)
fcntl64(294, F_SETFL, O_RDWR|O_NONBLOCK) = 0
setsockopt(294, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
futex(0x87a12c4, FUTEX_WAKE_OP_ PRIVATE, 1, 1, 0x87a12c0, {FUTEX_OP_SET, 0, FUTEX_OP_CMP_ GT, 1}) = 1
futex(0x87a0be0, FUTEX_WAKE_PRIVATE, 1) = 1
select(5, [4], NULL, NULL, NULL) = 1 (in [4])
fcntl64(4, F_SETFL, O_RDWR|O_NONBLOCK) = 0
accept(4, {sa_family=AF_ FILE, path="\354\277\ 1"...}, [2]) = 294
fcntl64(4, F_SETFL, O_RDWR) = 0
getsockname( 294, {sa_family=AF_ FILE, path="/var/lib/ mysql\1". ..}, [28]) = 0
fcntl64(294, F_SETFL, O_RDONLY) = 0
fcntl64(294, F_GETFL) = 0x2 (flags O_RDWR)
fcntl64(294, F_SETFL, O_RDWR|O_NONBLOCK) = 0
setsockopt(294, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
futex(0x87a12c4, FUTEX_WAKE_OP_ PRIVATE, 1, 1, 0x87a12c0, {FUTEX_OP_SET, 0, FUTEX_OP_CMP_ GT, 1}) = 1
select(5, [4], NULL, NULL, NULL) = 1 (in [4])
fcntl64(4, F_SETFL, O_RDWR|O_NONBLOCK) = 0
accept(4, {sa_family=AF_ FILE, path="\354\277\ 1"...}, [2]) = 409
fcntl64(4, F_SETFL, O_RDWR) = 0
getsockname( 409, {sa_family=AF_ FILE, path="/var/lib/ mysql\1". ..}, [28]) = 0
fcntl64(409, F_SETFL, O_RDONLY) = 0
fcntl64(409, F_GETFL) = 0x2 (flags O_RDWR)
fcntl64(409, F_SETFL, O_RDWR|O_NONBLOCK) = 0
setsockopt(409, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
futex(0x87a12c4, FUTEX_WAKE_OP_ PRIVATE, 1, 1, 0x87a12c0, {FUTEX_OP_SET, 0, FUTEX_OP_CMP_ GT, 1}) = 1
select(5, [4], NULL, NULL, NULL) = 1 (in [4])
fcntl64(4, F_SETFL, O_RDWR|O_NONBLOCK) = 0
accept(4, {sa_family=AF_ FILE, path="\354\277\ 1"...}, [2]) = 410
fcntl64(4, F_SETFL, O_RDWR) = 0
getsockname( 410, {sa_family=AF_ FILE, path="/var/lib/ mysql\1". ..}, [28]) = 0
fcntl64(410, F_SETFL, O_RDONLY) = 0
fcntl64(410, F_GETFL) = 0x2 (flags O_RDWR)
fcntl64(410, F_SETFL, O_RDWR|O_NONBLOCK) = 0
setsockopt(410, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
futex(0x87a12c4, FUTEX_WAKE_OP_ PRIVATE, 1, 1, 0x87a12c0, {FUTEX_OP_SET, 0, FUTEX_OP_CMP_ GT, 1}) = 1
select(5, [4], NULL, NULL, NULL) = 1 (in [4])
fcntl64(4, F_SETFL, O_RDWR|O_NONBLOCK) = 0
accept(4, {sa_family=AF_ FILE, path="\354\277\ 1"...}, [2]) = 294
fcntl64(4, F_SETFL, O_RDWR) = 0
getsockname( 294, {sa_family=AF_ FILE, path="/var/lib/ mysql\1". ..}, [28]) = 0
fcntl64(294, F_SETFL, O_RDONLY) = 0
fcntl64(294, F_GETFL) = 0x2 (flags O_RDWR)
fcntl64(294, F_SETFL, O_RDWR|O_NONBLOCK) = 0
setsockopt(294, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
futex(0x87a12c4, FUTEX_WAKE_OP_ PRIVATE, 1, 1, 0x87a12c0, {FUTEX_OP_SET, 0, FUTEX_OP_CMP_ GT, 1}) = 1
select(5, [4], NULL, NULL, NULL) = 1 (in [4])
fcntl64(4, F_SETFL, O_RDWR|O_NONBLOCK) = 0
accept(4, {sa_family=AF_ FILE, path="\354\277\ 1"...}, [2]) = 294
fcntl64(4, F_SETFL, O_RDWR) = 0
|
