Let's Tweak My Server! [cthomp]
January 5, 2009
I host multiple forums on the same servers.
Win2k AVS
php 4.2.1
mysql 3.23.51
VB 2.2.8
Would also like If possable to set a diff, password for each database for each forum
Just let me Know what else you need to look at it for me
Thanks
1. your server specs, such as mysql and php version mysql=3.23.51 PHP=4.2.1
2. if possible how mysql was compiled/installed mysql installer for win
3. your top stats
4. your mysql configuration variables
#This File was made using the WinMySQLAdmin 1.4 Tool
#8/28/2002 8:38:34 PM
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
basedir=D:/mysql
#bind-address=203.194.146.93
datadir=D:/mysql/data
#language=D:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=D:/mysql/bin/mysqld-nt.exe
5. your mysql extended-status output either still telnet as root user type
mysqladmin -u root -p extended-status
SQL result
Host: localhost
Database : mysql
Generation Time: Oct 21, 2002 at 11:51 AM
Generated by: phpMyAdmin 2.3.0
SQL-query: SHOW VARIABLES;
Variable_name Value
back_log 50
basedir D:mysql
binlog_cache_size 32768
character_set latin1
character_sets latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
concurrent_insert ON
connect_timeout 5
datadir D:mysqldata
delay_key_write ON
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
flush OFF
flush_time 1800
have_bdb NO
have_gemini NO
have_innodb NO
have_isam YES
have_raid NO
have_openssl NO
init_file
interactive_timeout 28800
join_buffer_size 131072
key_buffer_size 8388600
language D:mysqlshareenglish
large_files_support ON
log OFF
log_update OFF
log_bin OFF
log_slave_updates OFF
log_long_queries OFF
long_query_time 10
low_priority_updates OFF
lower_case_table_names 1
max_allowed_packet 1048576
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connections 100
max_connect_errors 10
max_delayed_threads 20
max_heap_table_size 16777216
max_join_size 4294967295
max_sort_length 1024
max_user_connections 0
max_tmp_tables 32
max_write_lock_count 4294967295
myisam_max_extra_sort_file_size 256
myisam_max_sort_file_size 2047
myisam_recover_options 0
myisam_sort_buffer_size 8388608
named_pipe OFF
net_buffer_length 16384
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
open_files_limit 0
pid_file D:mysqldatans.pid
port 3306
protocol_version 10
record_buffer 131072
record_rnd_buffer 131072
query_buffer_size 0
safe_show_database OFF
server_id 0
slave_net_timeout 3600
skip_locking ON
skip_networking OFF
skip_show_database OFF
slow_launch_time 2
socket MySQL
sort_buffer 2097144
sql_mode 0
table_cache 64
table_type MYISAM
thread_cache_size 0
thread_stack 65536
transaction_isolation READ-COMMITTED
timezone Eastern Daylight Time
tmp_table_size 33554432
tmpdir C:WINNTTEMP
version 3.23.51-nt
wait_timeout 28800
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
Sorry, I need help with edit $mysqllogin to get the info you need
6. oh and is your vB the only thing on the server? or other scripts? sites?
I am running Merk mail and Bulletproof FTP and NAV Corporate
7. how many average and max concurrent users on your vB forum ? 40/ 100 but is growing FAST
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.gimmetv.com/phpinfo.php
10. what version of vB are you running 2.2.8
linux is definitely what you need to run more active vBs
software on the server and how it's configured are vitally important, if not setup correct even the most powerful servers will fall ;)
to tweak your current server please provide the following
1. your server specs, such as mysql and php version
2. if possible how mysql was compiled/installed
3. your top stats
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
mysqladmin -u root -p variables
copy and paste output here
5. 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
6. oh and is your vB the only thing on the server? or other scripts? sites?
7. how many average and max concurrent users on your vB forum ?
8. 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
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
MaxKeepAliveRequests
KeepAliveTimeout
MinSpareServers
MaxSpareServers
StartServers
MaxClients
10. what version of vB are you running ?
Also dual XEON P4 1.8gig
2 gig ECC DDR
Dual ultra 160 SCSI interfaces and 2 IBM ultra 160 Drives.
I forsee thwsw servers getting very busy. I will be building more as needed
Thanls
If you would not mind. I would like for you to take a look at my setup and suggest how to get the most out of what I have.
I host multiple forums on the same servers.
Win2k AVS
php 4.2.1
mysql 3.23.51
VB 2.2.8
Would also like If possable to set a diff, password for each database for each forum
Just let me Know what else you need to look at it for me
Thanks well my best recommendation is to move from win2k to linux ... but that's a biggie :)
#If you have any other info about this subject , Please add it free.# |