PDA

View Full Version : Server optimization help please


mickknutson
Thu 13th Jan '05, 3:32pm
I have filled in all the information except TOP which I will do tonight.
Here is my forum URL:
http://www.blincmagazine.com/forum/

I am planing on getting turk asap as this sounds like it will help.
How difficult is it to upgrade php?

Also, should I be running NOT in safe-mode as safe-mode is configured right now?

Here is the required info:
================================================== ========
1. Dedicated Server.
2.:
cpu speed/type single or dual cpus): p3 2.1ghtz
how much memory installed: 512mb ram
hard drive type/configuration: 60GB EIDE non raid
linux distributor or windows version: redhat linux Fedora
apache version: apache 2.0.49
PHP version: php 4.3.4
MySQL version: mysql 3.23.58
3. No.
4. Not sure. Servepath.com setup the entire server for me.
5. top....Working on that...
6. Mysql.cf:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
================================================== =============================
mysqladmin -u root -p variables
================================================== =============================
+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| back_log | 50 |
| basedir | /usr/ |
| bdb_cache_size | 8388600 |
| bdb_log_buffer_size | 32768 |
| bdb_home | /var/lib/mysql/ |
| bdb_max_lock | 10000 |
| bdb_logdir | |
| bdb_shared_data | OFF |
| bdb_tmpdir | /tmp/ |
| bdb_version | Sleepycat Software: Berkeley DB 3.2.9a: (September 11, 2003) |
| binlog_cache_size | 32768 |
| character_set | latin1 |
| character_sets | latin1 big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312 gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin2 latin5 swe7 usa7 win1250 win1251 win1251ukr ujis sjis tis620 |
| concurrent_insert | ON |
| connect_timeout | 5 |
| datadir | /var/lib/mysql/ |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| flush | OFF |
| flush_time | 0 |
| have_bdb | YES |
| have_gemini | NO |
| have_innodb | DISABLED |
| have_isam | YES |
| have_raid | NO |
| have_openssl | NO |
| init_file | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | |
| innodb_data_home_dir | |
| innodb_file_io_threads | 4 |
| innodb_force_recovery | 0 |
| innodb_thread_concurrency | 8 |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_fast_shutdown | ON |
| innodb_flush_method | |
| innodb_lock_wait_timeout | 50 |
| 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_mirrored_log_groups | 1 |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 8388600 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| locked_in_memory | OFF |
| 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 | 0 |
| 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 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| open_files_limit | 0 |
| pid_file | /var/run/mysqld/mysqld.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 | /var/lib/mysql/mysql.sock |
| sort_buffer | 2097144 |
| sql_mode | 0 |
| table_cache | 64 |
| table_type | MYISAM |
| thread_cache_size | 0 |
| thread_stack | 65536 |
| transaction_isolation | READ-COMMITTED |
| timezone | PDT |
| tmp_table_size | 33554432 |
| tmpdir | /tmp/ |
| version | 3.23.58 |
| wait_timeout | 28800 |
+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Enter password:

================================================== =============================
7. Mysql info:
================================================== =============================

Thu Jan 13 09:18:45 PST 2005

top - 09:18:46 up 95 days, 20:17, 0 users, load average: 0.05, 0.08, 0.08
Tasks: 63 total, 1 running, 62 sleeping, 0 stopped, 0 zombie
Cpu(s): 5.0% us, 0.8% sy, 0.0% ni, 93.6% id, 0.6% wa, 0.0% hi, 0.0% si
Mem: 515448k total, 502940k used, 12508k free, 39388k buffers
Swap: 1052248k total, 21880k used, 1030368k free, 272436k cached

Http processes currently running = 20
Mysql processes currently running = 3
Netstat information summary
1 SYN_RECV
2 FIN_WAIT1
4 ESTABLISHED
18 LISTEN
130 TIME_WAIT

