The reason for 2000% CPU usage caused by MySQL5.6.12

Source: Internet
Author: User
Tags high cpu usage
Top leads to high CPU usage: top

Top: Super high CPU usage: top-16:41:04 up 184 days, 2 users, load average: 19.97, 18.38, 18.36 Tasks: 584 total,

Top:
Top-16:41:04 up 184 days, 2 users, load average: 19.97, 18.38, 18.36
Task: 584 total, 1 running, 583 sleeping, 0 stopped, 0 zombie
Cpu (s): 0.0% us, 0.0% sy, 41.2% ni, 58.7% id, 0.0% wa, 0.0% hi, 0.0% si, 0.0% st
Mem: 65923008 k total, 34622724 k used, 31300284 k free, 315684 k buffers
Swap: 33030136 k total, 0 k used, 33030136 k free, 24200968 k cached

Pid user pr ni virt res shr s % CPU % mem time + COMMAND
28518 root 20 0 1652 m 62 m 1172 S 2014.5 0.1 49701,58 mysql_test
24878 root 20 0 15416 1616 R 896 3.9 0: 00. 02 top
1 root 20 0 19228 1512 S 1220 0.0. 95 init
CPU usage is very high.

[Root @ db-m1-slave-1 ~] # Ps-eaf | grep mysql
Root 24917 24834 0 00:00:00 pts/1 grep mysql
Root 26452, 1 0 2013? 00:00:00/bin/sh/usr/local/mysql/bin/mysqld_safe -- datadir =/home/data/mysql/data -- pid-file =/usr/local/mysql/mysqld. pid
Mysql 27584 26452 0 2013? 01:56:49/usr/local/mysql/bin/mysqld -- basedir =/usr/local/mysql -- datadir =/home/data/mysql/data -- plugin-dir =/usr/local /mysql/lib/plugin -- user = mysql -- log-error =/usr/local/mysql/mysqld. log -- open-files-limit = 8192 -- pid-file =/usr/local/mysql/mysqld. pid -- socket =/usr/local/mysql. sock -- Ports = 3306
Root 28518, 1 99 2013? 2070-22:25:20./mysql_test -- config =./cfg -- threads = 20-B

The./mysql_test script is running. find/-name mysql_test

[Root @ db-m1-slave-1 ~] # Find/-name mysql_test
/Usr/local/mysql/test/mysql_test
[Root @ db-m1-slave-1 ~] #

[Root @ db-m1-slave-1 test] # more mysql_test
* ******* Mysql_test: Not a text file ********

Mysql_test is a plug-in used to collect mysql user information. It is uploaded to the mysql official website. It is a type of software operation information feedback function.
It's okay if you kill it.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.