PDA

View Full Version : Server Optimization Reqiured


offline
Wed 23rd Aug '06, 12:19pm
Hello,

Support has sent me your way saying that I need some server optimization.

1. Dedicated but has 4 forums, only one real active.

2. IBM 335x Blade Server. Dual 2.4 Xeon Proccessors, 3 gigs of ram, two 80 gig 320mb SCSI drives hardware mirrored.

Fedora Core release 5 (Bordeaux) Kernel 2.6.16-1.2133_FC5smp on an i686.
mysql Ver 14.12 Distrib 5.0.22, for redhat-linux-gnu (i386) using readline 5.0
PHP 5.1.4

3. N/A
4. Mysql installed
5. Top Stats...


top - 11:18:57 up 60 days, 16:34, 1 user, load average: 0.06, 0.07, 0.07
Tasks: 115 total, 1 running, 114 sleeping, 0 stopped, 0 zombie
Cpu(s): 6.7% us, 0.6% sy, 0.0% ni, 92.5% id, 0.1% wa, 0.0% hi, 0.1% si, 0.0% st
Mem: 3108904k total, 1701240k used, 1407664k free, 89412k buffers
Swap: 2031608k total, 52k used, 2031556k free, 1153648k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5430 apache 15 0 38540 20m 5944 S 22 0.7 0:12.22 httpd
5425 apache 16 0 36092 18m 5744 S 6 0.6 0:12.81 httpd
6544 root 16 0 2124 1032 792 R 1 0.0 0:00.05 top
3506 chris 16 0 7968 1804 1272 S 0 0.1 0:00.77 sshd
5427 apache 15 0 35972 18m 6200 S 0 0.6 0:14.10 httpd
5484 apache 15 0 35764 18m 5876 S 0 0.6 0:07.92 httpd
1 root 16 0 1996 640 556 S 0 0.0 0:06.36 init
2 root RT 0 0 0 0 S 0 0.0 0:02.16 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:00.01 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:00.00 watchdog/0
5 root RT 0 0 0 0 S 0 0.0 0:02.20 migration/1
6 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/1
7 root RT 0 0 0 0 S 0 0.0 0:00.00 watchdog/1
8 root RT 0 0 0 0 S 0 0.0 0:05.11 migration/2
9 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/2
10 root RT 0 0 0 0 S 0 0.0 0:00.00 watchdog/2
11 root RT 0 0 0 0 S 0 0.0 0:03.38 migration/3
12 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/3
13 root RT 0 0 0 0 S 0 0.0 0:00.00 watchdog/3



6. .etc.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
back_log = 50
skip-innodb
max_connections = 900
key_buffer = 128M
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 = 28800
connect_timeout = 10
tmp_table_size = 256M
max_heap_table_size = 256M
max_allowed_packet = 64M
max_connect_errors = 100000
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 8M
query_cache_size = 128M
query_cache_type = 1
query_prealloc_size = 65536
query_alloc_block_size = 131072
default-storage-engine = MyISAM
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

