Intergamod killing cpu usage? [Resolved]

[zenrei]

Your phpBB Version: 2.0.22
phpBB Type: phpBB / IMPortal
MODs: Yes
Your knowledge: Basic Knowledge
Board URL: http://falloutzone.net

PHP Version:
MySQL Version:


What was done before the problem appeared?
nothing


What was done to try to solve the problem?
nothing



De.scription and Message

ok, 3 times today, i get a cpu usage screen from my domain... it says:

If you are the webmaster, your account may have gotten this error for one or more of the following reasons:
Your account has used more than its share of the cpu in the past 60 second sliding window.
Your account has too many concurrent processes running simultanously.
Your account has consumed too much memory.
Your site was recently very busy trying to run inefficient .scripts.
The solution would be to optimize your applications to use less CPU.
Adding appropriate indeces to your SQL tables can often help reduce CPU.
Using static .html documents instead of painful .php .scripts will practically eliminate CPU usage.

Is there something i can do to check what may be killing my CPU??? I don't have many concurrent users (about 10, nothing horrible), what could be killing it??

[tmotley]

I saw nothing out of the ordinary on your site except a 3.8 MB video that downloads automatically on your portal. I don't know if that would cause that or not.

Video I'm talking about

[spoil:1smscpx4]http://www.falloutzone.net/foz/etc/bounce_1.mpeg[/spoil:1smscpx4]

[zenrei]

hmmmm yeah... i'll take that out (was gonna replace it anyway) and see if that helps.

[zenrei]

apparently, there is a .script that is taking 13 seconds to access the database... if i turned on debugging, will it show me what's being accessed when my cpu usage tanks out?

[.QUACK.Major.Pain]

I had the same problem on another site, not using integramod.
My site manager was crapping out - may of been a corrupt file. It was totally draining the resources and eventually my host suspended my site for overloading.

I had to do a fresh install because i didn't know how to track down which file was screwed.

I think your having the same problem. Do you have something on your page that takes forever to load?

Our aaquacks.com site had an issue like this too with a block we installed using a ventrilo monitor. The block took a very long time to load and eventually came up page cannot be displayed inside the block. When I turned off the block, the problem went away and page loads were alot quicker.

[zenrei]

usually, it seems to be when i'm going into a thread... and when i'm posting, but it's not consistantly so

[.QUACK.Major.Pain]

Do you have any banners from other sites?

We have auctionads on one of our sites and some days, it takes a long time to retrieve and load the banners.

[zenrei]

no, i disabled all the banners, the only one is my header, and one i made via a portal block, but i made that myself as well.

So am I to understand that debugging doesn't make a log so I can see what the last thing was that happened before it spikes the CPU??

what's the point in HAVING debug if you can't use it to debug???

[zenrei]

it SEEMS it may be the search function killing the site... i looked at my cpu usage log from my domain peeps...here is a sample for today... each time it spikes it's doing a database query... is that caused by indexing, maybe?

--------------------------------------------------------------------------------
CPU Exceeded Log For Tue Aug 21 10:19:54 2007

