| Author |
Message |
ksen
Joined: 04 Jun 2006
Posts: 142
|
|
 Heavy server load |
 |
Hi, i'm writing after a very long time, mainly due to the fact that my site has been running smoothly for all this time 
But now i'm starting to have a bit of problems. It simply takes ages to open the www.mysite.com/admin page. However the proper web site is working normally and even the full news pages open normally, But this could be due to the fact that there is a good cache system in plc and the pages are read off the memory.
I contacted my server thru the help desk about the problem and this is what they had to say.
"We found that your database was causing high cpu usage. Please consult with your programmers to double check the query on the webpages and find tune the database."
A couple of important info about the site is that currently i have 4903 articles in the database (8.4MB). AND also i have a minimum of 5000 (five thousand) visitors to the site per DAY. (With about 20 new articles added daily.)
And this whole slow problem started about 2 weeks ago!! So do u think the script is starting to creak under the weight of the usage??
Any advice guys? Or any tips on how to optimize?
Btw does anybody currently have a web site tunning cutenews with a larger database with a larger visitor rate?? Any problems with those??
|
|
| Mon Mar 05, 2007 5:59 pm |
  |
 |
Guest
|
| |
|
Please login to hide the ads.
|
|
|
|
|
FI-DD
Admin
Joined: 22 Sep 2005
Posts: 2857
Location: Germany |
|
| |
|
http://harrypotterspage.com/news.php
News: 3933 (3.56 MByte)
Comments: 27689 (10.76 MByte)
The webmaster told me about having several hundred thousand page views per month.
What exactly takes the time? Loading the login page or logging in or going to "Main" or going to "Edit news" or ...?
|
|
| Mon Mar 05, 2007 7:06 pm |
|
|
ksen
Joined: 04 Jun 2006
Posts: 142
|
|
| |
|
ok great!! point taken!
Well i think u asked the precise question-
 | | What exactly takes the time? Loading the login page or logging in or going to "Main" or going to "Edit news" or ...? |
Loading the login page is the immediate problem!! Sometimes the editor has to be refreshing the page for over an hour!! (honestly over an hour!!)
Puttin the user/pass and getting in is not so much of a problem. Then once in, the problem is somewhat there with error pages cummin up only evry few articles, when they are attempted to be added to the DB. The funny part is that when a article is attempted to be inserted and when we get a error page, the next time we check, the artcle has actually been inserted - just that the success page fails to show up.
| | http://harrypotterspage.com/news.php
News: 3933 (3.56 MByte)
Comments: 27689 (10.76 MByte)
The webmaster told me about having several hundred thousand page views per month. |
Is this site hosted on shared hosting or VPS / dedicated???
|
|
| Tue Mar 06, 2007 4:33 am |
|
|
astrostart
Joined: 11 Feb 2007
Posts: 124
Location: The Netherlands |
|
| |
|
My website has more than 10.000 pageviews a day (so more than 300.000 pageviews a month). We have 5.000 newsmessages and almost 28.000 comments.
Sometimes I see a slowdown, but the script often loads very quickly.
_________________
My site: http://www.astrostart.nl | Thanks to everyone here who has helped me! |
|
| Tue Mar 06, 2007 4:06 pm |
 |
|
scottdallas
Joined: 04 May 2006
Posts: 2027
Location: US |
|
| |
|
I also don't have trouble on either of my high traffic and high news sites. The only thing is the admin panel blanks out occasionally so I add using the guest can add news hack with a few modifications.. which in some ways is faster and easier considering it doesn't load through the admin panel. So when you load that page it's like BAM I'm ready for content. More? Not a problem! Ready again!
_________________
www.scodal.com is an example of cnr as a social forum - www.scottdizzle.com is an example of cnr as a personal website to share whatever cool stuff i feel like. i have another, but it's nsfw. pm me |
|
| Tue Mar 06, 2007 5:31 pm |
 |
|
FI-DD
Admin
Joined: 22 Sep 2005
Posts: 2857
Location: Germany |
|
| |
|
| | Loading the login page is the immediate problem!! Sometimes the editor has to be refreshing the page for over an hour!! (honestly over an hour!!) |
That's really weird because there's no database query in index.php. It only includes head.php which has 2 database queries: It queries the category table and the user table. So the number of news shouldn't matter when loading index.php.
What plugins are you using?
|
|
| Tue Mar 06, 2007 6:33 pm |
|
|
ksen
Joined: 04 Jun 2006
Posts: 142
|
|
| |
|
The main plugind that i'm using are only cnfunction, newsletter, and visual editor, Prev-next-links and meta tags!! I dont even use xfields!!
Hmm.. the more i'm convinced that the server seems to be giving sometrouble. Thanx for all the lafp guys
|
|
| Wed Mar 07, 2007 6:43 pm |
|
|
ksen
Joined: 04 Jun 2006
Posts: 142
|
|
| |
|
hey by the way,
| | My website has more than 10.000 pageviews a day (so more than 300.000 pageviews a month). We have 5.000 newsmessages and almost 28.000 comments.
|
are these sites on shared hsoting??
|
|
| Thu Mar 08, 2007 1:59 am |
|
|
astrostart
Joined: 11 Feb 2007
Posts: 124
Location: The Netherlands |
|
| |
|
Its just one site
But yeah, it is on a shared hosting. The site is not on my own server.
_________________
My site: http://www.astrostart.nl | Thanks to everyone here who has helped me! |
|
| Fri Mar 09, 2007 2:03 pm |
|
|
ksen
Joined: 04 Jun 2006
Posts: 142
|
|
| SITE DOWN!!! |
|
Can you beleive it!! My server pulled down my web site yesterday!! And we frantically uploaded backup copies on to different server and after much hanggling got the first server to do a re-direct as a temporary measure!!
They simply didnt reveal what the problem was until after the site was pulled down. The reason for the 100% server usage was given as
" An large number of proccesses accesing the data/url.ini file"
My mod_rewrite is off so i had frienly URLs off and had the normal url.ini code in there.
Well anyways now we are shifting to a dedicated server. But i'm still very curious as to what the problem with the url.ini file was that it required so much of resources!!! Except for the fact that we had 13500 unique visitors on the site the day before it was shut, with nearly 400,000 hits...
Any ways i will post more details on this in due course... If anyone has experienced similar problems i would appreciate sharing the outcome of it.
Thanx..
|
|
| Thu Mar 29, 2007 1:23 pm |
|
|
scottdallas
Joined: 04 May 2006
Posts: 2027
Location: US |
|
| |
|
What! That's awful! I can't believe it! That makes me nervous about all my projects. I would be sick if they just got taken down one day. So what's your solution? Are you going to be able to put up the site again?
_________________
www.scodal.com is an example of cnr as a social forum - www.scottdizzle.com is an example of cnr as a personal website to share whatever cool stuff i feel like. i have another, but it's nsfw. pm me |
|
| Thu Mar 29, 2007 5:38 pm |
|
|
|
