vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   vbulletin is killing my server! :( (https://vborg.vbsupport.ru/showthread.php?t=60073)

Areku 01-11-2004 05:30 PM
vbulletin is killing my server! :(
 
HI there,

I'm getting mad...

Vbulletin seems to be working fine. Right now I'm running 2.3.0 and its a bit hacked but they're quite "standard" hacks, like quick reply, pm popup box, vbarcade and member photo.

Server is a dedicated dual Xeon with 1Gb Ram. Im running latest php and mysql versions.

I've seen traffic of an average of 500 simultanous users and microstats keep displaying a server load average of 0.85...

However, sometimes, all of a sudden, something makes it go mad and server reaches loads of 170.x and up, bringing apache and mysql down...

HOW can I identify the problem? First I thought it was vbportal, but i replaced it with vbhome lite and problem persists...

Help PLEASE!

Zachery 01-11-2004 05:32 PM
Quote:
Originally Posted by Areku
HI there,

I'm getting mad...

Vbulletin seems to be working fine. Right now I'm running 2.3.0 and its a bit hacked but they're quite "standard" hacks, like quick reply, pm popup box, vbarcade and member photo.

Server is a dedicated dual Xeon with 1Gb Ram. Im running latest php and mysql versions.

I've seen traffic of an average of 500 simultanous users and microstats keep displaying a server load average of 0.85...

However, sometimes, all of a sudden, something makes it go mad and server reaches loads of 170.x and up, bringing apache and mysql down...


HOW can I identify the problem? First I thought it was vbportal, but i replaced it with vbhome lite and problem persists...

Help PLEASE!
well i can suggest switching to vbulletin 3.0 as i know it has decreased server load in many instances,

you should go to vbulletin.com and talk to eva2000 and he will help you tweak the mysql settings :)

Areku 01-11-2004 05:47 PM
But this is not an issue of "vb 2.xx being overloader than vb 3.xx"...

When it works, it works fine, keeping server low (0.8x), but there's something making it hit the 170.xx...

Link14716 01-11-2004 06:29 PM
How many games are in your arcade?

Areku 01-11-2004 06:32 PM
14

Zachery 01-11-2004 06:37 PM
Quote:
Originally Posted by Areku
But this is not an issue of "vb 2.xx being overloader than vb 3.xx"...

When it works, it works fine, keeping server low (0.8x), but there's something making it hit the 170.xx...
overall vB3 is less server intensive than vB2 i still suggest talking to eva2000 in the server configuration area thought :)

Link14716 01-11-2004 06:42 PM
Even though 14 arcade games aren't a lot, a major problem with the arcade is the number of queries skyrocket when you add more games. I believe that it might be causing the chaos.

Areku 01-11-2004 06:44 PM
I think server is tweaked VBoriented, and I'll talk to eva2000, but the problem is clearly temporary and it occurrs may be once or twice a day, being days with no problems at all...

I don't think arcade is the problem either, mine is not a game-oriented forum, and I think arcade is the least traffiqued area of my site...

Zachery 01-11-2004 06:44 PM
Quote:
Originally Posted by Areku
I think server is tweaked VBoriented, and I'll talk to eva2000, but the problem is clearly temporary and it occurrs may be once or twice a day, being days with no problems at all...

I don't think arcade is the problem either, mine is not a game-oriented forum, and I think arcade is the least traffiqued area of my site...
do you have mysql 4.0.17 with querry cacheing enabled?

Areku 01-11-2004 06:45 PM
For example, right now, 517 online users, 11 playing the arcade. Server load: 1.40

Areku 01-11-2004 06:47 PM
Faranth were do I check that?

MySQL is v3.23.58
PHP v4.3.3

Zachery 01-11-2004 06:51 PM
Quote:
Originally Posted by Areku
Faranth were do I check that?

MySQL is v3.23.58
PHP v4.3.3
im purdy sure its only aviable in the 4.x serries

Areku 01-11-2004 06:52 PM
Isn't there any sort of "server load vs scripts" logger?

Ie. before load gets higher than xx, i get a log of what caused it?

Areku 01-11-2004 06:53 PM
faranth,

would a mysql upgrade + enabling cache save us?

Link14716 01-11-2004 06:53 PM
I'm still putting my money on the arcade hack being the culprit.

Zachery 01-11-2004 06:54 PM
Quote:
Originally Posted by Areku
faranth,

would a mysql upgrade + enabling cache save us?
it might, but im not mysql expert :) thats why its always best to ask eva :)

NTLDR 01-11-2004 06:54 PM
Yep, query caching is only available in MySQL 4.x, I'd recommend upgrading to that for starters :) I'd also recommend installing MMCache, Erwin wrote a tutorial over at vB.com for it.

Areku 01-11-2004 09:33 PM
It seems I can't upgrade as server works with Ensim... any other tips?

Erwin 01-11-2004 11:30 PM
What does MRTG (or whatever you use to monitor stats) say regarding when the load is highest?