Tue Aug 21 10:19:09 2007: used 0.82 seconds of cpu time for HTTP Request: GET /viewtopic.php?p=80875 HTTP/1.0
Tue Aug 21 10:18:54 2007: used 5.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 10:19:01 2007: used 0.64 seconds of cpu time for HTTP Request: GET /viewtopic.php?t=4606&start=15 HTTP/1.1
Tue Aug 21 10:15:56 2007: used 0.43 seconds of cpu time for HTTP Request: GET /album_thumbnail.php?pic_id=650 HTTP/1.1
Tue Aug 21 10:16:02 2007: used 2.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 10:16:01 2007: used 0.38 seconds of cpu time for HTTP Request: GET /shoutbox_view.php?start=0 HTTP/1.1
Tue Aug 21 10:15:54 2007: used 0.32 seconds of cpu time for HTTP Request: GET /shoutbox.php HTTP/1.1
Tue Aug 21 10:15:56 2007: used 0.42 seconds of cpu time for HTTP Request: GET /album_thumbnail.php?pic_id=651 HTTP/1.1
Tue Aug 21 10:16:08 2007: used 0.56 seconds of cpu time for HTTP Request: GET /viewforum.php?f=11&sid=06d914210d91dba6846f620b40593eb1 HTTP/1.1
Tue Aug 21 10:16:06 2007: used 0.56 seconds of cpu time for HTTP Request: GET /viewforum.php?f=11&sid=06d914210d91dba6846f620b40593eb1 HTTP/1.1
Tue Aug 21 10:19:05 2007: used 4.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 10:19:06 2007: used 0.82 seconds of cpu time for HTTP Request: GET /viewtopic.php?p=72066 HTTP/1.1
Tue Aug 21 10:19:35 2007: used 0.78 seconds of cpu time for HTTP Request: GET /viewtopic.php?p=69466 HTTP/1.1
Tue Aug 21 10:19:27 2007: used 0.30 seconds of cpu time for /usr/bin/php viewtopic.php
Tue Aug 21 10:19:46 2007: used 0.33 seconds of cpu time for HTTP Request: GET /imclient.php?mode=1 HTTP/1.1
Tue Aug 21 10:19:51 2007: used 0.55 seconds of cpu time for HTTP Request: GET /viewforum.php?f=11 HTTP/1.1
Tue Aug 21 10:17:22 2007: used 0.56 seconds of cpu time for HTTP Request: GET /viewforum.php?f=11&sid=5f572f8446924ed338c2d74f56a0492b HTTP/1.1
Tue Aug 21 10:14:57 2007: used 0.55 seconds of cpu time for HTTP Request: GET /viewforum.php?f=11&sid=5f572f8446924ed338c2d74f56a0492b HTTP/1.1
Tue Aug 21 10:15:29 2007: used 3.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 10:15:31 2007: used 0.84 seconds of cpu time for HTTP Request: GET /viewtopic.php?p=73056 HTTP/1.0
Tue Aug 21 10:19:47 2007: used 4.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 10:19:48 2007: used 0.52 seconds of cpu time for HTTP Request: GET /viewtopic.php?p=73060 HTTP/1.1
Tue Aug 21 10:19:48 2007: used 0.55 seconds of cpu time for HTTP Request: GET /viewforum.php?f=11 HTTP/1.1
Tue Aug 21 10:15:44 2007: used 0.52 seconds of cpu time for HTTP Request: GET /portal.php HTTP/1.1
Tue Aug 21 10:18:29 2007: used 0.05 seconds of cpu time for HTTP Request: GET /avatar.php/includes/functions_portal.php?phpbb_root_path=http:/h1.ripway.com/ummi/cmdx.txt? HTTP/1.1
Tue Aug 21 10:18:29 2007: used 0.03 seconds of cpu time for HTTP Request: GET /includes/functions_portal.php?phpbb_root_path=http:/h1.ripway.com/ummi/cmdx.txt? HTTP/1.1
Tue Aug 21 10:18:29 2007: used 0.59 seconds of cpu time for HTTP Request: GET /viewforum.php?f=11 HTTP/1.1
Tue Aug 21 10:15:49 2007: used 0.55 seconds of cpu time for HTTP Request: GET /viewforum.php?f=11 HTTP/1.1
Tue Aug 21 10:16:51 2007: used 0.66 seconds of cpu time for HTTP Request: GET /viewtopic.php?p=73714 HTTP/1.0
Tue Aug 21 10:16:49 2007: used 3.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 10:18:16 2007: used 0.84 seconds of cpu time for HTTP Request: GET /viewtopic.php?p=69827 HTTP/1.1
Tue Aug 21 10:18:55 2007: used 0.81 seconds of cpu time for HTTP Request: GET /viewtopic.php?p=71499 HTTP/1.1
Tue Aug 21 10:15:38 2007: used 0.80 seconds of cpu time for HTTP Request: GET /viewtopic.php?p=83627 HTTP/1.0
Tue Aug 21 10:18:45 2007: used 0.33 seconds of cpu time for HTTP Request: GET /imclient.php?mode=1 HTTP/1.1
Tue Aug 21 10:15:42 2007: used 0.32 seconds of cpu time for HTTP Request: GET /imclient.php?mode=1 HTTP/1.1
Tue Aug 21 10:17:36 2007: used 0.83 seconds of cpu time for HTTP Request: GET /viewtopic.php?p=78789 HTTP/1.0
Tue Aug 21 10:18:15 2007: used 5.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 10:17:44 2007: used 0.05 seconds of cpu time for HTTP Request: GET /templates/dark/prillian/layout.css HTTP/1.1
Tue Aug 21 10:17:44 2007: used 0.33 seconds of cpu time for HTTP Request: GET /imclient.php?mode=1 HTTP/1.1
Tue Aug 21 10:19:34 2007: used 6.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 10:19:25 2007: used 0.41 seconds of cpu time for HTTP Request: GET /viewtopic.php?p=72520 HTTP/1.1
Tue Aug 21 10:19:20 2007: used 5.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 10:19:21 2007: used 0.59 seconds of cpu time for HTTP Request: GET /viewtopic.php?p=72029 HTTP/1.1
Tue Aug 21 10:18:34 2007: used 5.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 10:18:35 2007: used 0.69 seconds of cpu time for HTTP Request: GET /viewtopic.php?p=71052 HTTP/1.1
Tue Aug 21 10:17:15 2007: used 0.74 seconds of cpu time for HTTP Request: GET /viewtopic.php?p=77697 HTTP/1.0
Tue Aug 21 10:18:43 2007: used 0.07 seconds of cpu time for HTTP Request: GET /posting.php/includes/functions_portal.php?phpbb_root_path=http:/h1.ripway.com/ummi/cmdx.txt? HTTP/1.1
Tue Aug 21 10:19:30 2007: used 0.11 seconds of cpu time for /usr/bin/php viewtopic.php
Tue Aug 21 10:19:29 2007: used 9.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 10:19:25 2007: used 0.55 seconds of cpu time for HTTP Request: GET /viewforum.php?f=11&sid=5f572f8446924ed338c2d74f56a0492b HTTP/1.1
Tue Aug 21 10:19:34 2007: used 0.39 seconds of cpu time for PROCESS : /usr/bin/php viewtopic.php
Tue Aug 21 10:17:14 2007: used 3.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 10:16:43 2007: used 0.34 seconds of cpu time for HTTP Request: GET /imclient.php?mode=1 HTTP/1.1