+---------------------------+-----------------+
| Variable_name | Value |
+---------------------------+-----------------+
| Aborted_clients | 19 |
| Aborted_connects | 1694 |
| Bytes_received | 3266833366 |
| Bytes_sent | 3551587431 |
| Com_admin_commands | 3 |
| Com_alter_table | 4 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 716001 |
| Com_change_master | 0 |
| Com_check | 1 |
| Com_commit | 0 |
| Com_create_db | 19 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 620 |
| Com_delete | 40542 |
| Com_drop_db | 2 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 558 |
| Com_flush | 2 |
| Com_grant | 0 |
| Com_insert | 2977593 |
| Com_insert_select | 516 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 2215 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 41304 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 8843104 |
| Com_set_option | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 85 |
| Com_show_databases | 94 |
| Com_show_fields | 118 |
| 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 | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 30 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 107 |
| Com_show_variables | 28 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 2215 |
| Com_update | 1773568 |
| Connections | 1005671 |
| Created_tmp_disk_tables | 3193 |
| Created_tmp_tables | 327435 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 2 |
| Delayed_writes | 288610 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 387099 |
| Handler_read_first | 1076402 |
| Handler_read_key | 193530943 |
| Handler_read_next | 382246105 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 12138746 |
| Handler_read_rnd_next | 276832910 |
| Handler_update | 1822672 |
| Handler_write | 12063133 |
| Key_blocks_used | 7793 |
| Key_read_requests | 311585228 |
| Key_reads | 159169 |
| Key_write_requests | 5049168 |
| Key_writes | 4645776 |
| Max_used_connections | 19 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 64 | 100% of table_cache in use
| Open_files | 122 |
| Open_streams | 0 |
| Opened_tables | 51361 |
| Questions | 15401201 |
| Select_full_join | 5163 |
| Select_full_range_join | 0 |
| Select_range | 1997834 |
| Select_range_check | 0 |
| Select_scan | 1279839 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 1 |
| Slow_queries | 5 | (execution time > 10 secs)
| Sort_merge_passes | 0 |
| Sort_range | 1148648 |
| Sort_rows | 200954640 |
| Sort_scan | 423551 |
| Table_locks_immediate | 18795617 |
| Table_locks_waited | 1571 |
| Threads_cached | 0 |
| Threads_created | 1003126 |
| Threads_connected | 3 |
| Threads_running | 1 |
| Uptime | 8204308 | 94 days 22 hrs 58 mins 28 secs
+---------------------------+-----------------+

Key Reads/Key Read Requests = 0.000511 (Cache hit = 99.999489%)
Key Writes/Key Write Requests = 0.920107
Connections/second = 0.123 (/hour = 441.282)
KB received/second = 0.256 (/hour = 920.217)
KB sent/second = 0.256 (/hour = 920.217)
Temporary Tables Created/second = 0.040 (/hour = 143.676)
Opened Tables/second = 0.006 (/hour = 22.537)
Slow Queries/second = 0.000 (/hour = 0.002)
% of slow queries = 0.000%
Queries/second = 1.877 (/hour = 6757.952)

Pete

================================================== =============================
8. No, I have several small scripts on my server, but they get very little use. Such as a Guestbook, and php contact form. 99% of my traffic is to VB.
================================================== =============================
9. Server Load Averages 0.36 0.76 0.83 | 45 Users Online (4 members and 41 guests)
================================================== =============================
10. PHPInfo()
================================================== =============================

