Configuration [Archive] - vBulletin Community Forum

Dell

Tue 14th Jan '03, 5:32pm

I got a forums that at time will have 3000 + users online and having mysql problems.

1. Server load ( mysql )

Processors 4
Model Intel(R) Xeon(TM) CPU 2.80GHz
Chip MHz 2799.75
Cache Size 512 KB
System Bogomips 22373.97
Ram 4 gig
PCI Devices PCI device 8086:248b (Intel Corporation)
PCI device 8086:1461 (Intel Corporation)
PCI device 8086:1461 (Intel Corporation)
PCI device 8086:100f (Intel Corporation)
PCI device 1119:0136 (ICP Vortex Computersysteme GmbH)
Intel Corporation 82557 [Ethernet Pro 100]
ATI Technologies Inc Rage XL

IDE Devices hda: CDU5211

SCSI Devices ICP Host Drive #00 ( Direct-Access )
raid 10
the way I figure it the server should be able to handle 4000 members online I could be wrong.

my main problem is server load @ 1700 online. I see no reason for this with this type of hardware I have another forum that I host that is 1/3 the hardware and had 1500 online with a server load of 2.0
This hardware seams to go's to a load of 35 + w/1700 online
It seams its all mysql and process not closing.

Any suggestions would be greatly appreciated

Steve Machol

Tue 14th Jan '03, 5:43pm

To get vb support on these forums you first need to register for Priority Forum Support. To do this, please click HERE (http://www.vbulletin.com/members/forums.php) and enter your email address in one of the boxes. You'll need to have your customer number and password to access the page. Thanks.

Dell

Tue 14th Jan '03, 5:45pm

I guess me email address was out of date I think I fixed it sorry

Steve Machol

Tue 14th Jan '03, 5:50pm

Thanks. Have you tried turning off persistant connections in the config.php file? You might also want to post your server info, link to phpinfo and contents of your my.cnf file in the Server Configuration forum since this is likely to require optimizing your server.

Dell

Tue 14th Jan '03, 5:59pm

[mysqld]
port = 3306
datadir=/var/lib/mysql
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = max_connections=6000
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
set-variable = wait_timeout=7200
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[myisamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

eva2000

Tue 14th Jan '03, 10:37pm

Originally posted by Dell
I got a forums that at time will have 3000 + users online and having mysql problems.

1. Server load ( mysql )

Processors 4
Model Intel(R) Xeon(TM) CPU 2.80GHz
Chip MHz 2799.75
Cache Size 512 KB
System Bogomips 22373.97
Ram 4 gig
PCI Devices PCI device 8086:248b (Intel Corporation)
PCI device 8086:1461 (Intel Corporation)
PCI device 8086:1461 (Intel Corporation)
PCI device 8086:100f (Intel Corporation)
PCI device 1119:0136 (ICP Vortex Computersysteme GmbH)
Intel Corporation 82557 [Ethernet Pro 100]
ATI Technologies Inc Rage XL

IDE Devices hda: CDU5211

SCSI Devices ICP Host Drive #00 ( Direct-Access )
raid 10
the way I figure it the server should be able to handle 4000 members online I could be wrong.

my main problem is server load @ 1700 online. I see no reason for this with this type of hardware I have another forum that I host that is 1/3 the hardware and had 1500 online with a server load of 2.0
This hardware seams to go's to a load of 35 + w/1700 online
It seams its all mysql and process not closing.

Any suggestions would be greatly appreciated 1 server for that many users :eek:

okay please provide the following

1. is this on dedicated or shared virual server
2. your server specs, such as mysql and php version
3. if possible how mysql was compiled/installed
4. your top stats
5. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf if on Windows server if you don't have that file you need to log into telnet and as root user type

mysqladmin -u root -p variables

copy and paste output here

6. your mysql extended-status output either still telnet as root user type

mysqladmin -u root -p extended-status

copy and paste output here

or preferred is to installed extended-status output script which is either located

- in your vB 2.2.6 or higher vB version's zip file extra's folder, upload mysqlinfo.php script to your site or if you're on an pre vB 2.2.6 install go to
- http://vbulletin.com/forum/showthread.php?threadid=3477 and install that scrip making sure to edit $mysqllogin line with your own mysqlusername and password

and post url to that here

7. oh and is your vB the only thing on the server? or other scripts? sites?

8. how many average and max concurrent users on your vB forum ?

9. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site

<?
phpinfo();
?>

i.e. yourdomain.com/phpinfo.php

10. if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following :

KeepAlive
MaxKeepAliveRequests
KeepAliveTimeout
MinSpareServers
MaxSpareServers
StartServers
MaxClients

11. what version of vB are you running ?

eva2000

Tue 14th Jan '03, 10:38pm

also could you post the same details for the other forum you mentioned, so i can compare their forum activity on both servers

Dell

Wed 15th Jan '03, 10:21am

1 server for that many users :eek:
keep in mind this server serves 1 site:
4 Intel(R) Xeon(TM) CPU 2.80GHz
4gig ram
6 SCSI 1500rpm drives w/Raid

This is a dedicated server
my.cnf is located above in post
Vb is pretty much the only thing running on the server few miscellaneous html pages:

Average vb users online is 1500, max is 3300 + during peak times I believe there could be as many as 4 to 5000 if no mysql errors

MaxKeepAliveRequests 500
KeepAliveTimeout 15
MinSpareServers 15
MaxSpareServers 20
StartServers 20

Mysql v3.23.41
Zend Accelerator v2.0.5,
PHP Version 4.2.2
vB version is 2.2.4

phpinfo: http://64.141.32.215/phpinfo.php (http://64.141.32.215/phpinfo.php)

continued below:

Dell

Wed 15th Jan '03, 10:24am

eva2000

Thu 16th Jan '03, 3:31am

i see a Quad P4 2.8 Xeon that explains how you can handle such a load to this date

can you post a url to your mysqlinfo.php link for this server ?

also how was mysql installed ? via rpm binary or compiled from source ?

better yet, if you want, you can submit an official support ticket at http://www.vbulletin.com/members/support_form.php and provide server log in access so i can check myself at your peak forum time (when the problem occurs)