powerful-server ==> slow-forum

[elrafei]

What are the best possibilities for server in the case of the many members and visitors?

What is the best size required database must not exceed about?

If the server best forum is not good and it hacks Yet there is remarkably slow in the Forum is the solution?


What is the connection speed required for the server?

[SEOvB]

All of those are hypothetical questions which you can't get an accurate answer for

[elrafei]

thanks FRDS for your reply

my forum all the day database errors

To the Forum by a large number of members and visitors, and many problems now occur in the database for the Forum for example
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections
/usr/home/amrkhaled/public_html/forum/includes/class_core.php on line 274

MySQL Error :
Error Number :
Date : Saturday, September 6th 2008 @ 06:02:59 PM
Script : http://forum.
Referrer : http://forum.
IP Address : 41.196.179.226
Username :
Classname : vB_Database


The possibilities with the server is


Intel Xeon Dual Quad Core 2.33
8 GB RAM
FreeBSD 7.0
PHP 5.26
Apache 2.2.8
MySQL 5.1.25

Is this enough possibilities?

Is this a server or this potential sufficient to deal with a good standard, the Forum?

If were not good, what are the specifications required for large server and a special forum for a large number of visitors and members and the size of the database of 4.32 GB


myforum

Currently Active Users: 830 (146 members and 684 guests)

[SEOvB]

you may need to optimize your server settings in such files such as my.cnf, php.ini httpd.conf just to name a few.

Post a optimization request over in the forum at vBulletin.com and those guys will help you out

[azn_romeo_4u]

Your server is better than mine in terms of memory. I have a 2.5ghz dual quad harpertown with 4 gigs of ram. Here's what I learned. My server gets 20k visitors per day and over 5million file requests per day.

Install Memcache - brilliant. I was getting crashes the same as you "mysql has gone away" like 100 of these per day but I allocated 1 gig of memory to memcache and the messages have dropped down to like 4-10 per day.

Better HDD - Scsi for faster rpm and I/O wait. Forums that have a ton of visitors usually have high I/O wait. 10k rpm scsi drive works so much better than a normal 7200rpm sata. I ran my forum about two year ago on a Dual Xeon 2.8ghz (old 2003 models) 36gb scsi drive with 2gb ram with about 40-60% of the visitors I have now and it worked out good! But wouldn't be able to handle my website now. Scsi drives are very good. I don't have one now though T_T too expensive with my host.

Like FRDS said, httpd.conf, my.cnf, and php.ini memcache, and apc could be good. If you have 45 bucks to spare try www.litespeedtech.com I here it works very very very well. Free 15 day trail with 2 cores running.

But first I would try to increase the memory amount that you allocate to memcache if you have this installed. Since you have 8 gigs of ram, 2gigs to memcache should be good I think.

[mute]

Originally Posted by azn_romeo_4u

Your server is better than mine in terms of memory. I have a 2.5ghz dual quad harpertown with 4 gigs of ram. Here's what I learned. My server gets 20k visitors per day and over 5million file requests per day.

Install Memcache - brilliant. I was getting crashes the same as you "mysql has gone away" like 100 of these per day but I allocated 1 gig of memory to memcache and the messages have dropped down to like 4-10 per day.

Better HDD - Scsi for faster rpm and I/O wait. Forums that have a ton of visitors usually have high I/O wait. 10k rpm scsi drive works so much better than a normal 7200rpm sata. I ran my forum about two year ago on a Dual Xeon 2.8ghz (old 2003 models) 36gb scsi drive with 2gb ram with about 40-60% of the visitors I have now and it worked out good! But wouldn't be able to handle my website now. Scsi drives are very good. I don't have one now though T_T too expensive with my host.

Like FRDS said, httpd.conf, my.cnf, and php.ini memcache, and apc could be good. If you have 45 bucks to spare try www.litespeedtech.com I here it works very very very well. Free 15 day trail with 2 cores running.

But first I would try to increase the memory amount that you allocate to memcache if you have this installed. Since you have 8 gigs of ram, 2gigs to memcache should be good I think.

Actually, if you're just using the built in memcache functionality in vBulletin, you don't need more than 64 megabytes of memory allocated for memcache. By default, the amount of information stored in memcache by vBulletin (the datastore) is very small. Allocating more memory for memcache when vBulletin isn't storing anything but the datastore in it is a waste.

[azn_romeo_4u]

I haven't used the built in memcache feature that vb uses.

Seriously working wonders right now. 100 mysql messages per day about errors down to virutally zero. http://www.danga.com/memcached/

# ./memcached -d -m 2048 -l 10.0.0.40 -p 11211

He has 8 gigs of ram, 2 to memcache shouldn't be a big deal right?

[mute]

Originally Posted by azn_romeo_4u

I haven't used the built in memcache feature that vb uses.

Seriously working wonders right now. 100 mysql messages per day about errors down to virutally zero. http://www.danga.com/memcached/



He has 8 gigs of ram, 2 to memcache shouldn't be a big deal right?

You're missing the point, if you allocate that much memory, and vBulletin is the only thing using memcache, and you're not caching anything other than the datastore, it's going to waste. You might as well yank it out of the machine..

[Alfa1]

Originally Posted by elrafei

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections
/usr/home/amrkhaled/public_html/forum/includes/class_core.php on line 274

As said above you will have to review your server settings. Start by upping your allowed connections, until this error disappears. 200 should do it.