--------------------------------------------------------------------------------
CPU Exceeded Log For Tue Aug 21 11:54:01 2007

Tue Aug 21 11:49:25 2007: used 0.04 seconds of cpu time for HTTP Request: GET /templates/dark/images/red/lang_english/icon_online.gif HTTP/1.1
Tue Aug 21 11:49:25 2007: used 0.02 seconds of cpu time for HTTP Request: GET /images/state/us_pennsylvania.gif HTTP/1.1
Tue Aug 21 11:49:26 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/icon_minipost_new.gif HTTP/1.1
Tue Aug 21 11:49:44 2007: used 0.39 seconds of cpu time for HTTP Request: GET /login.php?sid=b89f9098720e53bbc568e7c25c892fbd HTTP/1.1
Tue Aug 21 11:49:21 2007: used 0.04 seconds of cpu time for HTTP Request: GET /templates/dark/images/red/ns_icon_down.gif HTTP/1.1
Tue Aug 21 11:49:21 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/red/topic_export.gif HTTP/1.1
Tue Aug 21 11:49:20 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/red/tb4_l.gif HTTP/1.1
Tue Aug 21 11:49:18 2007: used 0.69 seconds of cpu time for HTTP Request: GET /viewtopic.php?p=83980 HTTP/1.1
Tue Aug 21 11:53:24 2007: used 0.74 seconds of cpu time for /usr/bin/php viewtopic.php
Tue Aug 21 11:53:24 2007: used 6.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 11:53:25 2007: used 0.02 seconds of cpu time for PROCESS : /usr/bin/php viewtopic.php
Tue Aug 21 11:53:14 2007: used 0.57 seconds of cpu time for HTTP Request: GET /viewtopic.php?p=84572#84572 HTTP/1.1
Tue Aug 21 11:53:50 2007: used 0.63 seconds of cpu time for HTTP Request: GET //viewtopic.php?p=70184 HTTP/1.1
Tue Aug 21 11:53:58 2007: used 0.73 seconds of cpu time for HTTP Request: GET //viewtopic.php?p=70220 HTTP/1.1
Tue Aug 21 11:53:58 2007: used 5.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 11:54:01 2007: used 0.53 seconds of cpu time for HTTP Request: GET /viewforum.php?f=11 HTTP/1.1
Tue Aug 21 11:50:23 2007: used 0.64 seconds of cpu time for /usr/bin/php viewtopic.php
Tue Aug 21 11:50:23 2007: used 0.76 seconds of cpu time for HTTP Request: GET /viewtopic.php?t=4602 HTTP/1.1
Tue Aug 21 11:50:23 2007: used 6.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 11:50:24 2007: used 0.15 seconds of cpu time for PROCESS : /usr/bin/php viewtopic.php
Tue Aug 21 11:49:38 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/ftr_images/c_rcap.png HTTP/1.1
Tue Aug 21 11:49:38 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/ftr_images/p_lcap.png HTTP/1.1
Tue Aug 21 11:49:36 2007: used 0.01 seconds of cpu time for HTTP Request: GET /images/logologo.png HTTP/1.1
Tue Aug 21 11:49:36 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/spacer.gif HTTP/1.1
Tue Aug 21 11:49:35 2007: used 0.61 seconds of cpu time for HTTP Request: GET /viewforum.php?f=10 HTTP/1.1
Tue Aug 21 11:52:06 2007: used 0.01 seconds of cpu time for HTTP Request: GET /shop/images/Tyra.gif HTTP/1.1
Tue Aug 21 11:50:25 2007: used 0.31 seconds of cpu time for HTTP Request: GET /album_picm.php?pic_id=526 HTTP/1.1
Tue Aug 21 11:51:32 2007: used 5.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 11:51:14 2007: used 0.72 seconds of cpu time for HTTP Request: GET //viewtopic.php?p=75198 HTTP/1.1
Tue Aug 21 11:51:33 2007: used 0.42 seconds of cpu time for /usr/bin/php viewtopic.php
Tue Aug 21 11:51:37 2007: used 0.16 seconds of cpu time for PROCESS : /usr/bin/php viewtopic.php
Tue Aug 21 11:51:37 2007: used 6.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 11:51:38 2007: used 0.80 seconds of cpu time for php
Tue Aug 21 11:51:39 2007: used 0.02 seconds of cpu time for PROCESS : php
Tue Aug 21 11:52:01 2007: used 0.01 seconds of cpu time for HTTP Request: GET /images/smiles/attentionwhore.gif HTTP/1.1
Tue Aug 21 11:52:00 2007: used 0.02 seconds of cpu time for HTTP Request: GET /templates/dark/images/icon_zodiac_leo.gif HTTP/1.1
Tue Aug 21 11:51:09 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/ftr_images/phpbb_foot_over.png HTTP/1.1
Tue Aug 21 11:51:09 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/ftr_images/phpbb_foot.png HTTP/1.1
Tue Aug 21 11:51:06 2007: used 0.53 seconds of cpu time for HTTP Request: GET /viewforum.php?selected_id=f11 HTTP/1.1
Tue Aug 21 11:51:07 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/green/navbl.gif HTTP/1.1
Tue Aug 21 11:49:08 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/ftr_images/phpbb_foot.png HTTP/1.1
Tue Aug 21 11:49:13 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/cat_folder_big.gif HTTP/1.1
Tue Aug 21 11:49:58 2007: used 0.53 seconds of cpu time for HTTP Request: GET /viewforum.php?selected_id=f11 HTTP/1.1
Tue Aug 21 11:49:50 2007: used 0.30 seconds of cpu time for HTTP Request: POST /login.php HTTP/1.1
Tue Aug 21 11:50:02 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/ftr_images/phpbb_cpyrt.png HTTP/1.1
Tue Aug 21 11:50:15 2007: used 0.63 seconds of cpu time for HTTP Request: GET //viewtopic.php?p=76493 HTTP/1.1
Tue Aug 21 11:49:51 2007: used 0.46 seconds of cpu time for HTTP Request: GET /portal.php?sid=b89f9098720e53bbc568e7c25c892fbd HTTP/1.1
Tue Aug 21 11:49:51 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/dark_black.css HTTP/1.1
Tue Aug 21 11:49:52 2007: used 0.35 seconds of cpu time for HTTP Request: GET /images/avatars/210780898746c5e35be4caa.jpg HTTP/1.1
Tue Aug 21 11:49:52 2007: used 0.64 seconds of cpu time for HTTP Request: GET /shoutbox.php HTTP/1.1
Tue Aug 21 11:49:53 2007: used 0.35 seconds of cpu time for HTTP Request: GET /shoutbox_view.php?start=0 HTTP/1.1
Tue Aug 21 11:52:26 2007: used 0.77 seconds of cpu time for HTTP Request: GET /viewtopic.php?p=7414 HTTP/1.0
Tue Aug 21 11:53:02 2007: used 0.36 seconds of cpu time for HTTP Request: GET /templates/dark/images/ftr_images/c_lcap.png HTTP/1.1
Tue Aug 21 11:51:02 2007: used 0.84 seconds of cpu time for HTTP Request: GET //viewtopic.php?p=70225 HTTP/1.1
Tue Aug 21 11:51:20 2007: used 0.70 seconds of cpu time for HTTP Request: GET //viewtopic.php?p=78524 HTTP/1.1
Tue Aug 21 11:51:19 2007: used 2.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 11:51:13 2007: used 3.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 11:51:56 2007: used 0.56 seconds of cpu time for HTTP Request: GET /viewtopic.php?t=4586&start=30 HTTP/1.1
Tue Aug 21 11:53:00 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/spacer.gif HTTP/1.1
Tue Aug 21 11:53:00 2007: used 0.30 seconds of cpu time for HTTP Request: GET /images/logologo.png HTTP/1.1
Tue Aug 21 11:52:58 2007: used 0.64 seconds of cpu time for HTTP Request: GET //viewtopic.php?p=75194 HTTP/1.1
Tue Aug 21 11:52:59 2007: used 0.45 seconds of cpu time for HTTP Request: GET /index.php?sid=e3b7540b71d1705b898f8fabfedd31c5 HTTP/1.1
Tue Aug 21 11:53:00 2007: used 0.01 seconds of cpu time for HTTP Request: GET /images/smiles/nuke.gif HTTP/1.1
Tue Aug 21 11:51:59 2007: used 0.63 seconds of cpu time for HTTP Request: GET /viewtopic.php?t=4606&start=15 HTTP/1.1
Tue Aug 21 11:52:01 2007: used 0.02 seconds of cpu time for HTTP Request: GET /shop/images/Animal.gif HTTP/1.1
Tue Aug 21 11:52:18 2007: used 0.78 seconds of cpu time for HTTP Request: GET /viewtopic.php?p=81578 HTTP/1.0
Tue Aug 21 11:52:08 2007: used 0.95 seconds of cpu time for HTTP Request: GET /viewtopic.php?t=4586&postdays=0&postorder=asc&&start=15 HTTP/1.1
Tue Aug 21 11:49:23 2007: used 0.02 seconds of cpu time for HTTP Request: GET /templates/dark/images/red/lang_english/icon_pm.gif HTTP/1.1
Tue Aug 21 11:49:19 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/toggle_display.js HTTP/1.1
Tue Aug 21 11:53:11 2007: used 0.01 seconds of cpu time for HTTP Request: GET /images/smiles/icon_question.gif HTTP/1.1
Tue Aug 21 11:53:01 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/cat_folder_big.gif HTTP/1.1
Tue Aug 21 11:49:05 2007: used 0.61 seconds of cpu time for HTTP Request: GET /./viewtopic.php?p=18629 HTTP/1.0
Tue Aug 21 11:49:05 2007: used 2.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 11:49:06 2007: used 0.01 seconds of cpu time for HTTP Request: GET /images/smiles/icon_biggrin.gif HTTP/1.1
Tue Aug 21 11:49:06 2007: used 0.80 seconds of cpu time for HTTP Request: GET /viewtopic.php?t=4319&highlight= HTTP/1.1
Tue Aug 21 11:49:11 2007: used 0.32 seconds of cpu time for HTTP Request: GET /images/logologo.png HTTP/1.1
Tue Aug 21 11:49:10 2007: used 0.45 seconds of cpu time for HTTP Request: GET /index.php?sid=e3b7540b71d1705b898f8fabfedd31c5 HTTP/1.1
Tue Aug 21 11:50:47 2007: used 0.58 seconds of cpu time for HTTP Request: GET /viewtopic.php?p=83324&highlight= HTTP/1.1
Tue Aug 21 11:51:01 2007: used 5.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 11:52:05 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/black/lang_english/icon_email.gif HTTP/1.1
Tue Aug 21 11:52:06 2007: used 0.01 seconds of cpu time for HTTP Request: GET /images/avatars/210780898746c5e35be4caa.jpg HTTP/1.1
Tue Aug 21 11:53:35 2007: used 0.67 seconds of cpu time for HTTP Request: GET //viewtopic.php?p=71052 HTTP/1.1
Tue Aug 21 11:53:34 2007: used 4.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 11:53:17 2007: used 0.01 seconds of cpu time for HTTP Request: GET /shop/images/Animal.gif HTTP/1.1
Tue Aug 21 11:53:17 2007: used 0.01 seconds of cpu time for HTTP Request: GET /images/cash/chedda.gif HTTP/1.1
Tue Aug 21 11:53:50 2007: used 5.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 11:53:09 2007: used 0.02 seconds of cpu time for HTTP Request: GET /templates/toggle_display.js HTTP/1.1
Tue Aug 21 11:53:05 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/ftr_images/phpbb_cpyrt.png HTTP/1.1
Tue Aug 21 11:53:08 2007: used 8.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 11:53:19 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/ftr_images/c_lcap.png HTTP/1.1
Tue Aug 21 11:53:08 2007: used 0.57 seconds of cpu time for HTTP Request: GET /viewforum.php?f=11 HTTP/1.1
Tue Aug 21 11:53:08 2007: used 0.83 seconds of cpu time for HTTP Request: GET //viewtopic.php?p=73093 HTTP/1.1
Tue Aug 21 11:53:08 2007: used 0.57 seconds of cpu time for HTTP Request: GET /viewforum.php?f=11 HTTP/1.1
Tue Aug 21 11:53:08 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/pngfix.js HTTP/1.1
Tue Aug 21 11:53:05 2007: used 5.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 11:51:53 2007: used 0.30 seconds of cpu time for /usr/bin/php viewtopic.php
Tue Aug 21 11:51:55 2007: used 5.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 11:51:56 2007: used 0.31 seconds of cpu time for PROCESS : /usr/bin/php viewtopic.php
Tue Aug 21 11:52:20 2007: used 0.35 seconds of cpu time for HTTP Request: GET /viewtopic.php?download=83500&t=4543 HTTP/1.1
Tue Aug 21 11:49:03 2007: used 0.55 seconds of cpu time for HTTP Request: GET /viewforum.php?f=11&sid=e3b7540b71d1705b898f8fabfedd31c5 HTTP/1.1
Tue Aug 21 11:49:17 2007: used 0.48 seconds of cpu time for HTTP Request: GET /album_showpage.php?pic_id=526&mode=prev HTTP/1.1
Tue Aug 21 11:49:05 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images_sticky.gif HTTP/1.1
Tue Aug 21 11:49:05 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/red/cellpic3.gif HTTP/1.1
Tue Aug 21 11:49:04 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/red/icon_down_arrow.gif HTTP/1.1
Tue Aug 21 11:50:17 2007: used 0.12 seconds of cpu time for HTTP Request: GET /images/avatars/128083393845aa979629daa.jpg HTTP/1.1
Tue Aug 21 11:50:01 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/ftr_images/phpbb_foot.png HTTP/1.1
Tue Aug 21 11:49:59 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/green/navbl.gif HTTP/1.1
Tue Aug 21 11:50:50 2007: used 0.78 seconds of cpu time for HTTP Request: GET //viewtopic.php?p=80137 HTTP/1.1
Tue Aug 21 11:50:37 2007: used 5.00 seconds of cpu time for [[mysql query]]
Tue Aug 21 11:50:37 2007: used 0.77 seconds of cpu time for HTTP Request: GET //viewtopic.php?p=72513 HTTP/1.1
Tue Aug 21 11:53:13 2007: used 0.34 seconds of cpu time for HTTP Request: GET /templates/dark/images/ftr_images/phpbb_cpyrt.png HTTP/1.1
Tue Aug 21 11:53:09 2007: used 0.67 seconds of cpu time for HTTP Request: GET /./viewtopic.php?t=3756 HTTP/1.0
Tue Aug 21 11:53:09 2007: used 0.61 seconds of cpu time for HTTP Request: POST /posting.php HTTP/1.1
Tue Aug 21 11:53:10 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/red/cellpic3.gif HTTP/1.1
Tue Aug 21 11:53:10 2007: used 0.57 seconds of cpu time for HTTP Request: GET /viewtopic.php?p=84572 HTTP/1.1
Tue Aug 21 11:53:13 2007: used 0.35 seconds of cpu time for HTTP Request: GET /templates/dark/images/ftr_images/p_rcap.png HTTP/1.1
Tue Aug 21 11:49:14 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/ftr_images/c_rcap.png HTTP/1.1
Tue Aug 21 11:49:14 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/ftr_images/p_lcap.png HTTP/1.1
Tue Aug 21 11:49:15 2007: used 0.35 seconds of cpu time for HTTP Request: GET /shoutbox_view.php?start=0 HTTP/1.1
Tue Aug 21 11:49:37 2007: used 0.01 seconds of cpu time for HTTP Request: GET /images/smiles/icon_smile.gif HTTP/1.1
Tue Aug 21 11:51:43 2007: used 0.55 seconds of cpu time for HTTP Request: GET /viewforum.php?f=11&sid=b89f9098720e53bbc568e7c25c892fbd HTTP/1.1
Tue Aug 21 11:51:43 2007: used 0.64 seconds of cpu time for HTTP Request: GET /viewtopic.php?p=82989&highlight= HTTP/1.1
Tue Aug 21 11:51:44 2007: used 0.01 seconds of cpu time for HTTP Request: GET /templates/dark/images/black/lang_english/post.gif HTTP/1.1