PHP Version 4.3.4
System Linux baselogic.com 2.6.5-1.358 #1 Sat May 8 09:04:50 EDT 2004 i686
Build Date Apr 7 2004 09:46:36
Configure Command './configure' '--host=i386-redhat-linux' '--build=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-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' '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-ncurses' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png' '--with-pspell' '--with-regex=system' '--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-safe-mode' '--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-bcmath' '--enable-shmop' '--enable-calendar' '--enable-dbx' '--enable-dio' '--enable-mcal' '--enable-mbstring' '--enable-mbstr-enc-trans' '--enable-mbregex' '--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/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, Copyright (c) 1998-2003 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 30 30
max_input_time 60 60
memory_limit 8M 8M
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.49 (Fedora)
Apache API Version 20020903
Server Administrator root@localhost
Hostname:Port blincmagazine.com:0
User/Group apache(48)/48
Max Requests Per Child: 4000 - Keep Alive: off - Max Per Connection: 100
Timeouts Connection: 300 - 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_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_REFERER http://www.blincmagazine.com/forum/admincp/index.php?do=nav
HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, application/x-shockwave-flash, */*
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; T312461; .NET CLR 1.1.4322)
HTTP_HOST www.blincmagazine.com (http://www.blincmagazine.com/)
HTTP_ACCEPT_LANGUAGE en-us
HTTP_COOKIE bblastvisit=1097707806; bblastactivity=1098802473; i4=11:18:28:1098802525:333|12:19:28:1098802512:333 |14:50:28:1097697017:333|17:26:28:1097697008:333|1 5:24:27:1098802596:333|13:20:27:1098802551:333|34: 119:26:1098802485:333||||||||||||||||||||||||||||| ; i1=7:12:49:1098802512:4|6:14:49:1097697017:4|4:52: 49:1097697008:4|8:15:45:1098802485:4|||||||||||||| ||||||||||||||||||; bbuserid=1; bbpassword=d5db985297f8c1dc2cf6c4b7c72257ef; bbthread_rate=ax4x-ix22398yix4yix22419yix5yix22428yix5yix22441yix5y_; bbsessionhash=c845144ee205f06a0f8969fb5b0a0089; bbthread_lastview=ax1x-ix17316ysx10x%221105462712%22y_; IMAIL_SESS_KEY_1105468324-59257=TOGpO83UDkf28l5d; bbcpsession=3c63f3e9d7e85f96bb506f94fc758a2c; bblastvisit=1097707806; bblastactivity=1097707806
PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
SERVER_SIGNATURE <address>Apache/2.0.49 (Fedora) Server at www.blincmagazine.com (http://www.blincmagazine.com/) Port 80</address>
SERVER_SOFTWARE Apache/2.0.49 (Fedora)
SERVER_NAME www.blincmagazine.com (http://www.blincmagazine.com/)
SERVER_ADDR 216.93.182.204
SERVER_PORT 80
REMOTE_ADDR 171.72.5.240
DOCUMENT_ROOT /home/blinc/htdocs
SERVER_ADMIN root@localhost
SCRIPT_FILENAME /home/blinc/htdocs/forum/admincp/index.php
REMOTE_PORT 54664
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.0
REQUEST_METHOD GET
QUERY_STRING do=phpinfo
REQUEST_URI /forum/admincp/index.php?do=phpinfo
SCRIPT_NAME /forum/admincp/index.php
DATE_LOCAL no value
DATE_GMT no value
LAST_MODIFIED no value
DOCUMENT_URI /forum/admincp/index.php
USER_NAME no value
DOCUMENT_NAME index.php
QUERY_STRING_UNESCAPED do=phpinfo

HTTP Headers Information
HTTP Request Headers
HTTP Request GET /forum/admincp/index.php?do=phpinfo HTTP/1.0
Referer http://www.blincmagazine.com/forum/admincp/index.php?do=nav
Accept image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, application/x-shockwave-flash, */*
User-Agent Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; T312461; .NET CLR 1.1.4322)
Host www.blincmagazine.com (http://www.blincmagazine.com/)
Accept-Language en-us
Cookie bblastvisit=1097707806; bblastactivity=1098802473; i4=11:18:28:1098802525:333|12:19:28:1098802512:333 |14:50:28:1097697017:333|17:26:28:1097697008:333|1 5:24:27:1098802596:333|13:20:27:1098802551:333|34: 119:26:1098802485:333||||||||||||||||||||||||||||| ; i1=7:12:49:1098802512:4|6:14:49:1097697017:4|4:52: 49:1097697008:4|8:15:45:1098802485:4|||||||||||||| ||||||||||||||||||; bbuserid=1; bbpassword=d5db985297f8c1dc2cf6c4b7c72257ef; bbthread_rate=ax4x-ix22398yix4yix22419yix5yix22428yix5yix22441yix5y_; bbsessionhash=c845144ee205f06a0f8969fb5b0a0089; bbthread_lastview=ax1x-ix17316ysx10x%221105462712%22y_; IMAIL_SESS_KEY_1105468324-59257=TOGpO83UDkf28l5d; bbcpsession=3c63f3e9d7e85f96bb506f94fc758a2c; bblastvisit=1097707806; bblastactivity=1097707806
HTTP Response Headers
X-Powered-By PHP/4.3.4
Expires 0
Cache-Control private, post-check=0, pre-check=0, max-age=0
Pragma no-cache
Connection close
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.11.1 OpenSSL/0.9.7a ipv6 zlib/1.2.1.1

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.25 2003/09/22 23:28:07 iliaa Exp $
Supported EXIF Version 0220
Supported filetypes JPEG,TIFF

ftp
FTP support enabled

gd
GD Support enabled
GD Version bundled (2.0.15 compatible)
FreeType Support enabled
FreeType Linkage with freetype
GIF Read 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.3
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.9 2003/10/07 00:36:27 iliaa Exp $
Total Links 0/unlimited
API Version 2004
Vendor Name OpenLDAP
Vendor Version 20124

mbstring
Multibyte Support enabled
Multibyte (japanese) regex support enabled
mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.
Directive Local Value Master Value
mbstring.detect_order no value no value
mbstring.encoding_translation Off Off
mbstring.func_overload 0 0
mbstring.http_input pass pass
mbstring.http_output pass pass
mbstring.internal_encoding no value no value
mbstring.language neutral neutral
mbstring.substitute_character no value no value

mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 1
Client API version 3.23.58
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.2
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.1
Linked Version 1.2.1.1
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
TERM xterm
PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
PWD /
LANG en_US.UTF-8
SHLVL 1
_ /sbin/initlog

PHP Variables
Variable Value
_REQUEST["do"] phpinfo
_REQUEST["bblastvisit"] 1097707806
_REQUEST["bblastactivity"] 1097707806
_REQUEST["i4"] 11:18:28:1098802525:333|12:19:28:1098802512:333|14 :50:28:1097697017:333|17:26:28:1097697008:333|15:2 4:27:1098802596:333|13:20:27:1098802551:333|34:119 :26:1098802485:333|||||||||||||||||||||||||||||
_REQUEST["i1"] 7:12:49:1098802512:4|6:14:49:1097697017:4|4:52:49: 1097697008:4|8:15:45:1098802485:4||||||||||||||||| |||||||||||||||
_REQUEST["bbuserid"] 1
_REQUEST["bbpassword"] d5db985297f8c1dc2cf6c4b7c72257ef
_REQUEST["bbthread_rate"] ax4x-ix22398yix4yix22419yix5yix22428yix5yix22441yix5y_
_REQUEST["bbsessionhash"] c845144ee205f06a0f8969fb5b0a0089
_REQUEST["bbthread_lastview"] ax1x-ix17316ysx10x"1105462712"y_
_REQUEST["IMAIL_SESS_KEY_1105468324-59257"] TOGpO83UDkf28l5d
_REQUEST["bbcpsession"] 3c63f3e9d7e85f96bb506f94fc758a2c
_REQUEST["sessionhash"] c845144ee205f06a0f8969fb5b0a0089
_REQUEST["nojs"] 0
_GET["do"] phpinfo
_COOKIE["bblastvisit"] 1097707806
_COOKIE["bblastactivity"] 1097707806
_COOKIE["i4"] 11:18:28:1098802525:333|12:19:28:1098802512:333|14 :50:28:1097697017:333|17:26:28:1097697008:333|15:2 4:27:1098802596:333|13:20:27:1098802551:333|34:119 :26:1098802485:333|||||||||||||||||||||||||||||
_COOKIE["i1"] 7:12:49:1098802512:4|6:14:49:1097697017:4|4:52:49: 1097697008:4|8:15:45:1098802485:4||||||||||||||||| |||||||||||||||
_COOKIE["bbuserid"] 1
_COOKIE["bbpassword"] d5db985297f8c1dc2cf6c4b7c72257ef
_COOKIE["bbthread_rate"] ax4x-ix22398yix4yix22419yix5yix22428yix5yix22441yix5y_
_COOKIE["bbsessionhash"] c845144ee205f06a0f8969fb5b0a0089
_COOKIE["bbthread_lastview"] ax1x-ix17316ysx10x"1105462712"y_
_COOKIE["IMAIL_SESS_KEY_1105468324-59257"] TOGpO83UDkf28l5d
_COOKIE["bbcpsession"] 3c63f3e9d7e85f96bb506f94fc758a2c
_SERVER["HTTP_REFERER"] http://www.blincmagazine.com/forum/admincp/index.php?do=nav
_SERVER["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, application/x-shockwave-flash, */*
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; T312461; .NET CLR 1.1.4322)
_SERVER["HTTP_HOST"] www.blincmagazine.com (http://www.blincmagazine.com/)
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-us
_SERVER["HTTP_COOKIE"] bblastvisit=1097707806; bblastactivity=1098802473; i4=11:18:28:1098802525:333|12:19:28:1098802512:333 |14:50:28:1097697017:333|17:26:28:1097697008:333|1 5:24:27:1098802596:333|13:20:27:1098802551:333|34: 119:26:1098802485:333||||||||||||||||||||||||||||| ; i1=7:12:49:1098802512:4|6:14:49:1097697017:4|4:52: 49:1097697008:4|8:15:45:1098802485:4|||||||||||||| ||||||||||||||||||; bbuserid=1; bbpassword=d5db985297f8c1dc2cf6c4b7c72257ef; bbthread_rate=ax4x-ix22398yix4yix22419yix5yix22428yix5yix22441yix5y_; bbsessionhash=c845144ee205f06a0f8969fb5b0a0089; bbthread_lastview=ax1x-ix17316ysx10x%221105462712%22y_; IMAIL_SESS_KEY_1105468324-59257=TOGpO83UDkf28l5d; bbcpsession=3c63f3e9d7e85f96bb506f94fc758a2c; bblastvisit=1097707806; bblastactivity=1097707806
_SERVER["PATH"] /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
_SERVER["SERVER_SIGNATURE"] <address>Apache/2.0.49 (Fedora) Server at www.blincmagazine.com (http://www.blincmagazine.com/) Port 80</address>
_SERVER["SERVER_SOFTWARE"] Apache/2.0.49 (Fedora)
_SERVER["SERVER_NAME"] www.blincmagazine.com (http://www.blincmagazine.com/)
_SERVER["SERVER_ADDR"] 216.93.182.204
_SERVER["SERVER_PORT"] 80
_SERVER["REMOTE_ADDR"] 171.72.5.240
_SERVER["DOCUMENT_ROOT"] /home/blinc/htdocs
_SERVER["SERVER_ADMIN"] root@localhost
_SERVER["SCRIPT_FILENAME"] /home/blinc/htdocs/forum/admincp/index.php
_SERVER["REMOTE_PORT"] 54664
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.0
_SERVER["REQUEST_METHOD"] GET
_SERVER["QUERY_STRING"] do=phpinfo
_SERVER["REQUEST_URI"] /forum/admincp/index.php?do=phpinfo
_SERVER["SCRIPT_NAME"] /forum/admincp/index.php
_SERVER["PHP_SELF"] /forum/admincp/index.php
_SERVER["PATH_TRANSLATED"] /home/blinc/htdocs/forum/admincp/index.php
_SERVER["argv"] Array
(
[0] => do=phpinfo
)
_SERVER["argc"] 1
_ENV["TERM"] xterm
_ENV["PATH"] /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
_ENV["PWD"] /
_ENV["LANG"] en_US.UTF-8
_ENV["SHLVL"] 1
_ENV["_"] /sbin/initlog

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 info:
KeepAlive = off
MaxKeepAliveRequests = 10
KeepAliveTimeout = 15
MinSpareServers = 5
MaxSpareServers = 20
StartServers = 15
MaxClients = 200

================================================== =============================
12. I am runing VB 3.0.3
================================================== =============================

Zachery
Thu 13th Jan '05, 3:48pm
Upgrade Apache to 2.0.52
Upgrade MySQL to 4.0.23
Upgrade php to 4.3.10 and compile with system mysql.

After that Wait for George

mickknutson
Thu 13th Jan '05, 3:51pm
George?

Upgrade Apache to 2.0.52
Upgrade MySQL to 4.0.23
Upgrade php to 4.3.10 and compile with system mysql.

After that Wait for George
How difficult and how risky is it to upgrade Apache, MySql and PHP?
I have not installed or upgraded any of these

Zachery
Thu 13th Jan '05, 4:16pm
George is our local server Guru (his forum name is Eva2000)

If you are not comfortable with prefomring the upgrades yourself you should contact your host.

eva2000
Fri 14th Jan '05, 10:54am
Upgrade Apache to 2.0.52
Upgrade MySQL to 4.0.23
Upgrade php to 4.3.10 and compile with system mysql.

After that Wait for George
yup i recommend those upgrades especially

PHP 4.3.10 to fix security bugs
MySQL 4.0.23 as 4.0.x series is 3x times faster than 3.23.x series!

After upgrading to MySQL 4.0.23 change your /etc/my.cnf to below and restart mysql server


[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb
max_connections = 500
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 64
wait_timeout = 7200
connect_timeout = 10
tmp_table_size = 32M
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1

[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

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



Also reduce httpd.conf maxclients from 200 to 150 and restart apache

mickknutson
Wed 19th Jan '05, 9:42pm
what should I use in the -configure flag of PHP?

Upgrading from 3x to 4x sounds pretty serious? What about all my data (around 7 DB's)? Is this going to be a nightmare to upgrade from 3 to 4?

yup i recommend those upgrades especially

PHP 4.3.10 to fix security bugs
MySQL 4.0.23 as 4.0.x series is 3x times faster than 3.23.x series!

After upgrading to MySQL 4.0.23 change your /etc/my.cnf to below and restart mysql server



Also reduce httpd.conf maxclients from 200 to 150 and restart apache

eva2000
Thu 20th Jan '05, 2:17am
upgrading mysql won't harm your database data, but to be safe backup databases and put them in safe place - 4.0.23 is really alot faster and reduces loads by 50% nearly!

as to php configure i generally don't like to rock the boat too much and use the same or similar configure as existing php install which you can see from your phpinfo is as follows


./configure --host=i386-redhat-linux --build=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-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 --enable-gd-native-ttf --without-gdbm --with-gettext --with-ncurses --with-gmp --with-iconv --with-jpeg-dir=/usr --with-openssl --with-png --with-pspell --with-regex=system --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-safe-mode --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-bcmath --enable-shmop --enable-calendar --enable-dbx --enable-dio --enable-mcal --enable-mbstring --enable-mbstr-enc-trans --enable-mbregex --with-apxs2=/usr/sbin/apxs



but best to see what works for you or get web host to upgrade if you're unsure

mickknutson
Thu 20th Jan '05, 11:32am
Ok, thanks.

But, on the PHP configuration, I am still very confused about the -safe-mode option. I have it turned on. and I get 50% of the people telling me to turn it off, and the other 50% telling me ways to get code to work with it on.??????:confused:
So, what is SAFE MODE? Why do I need it anyways? Should I turn it off?
upgrading mysql won't harm your database data, but to be safe backup databases and put them in safe place - 4.0.23 is really alot faster and reduces loads by 50% nearly!

as to php configure i generally don't like to rock the boat too much and use the same or similar configure as existing php install which you can see from your phpinfo is as follows



but best to see what works for you or get web host to upgrade if you're unsure

Zachery
Thu 20th Jan '05, 11:35am
Safe-mode is a restivitve state of php that limits abit of functionality. If you are on your own server with no on else, I do not personaly see any large security risk.

If you disable safemode you will be able to store attachments and other files in the filesystem over the database, which is very benifitaial for things like avatars + attachments + css :)

mickknutson
Thu 20th Jan '05, 11:38am
Perfect. That is what I was looking for!
Thanks heaps!
Safe-mode is a restivitve state of php that limits abit of functionality. If you are on your own server with no on else, I do not personaly see any large security risk.

If you disable safemode you will be able to store attachments and other files in the filesystem over the database, which is very benifitaial for things like avatars + attachments + css :)

mickknutson
Thu 20th Jan '05, 11:43am
I just asked my Server provider (i have a dedicated machine), and this is their response:

Hello Mick Knutson,

We have the following RPMs available for Fedora Core 2 :

*****************************************
Apache :
___________________________________
httpd-2.0.49-4.i386.rpm is available

(httpd-2.0.52-2.i386.rpm is in the testing phase.
This might break your system and might contain bugs!)
___________________________________

Mysql :
___________________________________
mysql-4.1.9-1.i386.rpm is available

(MySQL-4.0.23-1mdk.ppc.rpm is only available for Mandrake Cooker)
___________________________________

PHP :

php-4.3.10-2.4.i386.rpm is available
****************************************

We charge $99/hr for the upgrade.

To upgrade using the RPMs it may take 1 hour.

If you need the versions you have specified in the ticket,
we will have to do a manual upgrade and this may take about 2 to 3 hours.


It also sounds like I could do all the upgrades via an RPM, and this would be ULTRA easy? Yes? No?

Upgrade Apache to 2.0.52
Upgrade MySQL to 4.0.23
Upgrade php to 4.3.10 and compile with system mysql.

After that Wait for George

Zachery
Thu 20th Jan '05, 11:46am
Do not use 2.0.49, use 2.0.52, it is safer.
I would use for the time 4.0.23 if its possible, 4.1.9 is still atad buggy (well it might not be but its just goten out of beta)

PHP looks fine.

mickknutson
Thu 27th Jan '05, 2:48pm
Upgrade Apache to 2.0.52
Upgrade MySQL to 4.0.23
Upgrade php to 4.3.10 and compile with system mysql.

After that Wait for George
My ISP wants heaps to do these upgrades, and I am literally swamped. Can you recommend someone to do these upgrades for me and how much it may/should cost?

eva2000
Fri 28th Jan '05, 11:50am
note if you get someone to do this and they mess up, you end up paying even more to get your web host to fix it ;)

best person to do upgrades would be the person who built the server i.e. web host

mickknutson
Fri 28th Jan '05, 11:56am
How hard is it to mess up?
I backed up my databases, and then just need someone to upgrade the 3 products.
I found a guy on Craigslist.org that will do it for $100.00 and he says it will only take 1-3 hours total.
Unfortunately I do not have a spare 1-3 hours myself. Not to mention that I would have double that time in learning surve to get to know how to do the install.

eva2000
Fri 28th Jan '05, 11:58am
Depends on the person doing the work .. i've had to fix a fair number of messed up servers before not fun heh

how much is your web host asking for ?

mickknutson
Fri 28th Jan '05, 11:44pm
So how do I guage actual performance before and after the upgrade to ensure I get the results I am after?
I am going to do the upgrade tonight.

eva2000
Sun 30th Jan '05, 12:52pm
server loads, and mysql extended-status output and how well the forum holds up during peak hours would be a few things

mickknutson
Wed 2nd Feb '05, 11:53am
OK, This was the toughest thing I have ever encountered!
I got my ISP to do it, and it took them 12+ hours to get MySql upgraded. Oh well.
I have a pretty urgent question now.
The new install did not have ANY my.cnf file anywere.
So, I did create one with the parameters you specified, and I just want to know if that was a correct thing to do?

BTW, even without the my.cnf, and having a cable modem already, I noticed a HUGE speed increase with the upgrade!
Thanks!

yup i recommend those upgrades especially

PHP 4.3.10 to fix security bugs
MySQL 4.0.23 as 4.0.x series is 3x times faster than 3.23.x series!

After upgrading to MySQL 4.0.23 change your /etc/my.cnf to below and restart mysql server



Also reduce httpd.conf maxclients from 200 to 150 and restart apache

eva2000
Fri 4th Feb '05, 6:14am
The new install did not have ANY my.cnf file anywere.
So, I did create one with the parameters you specified, and I just want to know if that was a correct thing to do?
yup should be fine but to be sure

post the output of your mysql extended-status

in ssh telnet type

mysqladmin -u root -p extended-status