mysql process hanging...

I have a problem with a mysql process hanging, any help would be appreciated, it's running RH 9, Cpanel 9, latest version of PHP/Mysql and Apache...

The process that hangs, here is the results from the strace...

Any help would be very much appreciated!!

select(5, [3 4], NULL, NULL, NULL) = 1 (in [4])
fcntl64(4, F_SETFL, O_RDWR|O_NONBLOCK) = 0
accept(4, {sa_family=AF_UNIX, path="ÿ¿Zu"}, [2]) = 163
fcntl64(4, F_SETFL, O_RDWR) = 0
getsockname(163, {sa_family=AF_UNIX, path="/var/lib/mysql"}, [28]) = 0
fcntl64(163, F_GETFL) = 0x2 (flags O_RDWR)
fcntl64(163, F_SETFL, O_RDWR|O_NONBLOCK) = 0
setsockopt(163, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
kill(6541, SIGRTMIN) = 0
kill(6541, SIGRTMIN) = 0
select(5, [3 4], NULL, NULL, NULL) = 1 (in [4])
fcntl64(4, F_SETFL, O_RDWR|O_NONBLOCK) = 0
accept(4, {sa_family=AF_UNIX, path="ÿ¿Zu"}, [2]) = 303
fcntl64(4, F_SETFL, O_RDWR) = 0
getsockname(303, {sa_family=AF_UNIX, path="/var/lib/mysql"}, [28]) = 0
fcntl64(303, F_GETFL) = 0x2 (flags O_RDWR)
fcntl64(303, F_SETFL, O_RDWR|O_NONBLOCK) = 0
setsockopt(303, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
kill(6324, SIGRTMIN) = 0
select(5, [3 4], NULL, NULL, NULL) = 1 (in [4])
fcntl64(4, F_SETFL, O_RDWR|O_NONBLOCK) = 0
accept(4, {sa_family=AF_UNIX, path="ÿ¿Zu"}, [2]) = 303
fcntl64(4, F_SETFL, O_RDWR) = 0
getsockname(303, {sa_family=AF_UNIX, path="/var/lib/mysql"}, [28]) = 0
fcntl64(303, F_GETFL) = 0x2 (flags O_RDWR)
fcntl64(303, F_SETFL, O_RDWR|O_NONBLOCK) = 0
setsockopt(303, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
kill(4909, SIGRTMIN) = 0
kill(4909, SIGRTMIN) = 0
select(5, [3 4], NULL, NULL, NULL) = 1 (in [4])
fcntl64(4, F_SETFL, O_RDWR|O_NONBLOCK) = 0
accept(4, {sa_family=AF_UNIX, path="ÿ¿Zu"}, [2]) = 303
fcntl64(4, F_SETFL, O_RDWR) = 0
getsockname(303, {sa_family=AF_UNIX, path="/var/lib/mysql"}, [28]) = 0
fcntl64(303, F_GETFL) = 0x2 (flags O_RDWR)
fcntl64(303, F_SETFL, O_RDWR|O_NONBLOCK) = 0
setsockopt(303, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
kill(5216, SIGRTMIN) = 0
kill(5216, SIGRTMIN) = 0
select(5, [3 4], NULL, NULL, NULL) = 1 (in [4])
fcntl64(4, F_SETFL, O_RDWR|O_NONBLOCK) = 0
accept(4, {sa_family=AF_UNIX, path="ÿ¿Zu"}, [2]) = 163
fcntl64(4, F_SETFL, O_RDWR) = 0
getsockname(163, {sa_family=AF_UNIX, path="/var/lib/mysql"}, [28]) = 0
fcntl64(163, F_GETFL) = 0x2 (flags O_RDWR)
fcntl64(163, F_SETFL, O_RDWR|O_NONBLOCK) = 0
setsockopt(163, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
kill(4928, SIGRTMIN) = 0
kill(4928, SIGRTMIN) = 0
select(5, [3 4], NULL, NULL, NULL) = 1 (in [4])
fcntl64(4, F_SETFL, O_RDWR|O_NONBLOCK) = 0
accept(4, {sa_family=AF_UNIX, path="ÿ¿Zu"}, [2]) = 304
fcntl64(4, F_SETFL, O_RDWR) = 0
getsockname(304, {sa_family=AF_UNIX, path="/var/lib/mysql"}, [28]) = 0
fcntl64(304, F_GETFL) = 0x2 (flags O_RDWR)
fcntl64(304, F_SETFL, O_RDWR|O_NONBLOCK) = 0
setsockopt(304, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
kill(4907, SIGRTMIN) = 0
kill(4907, SIGRTMIN) = 0
select(5, [3 4], NULL, NULL, NULL <unfinished ...>

I stopped it there, looked pretty reptetitive.

Thanks
Rob

 

 

 

 

Top