PP using 30% of dual quad-core 1.6ghz box?

Johnny Doomo · October 30th, 2007, 05:32 PM

I think something is seriously wrong here. My gallery http://www.gamersgallery.com I think is responsible for constant server crashes. I've talked with my management company and they say it's taking 30%. I've had them tweak the server and I've tried tweaking the script, but nothing seems to work.

I had an old thread about this same problem, but figured a new thread with more detail in it would get me faster response. Here's what my WHM reports about my gamersgallery.com site:

User Domain %CPU %MEM Mysql Processes
ggadmin gamersgallery.com 30.40 28.21 0.9
Top Process %CPU 34.4 httpd [gamersgallery.com] [/gallery/showphoto.php/photo/8408/cat/all/page/6]
Top Process %CPU 31.5 httpd [gamersgallery.com] [/gallery/slideshow.php?photo27039&limit&cat1295]
Top Process %CPU 30.5 httpd [gamersgallery.com] [/gallery/showphoto.php/photo/38675/cat/2841/page/2]

Does anybody see a problem here? 2 of those are just regular image pages and one is a setting for the slideshow time before it switched to a new picture.

I really want to solve this problem once and for all. The version that the site is running isn't old at all. (5.03)

The only real modifications that I've done that I don't know if they are affecting the performance is on the frontpage at http://www.gamersgallery.com

The only sections on that page that are dynamically pulling their images are the babes section, user submitted wallpapers, and the Funny & Cool Images section. Everything else on that page I add manually. Could it be anything on that frontpage? (If I need to post the mod code for those sections and how they grab the content from the database, I'd be more than happy to.)

The only other thing that I can even remotely think of what's causing this excessive CPU usage, is the way my categories are setup at http://www.gamersgallery.com/gallery/

Basically, I've used the categories to really help with organizing. You can click on the categories on that page just mentioned and see what I'm talking about. It just has a lot of steps to the tree structure, but I was never told this could cause this problem. The only other thing that I can think of that is somewhat related to all these categories, is that when you click on the upload link to upload a picture, the dropdown box contains the names of all these categories. Could that be too much for the script / server? If so, can somebody help me without how to remove it without affecting what category the pictures are uploaded to?

Thanks for any help, I need to get this problem fixed as it's killing my server constantly.

Chuck S · October 30th, 2007, 05:56 PM

Is this a heavily traveled/viewed video site? I can see that being an issue and yes if you have made modifications to the code uploading clean code might help. However your host should be able to narrow down more importantly which scripts etc might exactly be using the most resources and narrow things down.

Johnny Doomo · October 31st, 2007, 04:35 PM

Quote:

Originally Posted by Chuck S

Is this a heavily traveled/viewed video site? I can see that being an issue and yes if you have made modifications to the code uploading clean code might help. However your host should be able to narrow down more importantly which scripts etc might exactly be using the most resources and narrow things down.

It's not my video site, it's just an image only site. It only has around 50 - 70 people on at a time. (I don't consider that big at all).

I've talked with my management company and they claim that as close as they can narrow it down to is what host account is using the processing. If this isn't true, are there some server performance tracking scripts I should ask them to install that would better pinpoint the problem?

I really didn't want to upgrade to fix the problem, only to have it not fix the problem. I'm more considering an upgrade as a last resort. I don't know how to better pinpoint the problem, but if you could help me on what I should ask for, I can tell it to my management company and they should be able to handle it.

Thanks for any help you can provide.

Chuck S · October 31st, 2007, 05:27 PM

I am not a server guy here. I do know most any host I know can has stuff in place to tell someone what scripts are slow and which ones use up percentage of resources. If they cant come back with definate information we cant know where your issue is or even if its photopost and not your hacking. Lots of changes since 5.03 so I would upgrade and unhacked scripts will run faster than ones with lots of hacks. I do know thats why you wont upgrade.