1. Dedicated server only 1 webiste
2. Specs:
Intel Celeron 2.0 Ghz
2GB of Ram
Red Had Linux 4 ES
2 x 120GB HD (RAID 1)
Apache v2.0.52
PHP 4.3.9
MySQL 4.1.20
3. Latest version of vBulletin 3.6.5
4. No InnoDB
5. Simple Control Panel
6.
top - 18:07:50 up 2 days, 14:27, 1 user, load average: 0.13, 0.09, 0.09
Tasks: 110 total, 1 running, 109 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0% us, 0.0% sy, 0.0% ni, 99.3% id, 0.7% wa, 0.0% hi, 0.0% si
Mem: 2057664k total, 2032620k used, 25044k free, 191992k buffers
Swap: 2096472k total, 144k used, 2096328k free, 1275968k cached
7.
my.cnf:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
max_connections = 500
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
8. MySQL stats from ssh telnet as root user type:
+---------------------------------+--------------------------------------------------------+
Variable_name Value
+---------------------------------+--------------------------------------------------------+
back_log 50
basedir /usr/
bdb_cache_size 8388600
bdb_home /var/lib/mysql/
bdb_log_buffer_size 32768
bdb_logdir
bdb_max_lock 10000
bdb_shared_data OFF
bdb_tmpdir /tmp/
binlog_cache_size 32768
bulk_insert_buffer_size 8388608
character_set_client latin1
character_set_connection latin1
character_set_database latin1
character_set_results latin1
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/
collation_connection latin1_swedish_ci
collation_database latin1_swedish_ci
collation_server latin1_swedish_ci
concurrent_insert ON
connect_timeout 5
datadir /var/lib/mysql/
date_format %Y-%m-%d
datetime_format %Y-%m-%d %H:%i:%s
default_week_format 0
delay_key_write ON
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
expire_logs_days 0
flush OFF
flush_time 0
ft_boolean_syntax + -><()~*:""&
ft_max_word_len 84
ft_min_word_len 4
ft_query_expansion_limit 20
ft_stopword_file (built-in)
group_concat_max_len 1024
have_archive NO
have_bdb YES
have_blackhole_engine NO
have_compress YES
have_crypt YES
have_csv NO
have_example_engine NO
have_geometry YES
have_innodb YES
have_isam YES
have_ndbcluster NO
have_openssl YES
have_query_cache YES
have_raid NO
have_rtree_keys YES
have_symlink YES
init_connect
init_file
init_slave
innodb_additional_mem_pool_size 1048576
innodb_autoextend_increment 8
innodb_buffer_pool_awe_mem_mb 0
innodb_buffer_pool_size 8388608
innodb_data_file_path ibdata1:10M:autoextend
innodb_data_home_dir
innodb_fast_shutdown ON
innodb_file_io_threads 4
innodb_file_per_table OFF
innodb_flush_log_at_trx_commit 1
innodb_flush_method
innodb_force_recovery 0
innodb_lock_wait_timeout 50
innodb_locks_unsafe_for_binlog OFF
innodb_log_arch_dir
innodb_log_archive OFF
innodb_log_buffer_size 1048576
innodb_log_file_size 5242880
innodb_log_files_in_group 2
innodb_log_group_home_dir ./
innodb_max_dirty_pages_pct 90
innodb_max_purge_lag 0
innodb_mirrored_log_groups 1
innodb_open_files 300
innodb_table_locks ON
innodb_thread_concurrency 8
interactive_timeout 28800
join_buffer_size 131072
key_buffer_size 8388600
key_cache_age_threshold 300
key_cache_block_size 1024
key_cache_division_limit 100
language /usr/share/mysql/english/
large_files_support ON
license GPL
local_infile ON
locked_in_memory OFF
log OFF
log_bin OFF
log_error
log_slave_updates OFF
log_slow_queries OFF
log_update OFF
log_warnings 1
long_query_time 10
low_priority_updates OFF
lower_case_file_system OFF
lower_case_table_names 0
max_allowed_packet 1048576
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connect_errors 10
max_connections 500
max_delayed_threads 20
max_error_count 64
max_heap_table_size 16777216
max_insert_delayed_threads 20
max_join_size 4294967295
max_length_for_sort_data 1024
max_prepared_stmt_count 16382
max_relay_log_size 0
max_seeks_for_key 4294967295
max_sort_length 1024
max_tmp_tables 32
max_user_connections 0
max_write_lock_count 4294967295
myisam_data_pointer_size 4
myisam_max_extra_sort_file_size 2147483648
myisam_max_sort_file_size 2147483647
myisam_recover_options OFF
myisam_repair_threads 1
myisam_sort_buffer_size 8388608
myisam_stats_method nulls_unequal
net_buffer_length 16384
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
new OFF
old_passwords ON
open_files_limit 2510
pid_file /var/run/mysqld/mysqld.pid
port 3306
preload_buffer_size 32768
prepared_stmt_count 0
protocol_version 10
query_alloc_block_size 8192
query_cache_limit 1048576
query_cache_min_res_unit 4096
query_cache_size 0
query_cache_type ON
query_cache_wlock_invalidate OFF
query_prealloc_size 8192
range_alloc_block_size 2048
read_buffer_size 131072
read_only OFF
read_rnd_buffer_size 262144
relay_log_purge ON
relay_log_space_limit 0
rpl_recovery_rank 0
secure_auth OFF
server_id 0
skip_external_locking ON
skip_networking OFF
skip_show_database OFF
slave_net_timeout 3600
slave_transaction_retries 0
slow_launch_time 2
socket /var/lib/mysql/mysql.sock
sort_buffer_size 2097144
sql_mode
sql_notes ON
sql_warnings ON
storage_engine MyISAM
sync_binlog 0
sync_frm ON
sync_replication 0
sync_replication_slave_id 0
sync_replication_timeout 0
system_time_zone MST
table_cache 64
table_type MyISAM
thread_cache_size 0
thread_stack 196608
time_format %H:%i:%s
time_zone SYSTEM
tmp_table_size 33554432
tmpdir
transaction_alloc_block_size 8192
transaction_prealloc_size 4096
tx_isolation REPEATABLE-READ
version 4.1.20
version_bdb Sleepycat Software: Berkeley DB 4.1.24: (May 24, 2006)
version_comment Source distribution
version_compile_machine i386
version_compile_os redhat-linux-gnu
wait_timeout 28800
+---------------------------------+--------------------------------------------------------+
+--------------------------------+-----------+
Variable_name Value
+--------------------------------+-----------+
Aborted_clients 34
Aborted_connects 2
Binlog_cache_disk_use 0
Binlog_cache_use 0
Bytes_received 4953145
Bytes_sent 535971987
Com_admin_commands 902
Com_alter_db 0
Com_alter_table 0
Com_analyze 0
Com_backup_table 0
Com_begin 0
Com_change_db 931
Com_change_master 0
Com_check 0
Com_checksum 0
Com_commit 0
Com_create_db 0
Com_create_function 0
Com_create_index 0
Com_create_table 0
Com_dealloc_sql 0
Com_delete 130
Com_delete_multi 0
Com_do 0
Com_drop_db 0
Com_drop_function 0
Com_drop_index 0
Com_drop_table 0
Com_drop_user 0
Com_execute_sql 0
Com_flush 0
Com_grant 0
Com_ha_close 0
Com_ha_open 0
Com_ha_read 0
Com_help 0
Com_insert 419
Com_insert_select 1
Com_kill 0
Com_load 0
Com_load_master_data 0
Com_load_master_table 0
Com_lock_tables 0
Com_optimize 0
Com_preload_keys 0
Com_prepare_sql 0
Com_purge 0
Com_purge_before_date 0
Com_rename_table 0
Com_repair 0
Com_replace 1299
Com_replace_select 0
Com_reset 0
Com_restore_table 0
Com_revoke 0
Com_revoke_all 0
Com_rollback 0
Com_savepoint 0
Com_select 13294
Com_set_option 0
Com_show_binlog_events 0
Com_show_binlogs 0
Com_show_charsets 0
Com_show_collations 0
Com_show_column_types 0
Com_show_create_db 0
Com_show_create_table 0
Com_show_databases 0
Com_show_errors 0
Com_show_fields 0
Com_show_grants 0
Com_show_innodb_status 0
Com_show_keys 0
Com_show_logs 0
Com_show_master_status 0
Com_show_ndb_status 0
Com_show_new_master 0
Com_show_open_tables 0
Com_show_privileges 0
Com_show_processlist 0
Com_show_slave_hosts 0
Com_show_slave_status 0
Com_show_status 16
Com_show_storage_engines 0
Com_show_tables 1
Com_show_variables 14
Com_show_warnings 0
Com_slave_start 0
Com_slave_stop 0
Com_stmt_close 0
Com_stmt_execute 0
Com_stmt_prepare 0
Com_stmt_reset 0
Com_stmt_send_long_data 0
Com_truncate 4
Com_unlock_tables 0
Com_update 1409
Com_update_multi 0
Connections 47
Created_tmp_disk_tables 20
Created_tmp_files 4
Created_tmp_tables 388
Delayed_errors 0
Delayed_insert_threads 0
Delayed_writes 0
Flush_commands 1
Handler_commit 0
Handler_delete 519
Handler_discover 0
Handler_read_first 1395
Handler_read_key 181730
Handler_read_next 378168
Handler_read_prev 2310
Handler_read_rnd 23119
Handler_read_rnd_next 1210586
Handler_rollback 0
Handler_update 5087
Handler_write 108660
Key_blocks_not_flushed 0
Key_blocks_unused 2845
Key_blocks_used 4738
Key_read_requests 483318
Key_reads 7465
Key_write_requests 6892
Key_writes 2893
Max_used_connections 22
Not_flushed_delayed_rows 0
Open_files 122
Open_streams 0
Open_tables 64
Opened_tables 530
Qcache_free_blocks 0
Qcache_free_memory 0
Qcache_hits 0
Qcache_inserts 0
Qcache_lowmem_prunes 0
Qcache_not_cached 0
Qcache_queries_in_cache 0
Qcache_total_blocks 0
Questions 17513
Rpl_status NULL
Select_full_join 45
Select_full_range_join 0
Select_range 3360
Select_range_check 0
Select_scan 1034
Slave_open_temp_tables 0
Slave_retried_transactions 0
Slave_running OFF
Slow_launch_threads 0
Slow_queries 0
Sort_merge_passes 0
Sort_range 1238
Sort_rows 147837
Sort_scan 345
Ssl_accept_renegotiates 0
Ssl_accepts 0
Ssl_callback_cache_hits 0
Ssl_cipher
Ssl_cipher_list
Ssl_client_connects 0
Ssl_connect_renegotiates 0
Ssl_ctx_verify_depth 0
Ssl_ctx_verify_mode 0
Ssl_default_timeout 0
Ssl_finished_accepts 0
Ssl_finished_connects 0
Ssl_session_cache_hits 0
Ssl_session_cache_misses 0
Ssl_session_cache_mode NONE
Ssl_session_cache_overflows 0
Ssl_session_cache_size 0
Ssl_session_cache_timeouts 0
Ssl_sessions_reused 0
Ssl_used_session_cache_entries 0
Ssl_verify_depth 0
Ssl_verify_mode 0
Ssl_version
Table_locks_immediate 25429
Table_locks_waited 2
Threads_cached 0
Threads_connected 22
Threads_created 46
Threads_running 1
Uptime 3920
+--------------------------------+-----------+
Uptime: 3920 Threads: 22 Questions: 17514 Slow queries: 0 Opens: 530 Flush tables: 1 Open tables: 64 Queries per second avg: 4.468
mysqladmin Ver 8.41 Distrib 4.1.20, for redhat-linux-gnu on i386
(C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.1.20
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 hour 5 min 20 sec
Threads: 22 Questions: 17514 Slow queries: 0 Opens: 530 Flush tables: 1 Open tables: 64 Queries per second avg: 4.468
9. Only site / vb
10. 100 concurrent, 1hr cookie timeout
11. PHP Info
System Linux ip-208-109-205-42.ip.secureserver.net 2.6.9-42.0.3.EL_HPTRAID #1 SMP Mon Jan 8 14:08:55 MST 2007 i686
Build Date Feb 16 2007 09:43:03
Configure Command './configure' '--build=i686-redhat-linux-gnu' '--host=i686-redhat-linux-gnu' '--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--cache-file=../config.cache' '--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--enable-force-cgi-redirect' '--disable-debug' '--enable-pic' '--disable-rpath' '--enable-inline-optimization' '--with-bz2' '--with-db4=/usr' '--with-curl' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-gd=shared' '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-ncurses=shared' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png' '--with-pspell' '--with-xml' '--with-expat-dir=/usr' '--with-dom=shared,/usr' '--with-dom-xslt=/usr' '--with-dom-exslt=/usr' '--with-xmlrpc=shared' '--with-pcre-regex=/usr' '--with-zlib' '--with-layout=GNU' '--enable-bcmath' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--with-pear=/usr/share/pear' '--with-imap=shared' '--with-imap-ssl' '--with-kerberos' '--with-ldap=shared' '--with-mysql=shared,/usr' '--with-pgsql=shared' '--with-snmp=shared,/usr' '--with-snmp=shared' '--enable-ucd-snmp-hack' '--with-unixODBC=shared,/usr' '--enable-memory-limit' '--enable-shmop' '--enable-calendar' '--enable-dbx' '--enable-dio' '--enable-mbstring=shared' '--enable-mbstr-enc-trans' '--enable-mbregex' '--with-mime-magic=/usr/share/file/magic.mime' '--with-apxs2=/usr/sbin/apxs'
Server API Apache 2.0 Handler
Virtual Directory Support disabled
Configuration File (php.ini) Path /etc/php.ini
Scan this dir for additional .ini files /etc/php.d
additional .ini files parsed /etc/php.d/gd.ini, /etc/php.d/imap.ini, /etc/php.d/ldap.ini, /etc/php.d/mysql.ini, /etc/php.d/odbc.ini, /etc/php.d/pgsql.ini
PHP API 20020918
PHP Extension 20020429
Zend Extension 20021010
Debug Build no
Thread Safety disabled
Registered PHP Streams php, http, ftp, https, ftps, compress.bzip2, compress.zlib
This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.3.0, (c) 1998-2004 Zend Technologies
--------------------------------------------------------------------------------
PHP Credits
--------------------------------------------------------------------------------
Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference Off Off
allow_url_fopen On On
always_populate_raw_post_data Off Off
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_prepend_file no value no value
browscap no value no value
default_charset no value no value
default_mimetype text/html text/html
define_syslog_variables Off Off
disable_classes no value no value
disable_functions no value no value
display_errors Off Off
display_startup_errors Off Off
doc_root no value no value
docref_ext no value no value
docref_root no value no value
enable_dl On On
error_append_string no value no value
error_log no value no value
error_prepend_string no value no value
error_reporting 2039 2047
expose_php On On
extension_dir /usr/lib/php4 /usr/lib/php4
file_uploads On On
gpc_order GPC GPC
highlight.bg #FFFFFF #FFFFFF
highlight.comment #FF8000 #FF8000
highlight.default #0000BB #0000BB
highlight.html #000000 #000000
highlight.keyword #007700 #007700
highlight.string #DD0000 #DD0000
html_errors On On
ignore_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off
include_path .:/usr/share/pear .:/usr/share/pear
log_errors On On
log_errors_max_len 1024 1024
magic_quotes_gpc Off Off
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
max_execution_time 240 240
max_input_time 60 60
memory_limit 32M 32M
open_basedir no value no value
output_buffering no value no value
output_handler no value no value
post_max_size 8M 8M
precision 14 14
register_argc_argv On On
register_globals Off Off
report_memleaks On On
safe_mode Off Off
safe_mode_exec_dir no value no value
safe_mode_gid Off Off
safe_mode_include_dir no value no value
sendmail_from no value no value
sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i
serialize_precision 100 100
short_open_tag On On
SMTP localhost localhost
smtp_port 25 25
sql.safe_mode Off Off
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 2M 2M
upload_tmp_dir no value no value
user_dir no value no value
variables_order EGPCS EGPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
apache2handler
Apache Version Apache/2.0.52 (Red Hat)
Apache API Version 20020903
Server Administrator webmaster@planetsrk.com
Hostname:Port planetsrk.com:0
User/Group apache(48)/48
Max Requests Per Child: 4000 - Keep Alive: off - Max Per Connection: 100
Timeouts Connection: 120 - Keep-Alive: 15
Virtual Server Yes
Server Root /etc/httpd
Loaded Modules core prefork http_core mod_so mod_access mod_auth mod_auth_anon mod_auth_dbm mod_auth_digest util_ldap mod_auth_ldap mod_include mod_log_config mod_env mod_mime_magic mod_cern_meta mod_expires mod_deflate mod_headers mod_usertrack mod_setenvif mod_mime mod_dav mod_status mod_autoindex mod_asis mod_info mod_dav_fs mod_vhost_alias mod_negotiation mod_dir mod_imap mod_actions mod_speling mod_userdir mod_alias mod_rewrite mod_proxy proxy_ftp proxy_http proxy_connect mod_cache mod_suexec mod_disk_cache mod_file_cache mod_mem_cache mod_cgi mod_auth_mysql mod_auth_pgsql mod_authz_ldap mod_fpcgid mod_jk mod_perl sapi_apache2 mod_python mod_ssl
Directive Local Value Master Value
engine 1 1
last_modified 0 0
xbithack 0 0
Apache Environment
Variable Value
HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-ms-application, application/vnd.ms-xpsdocument, application/xaml+xml, application/x-ms-xbap, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
HTTP_REFERER http://www.planetsrk.com/forums/admincp/
HTTP_ACCEPT_LANGUAGE en-us
HTTP_UA_CPU x86
HTTP_ACCEPT_ENCODING gzip, deflate
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506)
HTTP_HOST www.planetsrk.com (http://www.planetsrk.com)
HTTP_CONNECTION Keep-Alive
HTTP_COOKIE __utma=86630873.2127257739.1171250223.1173225755.1 173229320.110; __utmz=86630873.1171673268.24.2.utmccn=(referral) utmcsr=omshantiom.comutmcct=/news/om-shanti-om/farah-khan-talks-about-happy-new-year--shah-rukh.htmlutmcmd=referral; __utmb=86630873; __utmc=86630873; bblastvisit=1173201993; bblastactivity=0; bbuserid=1; bbpassword=c1bb0815ed42f12048846356665950ba; bbsessionhash=a2671754f4b1a5fd24e189a492423237; bbcpsession=93f8273b91cc111eaaa502bbadbc5b4d
PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
SERVER_SIGNATURE Apache/2.0.52 (Red Hat) Server at www.planetsrk.com (http://www.planetsrk.com) Port 80
SERVER_SOFTWARE Apache/2.0.52 (Red Hat)
SERVER_NAME www.planetsrk.com (http://www.planetsrk.com)
SERVER_ADDR 10.0.0.1
SERVER_PORT 80
REMOTE_ADDR 151.199.28.225
DOCUMENT_ROOT /home/psrk/public_html
SERVER_ADMIN webmaster@planetsrk.com
SCRIPT_FILENAME /home/psrk/public_html/forums/admincp/index.php
REMOTE_PORT 53938
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING do=phpinfo
REQUEST_URI /forums/admincp/index.php?do=phpinfo
SCRIPT_NAME /forums/admincp/index.php
HTTP Headers Information
HTTP Request Headers
HTTP Request GET /forums/admincp/index.php?do=phpinfo HTTP/1.1
Accept image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-ms-application, application/vnd.ms-xpsdocument, application/xaml+xml, application/x-ms-xbap, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
Referer http://www.planetsrk.com/forums/admincp/
Accept-Language en-us
UA-CPU x86
Accept-Encoding gzip, deflate
User-Agent Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506)
Host www.planetsrk.com (http://www.planetsrk.com)
Connection Keep-Alive
Cookie __utma=86630873.2127257739.1171250223.1173225755.1 173229320.110; __utmz=86630873.1171673268.24.2.utmccn=(referral) utmcsr=omshantiom.comutmcct=/news/om-shanti-om/farah-khan-talks-about-happy-new-year--shah-rukh.htmlutmcmd=referral; __utmb=86630873; __utmc=86630873; bblastvisit=1173201993; bblastactivity=0; bbuserid=1; bbpassword=c1bb0815ed42f12048846356665950ba; bbsessionhash=a2671754f4b1a5fd24e189a492423237; bbcpsession=93f8273b91cc111eaaa502bbadbc5b4d
HTTP Response Headers
X-Powered-By PHP/4.3.9
Expires 0
Cache-Control private, post-check=0, pre-check=0, max-age=0
Pragma no-cache
Connection close
Transfer-Encoding chunked
Content-Type text/html; charset=ISO-8859-1
bcmath
BCMath support enabled
bz2
BZip2 Support Enabled
BZip2 Version 1.0.2, 30-Dec-2001
calendar
Calendar support enabled
ctype
ctype functions enabled
curl
CURL support enabled
CURL Information libcurl/7.12.1 OpenSSL/0.9.7a zlib/1.2.1.2 libidn/0.5.6
dba
DBA support enabled
Supported handlers cdb cdb_make db4 inifile flatfile
dbx
dbx support enabled
dbx version 1.0.0
supported databases MySQL ODBC PostgreSQL Microsoft SQL Server FrontBase Oracle 8 (oci8) Sybase-CT
Directive Local Value Master Value
dbx.colnames_case lowercase lowercase
dio
dio support enabled
exif
EXIF Support enabled
EXIF Version 1.4 $Id: exif.c,v 1.118.2.35 2005/03/05 18:30:47 rasmus Exp $
Supported EXIF Version 0220
Supported filetypes JPEG,TIFF
ftp
FTP support enabled
gd
GD Support enabled
GD Version bundled (2.0.28 compatible)
FreeType Support enabled
FreeType Linkage with freetype
GIF Read Support enabled
GIF Create Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled
gettext
GetText Support enabled
gmp
gmp support enabled
iconv
iconv support enabled
iconv implementation glibc
iconv library version 2.3.4
Directive Local Value Master Value
iconv.input_encoding ISO-8859-1 ISO-8859-1
iconv.internal_encoding ISO-8859-1 ISO-8859-1
iconv.output_encoding ISO-8859-1 ISO-8859-1
imap
IMAP c-Client Version 2001
SSL Support enabled
Kerberos Support enabled
ldap
LDAP Support enabled
RCS Version $Id: ldap.c,v 1.130.2.10 2004/06/01 21:05:33 iliaa Exp $
Total Links 0/unlimited
API Version 3001
Vendor Name OpenLDAP
Vendor Version 20213
mime_magic
mime_magic support enabled
Directive Local Value Master Value
mime_magic.magicfile /usr/share/file/magic.mime /usr/share/file/magic.mime
mysql
MySQL Support enabled
Active Persistent Links 1
Active Links 1
Client API version 4.1.20
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient
Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off
odbc
ODBC Support enabled
Active Persistent Links 0
Active Links 0
ODBC library unixODBC
ODBC_INCLUDE -I/usr/include
ODBC_LFLAGS -L/usr/lib
ODBC_LIBS -lodbc
Directive Local Value Master Value
odbc.allow_persistent On On
odbc.check_persistent On On
odbc.default_db no value no value
odbc.default_pw no value no value
odbc.default_user no value no value
odbc.defaultbinmode return as is return as is
odbc.defaultlrl return up to 4096 bytes return up to 4096 bytes
odbc.max_links Unlimited Unlimited
odbc.max_persistent Unlimited Unlimited
openssl
OpenSSL support enabled
OpenSSL Version OpenSSL 0.9.7a Feb 19 2003
overload
User-Space Object Overloading Support enabled
pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 4.5 01-December-2003
pgsql
PostgreSQL Support enabled
PostgreSQL(libpq) Version 7.4.16
Multibyte character support enabled
SSL support enabled
Active Persistent Links 0
Active Links 0
Directive Local Value Master Value
pgsql.allow_persistent On On
pgsql.auto_reset_persistent Off Off
pgsql.ignore_notice Off Off
pgsql.log_notice Off Off
pgsql.max_links Unlimited Unlimited
pgsql.max_persistent Unlimited Unlimited
posix
Revision $Revision: 1.51.2.2 $
pspell
PSpell Support enabled
session
Session Support enabled
Registered save handlers files user
Directive Local Value Master Value
session.auto_start Off Off
session.bug_compat_42 Off Off
session.bug_compat_warn On On
session.cache_expire 180 180
session.cache_limiter nocache nocache
session.cookie_domain no value no value
session.cookie_lifetime 0 0
session.cookie_path / /
session.cookie_secure Off Off
session.entropy_file no value no value
session.entropy_length 0 0
session.gc_divisor 1000 1000
session.gc_maxlifetime 1440 1440
session.gc_probability 1 1
session.name PHPSESSID PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path /var/lib/php/session /var/lib/php/session
session.serialize_handler php php
session.use_cookies On On
session.use_only_cookies Off Off
session.use_trans_sid Off Off
shmop
shmop support enabled
sockets
Sockets Support enabled
standard
Regex Library Bundled library enabled
Dynamic Library Support enabled
Path to sendmail /usr/sbin/sendmail -t -i
Directive Local Value Master Value
assert.active 1 1
assert.bail 0 0
assert.callback no value no value
assert.quiet_eval 0 0
assert.warning 1 1
auto_detect_line_endings 0 0
default_socket_timeout 60 60
safe_mode_allowed_env_vars PHP_ PHP_
safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH
url_rewriter.tags a=href,area=href,frame=src,input=src,form=fakeentr y a=href,area=href,frame=src,input=src,form=fakeentr y
user_agent no value no value
tokenizer
Tokenizer Support enabled
wddx
WDDX Support enabled
WDDX Session Serializer enabled
xml
XML Support active
XML Namespace Support active
EXPAT Version expat_1.95.7
yp
YP Support enabled
zlib
ZLib Support enabled
Compiled Version 1.2.1.2
Linked Version 1.2.1.2
Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value
Additional Modules
Module Name
sysvsem
sysvshm
Environment
Variable Value
LANG C
TERM vt100
PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
PWD /
SHLVL 1
_ /sbin/initlog
PHP Variables
Variable Value
_REQUEST["do"] phpinfo
_REQUEST["s"] no value
_REQUEST["styleid"] 0
_REQUEST["langid"] 0
_REQUEST["redirect"] no value
_REQUEST["nojs"] 0
_REQUEST["navprefs"] no value
_GET["do"] phpinfo
_POST["adminhash"] no value
_COOKIE["__utma"] 86630873.2127257739.1171250223.1173225755.11732293 20.110
_COOKIE["__utmz"] 86630873.1171673268.24.2.utmccn=(referral)utmcsr= omshantiom.comutmcct=/news/om-shanti-om/farah-khan-talks-about-happy-new-year--shah-rukh.htmlutmcmd=referral
_COOKIE["__utmb"] 86630873
_COOKIE["__utmc"] 86630873
_COOKIE["bblastvisit"] 1173201993
_COOKIE["bblastactivity"] 0
_COOKIE["bbuserid"] 1
_COOKIE["bbpassword"] c1bb0815ed42f12048846356665950ba
_COOKIE["bbsessionhash"] a2671754f4b1a5fd24e189a492423237
_COOKIE["bbcpsession"] 93f8273b91cc111eaaa502bbadbc5b4d
_COOKIE["vbulletin_collapse"] no value
_COOKIE["bbreferrerid"] 0
_COOKIE["bbthreadedmode"] no value
_COOKIE["bbstyleid"] 0
_COOKIE["bblanguageid"] 0
_SERVER["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-ms-application, application/vnd.ms-xpsdocument, application/xaml+xml, application/x-ms-xbap, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
_SERVER["HTTP_REFERER"] http://www.planetsrk.com/forums/admincp/
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-us
_SERVER["HTTP_UA_CPU"] x86
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506)
_SERVER["HTTP_HOST"] www.planetsrk.com (http://www.planetsrk.com)
_SERVER["HTTP_CONNECTION"] Keep-Alive
_SERVER["HTTP_COOKIE"] __utma=86630873.2127257739.1171250223.1173225755.1 173229320.110; __utmz=86630873.1171673268.24.2.utmccn=(referral) utmcsr=omshantiom.comutmcct=/news/om-shanti-om/farah-khan-talks-about-happy-new-year--shah-rukh.htmlutmcmd=referral; __utmb=86630873; __utmc=86630873; bblastvisit=1173201993; bblastactivity=0; bbuserid=1; bbpassword=c1bb0815ed42f12048846356665950ba; bbsessionhash=a2671754f4b1a5fd24e189a492423237; bbcpsession=93f8273b91cc111eaaa502bbadbc5b4d
_SERVER["PATH"] /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
_SERVER["SERVER_SIGNATURE"] Apache/2.0.52 (Red Hat) Server at www.planetsrk.com (http://www.planetsrk.com) Port 80
_SERVER["SERVER_SOFTWARE"] Apache/2.0.52 (Red Hat)
_SERVER["SERVER_NAME"] www.planetsrk.com (http://www.planetsrk.com)
_SERVER["SERVER_ADDR"] 10.0.0.1
_SERVER["SERVER_PORT"] 80
_SERVER["REMOTE_ADDR"] 151.199.28.225
_SERVER["DOCUMENT_ROOT"] /home/psrk/public_html
_SERVER["SERVER_ADMIN"] webmaster@planetsrk.com
_SERVER["SCRIPT_FILENAME"] /home/psrk/public_html/forums/admincp/index.php
_SERVER["REMOTE_PORT"] 53938
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["QUERY_STRING"] do=phpinfo
_SERVER["REQUEST_URI"] /forums/admincp/index.php?do=phpinfo
_SERVER["SCRIPT_NAME"] /forums/admincp/index.php
_SERVER["PHP_SELF"] /forums/admincp/index.php
_SERVER["PATH_TRANSLATED"] /home/psrk/public_html/forums/admincp/index.php
_SERVER["argv"] Array
_SERVER["argc"] 1
_ENV["LANG"] C
_ENV["TERM"] vt100
_ENV["PATH"] /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
_ENV["PWD"] /
_ENV["SHLVL"] 1
_ENV["_"] /sbin/initlog
12. 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 - Off
MaxKeepAliveRequests -100
KeepAliveTimeout -10
MinSpareServers -5
MaxSpareServers -20
StartServers -8
MaxClients -256
Maxrequestsperchild value = 4000
13. Nothing
14.
Linux XXXXXXXXXX3.EL_HPTRAID #1 SMP Mon Jan 8 14:08:55 MST 2007 i686 i686 i386 GNU/Linux
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 32495
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Celeron(R) CPU 2.66GHz
stepping : 9
cpu MHz : 2674.440
cache size : 256 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm pni monitor ds_cpl tm2 cid xtpr
bogomips : 5348.52
increase # 50%
increase # 50%
what exactly doesit cache?
thanks! willsee how this works out!!
cache's PHP.. and can reduce cpu loads by 25-50% sometimes
Does APC cache really make that much of a difference?
Try the following in this exact order. You can ignore any of the suggestions that you have already done.
1. Upgrade MySQL server to 4.1.22
2. Upgrade PHP to 4.4.4 or 4.4.6 and/or recompile PHP 4.4.4/4.4.6 after upgrading MySQL
3. Edit /etc/my.cnf and place the following mysql server settings in /etc/my.cnf and restart mysql server afterwards
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 500
key_buffer = 64M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 35
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 4M
query_cache_size = 80M
query_cache_type = 1
query_prealloc_size = 163840
query_alloc_block_size = 32768
default-storage-engine = MyISAM
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
4. Install APC Cache lastest version from http://pecl.php.net/package/APC. Read install guide at http://www.vbulletin.com/forum/showthread.php?t=165367 - please remove Zend Optimizer from php.ini before installing APC Cache.
5. Edit httpd.conf values from
KeepAlive - Off
MaxKeepAliveRequests -100
KeepAliveTimeout -10
MinSpareServers -5
MaxSpareServers -20
StartServers -8
MaxClients -256
Maxrequestsperchild value = 4000
to
KeepAlive - Off
MaxKeepAliveRequests 100
KeepAliveTimeout 5
MinSpareServers 10
MaxSpareServers 15
StartServers 10
MaxClients 150
Maxrequestsperchild value = 1000
restart apache
6. If you just upgraded to vB 3.5.x/3.6.x try to disable these 4 options:
Admin CP -> vBulletin Options -> Forums Home Page Options -> Display Logged in Users?
Admin CP -> vBulletin Options -> Forum Display Options (forumdisplay) -> Show Users Browsing Forums
Admin CP -> vBulletin Options -> Thread Display Options -> Show Users Browsing Thread
Admin CP -> vBulletin Options -> Message Searching Options -> Automatic Similar Thread search
 Nortel Unveils Vision, Strategy for Israeli High-Performance Net
 Busy Friday Leads to Strong Close for Net Stocks
|
Yet Another Server Request...Optimization