Go Back   vb.org Archive > News and Announcements > vBulletin Pre-Sales Questions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 11-21-2005, 04:05 AM
mike_cruz mike_cruz is offline
 
Join Date: Nov 2005
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Server used by Vbulletin.org?

I'm looking to swtich from phpbb to Vbulletin. I have a dedicated server running MySQL and PHPBB and it runs into "too may SQL connections" problem. Number of users range from 20-100.

Can someone tell me if Vbulletin.org runs multiple servers to support load on this site? 700+ users!

Thanks.
Reply With Quote
  #2  
Old 11-21-2005, 04:11 AM
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Location: Germany
Posts: 6,863
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

AFAIK, vbulletin.org runs on the same server as vbulletin.com and vbulletin-germany.com too.

My board used to run on one server (Dual Xeon 2.4 Ghz, 4 GB RAM, Non-RAID IDE HDs) which was fine for up to approx. 500-600 concurrent users.

I think if you have 15K SCSI HDs in a RAID setup you could even handle more users on one machine.
Reply With Quote
  #3  
Old 11-21-2005, 04:17 AM
Wayne Luke's Avatar
Wayne Luke Wayne Luke is offline
Senior Member
 
Join Date: Jan 2002
Location: Southern California
Posts: 1,694
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by mike_cruz
I'm looking to swtich from phpbb to Vbulletin. I have a dedicated server running MySQL and PHPBB and it runs into "too may SQL connections" problem. Number of users range from 20-100.
This is a MySQL configuration error. By default MySQL only allows a maximum of 100 connections server wide. So if your forum is using it as well as a stats program or web based email, then you can easily and quickly hit the limit. Especially if any of the applications use persistant connections and don't close them when done.

As a vBulletin customer, you are entitled to support including help in optimizing your server for maximum usage of available resources.

Also this server is a Dual Xeon machine with 4 GB of RAM. I think the processors are 2.8 GHZ. I don't really get involved with the hardware though. A couple of our developers maintain the server.
Reply With Quote
  #4  
Old 11-21-2005, 03:23 PM
mike_cruz mike_cruz is offline
 
Join Date: Nov 2005
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thank you. Let me check into the MySQL connection issue first as I feel that 100 is too low to be a problem.

Appreciate all the help so far; I'm liking Vbulletin and the folks who run it already.
Reply With Quote
  #5  
Old 11-21-2005, 07:43 PM
Delphiprogrammi Delphiprogrammi is offline
 
Join Date: Feb 2004
Location: Landen(Belgium)
Posts: 1,335
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

well,

Correct me if i'm wrong but i belive you can edit this in the file called "my.cnf"

Code:
[mysqld]
set-variable = max_connections=500
cheers
Reply With Quote
  #6  
Old 11-22-2005, 05:18 AM
mike_cruz mike_cruz is offline
 
Join Date: Nov 2005
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks. Let me find out how to edit that configuration. I guess my test now is to see how increasing the number of connections decrease server performance. At some point can my P4 2.4 with 1G ram bog down with users?

Cheers.
Reply With Quote
  #7  
Old 11-22-2005, 10:05 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It sure will, the question is how many user it can serve.

We have no knowledge about the server load of phpBB with a given number of users. For an answer to that question i suggest you try at a phpBB support site.

PS Or buy vBulletin ofcourse.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:24 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.03947 seconds
  • Memory Usage 2,217KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete