WHM VPS的数据库优化问题,占用CPU资源太高了!!


如下面截图所示
图片描述

占用CPY资源足足 343%,这太可怕了!
请教高手怎么优化?
点击“Trace”之后,看到进程一直在不断重复执行


 fcntl(18, F_GETFL)                      = 0x2 (flags O_RDWR)
fcntl(18, F_SETFL, O_RDWR|O_NONBLOCK)   = 0
accept(18, {sa_family=AF_FILE, NULL}, [2]) = 342
fcntl(18, F_SETFL, O_RDWR)              = 0
setsockopt(342, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
gettimeofday({1429663162, 700223}, NULL) = 0
mmap(NULL, 266240, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS|MAP_STACK, -1, 0) = 0x7ff4f26ee000
mprotect(0x7ff4f26ee000, 4096, PROT_NONE) = 0
clone(child_stack=0x7ff4f272dfd0, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tidptr=0x7ff4f272e9d0, tls=0x7ff4f272e700, child_tidptr=0x7ff4f272e9d0) = 4154
poll([{fd=15, events=POLLIN}, {fd=18, events=POLLIN}], 2, -1) = 1 ([{fd=18, revents=POLLIN}])

数据库 mysql vps mysql优化 服务器

小黑屋调教 9 years, 1 month ago

进到mysql命令行


 select * FROM information_schema.PROCESSLIST WHERE INFO IS NOT NULL;

看一下在最高峰这个会查询到什么东西,既然mysql在做事,你又想知道它在做什么,去看看不就知道了吗?

八十八粒米 answered 9 years, 1 month ago

Your Answer