Eva - New server, needs tuning...
Filed Under mercialleasing.com |
1. your server specs, such as mysql and php version
Dual P3 - 1.2 Ghz (512k cache)
1 gig, although it will be 2 gigs very soon.
RedHat Linux/Cpanel/WHM
SCSI hard drives
PHP version 4.2.3
MySQL version 3.23.39
2. if possible how mysql was compiled/installed
I don't know - host did it. :)
3. your top stats
8:45pm up 7:50, 1 user, load average: 0.15, 0.03, 0.01
73 processes: 72 sleeping, 1 running, 0 zombie, 0 stopped
CPU0 states: 0.2% user, 0.2% system, 0.0% nice, 99.1% idle
CPU1 states: 0.0% user, 0.1% system, 0.0% nice, 99.4% idle
Mem: 1031064K av, 474640K used, 556424K free, 0K shrd, 88180K buff
Swap: 2096472K av, 0K used, 2096472K free 305092K cached
4. 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
[mysqld]
set-variable = max_connections=500
5. your mysql extended-status output either still telnet as root user type
+--------------------------+-------+
Variable_name Value
+--------------------------+-------+
Aborted_clients 0
Aborted_connects 147
Bytes_received 54473
Bytes_sent 85089
Connections 560
Created_tmp_disk_tables 0
Created_tmp_tables 0
Created_tmp_files 0
Delayed_insert_threads 0
Delayed_writes 0
Delayed_errors 0
Flush_commands 1
Handler_delete 0
Handler_read_first 93
Handler_read_key 0
Handler_read_next 709
Handler_read_prev 0
Handler_read_rnd 105
Handler_read_rnd_next 513
Handler_update 107
Handler_write 115
Key_blocks_used 96
Key_read_requests 309
Key_reads 96
Key_write_requests 18
Key_writes 18
Max_used_connections 1
Not_flushed_key_blocks 0
Not_flushed_delayed_rows 0
Open_tables 1
Open_files 2
Open_streams 0
Opened_tables 157
Questions 948
Select_full_join 0
Select_full_range_join 0
Select_range 0
Select_range_check 0
Select_scan 62
Slave_running OFF
Slave_open_temp_tables 0
Slow_launch_threads 0
Slow_queries 0
Sort_merge_passes 0
Sort_range 0
Sort_rows 0
Sort_scan 0
Table_locks_immediate 333
Table_locks_waited 0
Threads_cached 0
Threads_created 559
Threads_connected 1
Threads_running 1
Uptime 28510
+--------------------------+-------+
6. oh and is your vB the only thing on the server? or other scripts? sites?
vB is technically about 1/3 of our traffic, but 99.9% of the site is driven by scripts that use vB HEAVILY.
7. how many average and max concurrent users on your vB forum ?
Average = 200-300
Max ("most users ever online) = 675
8. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
http://www.christianguitar.org/phpinfo.php
9. 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 On
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 150
Mickey
Superb. We're running about 300 people on the boards right now, and the load is staying in the 0.7-0.8 range, which I think is quite good. Thanks!
Mickey no probs .. great to hear it's performing well :D
2. create or replace /etc/my.cnf file with the below one and restart mysql
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = max_connections=650
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=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
#If you have any other info about this subject , Please add it free.# |