i'm really confused with this issue, not quite sure whats causing it, but i've noticed a proces running which is using up a large amount of CPU on my server..

when i trace the MySQL process, it just constantly loosk the message

select(13, [10 12], NULL, NULL, NULL) = 1 (in [12])

fcntl64(12, F_SETFL, O_RDWR|O_NONBLOCK) = 0

accept(12, {sa_family=AF_FILE, path=@}, [2]) = 17

fcntl64(12, F_SETFL, O_RDWR) = 0

getsockname(17, {sa_family=AF_FILE, path="/var/lib/mysql"}, [28]) = 0

fcntl64(17, F_SETFL, O_RDONLY) = 0

fcntl64(17, F_GETFL) = 0x2 (flags O_RDWR)

fcntl64(17, F_SETFL, O_RDWR|O_NONBLOCK) = 0

setsockopt(17, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)

futex(0x85eede4, FUTEX_WAKE, 1) = 1

over and over and over again i did a bit of googling and didnt find much information other than a few other people had had this issue. Any ideas what this stuff actually means and what could be causing it... from where i'm sat it looks asthough something is trying to open SQL on a different socket as shown above "17" yet when it loosk the socket its trying to set, changes...

select(13, [10 12], NULL, NULL, NULL) = 1 (in [12])

fcntl64(12, F_SETFL, O_RDWR|O_NONBLOCK) = 0

accept(12, {sa_family=AF_FILE, path=@}, [2]) = 194

fcntl64(12, F_SETFL, O_RDWR) = 0

getsockname(194, {sa_family=AF_FILE, path="/var/lib/mysql"}, [28]) = 0

fcntl64(194, F_SETFL, O_RDONLY) = 0

fcntl64(194, F_GETFL) = 0x2 (flags O_RDWR)

fcntl64(194, F_SETFL, O_RDWR|O_NONBLOCK) = 0

setsockopt(194, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)

futex(0x85eede4, FUTEX_WAKE, 1) = 1 

now its trying socket 194...

can anybody shed some light on this, or have any ideas...

mucho appreciato :)

Just updating MySQL to 5.1.40 to see if that helps... was previously running 5.0.89

done.. but its now changed to

select(13, [10 12], NULL, NULL, NULL) = 1 (in [12])

fcntl64(12, F_SETFL, O_RDWR|O_NONBLOCK) = 0

accept(12, {sa_family=AF_FILE, path="

@ח

h"}, [2]) = 376

fcntl64(12, F_SETFL, O_RDWR) = 0

getsockname(376, {sa_family=AF_FILE, path="/var/lib/mysql"}, [28]) = 0

fcntl64(376, F_SETFL, O_RDONLY) = 0

fcntl64(376, F_GETFL) = 0x2 (flags O_RDWR)

fcntl64(376, F_SETFL, O_RDWR|O_NONBLOCK) = 0

setsockopt(376, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)

futex(0x8703f24, FUTEX_WAKE, 1) = 1

futex(0x8703f20, FUTEX_WAKE, 1) = 1

futex(0x8702480, FUTEX_WAKE, 1) = 1

my brain hurts :(

Strange, funny enough the MySQL forums are disturbingly silent on the issue (http://forums.mysql.com/read.php?24,181499,184240) and the rest is not in english so I have no idea how to read it ><

http://forums.cpanel.net/search.php?searchid=9996785 not much here either, but it's worth a try.

Please enable slow query logging that info would be more useful than trace output.