Option one:
Two (one mysql one apache)
Redhat 7.3
Intel P4 1.7ghz
1GB DDR RAM
60gb IDE 7200rpm (2mb cache)
* I currently run just one of these servers for my forums / portal. We can handle up to 300 users just fine. 400 - 700 the server is ok just a little slow. When we reached 900+ thats when loads reached almost 50.0
Option two:
Redhat 7.3
Dual Intel P4 Xeon™ 2Ghz
1GB ECC REG DDR RAM
120GB IDE or 36GB SCSI Hard Drive
* Found a great deal on one located at nocster. Or I could build my own 1u/2u server as well.
Most days we have 150 - 300 users online and patch days we can have almost 900+ users that lasts for about a week. Attachments are enabled and are used a good deal but limmited to 300kb. We also have a portal where authors can submit zipfiles and a jpg into a queue and registered users can download the files once we aprove them. These files are from 100kb - 4mb (skin files for the everquest interface). We have 77,000 registered members and climbing and all of them like to login to our site when sony patches the game breaking there xml skins.
Site link:
http://www.eqinterface.com
* Late nights and early mornings traffic is slow.
Cost wise going with the two seprate servers is a little cheaper becuase of the price I can get on them.
I've gone through many threads and found people running similar setups like mine and I've configured my.cnf and all other settings. So I'm fairly certain my settings are tweaked properly.
Thanks for your advice.
900
Dedicated Server Specs:
Operating System:
Linux Redhat 7.3
Processor Info
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Pentium(R) 4 CPU 1.70GHz
Processor #1 speed: 1693.139 MHz
Processor #1 cache size: 256 KB
Memory Information
Memory: 1001496k/1015744k available (1142k kernel code, 13864k reserved, 464k data, 92k init, 98240k highmem)
Physical Drives
hda: ST360021A, ATA DISK drive
hda: 117231408 sectors (60022 MB) w/2048KiB Cache, CHS=7297/255/63
mySQL Version: 3.23.54
Php Version: 4.2.3
Apache Version: 1.3.27
* Not sure how mySQL was compiled or installed as it uses the cpanel / WHM management system that automaticly installs all that.
Top Stats (w/ aprox 390 online):6:09pm up 6 days, 9:05, 1 user, load average: 10.04, 12.12, 12.69
301 processes: 294 sleeping, 6 running, 0 zombie, 1 stopped
CPU states: 4.2% user, 0.0% system, 0.1% nice, 2.0% idle
Mem: 1001588K av, 992096K used, 9492K free, 0K shrd, 17908K buff
Swap: 522072K av, 196436K used, 325636K free 321884K cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
28965 mysql 19 0 37980 31M 5296 R 29.8 3.1 3:08 mysqld
14314 root 19 0 1064 1064 716 R 13.3 0.1 0:00 top
23214 mysql 9 0 37980 31M 5296 S 8.2 3.1 4:14 mysqld
12442 nobody 12 0 10012 9776 5692 S 6.2 0.9 0:24 httpd
28962 mysql 10 0 37980 31M 5296 S 4.7 3.1 3:19 mysqld
12501 nobody 10 0 10132 9896 5760 S 4.7 0.9 0:23 httpd
28966 mysql 20 0 37980 31M 5296 R 4.3 3.1 3:11 mysqld
12445 nobody 9 0 9992 9756 6028 S 4.3 0.9 0:24 httpd
12486 nobody 10 0 9620 9384 5524 S 4.3 0.9 0:15 httpd
12441 nobody 10 0 10104 9868 5856 S 3.9 0.9 0:20 httpd
12506 nobody 9 0 9892 9656 5956 S 2.7 0.9 0:23 httpd
23264 mysql 10 0 37980 31M 5296 S 2.3 3.1 4:26 mysqld
13159 mysql 9 0 37980 31M 5296 S 2.3 3.1 0:15 mysqld
23139 mysql 9 0 36952 30M 5296 S 1.9 3.0 5:09 mysqld
28961 mysql 14 0 37980 31M 5296 R 1.9 3.1 3:43 mysqld
28967 mysql 14 0 37980 31M 5296 S 1.9 3.1 3:26 mysqld
12448 nobody 9 0 10292 9.8M 6328 S 1.9 1.0 0:27 httpd
mySQL configureation:[mysqld]
set-variable = max_connections=550
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=9600
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
[safe_mysqld]
open_files_limit=8192
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=64M
set-variable = write_buffer=64M
mySQL Extended-Status script:
http://www.eqgui.com/admin/mysqlinfo.php (http://www.eqgui.com/admin/mysqlinfo.php)
Capture during 380ish online:
Fri Feb 7 18:42:12 EST 2003
6:42pm up 6 days, 9:37, 0 users, load average: 14.23, 10.51, 10.41
299 processes: 291 sleeping, 7 running, 0 zombie, 1 stopped
Mem: 1001588K av, 960616K used, 40972K free, 0K shrd, 11472K buff
Swap: 522072K av, 199636K used, 322436K free 341888K cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
14957 nobody 14 0 1056 1056 712 R 3.7 0.1 0:00 top
12482 nobody 14 0 9728 9200 5484 R 2.2 0.9 0:37 httpd
12489 nobody 15 0 9972 9444 5780 R 2.0 0.9 0:34 httpd
23139 mysql 12 0 39432 33M 6168 R 0.3 3.4 5:16 mysqld
23138 mysql 11 0 39432 33M 6168 R 0.2 3.4 4:41 mysqld
Http processes currently running = 157
Mysql processes currently running = 102
Netstat information summary
2 CLOSE_WAIT
3 FIN_WAIT1
4 SYN_RECV
9 FIN_WAIT2
30 LISTEN
145 TIME_WAIT
154 ESTABLISHED
+---------------------------+-----------------+
Variable_name Value
+---------------------------+-----------------+
Aborted_clients 35
Aborted_connects 0
Bytes_received 756173775
Bytes_sent 3246395691
Com_admin_commands 0
Com_alter_table 0
Com_analyze 0
Com_backup_table 0
Com_begin 0
Com_change_db 215095
Com_change_master 0
Com_check 0
Com_commit 0
Com_create_db 0
Com_create_function 0
Com_create_index 0
Com_create_table 0
Com_delete 28368
Com_drop_db 0
Com_drop_function 0
Com_drop_index 0
Com_drop_table 0
Com_flush 1
Com_grant 0
Com_insert 32449
Com_insert_select 147
Com_kill 0
Com_load 0
Com_load_master_table 0
Com_lock_tables 0
Com_optimize 0
Com_purge 0
Com_rename_table 0
Com_repair 0
Com_replace 320
Com_replace_select 13
Com_reset 0
Com_restore_table 0
Com_revoke 0
Com_rollback 0
Com_select 2980324
Com_set_option 0
Com_show_binlogs 0
Com_show_create 0
Com_show_databases 3
Com_show_fields 0
Com_show_grants 0
Com_show_keys 0
Com_show_logs 0
Com_show_master_status 0
Com_show_open_tables 0
Com_show_processlist 170
Com_show_slave_status 0
Com_show_status 2
Com_show_innodb_status 0
Com_show_tables 0
Com_show_variables 3
Com_slave_start 0
Com_slave_stop 0
Com_truncate 0
Com_unlock_tables 0
Com_update 383970
Connections 215279
Created_tmp_disk_tables 15
Created_tmp_tables 20853
Created_tmp_files 0
Delayed_insert_threads 0
Delayed_writes 0
Delayed_errors 0
Flush_commands 1
Handler_delete 27160
Handler_read_first 36793
Handler_read_key 28724505
Handler_read_next 29454006
Handler_read_prev 0
Handler_read_rnd 24072792
Handler_read_rnd_next 715857047
Handler_update 360789
Handler_write 2504541
Key_blocks_used 9669
Key_read_requests 152174196
Key_reads 9476
Key_write_requests 35445
Key_writes 33333
Max_used_connections 95
Not_flushed_key_blocks 0
Not_flushed_delayed_rows 0
Open_tables 342 33% of table_cache in use
Open_files 346
Open_streams 0
Opened_tables 353
Questions 3856075
Select_full_join 0
Select_full_range_join 0
Select_range 575176
Select_range_check 0
Select_scan 751287
Slave_running OFF
Slave_open_temp_tables 0
Slow_launch_threads 7
Slow_queries 8 (execution time > 10 secs)
Sort_merge_passes 0
Sort_range 570106
Sort_rows 25215854
Sort_scan 324162
Table_locks_immediate 3774095
Table_locks_waited 75172
Threads_cached 62
Threads_created 96
Threads_connected 34
Threads_running 12
Uptime 51040 14 hrs 10 mins 40 secs
+---------------------------+-----------------+
Key Reads/Key Read Requests = 0.000062 (Cache hit = 99.999938%)
Key Writes/Key Write Requests = 0.940415
Connections/second = 4.218 (/hour = 15184.255)
KB received/second = 14.468 (/hour = 52085.031)
KB sent/second = 41.088 (/hour = 147918.174)
Temporary Tables Created/second = 0.409 (/hour = 1470.823)
Opened Tables/second = 0.007 (/hour = 24.898)
Slow Queries/second = 0.000 (/hour = 0.564)
% of slow queries = 0.000%
Queries/second = 75.550 (/hour = 271980.212)
Other Scripts running:
Like I said in my above post I'm running a portal (http://www.eqinterface.com (http://www.eqinterface.com)) that has about 18 queries for guests and 21 queries for registerd users. I have a large file database that many people download from me. They are zip files 100k - 5mb (skin files for the game Everquest).
Average and max concurrent users:
average: 150 - 290
Server loads are fine with Average amount.
Max: 900+
Server loads climb to about 40.0 - 50.0
Php info:
http://www.eqinterface.com/phpinfo.php (http://www.eqinterface.com/phpinfo.php)
Apache config:
KeepAlive: ON
Very weird... loads seem to drop with it on. My old server I had to keep it off.
MaxKeepAliveRequests: 100
KeepAliveTimeout: 15
MinSpareServers: 5
MaxSpareServers: 10
StartServers: 5
MaxClients: 150
vBulletin Version:
2.2.8 with manualy patched XSS Vulnerability fixes.
http://www.eqgui.com
btw, don't go with nocster directly, go with one of the resellers (cheaper :P)
check the dedicated server offers at WHT :)
I would like to support up to 900 - 1000 online users and I am wondering witch would be better.
Option one:
Two (one mysql one apache)
Redhat 7.3
Intel P4 1.7ghz
1GB DDR RAM
60gb IDE 7200rpm (2mb cache)
* I currently run just one of these servers for my forums / portal. We can handle up to 300 users just fine. 400 - 700 the server is ok just a little slow. When we reached 900+ thats when loads reached almost 50.0
Option two:
Redhat 7.3
Dual Intel P4 Xeon™ 2Ghz
1GB ECC REG DDR RAM
120GB IDE or 36GB SCSI Hard Drive
* Found a great deal on one located at nocster. Or I could build my own 1u/2u server as well.
Most days we have 150 - 300 users online and patch days we can have almost 900+ users that lasts for about a week. Attachments are enabled and are used a good deal but limmited to 300kb. We also have a portal where authors can submit zipfiles and a jpg into a queue and registered users can download the files once we aprove them. These files are from 100kb - 4mb (skin files for the everquest interface). We have 77,000 registered members and climbing and all of them like to login to our site when sony patches the game breaking there xml skins.
Site link:
http://www.eqinterface.com
* Late nights and early mornings traffic is slow.
Cost wise going with the two seprate servers is a little cheaper becuase of the price I can get on them.
I've gone through many threads and found people running similar setups like mine and I've configured my.cnf and all other settings. So I'm fairly certain my settings are tweaked properly.
Thanks for your advice. how long is your cookie timeout set for that 944 max users online i see ?
if you can provide the following then i can work out how much and activity you are currently at and what you need
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 ?
I guess it would be almost easier to try a 2nd server then to move to a dual cpu system at this time. Hmmm.
Thanks for your input!
Yah saw a nice reseller package for $265/m at WHT. I do really like my current provider so I'll see if they can match that.
My GUESS is from having run it both ways that you will get far better performance out of the dual servers. The database server seems to run far better when it doesn't have other processes intererupting it all the time plus now you have 2 hard drive subsystems working etc....
do you have vB admin gzip enabled ? and at what level ?
mysql usage seems fine according to the 2day mysql uptime mysqlinfo.php stats displayed... however, you are swapping to disk by 50MB or so, even with 1GB of memory - and it doesn't look like mysql is causing it
you mentioned you're using whm/cpanel ?
do you have entropychat, interchange, analog stats and webalizer stats services running ?
do you need all of them ? try disabling entropychat, interchange, and analog stats from your whm service manager
it could be that IDE drives are also using up cpu resources...
also how large is your database size ?
I have mod_gzip installed from instructions in your signature. I thought since I'm using that I shouldnt use gzip on the forums.
I also have phpa installed too.
Just disabled interchange , melange , entropychat and analog/weblizer. Since I dont really need those.
Database is around 380mb
Thanks...
now if i were to go with a new server(s) for growth wise would you suggest the 2 servers or dual cpu one in my first post?
Posted this on the weekend and it kinda got washed away :) do you have vB admin gzip enabled ? and at what level ?
mysql usage seems fine according to the 2day mysql uptime mysqlinfo.php stats displayed... however, you are swapping to disk by 50MB or so, even with 1GB of memory - and it doesn't look like mysql is causing it
you mentioned you're using whm/cpanel ?
do you have entropychat, interchange, analog stats and webalizer stats services running ?
do you need all of them ? try disabling entropychat, interchange, and analog stats from your whm service manager
it could be that IDE drives are also using up cpu resources...
also how large is your database size ?
I find http://www.RackShack.net the best for dedicated servers.
Not really looking for server deals (I visit wht like 20 times a day hehe)... looking for a solution to heavy loads. Thanks though.
#If you have any other info about this subject , Please add it free.# |
