Server admin newbie. 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
