| 作者 |
 请教归坛的MYSQL高手：MYSQL的CPU一下就达到100%，应该怎么解决？（响应极少的情况下） |
 |
| 所跟贴 |
请教归坛的MYSQL高手：MYSQL的CPU一下就达到100%，应该怎么解决？（响应极少的情况下） -- 文成武德周，乾坤日月明，天地正气锋 - (422 Byte) 2006-1-13 周五, 17:13 (1415 reads) |
ykliu
头衔: 海归少校
加入时间: 2004/07/21
文章: 78
海归分: 10818
|
|
|
作者：ykliu 在 海归商务 发贴, 来自【海归网】 http://www.haiguinet.com
You may check this first.
Your memory usage on your system is high 720/920, I assume you have 512M physical memory rest is swap space. So most likely your system is swapping. That will make your system performance down to toilet. Can't see your system CPU usage, I suspect it using rest 30ish CPU time. Check what process using so much memory, your apache/mysql memory usage seems normal.
Next,
1. Check your mysql error log see if any outstanding errors
2. Your apache also using high CPU together with mysql, so most likely you have a loophole somewhere in your application.
Check mysql Bin log if you turned that on, see what query get executed recently.
3. Login to mysql,
show full processlist\G；
See how many processes runing and what they are running
作者：ykliu 在 海归商务 发贴, 来自【海归网】 http://www.haiguinet.com
|
|
|
| 返回顶端 |
|
 |
|
| |
|
|
|
您不能在本论坛发表新主题, 不能回复主题, 不能编辑自己的文章, 不能删除自己的文章, 不能发表投票, 您 不可以 发表活动帖子在本论坛, 不能添加附件不能下载文件, |
|
|