[zenrei]

upgrading the rebuild search function seemed to help a bit.

but it's still happening... i get page cannot be found when trying to view topic... i tried overwriting view topic, thinking it could be corrupted, but it's still happening

what else can i try??

[Helter]

you might try talking to your host to see if they have recently updated your php, apache, or mysql versions

[zenrei]

Hmmm... doesn't look like it:

php - 4.4.6
apache - 1.3.37 (Unix)
mysql - 4.1.22-standard-log

all of these are the correct specs for 141, right?

[Helter]

yes, those should are fine. IM will run on most combinations, but problems can arise occasionally when they are changed after IM is installed

[zenrei]

you know what? now that i'm thinking about it, about a month ago, they said they were doing working on the sql server... i'm not sure what it was, but ever since then, i've been having the spikes... if they did upgrade, what do i have to do to correct it? reinstall??

[Teelk]

It looks like you went ahead and wiped your site or it's down at the moment. But, what it looks like from those logs is that the problem lies with viewtopic... have you added any MODs that add anything to the viewtopic profile that may make a lot of sql queries?

[CaNNon]

If your a firefox user you can get the firebug add on, using the "net" tab it times everything and shows you in real time as your using the page.

A really handy tool for a lot other little jobs too. <img>

[zenrei]

the smilies category, i HAD to, because i have so many smilies, when people would browse them, their pages would wig out.

[zenrei]

i reinstalled integramod and all the mods and it appears to be flying again.

i have a sneaky suspision that it has something to do with the sql server maintenanace my domain czars did... because it all started then, but it appears to be cookin with gas now <img>