Previous Thread
Next Thread
Print Thread
Rate Thread
#241219 03/20/2003 12:33 PM
Joined: Nov 2002
Posts: 116
Journeyman
Journeyman
Offline
Joined: Nov 2002
Posts: 116
Hi
Recently my host (myacen.com) told me that my site impacting others and so they had to cancel my host account. They provided my with the following information

Code
 25247 mysql 24 0 13156 12M 1376 R 72.9 0.8 0:05 mysqld <br /><br />72.9% of cpu power. <br /><br />5143 | hal9000_admin | localhost | hal9000_forum | Query | 2 | Sending data | <br />SELECT COUNT(*) <br />FROM ubbthreadsPosts <br />WHERE B_Number = B_Main <br />AND B_Approved = |  


I would like to ask you if this script shows anything far from big use of cpu power . I think that this is normal for a large database. They said that a hacked file may causing this behiavour.

What's your opinion?

Sponsored Links
dlhanso #241220 03/20/2003 2:37 PM
Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
The easiest thing to do is to turn on the debugging info and watch the number of queries and time involved at the bottom of every page in your forum.

IIP can be very intensive if you aren't caching the info... as there's lots of info to lookup, depending on the number of posts/users/forums etc...

Turning the config to "partial" new post tracking, instead of "full" will save (I think) 2 queries per forum on the main index as well.

Daine #241221 03/22/2003 11:17 AM
Joined: Feb 2002
Posts: 1,759
Addict
Addict
Offline
Joined: Feb 2002
Posts: 1,759
I know Maycen, and from what I know I doubt they would lie to cancel an account. How big of a site do you have and how many users are usually online? Depending on their hardware configuration a large site with 50-100 users online all the time can be fairly taxing on a single CPU site with not much RAM.

I know my site, with 45-80 users online all the time on a PIII 1.2ghz machine with a gig of ram on a semi-dedicated server of mine was essentially eating up about 80% of server resources at peak times. So I moved it to a more powerful server that is completely decdicated, and even then it is still using a good chunk of the CPU power.



Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Posts: 70
Joined: January 2007
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)