Facebook
Twitter
Azurel
Silver Pleskian
I have a single mysql process that never stops and running with 10-200% CPU load:
http://img5.picload.org/image/igraidp/mysqla.png
I restart mysql => process coming back
I restart server => process coming back
I kill process => process coming back
I have run:
# mysqladmin -uadmin -p`cat /etc/psa/.psa.shadow` -i 1 processlist
but there was noting that runs >10min.
I have strace the PID
without child threads
I found with google a hint for high cpu http://stackoverflow.com/a/11293475/706420 but that not help me here.
I have deinstalled "health monitor" module, but that was not the reason.
Can anyhone help me here? I use plesk 12.0.18 Update #38 with CentOS 6.6 (Final).
http://img5.picload.org/image/igraidp/mysqla.png
I restart mysql => process coming back
I restart server => process coming back
I kill process => process coming back
I have run:
# mysqladmin -uadmin -p`cat /etc/psa/.psa.shadow` -i 1 processlist
but there was noting that runs >10min.
Code:
> SHOW FULL PROCESSLIST;
+------+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+-------+-----------+------+---------+------+-------+-----------------------+
| 328 | admin | localhost | psa | Sleep | 56 | | NULL |
| 8110 | admin | localhost | NULL | Query | 0 | init | SHOW FULL PROCESSLIST |
+------+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.00 sec)I have strace the PID
Code:
# timeout 1m strace -f -c -p 5873
Process 5873 attached with 30 threads - interrupt to quit
Process 10499 attached (waiting for parent)
Process 10499 resumed (parent 5873 ready)
Process 10502 attached (waiting for parent)
Process 10502 resumed (parent 5873 ready)
Process 10503 attached (waiting for parent)
Process 10503 resumed (parent 5873 ready)
Process 10505 attached (waiting for parent)
Process 10505 resumed (parent 5873 ready)
Process 10537 attached (waiting for parent)
Process 10537 resumed (parent 5873 ready)
Process 10540 attached (waiting for parent)
Process 10540 resumed (parent 5873 ready)
Process 10629 attached (waiting for parent)
Process 10629 resumed (parent 5873 ready)
Process 10640 attached (waiting for parent)
Process 10640 resumed (parent 5873 ready)
Process 10656 attached (waiting for parent)
Process 10656 resumed (parent 5873 ready)
Process 5873 detached
Process 5880 detached
Process 5881 detached
Process 5882 detached
Process 5883 detached
Process 5884 detached
Process 5885 detached
Process 5886 detached
Process 5887 detached
Process 5888 detached
Process 5889 detached
Process 5891 detached
Process 5892 detached
Process 5893 detached
Process 5894 detached
Process 5895 detached
Process 5896 detached
Process 5897 detached
Process 5898 detached
Process 5899 detached
Process 5900 detached
Process 5901 detached
Process 5902 detached
Process 6428 detached
Process 6432 detached
Process 6525 detached
Process 7434 detached
Process 8447 detached
Process 8448 detached
Process 8998 detached
Process 10499 detached
Process 10502 detached
Process 10503 detached
Process 10505 detached
Process 10537 detached
Process 10540 detached
Process 10629 detached
Process 10640 detached
Process 10656 detached
% time seconds usecs/call calls errors syscall
------ ----------- ----------- --------- --------- ----------------
43.67 357.223601 112511 3175 io_getevents
36.74 300.549511 29766 10097 1477 futex
8.46 69.218473 581668 119 select
5.67 46.369254 41699 1112 poll
1.87 15.278414 22 693743 read
1.43 11.661919 23 514736 lseek
1.02 8.349623 26 326256 pread
0.81 6.618995 945571 7 5 restart_syscall
0.09 0.758261 2916 260 fsync
0.09 0.748626 20 37497 gettimeofday
0.04 0.303792 71 4299 pwrite
0.03 0.207070 21 10016 clock_gettime
0.02 0.191698 74 2578 io_submit
0.02 0.161302 20 7891 797 recvfrom
0.02 0.131280 35 3796 sendto
0.01 0.107369 48 2230 write
0.00 0.039757 76 526 madvise
0.00 0.019726 21 948 fcntl
0.00 0.018605 29 639 mprotect
0.00 0.015217 22 682 sched_yield
0.00 0.013317 21 629 9 access
0.00 0.013312 44 301 shutdown
0.00 0.011557 37 316 accept
0.00 0.010241 16 632 316 setsockopt
0.00 0.007318 22 331 close
0.00 0.002177 14 157 5 lstat
0.00 0.001787 38 47 open
0.00 0.001637 117 14 unlink
0.00 0.001000 111 9 clone
0.00 0.000323 9 38 getcwd
0.00 0.000263 53 5 5 readlink
0.00 0.000000 0 18 mmap
0.00 0.000000 0 5 munmap
0.00 0.000000 0 9 set_robust_list
------ ----------- ----------- --------- --------- ----------------
100.00 818.035425 1623118 2614 totalwithout child threads
Code:
# timeout 1m strace -c -p 5873
Process 5873 attached - interrupt to quit
Process 5873 detached
% time seconds usecs/call calls errors syscall
------ ----------- ----------- --------- --------- ----------------
99.82 3.049377 5842 522 poll
0.12 0.003567 4 998 futex
0.04 0.001183 1 1569 fcntl
0.02 0.000528 1 523 accept
0.01 0.000317 1 523 523 setsockopt
0.00 0.000000 0 1 restart_syscall
------ ----------- ----------- --------- --------- ----------------
100.00 3.054972 4136 523 totalI found with google a hint for high cpu http://stackoverflow.com/a/11293475/706420 but that not help me here.
I have deinstalled "health monitor" module, but that was not the reason.
Can anyhone help me here? I use plesk 12.0.18 Update #38 with CentOS 6.6 (Final).