offline
Wed 23rd Aug '06, 12:24pm
| Variable_name | Value |
+-----------------------------------+------------+
| Aborted_clients | 60 |
| Aborted_connects | 19 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 540290242 |
| Bytes_sent | 2503385781 |
| Com_admin_commands | 343 |
| Com_alter_db | 0 |
| Com_alter_table | 16 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 516 |
| Com_change_db | 245545 |
| Com_change_master | 0 |
| Com_check | 202 |
| Com_checksum | 0 |
| Com_commit | 333 |
| Com_create_db | 2 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 100 |
| Com_dealloc_sql | 0 |
| Com_delete | 70032 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 3 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 4 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 113368 |
| Com_insert_select | 278 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 99 |
| Com_optimize | 286 |
| 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 | 23912 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 2 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 676396 |
| Com_set_option | 12334 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 21 |
| Com_show_charsets | 74 |
| Com_show_collations | 74 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 7098 |
| Com_show_databases | 12 |
| Com_show_errors | 0 |
| Com_show_fields | 7277 |
| Com_show_grants | 24 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 40 |
| 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 | 377 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 350 |
| Com_show_triggers | 7087 |
| Com_show_variables | 279 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 5153 |
| Com_unlock_tables | 99 |
| Com_update | 156042 |
| Com_update_multi | 0 |
| Com_xa_commit | 0 |
| Com_xa_end | 0 |
| Com_xa_prepare | 0 |
| Com_xa_recover | 0 |
| Com_xa_rollback | 0 |
| Com_xa_start | 0 |
| Compression | OFF |
| Connections | 155709 |
| Created_tmp_disk_tables | 23636 |
| Created_tmp_files | 0 |
| Created_tmp_tables | 50037 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 84156 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 99716 |
| Handler_read_key | 4918279 |
| Handler_read_next | 7786286 |
| Handler_read_prev | 244327 |
| Handler_read_rnd | 2158747 |
| Handler_read_rnd_next | 64903145 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 200938 |
| Handler_write | 9031431 |
| Innodb_buffer_pool_pages_data | 0 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 0 |
| Innodb_buffer_pool_pages_free | 0 |
| Innodb_buffer_pool_pages_latched | 0 |
| Innodb_buffer_pool_pages_misc | 0 |
| Innodb_buffer_pool_pages_total | 0 |
| Innodb_buffer_pool_read_ahead_rnd | 0 |
| Innodb_buffer_pool_read_ahead_seq | 0 |
| Innodb_buffer_pool_read_requests | 0 |
| Innodb_buffer_pool_reads | 0 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 0 |
| Innodb_data_fsyncs | 0 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 0 |
| Innodb_data_reads | 0 |
| Innodb_data_writes | 0 |
| Innodb_data_written | 0 |
| Innodb_dblwr_pages_written | 0 |
| Innodb_dblwr_writes | 0 |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 0 |
| Innodb_log_writes | 0 |
| Innodb_os_log_fsyncs | 0 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 0 |
| Innodb_page_size | 0 |
| Innodb_pages_created | 0 |
| Innodb_pages_read | 0 |
| Innodb_pages_written | 0 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 0 |
| Innodb_row_lock_time_avg | 0 |
| Innodb_row_lock_time_max | 0 |
| Innodb_row_lock_waits | 0 |
| Innodb_rows_deleted | 0 |
| Innodb_rows_inserted | 0 |
| Innodb_rows_read | 0 |
| Innodb_rows_updated | 0 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 108478 |
| Key_blocks_used | 7505 |
| Key_read_requests | 14526343 |
| Key_reads | 18192 |
| Key_write_requests | 365998 |
| Key_writes | 203284 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 23 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 2618 |
| Open_streams | 0 |
| Open_tables | 1720 |
| Opened_tables | 12642 |
| Qcache_free_blocks | 7099 |
| Qcache_free_memory | 89135224 |
| Qcache_hits | 994095 |
| Qcache_inserts | 640496 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 30316 |
| Qcache_queries_in_cache | 14586 |
| Qcache_total_blocks | 37568 |
| Questions | 2484408 |
| Rpl_status | NULL |
| Select_full_join | 811 |
| Select_full_range_join | 0 |
| Select_range | 145955 |
| Select_range_check | 0 |
| Select_scan | 164171 |
| 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 | 89250 |
| Sort_rows | 5018298 |
| Sort_scan | 39158 |
| 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 | 1522772 |
| Table_locks_waited | 46 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 21 |
| Threads_connected | 2 |
| Threads_created | 23 |
| Threads_running | 1 |
| Uptime | 772805 |
+-----------------------------------+------------+
Uptime: 772805 Threads: 2 Questions: 2484409 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 1720 Queries per second avg: 3.215
mysqladmin Ver 8.41 Distrib 5.0.22, for redhat-linux-gnu on i386
Copyright (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 5.0.22
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 8 days 22 hours 40 min 5 sec
Threads: 2 Questions: 2484409 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 1720 Queries per second avg: 3.215



8. There is also a X-Cart ecommerce site on the same server.

9. cookie time out is 900, average users is 30 max is 70.

offline
Wed 23rd Aug '06, 12:29pm
11.
[/URL]

PHP Version 5.1.4


System Linux gandalf.ctdx.net 2.6.16-1.2133_FC5smp #1 SMP Tue Jun 6 01:52:09 EDT 2006 i686 Build Date May 8 2006 08:43:39 Configure Command './configure' '--build=i386-redhat-linux' '--host=i386-redhat-linux' '--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-libdir=lib' '--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--disable-debug' '--with-pic' '--disable-rpath' '--without-pear' '--with-bz2' '--with-curl' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png' '--with-pspell' '--with-expat-dir=/usr' '--with-pcre-regex=/usr' '--with-zlib' '--with-layout=GNU' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--with-kerberos' '--enable-ucd-snmp-hack' '--with-unixODBC=shared,/usr' '--enable-memory-limit' '--enable-shmop' '--enable-calendar' '--enable-dbx' '--enable-dio' '--with-mime-magic=/etc/httpd/conf/magic' '--without-sqlite' '--with-libxml-dir=/usr' '--with-xml' '--with-apxs2=/usr/sbin/apxs' '--without-mysql' '--without-gd' '--without-odbc' '--disable-dom' '--disable-dba' '--without-unixODBC' '--disable-pdo' '--disable-xmlreader' '--disable-xmlwriter' 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/mbstring.ini, /etc/php.d/mysql.ini, /etc/php.d/mysqli.ini, /etc/php.d/pdo.ini, /etc/php.d/pdo_mysql.ini, /etc/php.d/pdo_sqlite.ini PHP API 20041225 PHP Extension 20050922 Zend Extension 220051025 Debug Build no Thread Safety disabled Zend Memory Manager enabled IPv6 Support enabled Registered PHP Streams php, file, http, ftp, compress.bzip2, compress.zlib, https, ftps Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls Registered Stream Filters string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, convert.iconv.*, bzip2.*, zlib.*
[URL]http://www.livingreefs.com/phpinfo.php?=PHPE9568F35-D428-11d2-A769-00AA001ACF42 (http://www.php.net/) This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies

PHP Credits (http://www.livingreefs.com/phpinfo.php?=PHPB8B5F2A0-3C92-11d3-A3A9-4C7B08C10000)

Configuration

PHP Core

DirectiveLocal ValueMaster Valueallow_call_time_pass_referenceOffOffallow_url _fopenOnOnalways_populate_raw_post_dataOffOffarg_s eparator.input&&arg_separator.output&&asp_tagsOffOffauto_append_fileno valueno valueauto_globals_jitOnOnauto_prepend_fileno valueno valuebrowscapno valueno valuedefault_charsetno valueno valuedefault_mimetypetext/htmltext/htmldefine_syslog_variablesOffOffdisable_classesno valueno valuedisable_functionsno valueno valuedisplay_errorsOffOffdisplay_startup_errorsOff Offdoc_rootno valueno valuedocref_extno valueno valuedocref_rootno valueno valueenable_dlOnOnerror_append_stringno valueno valueerror_logno valueno valueerror_prepend_stringno valueno valueerror_reporting20472047expose_phpOnOnextensio n_dir/usr/lib/php/modules/usr/lib/php/modulesfile_uploadsOnOnhighlight.bg#FFFFFF#FFFFFFh ighlight.comment#FF8000#FF8000highlight.default#00 00BB#0000BBhighlight.html#000000#000000highlight.k eyword#007700#007700highlight.string#DD0000#DD0000 html_errorsOnOnignore_repeated_errorsOffOffignore_ repeated_sourceOffOffignore_user_abortOffOffimplic it_flushOffOffinclude_path.:/usr/share/pear.:/usr/share/pearlog_errorsOnOnlog_errors_max_len10241024magic_ quotes_gpcOffOffmagic_quotes_runtimeOffOffmagic_qu otes_sybaseOffOffmail.force_extra_parametersno valueno valuemax_execution_time3030max_input_time6060memor y_limit64M64Mopen_basedirno valueno valueoutput_buffering40964096output_handlerno valueno valuepost_max_size32M32Mprecision1414realpath_cach e_size16K16Krealpath_cache_ttl120120register_argc_ argvOffOffregister_globalsOffOffregister_long_arra ysOnOnreport_memleaksOnOnreport_zend_debugOnOnsafe _modeOffOffsafe_mode_exec_dirno valueno valuesafe_mode_gidOffOffsafe_mode_include_dirno valueno valuesendmail_fromno valueno valuesendmail_path/usr/sbin/sendmail -t -i/usr/sbin/sendmail -t -iserialize_precision100100short_open_tagOnOnSMTPlo calhostlocalhostsmtp_port2525sql.safe_modeOffOfftr ack_errorsOffOffunserialize_callback_funcno valueno valueupload_max_filesize8M8Mupload_tmp_dirno valueno valueuser_dirno valueno valuevariables_orderEGPCSEGPCSxmlrpc_error_number0 0xmlrpc_errorsOffOffy2k_complianceOnOnzend.ze1_com patibility_modeOffOff
apache2handler

Apache Version Apache/2.2.2 (Fedora) Apache API Version 20051115 Server Administrator chris@livingreefs.com Hostname:Port www.livingreefs.com:0 (http://www.livingreefs.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_auth_basic mod_auth_digest mod_authn_file mod_authn_alias mod_authn_anon mod_authn_dbm mod_authn_default mod_authz_host mod_authz_user mod_authz_owner mod_authz_groupfile mod_authz_dbm mod_authz_default util_ldap mod_authnz_ldap mod_include mod_log_config mod_logio mod_env mod_ext_filter mod_mime_magic mod_expires mod_deflate mod_headers mod_usertrack mod_setenvif mod_mime mod_dav mod_status mod_autoindex mod_info mod_dav_fs mod_vhost_alias mod_negotiation mod_dir mod_actions mod_speling mod_userdir mod_alias mod_rewrite mod_proxy mod_proxy_balancer mod_proxy_ftp mod_proxy_http mod_proxy_connect mod_cache mod_disk_cache mod_file_cache mod_mem_cache mod_cgi mod_perl mod_php5 mod_proxy_ajp mod_python mod_ssl
DirectiveLocal ValueMaster Valueengine11last_modified00xbithack00
Apache Environment

VariableValueHTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, */* HTTP_ACCEPT_LANGUAGE en-us HTTP_ACCEPT_ENCODING gzip, deflate HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727) HTTP_HOST www.livingreefs.com (http://www.livingreefs.com/) HTTP_CONNECTION Keep-Alive HTTP_COOKIE vbulletin_collapse=; bblastvisit=1155835325; bblastactivity=0; bbuserid=1; bbpassword=af3d1f90cdb293f15388a2f8f708e8f0; livingreefs_com_-_wikiUserName=Chris; livingreefs_com_-_wikiLoggedOut=20060822155825; livingreefs_com_-_wikiUserID=2; bbsessionhash=3ed77e7d73703c22c4f1e80c9191b1f8; bbcpsession=226d94da3915b9c37993551bd4d31773 PATH /sbin:/usr/sbin:/bin:/usr/bin SERVER_SIGNATURE <address>Apache/2.2.2 (Fedora) Server at www.livingreefs.com (http://www.livingreefs.com/) Port 80</address> SERVER_SOFTWARE Apache/2.2.2 (Fedora) SERVER_NAME www.livingreefs.com (http://www.livingreefs.com/) SERVER_ADDR 192.168.50.25 SERVER_PORT 80 REMOTE_ADDR 71.31.127.90 DOCUMENT_ROOT /www/www.livingreefs.com SERVER_ADMIN chris@livingreefs.com SCRIPT_FILENAME /www/www.livingreefs.com/phpinfo.php REMOTE_PORT 4218 GATEWAY_INTERFACE CGI/1.1 SERVER_PROTOCOL HTTP/1.1 REQUEST_METHOD GET QUERY_STRING no value REQUEST_URI /phpinfo.php SCRIPT_NAME /phpinfo.php
HTTP Headers Information

HTTP Request HeadersHTTP Request GET /phpinfo.php HTTP/1.1 Accept image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, */* Accept-Language en-us Accept-Encoding gzip, deflate User-Agent Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727) Host www.livingreefs.com (http://www.livingreefs.com/) Connection Keep-Alive Cookie vbulletin_collapse=; bblastvisit=1155835325; bblastactivity=0; bbuserid=1; bbpassword=af3d1f90cdb293f15388a2f8f708e8f0; livingreefs_com_-_wikiUserName=Chris; livingreefs_com_-_wikiLoggedOut=20060822155825; livingreefs_com_-_wikiUserID=2; bbsessionhash=3ed77e7d73703c22c4f1e80c9191b1f8; bbcpsession=226d94da3915b9c37993551bd4d31773 HTTP Response HeadersX-Powered-By PHP/5.1.4 Connection close Transfer-Encoding chunked Content-Type text/html; charset=UTF-8
bz2

BZip2 Support Enabled Stream Wrapper support compress.bz2:// Stream Filter support bzip2.decompress, bzip2.compress BZip2 Version 1.0.3, 15-Feb-2005
calendar

Calendar support enabled
ctype

ctype functions enabled
curl

CURL support enabled CURL Information libcurl/7.15.1 OpenSSL/0.9.8a zlib/1.2.3 libidn/0.6.2
date

date/time support enabled Timezone Database Version 2006.1 Timezone Database internal Default timezone America/New_York
DirectiveLocal ValueMaster Valuedate.default_latitude31.766731.7667date.defau lt_longitude35.233335.2333date.sunrise_zenith90.58 333390.583333date.sunset_zenith90.58333390.583333d ate.timezoneno valueno value
exif

EXIF Support enabled EXIF Version 1.4 $Id: exif.c,v 1.173.2.5 2006/04/10 18:23:24 helly 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 FreeType Version 2.1.10 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
hash

hash supportenabledHashing Enginesmd4 md5 sha1 sha256 sha384 sha512 ripemd128 ripemd160 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru gost adler32 crc32 crc32b haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5
iconv

iconv support enabled iconv implementation glibc iconv library version 2.4
DirectiveLocal ValueMaster Valueiconv.input_encodingISO-8859-1ISO-8859-1iconv.internal_encodingISO-8859-1ISO-8859-1iconv.output_encodingISO-8859-1ISO-8859-1
libxml

libXML support active libXML Version 2.6.23 libXML streams enabled
mbstring

Multibyte Support enabled Multibyte string engine libmbfl Multibyte (japanese) regex support enabled Multibyte regex (oniguruma) version 3.7.1
mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.
DirectiveLocal ValueMaster Valuembstring.detect_orderno valueno valuembstring.encoding_translationOffOffmbstring.f unc_overload00mbstring.http_inputpasspassmbstring. http_outputpasspassmbstring.internal_encodingno valueno valuembstring.languageneutralneutralmbstring.stric t_detectionOffOffmbstring.substitute_characterno valueno value
mime_magic

mime_magic supportenabled
DirectiveLocal ValueMaster Valuemime_magic.debugOffOffmime_magic.magicfile/etc/httpd/conf/magic/etc/httpd/conf/magic
mysql

MySQL SupportenabledActive Persistent Links 0 Active Links 0 Client API version 5.0.22 MYSQL_MODULE_TYPE external MYSQL_SOCKET /var/lib/mysql/mysql.sock MYSQL_INCLUDE -I/usr/include/mysql MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient
DirectiveLocal ValueMaster Valuemysql.allow_persistentOnOnmysql.connect_timeo ut6060mysql.default_hostno valueno valuemysql.default_passwordno valueno valuemysql.default_portno valueno valuemysql.default_socketno valueno valuemysql.default_userno valueno valuemysql.max_linksUnlimitedUnlimitedmysql.max_pe rsistentUnlimitedUnlimitedmysql.trace_modeOffOff
mysqli

MysqlI SupportenabledClient API library version 5.0.22 Client API header version 5.0.18 MYSQLI_SOCKET /var/lib/mysql/mysql.sock
DirectiveLocal ValueMaster Valuemysqli.default_hostno valueno valuemysqli.default_port33063306mysqli.default_pwn o valueno valuemysqli.default_socketno valueno valuemysqli.default_userno valueno valuemysqli.max_linksUnlimitedUnlimitedmysqli.reco nnectOffOff
openssl

OpenSSL support enabled OpenSSL Version OpenSSL 0.9.8a 11 Oct 2005
pcre

PCRE (Perl Compatible Regular Expressions) Support enabled PCRE Library Version 6.3 15-Aug-2005
PDO

PDO supportenabledPDO drivers mysql, sqlite
pdo_mysql

PDO Driver for MySQL, client library version5.0.22
pdo_sqlite

PDO Driver for SQLite 3.xenabledPECL Module version 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6 2006/01/01 12:50:12 sniper Exp $ SQLite Library 3.3.3
posix

Revision $Revision: 1.70.2.3 $
pspell

PSpell Support enabled
Reflection

ReflectionenabledVersion $Id: php_reflection.c,v 1.164.2.33 2006/03/29 14:28:42 tony2001 Exp $
session

Session Support enabled Registered save handlers files user Registered serializer handlers php php_binary wddx
DirectiveLocal ValueMaster Valuesession.auto_startOffOffsession.bug_compat_42 OffOffsession.bug_compat_warnOnOnsession.cache_exp ire180180session.cache_limiternocachenocachesessio n.cookie_domainno valueno valuesession.cookie_lifetime00session.cookie_path//session.cookie_secureOffOffsession.entropy_fileno valueno valuesession.entropy_length00session.gc_divisor100 01000session.gc_maxlifetime14401440session.gc_prob ability11session.hash_bits_per_character55session. hash_function00session.namePHPSESSIDPHPSESSIDsessi on.referer_checkno valueno valuesession.save_handlerfilesfilessession.save_pa th/var/lib/php/session/var/lib/php/sessionsession.serialize_handlerphpphpsession.use_ cookiesOnOnsession.use_only_cookiesOffOffsession.u se_trans_sid00
shmop

shmop support enabled
SimpleXML

Simplexml supportenabledRevision $Revision: 1.151.2.22 $ Schema support enabled
sockets

Sockets Support enabled
SPL

SPL supportenabledInterfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RuntimeException, SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException
standard

Regex Library Bundled library enabled Dynamic Library Support enabled Path to sendmail /usr/sbin/sendmail -t -i
DirectiveLocal ValueMaster Valueassert.active11assert.bail00assert.callbackno valueno valueassert.quiet_eval00assert.warning11auto_detec t_line_endings00default_socket_timeout6060safe_mod e_allowed_env_varsPHP_PHP_safe_mode_protected_env_ varsLD_LIBRARY_PATHLD_LIBRARY_PATHurl_rewriter.tag sa=href,area=href,frame=src,input=src,form=fakeent rya=href,area=href,frame=src,input=src,form=fakeen tryuser_agentno valueno value
sysvmsg

sysvmsg support enabled Revision $Revision: 1.20.2.3 $
tokenizer

Tokenizer Support enabled
wddx

WDDX SupportenabledWDDX Session Serializer enabled
xml

XML Support active XML Namespace Support active libxml2 Version 2.6.23
zlib

ZLib Support enabled Stream Wrapper support compress.zlib:// Stream Filter support zlib.inflate, zlib.deflate Compiled Version 1.2.3 Linked Version 1.2.3
DirectiveLocal ValueMaster Valuezlib.output_compressionOffOffzlib.output_comp ression_level-1-1zlib.output_handlerno valueno value
Additional Modules

Module Namesysvsemsysvshm
Environment

VariableValueHOSTNAME gandalf.ctdx.net SHELL /bin/bash TERM xterm HISTSIZE 1000 SSH_CLIENT 71.31.127.90 2593 22 SSH_TTY /dev/pts/0 USER chris LS_COLORS no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd =40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;4 1:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.b tm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar= 00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00 ;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.b z2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio= 00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00 ;35:*.xpm=00;35:*.png=00;35:*.tif=00;35: PATH /sbin:/usr/sbin:/bin:/usr/bin MAIL /var/spool/mail/chris PWD /etc/awstats INPUTRC /etc/inputrc LANG C SSH_ASKPASS /usr/libexec/openssh/gnome-ssh-askpass HOME /root SHLVL 4 LOGNAME chris CVS_RSH ssh SSH_CONNECTION 71.31.127.90 2593 192.168.50.25 22 LESSOPEN |/usr/bin/lesspipe.sh %s G_BROKEN_FILENAMES 1 _ /usr/sbin/httpd
PHP Variables

VariableValue_REQUEST["vbulletin_collapse"]no value_REQUEST["bblastvisit"]1155835325_REQUEST["bblastactivity"]0_REQUEST["bbuserid"]1_REQUEST["bbpassword"]af3d1f90cdb293f15388a2f8f708e8f0_REQUEST["livingreefs_com_-_wikiUserName"]Chris_REQUEST["livingreefs_com_-_wikiLoggedOut"]20060822155825_REQUEST["livingreefs_com_-_wikiUserID"]2_REQUEST["bbsessionhash"]3ed77e7d73703c22c4f1e80c9191b1f8_REQUEST["bbcpsession"]226d94da3915b9c37993551bd4d31773_COOKIE["vbulletin_collapse"]no value_COOKIE["bblastvisit"]1155835325_COOKIE["bblastactivity"]0_COOKIE["bbuserid"]1_COOKIE["bbpassword"]af3d1f90cdb293f15388a2f8f708e8f0_COOKIE["livingreefs_com_-_wikiUserName"]Chris_COOKIE["livingreefs_com_-_wikiLoggedOut"]20060822155825_COOKIE["livingreefs_com_-_wikiUserID"]2_COOKIE["bbsessionhash"]3ed77e7d73703c22c4f1e80c9191b1f8_COOKIE["bbcpsession"]226d94da3915b9c37993551bd4d31773_SERVER["HTTP_ACCEPT"]image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, */*_SERVER["HTTP_ACCEPT_LANGUAGE"]en-us_SERVER["HTTP_ACCEPT_ENCODING"]gzip, deflate_SERVER["HTTP_USER_AGENT"]Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)_SERVER["HTTP_HOST"]www.livingreefs.com_SERVER["HTTP_CONNECTION"]Keep-Alive_SERVER["HTTP_COOKIE"]vbulletin_collapse=; bblastvisit=1155835325; bblastactivity=0; bbuserid=1; bbpassword=af3d1f90cdb293f15388a2f8f708e8f0; livingreefs_com_-_wikiUserName=Chris; livingreefs_com_-_wikiLoggedOut=20060822155825; livingreefs_com_-_wikiUserID=2; bbsessionhash=3ed77e7d73703c22c4f1e80c9191b1f8; bbcpsession=226d94da3915b9c37993551bd4d31773_SERVE R["PATH"]/sbin:/usr/sbin:/bin:/usr/bin_SERVER["SERVER_SIGNATURE"]<address>Apache/2.2.2 (Fedora) Server at www.livingreefs.com (http://www.livingreefs.com/) Port 80</address> _SERVER["SERVER_SOFTWARE"]Apache/2.2.2 (Fedora)_SERVER["SERVER_NAME"]www.livingreefs.com_SERVER["SERVER_ADDR"]192.168.50.25_SERVER["SERVER_PORT"]80_SERVER["REMOTE_ADDR"]71.31.127.90_SERVER["DOCUMENT_ROOT"]/www/www.livingreefs.com_SERVER["SERVER_ADMIN"]chris@livingreefs.com_SERVER["SCRIPT_FILENAME"]/www/www.livingreefs.com/phpinfo.php_SERVER["REMOTE_PORT"]4218_SERVER["GATEWAY_INTERFACE"]CGI/1.1_SERVER["SERVER_PROTOCOL"]HTTP/1.1_SERVER["REQUEST_METHOD"]GET_SERVER["QUERY_STRING"]no value_SERVER["REQUEST_URI"]/phpinfo.php_SERVER["SCRIPT_NAME"]/phpinfo.php_SERVER["PHP_SELF"]/phpinfo.php_SERVER["REQUEST_TIME"]1156346735_ENV["HOSTNAME"]gandalf.ctdx.net_ENV["SHELL"]/bin/bash_ENV["TERM"]xterm_ENV["HISTSIZE"]1000_ENV["SSH_CLIENT"]71.31.127.90 2593 22_ENV["SSH_TTY"]/dev/pts/0_ENV["USER"]chris_ENV["LS_COLORS"]no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd =40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;4 1:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.b tm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar= 00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00 ;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.b z2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio= 00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00 ;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:_ENV["PATH"]/sbin:/usr/sbin:/bin:/usr/bin_ENV["MAIL"]/var/spool/mail/chris_ENV["PWD"]/etc/awstats_ENV["INPUTRC"]/etc/inputrc_ENV["LANG"]C_ENV["SSH_ASKPASS"]/usr/libexec/openssh/gnome-ssh-askpass_ENV["HOME"]/root_ENV["SHLVL"]4_ENV["LOGNAME"]chris_ENV["CVS_RSH"]ssh_ENV["SSH_CONNECTION"]71.31.127.90 2593 192.168.50.25 22_ENV["LESSOPEN"]|/usr/bin/lesspipe.sh %s_ENV["G_BROKEN_FILENAMES"]1_ENV["_"]/usr/sbin/httpd
PHP License

This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact license@php.net.

11. Apache...

#
# KeepAlive: Whether or not to allow persistent connections (more than
# one request per connection). Set to "Off" to deactivate.
#
KeepAlive Off
#
# MaxKeepAliveRequests: The maximum number of requests to allow
# during a persistent connection. Set to 0 to allow an unlimited amount.
# We recommend you leave this number high, for maximum performance.
#
MaxKeepAliveRequests 100
#
# KeepAliveTimeout: Number of seconds to wait for the next request from the
# same client on the same connection.
#
KeepAliveTimeout 15
##
## Server-Pool Size Regulation (MPM specific)
##
# prefork MPM
# StartServers: number of server processes to start
# MinSpareServers: minimum number of server processes which are kept spare
# MaxSpareServers: maximum number of server processes which are kept spare
# ServerLimit: maximum value for MaxClients for the lifetime of the server
# MaxClients: maximum number of server processes allowed to start
# MaxRequestsPerChild: maximum number of requests a server process serves
<IfModule prefork.c>
StartServers 8
MinSpareServers 5
MaxSpareServers 20
ServerLimit 256
MaxClients 256
MaxRequestsPerChild 4000
</IfModule>



12. VB version 3.5.4

13. No Large Files

14.

Linux gandalf.ctdx.net 2.6.16-1.2133_FC5smp #1 SMP Tue Jun 6 01:52:09 EDT 2006 i686 i686 i386 GNU/Linux

core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
max nice (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 49149
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
max rt priority (-r) 0
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 49149
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
file locks (-x) unlimited

processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) XEON(TM) CPU 2.40GHz
stepping : 4
cpu MHz : 2392.740
cache size : 512 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm
bogomips : 4794.56
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.40GHz
stepping : 7
cpu MHz : 2392.740
cache size : 512 KB
physical id : 3
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe cid xtpr
bogomips : 4784.77
processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) XEON(TM) CPU 2.40GHz
stepping : 4
cpu MHz : 2392.740
cache size : 512 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm
bogomips : 4784.99
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.40GHz
stepping : 7
cpu MHz : 2392.740
cache size : 512 KB
physical id : 3
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe cid xtpr
bogomips : 4785.18

offline
Wed 23rd Aug '06, 12:45pm
mysqlreport...


MySQL 5.0.22 uptime 8 23:4:2 Wed Aug 23 11:46:05 2006
__ Key __________________________________________________ _______________
Buffer usage 7.33M of 128.00M %Used: 5.73
Write ratio 0.56
Read ratio 0.00
__ Questions __________________________________________________ _________
Total 2.49M 3.21/s
DMS 1.04M 1.35/s %Total: 41.86
QC Hits 995.48k 1.29/s 40.01
Com_ 288.11k 0.37/s 11.58
COM_QUIT 155.90k 0.20/s 6.27
+Unknown 6.86k 0.01/s 0.28
Slow 0 0.00/s 0.00 %DMS: 0.00
DMS 1.04M 1.35/s 41.86
SELECT 677.42k 0.87/s 27.23 65.04
UPDATE 156.24k 0.20/s 6.28 15.00
INSERT 113.81k 0.15/s 4.57 10.93
DELETE 70.12k 0.09/s 2.82 6.73
REPLACE 23.94k 0.03/s 0.96 2.30
Com_ 288.11k 0.37/s 11.58
change_db 245.88k 0.32/s 9.88
set_option 12.34k 0.02/s 0.50
show_fields 7.28k 0.01/s 0.29
__ SELECT and Sort __________________________________________________ ___
Scan 164.41k 0.21/s %SELECT: 24.27
Range 146.17k 0.19/s 21.58
Full join 821 0.00/s 0.12
Range check 0 0.00/s 0.00
Full rng join 0 0.00/s 0.00
Sort scan 39.22k 0.05/s
Sort range 89.39k 0.12/s
Sort mrg pass 0 0.00/s
__ Query Cache __________________________________________________ _______
Memory usage 44.45M of 128.00M %Used: 34.72
Block Fragmnt 18.13%
Hits 995.48k 1.29/s
Inserts 641.46k 0.83/s
Prunes 1 0.00/s
Insrt:Prune 641.46k:1 0.83/s
Hit:Insert 1.55:1
__ Table Locks __________________________________________________ _______
Waited 46 0.00/s %Total: 0.00
Immediate 1.52M 1.97/s
__ Tables __________________________________________________ ____________
Open 1.72k of 1800 %Cache: 95.56
Opened 12.66k 0.02/s
__ Connections __________________________________________________ _______
Max used 23 of 900 %Max: 2.56
Total 155.93k 0.20/s
__ Created Temp __________________________________________________ ______
Disk table 23.65k 0.03/s
Table 50.10k 0.06/s
File 0 0.00/s
__ Threads __________________________________________________ ___________
Running 1 of 1
Cache 22 %Hit: 99.99
Created 23 0.00/s
Slow 0 0.00/s
__ Aborted __________________________________________________ ___________
Clients 60 0.00/s
Connects 21 0.00/s
__ Bytes __________________________________________________ _____________
Sent 2.57G 3.32k/s
Received 541.03M 698.78/s

eva2000
Sat 26th Aug '06, 8:52pm
Hi Chris rather than reply to both ticket and thread, I'll reply to this thread with some tips

1. Upgrade MySQL server to latest MySQL 5.x server = 5.0.24 - there's a bug in 5.0.22 with vB 3.5.x that can cause your errors
2. Recompile PHP 5.1.4 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
old_passwords
back_log = 50
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 = 512
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 = 12M
query_cache_size = 144M
query_cache_type = 1
query_prealloc_size = 65536
query_alloc_block_size = 131072
default-storage-engine = MyISAM

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
nice = -5
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M


4. Install lastest version of eAccelerator

5. Upgrade to vB 3.5.5 http://www.vbulletin.com/forum/showthread.php?t=194061 if you're on vB 3.5.x

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

7. Edit httpd.conf values from

KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15

<IfModule prefork.c>
StartServers 8
MinSpareServers 5
MaxSpareServers 20
ServerLimit 256
MaxClients 256
MaxRequestsPerChild 4000
</IfModule>

to

KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 5

<IfModule prefork.c>
StartServers 10
MinSpareServers 10
MaxSpareServers 15
ServerLimit 256
MaxClients 180
MaxRequestsPerChild 100
</IfModule>

restart apache

offline
Tue 29th Aug '06, 10:49am
Awesome! Thanks! Server is flying right now. The only thing I couldn't do was upgrade the mysql server. This was by my choice, I am trying to keep everything in line with the Fedora release so I don't have to do any manual updating of the server. I am sure they will upgrade it soon enough and when they do hopefully my error will be solved. Thanks!!