我的CPU exceed 日记,帮我分析下呀!

LWGRM

昨天我的WORDRESS 站关闭了很多插件,晚上还是超了CPU,IP也不到3000  CPU exceed日记如下站名进行了替换)
CPU Exceeded Log For Fri Jul 18 11:06:20 2008

  Fri Jul 18 11:06:19 2008: used  0.49 seconds of cpu time for /ramdisk/bin/php5 /home/medicalh/public_html/mysite/index.php
  Fri Jul 18 11:06:00 2008: used  93.00 seconds of cpu time for [[mysql query]]
  Fri Jul 18 11:05:59 2008: used  1.00 seconds of cpu time for [[mysql query]]
  Fri Jul 18 11:05:55 2008: used  0.40 seconds of cpu time for /ramdisk/bin/php5 /home/medicalh/public_html/mysite/index.php
  Fri Jul 18 11:05:55 2008: used  0.32 seconds of cpu time for /ramdisk/bin/php5 /home/medicalh/public_html/mysite/index.php
  Fri Jul 18 11:05:44 2008: used  9.00 seconds of cpu time for [[mysql query]]
  Fri Jul 18 11:05:31 2008: used  0.11 seconds of cpu time for HTTP Request: www.another-site.info : GET /images/akane-kanazawa/th/akane-kanazawa-0037_thumb.jpg HTTP/1.1
  Fri Jul 18 11:05:11 2008: used  0.04 seconds of cpu time for HTTP Request: www.mysite.com : GET /images/Chieko-Okada/th/chieko%20okada%20is%20a%20pretty%20woman%20from%20jp-01_thumb.jpg HTTP/1.1
  Fri Jul 18 11:05:02 2008: used  0.57 seconds of cpu time for HTTP Request: www.mysite.com : GET /e-mail.gif HTTP/1.0
  Fri Jul 18 11:05:01 2008: used  0.16 seconds of cpu time for HTTP Request: www.another-site-2.com : GET /wp-content/plugins/sem-subscribe-me/img/addmyyahoo.gif HTTP/1.1
  Fri Jul 18 11:05:00 2008: used  0.20 seconds of cpu time for HTTP Request: www.mysite.com : GET /images/07-12-2-k/th/traditional_pretty_china_babe_2_thumb.jpg HTTP/1.1
  Fri Jul 18 11:05:00 2008: used  0.09 seconds of cpu time for PROCESS : /ramdisk/bin/php5 /home/medicalh/public_html/mysite/index.php
  Fri Jul 18 11:04:58 2008: used  2.00 seconds of cpu time for [[mysql query]]
  Fri Jul 18 11:04:58 2008: used  0.08 seconds of cpu time for PROCESS : php5
  Fri Jul 18 11:04:56 2008: used  0.55 seconds of cpu time for php5
  Fri Jul 18 11:04:56 2008: used  0.56 seconds of cpu time for php5
  Fri Jul 18 11:04:56 2008: used  0.30 seconds of cpu time for php5
  Fri Jul 18 11:04:49 2008: used  17.00 seconds of cpu time for [[mysql query]]
  Fri Jul 18 11:04:48 2008: used  4.00 seconds of cpu time for [[mysql query]]
  Fri Jul 18 11:04:48 2008: used  0.11 seconds of cpu time for /ramdisk/bin/php5 /home/medicalh/public_html/mysite/index.php
  Fri Jul 18 11:04:48 2008: used  0.02 seconds of cpu time for /ramdisk/bin/php5 /home/medicalh/public_html/mysite/index.php
  Fri Jul 18 11:04:48 2008: used  0.07 seconds of cpu time for php5
  Fri Jul 18 11:04:48 2008: used  0.01 seconds of cpu time for /ramdisk/bin/php5 /home/medicalh/public_html/mysite/index.php
  Fri Jul 18 11:04:47 2008: used  0.37 seconds of cpu time for /ramdisk/bin/php5 /home/medicalh/public_html/mysite/index.php
  Fri Jul 18 11:04:47 2008: used  0.40 seconds of cpu time for /ramdisk/bin/php5 /home/medicalh/public_html/mysite/index.php
  Fri Jul 18 11:04:47 2008: used  0.49 seconds of cpu time for /ramdisk/bin/php5 /home/medicalh/public_html/mysite/index.php
  Fri Jul 18 11:04:45 2008: used  41.00 seconds of cpu time for [[mysql query]]
  Fri Jul 18 11:04:45 2008: used  0.03 seconds of cpu time for /ramdisk/bin/php5 /home/medicalh/public_html/mysite/index.php
  Fri Jul 18 11:04:45 2008: used  0.24 seconds of cpu time for PROCESS : /ramdisk/bin/php5 /home/medicalh/public_html/celewallpaper/index.php
  Fri Jul 18 11:04:45 2008: used  1.55 seconds of cpu time for PROCESS : /ramdisk/bin/php5 /home/medicalh/public_html/mysite/index.php
  Fri Jul 18 11:04:43 2008: used  0.12 seconds of cpu time for /ramdisk/bin/php5 /home/medicalh/public_html/mysite/index.php
  Fri Jul 18 11:04:42 2008: used  0.70 seconds of cpu time for PROCESS : /ramdisk/bin/php5 /home/medicalh/public_html/mysite/index.php
  Fri Jul 18 11:04:41 2008: used  3.00 seconds of cpu time for [[mysql query]]
  Fri Jul 18 11:04:41 2008: used  0.07 seconds of cpu time for php5
  Fri Jul 18 11:04:41 2008: used  0.02 seconds of cpu time for /ramdisk/bin/php5 /home/medicalh/public_html/mysite/index.php
  Fri Jul 18 11:04:38 2008: used  0.14 seconds of cpu time for /ramdisk/bin/php5 /home/medicalh/public_html/mysite/index.php
  Fri Jul 18 11:04:37 2008: used  65.00 seconds of cpu time for [[mysql query]]
  Fri Jul 18 11:04:37 2008: used  0.15 seconds of cpu time for PROCESS : /ramdisk/bin/php5 /home/medicalh/public_html/mysite/index.php
  Fri Jul 18 11:04:36 2008: used  0.01 seconds of cpu time for /ramdisk/bin/php5 /home/medicalh/public_html/mysite/index.php


请高手帮忙研究下,CPU超过主要出自数据库查询,还是首页index.php 呢?  出自数据库库查询的话,用PHPADMIN 优化数据库有多大作用?
出自index.php,好象没折了吧?  能技术解决最好了,毕竟VPS  独立主机价格要高多了.

一路同行

应该是数据库查询太多了，建议设置查询间歇时间

LWGRM

查询间歇时间 老大你能否明示啊?   我不明白意思呀

一路同行

你是的网站是论坛吗？一般论坛程序都是可以设置，查询、搜索的间隔时间的

LWGRM

原帖由 一路同行 于 2008-7-19 10:04 AM 发表
你是的网站是论坛吗？一般论坛程序都是可以设置，查询、搜索的间隔时间的

我的是wordpress 也能设置吗?  哪里设置呢?