eva2000 01-12-2004 06:20 AM
Quote:
Originally Posted by Areku
HI there,

I'm getting mad...

Vbulletin seems to be working fine. Right now I'm running 2.3.0 and its a bit hacked but they're quite "standard" hacks, like quick reply, pm popup box, vbarcade and member photo.

Server is a dedicated dual Xeon with 1Gb Ram. Im running latest php and mysql versions.

I've seen traffic of an average of 500 simultanous users and microstats keep displaying a server load average of 0.85...

However, sometimes, all of a sudden, something makes it go mad and server reaches loads of 170.x and up, bringing apache and mysql down...


HOW can I identify the problem? First I thought it was vbportal, but i replaced it with vbhome lite and problem persists...

Help PLEASE!
go to server config forum at vbulletin.com and post a thread with this required info http://www.vbulletin.com/forum/showthread.php?t=70117 :)

Areku 01-12-2004 08:04 AM
eva2000, done.

Erwin, which kind of info exactly?

I've been told the server goes down due to a LOOP caused by a PHP/MYSQL call...

Does any1 know of any hack that would cause this/Has caused this in the past with VB 2.x series?

Zachery 01-12-2004 08:05 AM
id guess its squalls call on the arcade hack

Areku 01-12-2004 08:28 AM
Ok i'll try to disable this and see if server keeps alive...

g-force2k2 01-12-2004 08:40 AM
Use vbulletin's debug mode to display the query load how many are being made and how long each takes. That way you can get a closer fix on what the problem is.

Regards,
g-force2k2

Areku 01-12-2004 09:52 AM
I can now say it's not due to VBPRO ARCADE.... Server went down twice after turning the arcade off...

I already have microstats enabled and I monitor both the queries and server load from there...

I've seen VB working with PRO ARCADE enabled with 500 users online and server load be 0.85, so I DON'T THINK it's VB itself, but some sort of loop (as adviced by the server administration dept.) that it's causing the server overload (once it starts going up, load won't stop until apache and mysql go down).

Problem is mainly identifying the source of the loop...
:(

Erwin 01-12-2004 10:44 AM
Quote:
Originally Posted by Areku
I can now say it's not due to VBPRO ARCADE.... Server went down twice after turning the arcade off...

I already have microstats enabled and I monitor both the queries and server load from there...

I've seen VB working with PRO ARCADE enabled with 500 users online and server load be 0.85, so I DON'T THINK it's VB itself, but some sort of loop (as adviced by the server administration dept.) that it's causing the server overload (once it starts going up, load won't stop until apache and mysql go down).

Problem is mainly identifying the source of the loop...
:(
It might not be vB - it might be the way your server is set up, or a cron job. Does this happen at the same time each day?

Areku 01-12-2004 10:52 AM
It's a standard Rackshack (now EV1) dual xeon server, quite "normal" afai understand...

And no, it's not a cron job.

Erwin 01-12-2004 11:01 AM
Quote:
Originally Posted by Areku
It's a standard Rackshack (now EV1) dual xeon server, quite "normal" afai understand...

And no, it's not a cron job.
I have the same server. :) I have an ev1 dual xeon with 4Mb RAM. How busy is your server? My loads were fine on vB2. Do you need more RAM?

Areku 01-12-2004 11:10 AM
4Mb Ram? wow! ;)

I just have 1Gb RAM...

But I'm afraid whatever the bug is, it would consume the whole thing no matter how much resources I add, as it seems the load is only stopped once services (apache/sql) fail.....

And the server is NORMALLY not that busy, which means that in normal conditions, it averages 0.8x to 1.x load averages... Far from the 4.x maximum permitted...

Brad 01-12-2004 01:01 PM
Quote:
Originally Posted by Areku
4Mb Ram? wow! ;)

I just have 1Gb RAM...

But I'm afraid whatever the bug is, it would consume the whole thing no matter how much resources I add, as it seems the load is only stopped once services (apache/sql) fail.....

And the server is NORMALLY not that busy, which means that in normal conditions, it averages 0.8x to 1.x load averages... Far from the 4.x maximum permitted...
What other hacks do you have installed?, you need to find this loop and kill it/optimize it.

cirisme 01-12-2004 08:57 PM
Quote:
Originally Posted by Areku
It seems I can't upgrade as server works with Ensim... any other tips?
I had no trouble with using MySQl 4 + Turck MMCache with Ensim :)

It sounds like possibly a cron script that hangs. It might also be a form of a dos attack... we had this a while back and it took 3 weeks to find out why we had daily outages for no apparent reason.

When this happens, what does top say?

eva2000 01-13-2004 12:32 AM
Quote:
Originally Posted by Areku
It's a standard Rackshack (now EV1) dual xeon server, quite "normal" afai understand...

And no, it's not a cron job.
nah ya problem is your apache/mysql configuration settings.. as stated at vbulletin.com support forums :)


All times are GMT. The time now is 04:47 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01225 seconds
  • Memory Usage 1,804KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (32)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete