high process of mysql error log

[madpato]

Hello

In my server's lists of processes there is always one that shows up and spends quite some cpu resources, this is the line in the process manager un WHM:

/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/myserver.net.err --open-files-limit=6800 --pid-file=/var/lib/mysql/myserver.net.pid

I then trace it and this is what it shows:

Process 13333 attached - interrupt to quit
select(14, [12 13], NULL, NULL, NULL)   = 1 (in [13])
fcntl(13, F_SETFL, O_RDWR|O_NONBLOCK)   = 0
accept(13, {sa_family=AF_FILE, path="\302Y\270k\352\22"...}, [8516025424675864578]) = 92
fcntl(13, F_SETFL, O_RDWR)              = 0
getsockname(92, {sa_family=AF_FILE, path="/var/lib/mysql\1"...}, [8516025424675864604]) = 0
time(NULL)                              = 1367876242
fcntl(92, F_SETFL, O_RDONLY)            = 0
fcntl(92, F_GETFL)                      = 0x2 (flags O_RDWR)
fcntl(92, F_SETFL, O_RDWR|O_NONBLOCK)   = 0
setsockopt(92, SOL_IP, IP_TOS, [8], 4)  = -1 EOPNOTSUPP (Operation not supported)
futex(0xdadba4, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0xdadba0, {FUTEX_OP_SET, 0, FUTEX_OP_CMP_GT, 1}) = 1
futex(0xdacee0, FUTEX_WAKE_PRIVATE, 1)  = 1
select(14, [12 13], NULL, NULL, NULL)   = 1 (in [13])
fcntl(13, F_SETFL, O_RDWR|O_NONBLOCK)   = 0
accept(13, {sa_family=AF_FILE, path="\302Y\270k\352\22"...}, [8516025424675864578]) = 92
fcntl(13, F_SETFL, O_RDWR)              = 0
getsockname(92, {sa_family=AF_FILE, path="/var/lib/mysql\1"...}, [8516025424675864604]) = 0
time(NULL)                              = 1367876242
fcntl(92, F_SETFL, O_RDONLY)            = 0
fcntl(92, F_GETFL)                      = 0x2 (flags O_RDWR)
fcntl(92, F_SETFL, O_RDWR|O_NONBLOCK)   = 0
setsockopt(489, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
futex(0xdadba4, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0xdadba0, {FUTEX_OP_SET, 0, FUTEX_OP_CMP_GT, 1}) = 1
futex(0xdacee0, FUTEX_WAKE_PRIVATE, 1)  = 1
select(14, [12 13], NULL, NULL, NULL)   = 1 (in [13])
fcntl(13, F_SETFL, O_RDWR|O_NONBLOCK)   = 0
accept(13, {sa_family=AF_FILE, path=@""}, [8516025424675864578]) = 489
fcntl(13, F_SETFL, O_RDWR)              = 0
getsockname(489, {sa_family=AF_FILE, path="/var/lib/mysql\1"...}, [8516025424675864604]) = 0
time(NULL)                              = 1367876415
fcntl(489, F_SETFL, O_RDONLY)           = 0
fcntl(489, F_GETFL)                     = 0x2 (flags O_RDWR)
fcntl(489, F_SETFL, O_RDWR|O_NONBLOCK)  = 0
setsockopt(489, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
futex(0xdadba4, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0xdadba0, {FUTEX_OP_SET, 0, FUTEX_OP_CMP_GT, 1}) = 1
select(14, [12 13], NULL, NULL, NULL)   = 1 (in [13])
fcntl(13, F_SETFL, O_RDWR|O_NONBLOCK)   = 0
accept(13, {sa_family=AF_FILE, path=@""}, [8516025424675864578]) = 489
fcntl(13, F_SETFL, O_RDWR)              = 0
getsockname(489, {sa_family=AF_FILE, path="/var/lib/mysql\1"...}, [8516025424675864604]) = 0
time(NULL)                              = 1367876415
fcntl(489, F_SETFL, O_RDONLY)           = 0
fcntl(489, F_GETFL)                     = 0x2 (flags O_RDWR)
fcntl(489, F_SETFL, O_RDWR|O_NONBLOCK)  = 0
setsockopt(489, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
futex(0xdadba4, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0xdadba0, {FUTEX_OP_SET, 0, FUTEX_OP_CMP_GT, 1}) = 1
futex(0xdacee0, FUTEX_WAKE_PRIVATE, 1)  = 1
select(14, [12 13], NULL, NULL, NULL)   = 1 (in [13])
fcntl(13, F_SETFL, O_RDWR|O_NONBLOCK)   = 0
accept(13, {sa_family=AF_FILE, path=@""}, [8516025424675864578]) = 489
fcntl(13, F_SETFL, O_RDWR)              = 0
getsockname(489, {sa_family=AF_FILE, path="/var/lib/mysql\1"...}, [8516025424675864604]) = 0
time(NULL)                              = 1367876415
fcntl(489, F_SETFL, O_RDONLY)           = 0
fcntl(489, F_GETFL)                     = 0x2 (flags O_RDWR)
fcntl(489, F_SETFL, O_RDWR|O_NONBLOCK)  = 0

Some values change but its almost the same over and over.... the part that says (Operation not supported) is calling my attention, any idea on where should i look for to try to stop this. Thanks.

 

[markhard]

the process that you mentioned is MySQL server, have you look at /var/lib/mysql/myserver.net.err for error messages?

 

[Infopro]

Hello

In my server's lists of processes there is always one that shows up and spends quite some cpu resources, this is the line in the process manager un WHM:



I then trace it and this is what it shows:

...

IMHO, this looks normal.

While not perfect, you might get a better idea who's using resources, quick and easy, here:
Home » Server Status » Daily Process Log

You can click thru days via links at top, users spiking resources will be shown in red.

 

[24x7server]

Monitor your MySQL process through SSH

mysqladmin -i1 processlist