View Single Post
  #29  
Old 12 Mar 2006, 23:50
fastforward fastforward is offline
 
Join Date: Oct 2001
Originally Posted by eva2000
...
- a medium large forum as any forum which has 500+ vB users online over default cookie timeout and at least 300-400 mysql concurrent connections (this is usually the threshold where most vB forums are forced to split to more than one dedicated server)
- a large forum as 800+ vB users online over default cookie timeout and at least 400-600 mysql concurrent connections
- a very large forum as 1,000+ vB users online over default cookie timeout and greater than 600+ mysql concurrent connections
The number of concurrent MySQL connections are only applicable if you are using MyISAM tables. Connections are higher due to the number of threads waiting for table locks to be released. If you're using InnoDB, then the number of connections drops dramatically.

For example, with MyISAM and around 600 people online, I often had over 400 concurrent connections. Since switching to InnoDB, I rarely reach 100 connections.
__________________
BritishExpats.com - (British expatriate community)
Reply With Quote