hsiaok
Mon 30th Jun '03, 2:36pm
Here is my configuration:
I notice the php.ini from the phpinfo() is incorrect for my server.
The php.ini is on /usr/local/tmp/php-4.3.2/pear/tests/php.ini
and not /usr/local/lib and here is the content of php.ini
; php.ini for PEAR tests
include_path=..
1. is this on dedicated or shared virual server
Dedicated
2. your server specs. For example:
2 CPU SUNW, ULTRA-4;
RAM: 1 GB
Virtual RAM: 2.7 GB
HD: 133 GB
OS: SUN Solaris 5.8
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
# mysql --version
mysql Ver 12.20 Distrib 4.0.13, for sun-solaris2.8 (sparc)
I don't know what innodb is.
It contain the bareboon Mysql DB created by VBulletin during
installation. It has no datasbase used by any other application
other can VBulletin.
4. if possible how mysql was compiled/installed
The MySQl installation source is binary code.
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> tar xvf *.tar
shell> ln -s /usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc mysql
shell> cd mysql
shell> scripts/mysql_install_db
shell> chown -R root .
shell> chown -R mysql data
shell> chgrp -R mysql .
shell> bin/mysqld_safe --user=mysql &
or
shell> bin/mysqld_safe --user=mysql &
if you are running MySQL 4.x
After the MySql installation, to check for which version of MySQl installed
# mysql --version
mysql Ver 12.20 Distrib 4.0.13, for sun-solaris2.8 (sparc)
/usr/local/mysql/bin/mysql --version
5. your top stats
Please explain 'top stats'.
6. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf if on Windows server if you don't have that file you need to log into telnet and as root user type
mysqladmin -u root -p variables
copy and paste output here
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| back_log | 50 |
| basedir | /usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set | latin1 |
| character_sets | latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert | ON |
| connect_timeout | 5 |
| convert_character_set | |
| datadir | /usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/data/ |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_min_word_len | 4 |
| ft_max_word_len | 254 |
| ft_max_word_len_for_sort | 20 |
| ft_stopword_file | (built-in) |
| have_bdb | NO |
| have_crypt | YES |
| have_innodb | YES |
| have_isam | YES |
| have_raid | NO |
| have_symlink | YES |
| have_openssl | NO |
| have_query_cache | YES |
| init_file | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| 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 |
| innodb_max_dirty_pages_pct | 90 |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 8388600 |
| language | /usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/share/mysql/english/ |
| large_files_support | ON |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_update | OFF |
| log_bin | OFF |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_warnings | OFF |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_table_names | OFF |
| 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 | 268435456 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_repair_threads | 1 |
| myisam_recover_options | OFF |
| myisam_sort_buffer_size | 8388608 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| open_files_limit | 0 |
| pid_file | /usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/data/leo.pid |
| log_error | |
| port | 3306 |
| protocol_version | 10 |
| read_buffer_size | 131072 |
| read_rnd_buffer_size | 262144 |
| rpl_recovery_rank | 0 |
| query_cache_limit | 1048576 |
| query_cache_size | 0 |
| query_cache_type | ON |
| server_id | 0 |
| slave_net_timeout | 3600 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slow_launch_time | 2 |
| socket | /tmp/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | 0 |
| table_cache | 64 |
| table_type | MYISAM |
| thread_cache_size | 0 |
| thread_concurrency | 10 |
| thread_stack | 196608 |
| tx_isolation | REPEATABLE-READ |
| timezone | PDT |
| tmp_table_size | 33554432 |
| tmpdir | /var/tmp/ |
| version | 4.0.13-standard |
| wait_timeout | 28800 |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
7. your mysql extended-status output either still telnet as root user type
mysqladmin -u root -p extended-status
copy and paste output here
+--------------------------+---------+
| Variable_name | Value |
+--------------------------+---------+
| Aborted_clients | 206 |
| Aborted_connects | 12 |
| Bytes_received | 2246839 |
| Bytes_sent | 8362358 |
| Com_admin_commands | 0 |
| Com_alter_table | 8 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 1302 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 80 |
| Com_delete | 191 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 80 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 2195 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 0 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 6044 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 4 |
| Com_show_fields | 160 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 3 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 10 |
| Com_show_variables | 3 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 2068 |
| Connections | 1333 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_tables | 198 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 2 |
| Handler_commit | 0 |
| Handler_delete | 120 |
| Handler_read_first | 4002 |
| Handler_read_key | 5634 |
| Handler_read_next | 1317 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 3148 |
| Handler_read_rnd_next | 108117 |
| Handler_rollback | 0 |
| Handler_update | 1167 |
| Handler_write | 2516 |
| Key_blocks_used | 108 |
| Key_read_requests | 15378 |
| Key_reads | 0 |
| Key_write_requests | 3171 |
| Key_writes | 3165 |
| Max_used_connections | 2 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 22 |
| Open_files | 41 |
| Open_streams | 0 |
| Opened_tables | 212 |
| Questions | 13899 |
| Qcache_queries_in_cache | 0 |
| Qcache_inserts | 0 |
| Qcache_hits | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_free_memory | 0 |
| Qcache_free_blocks | 0 |
| Qcache_total_blocks | 0 |
| Rpl_status | NULL |
| Select_full_join | 6 |
| Select_full_range_join | 0 |
| Select_range | 44 |
| Select_range_check | 0 |
| Select_scan | 900 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 0 |
| Sort_rows | 3148 |
| Sort_scan | 539 |
| Table_locks_immediate | 12681 |
| Table_locks_waited | 2 |
| Threads_cached | 0 |
| Threads_created | 1332 |
| Threads_connected | 1 |
| Threads_running | 1 |
| Uptime | 1107073 |
+--------------------------+---------+
or preferred is to installed extended-status output script which is either located
- in your vB 2.2.6 or higher vB version's zip file extra's folder, upload mysqlinfo.php script to your site or if you're on an pre vB 2.2.6 install go to
- http://vbulletin.com/forum/showthread.php?threadid=3477 and install that scrip making sure to edit $mysqllogin line with your own mysqlusername and password
and post url to that here
Mon Jun 30 10:27:42 PDT 2003
Http processes currently running = 0
Mysql processes currently running = 0
Netstat information summary
+---------------------------+-----------------+
| Variable_name | Value |
+---------------------------+-----------------+
| Aborted_clients | 206 |
| Aborted_connects | 12 |
| Bytes_received | 2246901 |
| Bytes_sent | 8369042 |
| Com_admin_commands | 0 |
| Com_alter_table | 8 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 1302 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 80 |
| Com_delete | 191 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 80 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 2195 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 0 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 6044 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 4 |
| Com_show_fields | 160 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 4 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 10 |
| Com_show_variables | 4 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 2068 |
| Connections | 1334 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_tables | 198 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 2 |
| Handler_commit | 0 |
| Handler_delete | 120 |
| Handler_read_first | 4002 |
| Handler_read_key | 5634 |
| Handler_read_next | 1317 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 3148 |
| Handler_read_rnd_next | 108117 |
| Handler_rollback | 0 |
| Handler_update | 1167 |
| Handler_write | 2516 |
| Key_blocks_used | 108 |
| Key_read_requests | 15378 |
| Key_reads | 0 |
| Key_write_requests | 3171 |
| Key_writes | 3165 |
| Max_used_connections | 2 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 22 | 34% of table_cache in use
| Open_files | 41 |
| Open_streams | 0 |
| Opened_tables | 212 |
| Questions | 13902 |
| Qcache_queries_in_cache | 0 |
| Qcache_inserts | 0 |
| Qcache_hits | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_free_memory | 0 |
| Qcache_free_blocks | 0 |
| Qcache_total_blocks | 0 |
| Rpl_status | NULL |
| Select_full_join | 6 |
| Select_full_range_join | 0 |
| Select_range | 44 |
| Select_range_check | 0 |
| Select_scan | 900 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 | (execution time > 10 secs)
| Sort_merge_passes | 0 |
| Sort_range | 0 |
| Sort_rows | 3148 |
| Sort_scan | 539 |
| Table_locks_immediate | 12681 |
| Table_locks_waited | 2 |
| Threads_cached | 0 |
| Threads_created | 1333 |
| Threads_connected | 1 |
| Threads_running | 1 |
| Uptime | 1107442 | 12 days 19 hrs 37 mins 22 secs
+---------------------------+-----------------+
Key Reads/Key Read Requests = 0.000000 (Cache hit = 100%)
Key Writes/Key Write Requests = 0.998108
Connections/second = 0.001 (/hour = 4.336)
KB received/second = 0.002 (/hour = 7.132)
KB sent/second = 0.007 (/hour = 26.565)
Temporary Tables Created/second = 0.000 (/hour = 0.644)
Opened Tables/second = 0.000 (/hour = 0.689)
Slow Queries/second = 0.000 (/hour = 0.000)
% of slow queries = 0.000%
Queries/second = 0.013 (/hour = 45.192)
8. oh and is your vB the only thing on the server? or other scripts? sites?
Has some Java.
9. how many average and max concurrent users on your vB forum ?
Just I, the web admin.
10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
<?
phpinfo();
?>
i.e. yourdomain.com/phpinfo.php
This is an intranet and this is from cut and paste:
PHP Version 4.3.2
System SunOS leo 5.8 Generic_108528-18 sun4u
Build Date Jun 17 2003 15:15:11
Configure Command './configure' '--with-mysql=/usr/local/mysql' '--with-nsapi=/usr/local/nshome' '--enable-track-vars' '--enable-libgcc'
Server API NSAPI
Virtual Directory Support enabled
Configuration File (php.ini) Path /usr/local/lib
PHP API 20020918
PHP Extension 20020429
Zend Extension 20021010
Debug Build no
Thread Safety enabled
Registered PHP Streams php, http, ftp
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 On On
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 On On
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 no value no value
expose_php On On
extension_dir /usr/local/lib/php/extensions/no-debug-zts-20020429 /usr/local/lib/php/extensions/no-debug-zts-20020429
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/local/lib/php .:/usr/local/lib/php
log_errors Off Off
log_errors_max_len 1024 1024
magic_quotes_gpc On On
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
max_execution_time 30 30
max_input_time -1 -1
open_basedir no value no value
output_buffering 0 0
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 /usr/local/php/bin /usr/local/php/bin
safe_mode_gid Off Off
safe_mode_include_dir no value no value
sendmail_from no value no value
sendmail_path /usr/lib/sendmail -t -i /usr/lib/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 no value no value
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
ctype
ctype functions enabled
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 4.0.13
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE -I/usr/local/mysql/include
MYSQL_LIBS -L/usr/local/mysql/lib -lmysqlclient
Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout -1 -1
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
overload
User-Space Object Overloading Support enabled
pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 3.92 11-Sep-2002
posix
Revision $Revision: 1.51.2.2 $
session
Session Support enabled
Registered save handlers files user
Directive Local Value Master Value
session.auto_start Off Off
session.bug_compat_42 On On
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 100 100
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 /tmp /tmp
session.serialize_handler php php
session.use_cookies On On
session.use_only_cookies Off Off
session.use_trans_sid Off Off
standard
Regex Library Bundled library enabled
Dynamic Library Support enabled
Path to sendmail /usr/lib/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,form=,fieldset= a=href,area=href,frame=src,form=,fieldset=
user_agent no value no value
tokenizer
Tokenizer Support enabled
xml
XML Support active
XML Namespace Support active
EXPAT Version 1.95.2
Additional Modules
Module Name
Environment
Variable Value
CLASSPATH /usr/j2se/bin:/usr/local/nshome/bin/https/jar/servlet.jar
HOME /web/users/hsiaok
HZ 100
LC_COLLATE en_US.ISO8859-1
LC_CTYPE en_US.ISO8859-1
LC_MESSAGES C
LC_MONETARY en_US.ISO8859-1
LC_NUMERIC en_US.ISO8859-1
LC_TIME en_US.ISO8859-1
LD_LIBRARY_PATH /usr/j2se/jre/lib/sparc/server:/usr/j2se/jre/lib/sparc:/usr/j2se/jre/lib/sparc/classic:/usr/j2se/jre/lib/sparc/native_threads:/usr/local/nshome/bin/https/lib:
LIBPATH :/usr/j2se/jre/lib/sparc/server:/usr/j2se/jre/lib/sparc:/usr/j2se/jre/lib/sparc/classic:/usr/j2se/jre/lib/sparc/native_threads:/usr/local/nshome/bin/https/lib::/usr/lib/threads:/usr/ibmcxx/lib:/usr/lib:/lib
LOGNAME hsiaok
MAIL /var/mail/hsiaok
NES_SERVER_HOME /usr/local/nshome
NSES_CLASSPATH /usr/local/nshome/bin/https/jar/NSServletLayer.jar:/usr/local/nshome/bin/https/jar/NSJavaUtil.jar:/usr/local/nshome/bin/https/jar/NSJavaMiscUtil.jar:/usr/local/nshome/bin/https/jar/servlet.jar:/usr/local/nshome/bin/https/jar/jspengine.jar:/usr/local/nshome/bin/https/jar/jakarta-naming.jar
NSES_JDK /usr/j2se
NSES_JDK_RUNTIME_CLASSPATH /usr/j2se/jre/lib/ext/iiimp.jar:/usr/j2se/jre/lib/i18n.jar:/usr/j2se/jre/lib/rt.jar:/usr/j2se/lib/tools.jar:/usr/j2se/lib/dt.jar
NSES_JRE /usr/j2se/jre
NSES_JRE_RUNTIME_LIBPATH /usr/j2se/jre/lib/sparc/server:/usr/j2se/jre/lib/sparc:/usr/j2se/jre/lib/sparc/classic:/usr/j2se/jre/lib/sparc/native_threads
NSES_SERVER_HOME /usr/local/nshome
NS_HTTPS_HOME /usr/local/nshome/bin/https
NS_SERVER_HOME /usr/local/nshome
PATH /usr/local/nshome/bin/https/bin:/usr/sbin:/usr/bin
PS1 #
SHELL /bin/sh
SHLIB_PATH :/usr/j2se/jre/lib/sparc/server:/usr/j2se/jre/lib/sparc:/usr/j2se/jre/lib/sparc/classic:/usr/j2se/jre/lib/sparc/native_threads:/usr/local/nshome/bin/https/lib:
TERM vt220
TZ US/Pacific
_INIT_NET_STRATEGY none
_INIT_PREV_LEVEL S
_INIT_RUN_LEVEL 3
_INIT_RUN_NPREV 0
_INIT_UTS_ISA sparc
_INIT_UTS_MACHINE sun4u
_INIT_UTS_NODENAME leo
_INIT_UTS_PLATFORM SUNW,Ultra-4
_INIT_UTS_RELEASE 5.8
_INIT_UTS_SYSNAME SunOS
_INIT_UTS_VERSION Generic_108528-18
WD_PIPE_FD 0
NLSPATH /usr/dt/lib/nls/msg/%L/%N.cat
XFILESEARCHPATH /usr/dt/app-defaults/%L/Dt
PHP Variables
Variable Value
_REQUEST["bblastvisit"] 1055959585
_REQUEST["bbuserid"] 1
_REQUEST["bbpassword"] 90be705fcbf7a13d116c6e0929a37329
_REQUEST["sessionhash"] 90e41013791c815b78e1dc9742c4f977
_REQUEST["bbadminon"] 1
_COOKIE["bblastvisit"] 1055959585
_COOKIE["bbuserid"] 1
_COOKIE["bbpassword"] 90be705fcbf7a13d116c6e0929a37329
_COOKIE["sessionhash"] 90e41013791c815b78e1dc9742c4f977
_COOKIE["bbadminon"] 1
_SERVER["REQUEST_LINE"] GET /forums/admin/phpinfo.php HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["PHP_SELF"] /forums/admin/phpinfo.php
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["HTTP_ACCEPT"] */*
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-us
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; T312461)
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
_SERVER["HTTP_HOST"] intranet.losangeles.af.mil
_SERVER["HTTP_CONNECTION"] Keep-Alive
_SERVER["HTTP_COOKIE"] bblastvisit=1055959585; bbuserid=1; bbpassword=90be705fcbf7a13d116c6e0929a37329; ; bbadminon=1
_SERVER["SCRIPT_FILENAME"] /web/prod/docs/forums/admin/phpinfo.php
_SERVER["REMOTE_ADDR"] 138.13.69.13
_SERVER["REMOTE_HOST"] 138.13.69.13
_SERVER["SERVER_PORT"] 80
_SERVER["SERVER_NAME"] leo.losangeles.af.mil
_SERVER["SERVER_URL"] http://intranet.losangeles.af.mil
_SERVER["SERVER_SOFTWARE"] Netscape-Enterprise/6.1
_SERVER["HTTPS"] OFF
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["DOCUMENT_ROOT"] /web/prod/docs
_SERVER["REQUEST_URI"] /forums/admin/phpinfo.php
_SERVER["SCRIPT_NAME"] /forums/admin/phpinfo.php
_SERVER["argv"] Array
(
)
_SERVER["argc"] 0
_ENV["CLASSPATH"] /usr/j2se/bin:/usr/local/nshome/bin/https/jar/servlet.jar
_ENV["HOME"] /web/users/hsiaok
_ENV["HZ"] 100
_ENV["LC_COLLATE"] en_US.ISO8859-1
_ENV["LC_CTYPE"] en_US.ISO8859-1
_ENV["LC_MESSAGES"] C
_ENV["LC_MONETARY"] en_US.ISO8859-1
_ENV["LC_NUMERIC"] en_US.ISO8859-1
_ENV["LC_TIME"] en_US.ISO8859-1
_ENV["LD_LIBRARY_PATH"] /usr/j2se/jre/lib/sparc/server:/usr/j2se/jre/lib/sparc:/usr/j2se/jre/lib/sparc/classic:/usr/j2se/jre/lib/sparc/native_threads:/usr/local/nshome/bin/https/lib:
_ENV["LIBPATH"] :/usr/j2se/jre/lib/sparc/server:/usr/j2se/jre/lib/sparc:/usr/j2se/jre/lib/sparc/classic:/usr/j2se/jre/lib/sparc/native_threads:/usr/local/nshome/bin/https/lib::/usr/lib/threads:/usr/ibmcxx/lib:/usr/lib:/lib
_ENV["LOGNAME"] hsiaok
_ENV["MAIL"] /var/mail/hsiaok
_ENV["NES_SERVER_HOME"] /usr/local/nshome
_ENV["NSES_CLASSPATH"] /usr/local/nshome/bin/https/jar/NSServletLayer.jar:/usr/local/nshome/bin/https/jar/NSJavaUtil.jar:/usr/local/nshome/bin/https/jar/NSJavaMiscUtil.jar:/usr/local/nshome/bin/https/jar/servlet.jar:/usr/local/nshome/bin/https/jar/jspengine.jar:/usr/local/nshome/bin/https/jar/jakarta-naming.jar
_ENV["NSES_JDK"] /usr/j2se
_ENV["NSES_JDK_RUNTIME_CLASSPATH"] /usr/j2se/jre/lib/ext/iiimp.jar:/usr/j2se/jre/lib/i18n.jar:/usr/j2se/jre/lib/rt.jar:/usr/j2se/lib/tools.jar:/usr/j2se/lib/dt.jar
_ENV["NSES_JRE"] /usr/j2se/jre
_ENV["NSES_JRE_RUNTIME_LIBPATH"] /usr/j2se/jre/lib/sparc/server:/usr/j2se/jre/lib/sparc:/usr/j2se/jre/lib/sparc/classic:/usr/j2se/jre/lib/sparc/native_threads
_ENV["NSES_SERVER_HOME"] /usr/local/nshome
_ENV["NS_HTTPS_HOME"] /usr/local/nshome/bin/https
_ENV["NS_SERVER_HOME"] /usr/local/nshome
_ENV["PATH"] /usr/local/nshome/bin/https/bin:/usr/sbin:/usr/bin
_ENV["PS1"] #
_ENV["SHELL"] /bin/sh
_ENV["SHLIB_PATH"] :/usr/j2se/jre/lib/sparc/server:/usr/j2se/jre/lib/sparc:/usr/j2se/jre/lib/sparc/classic:/usr/j2se/jre/lib/sparc/native_threads:/usr/local/nshome/bin/https/lib:
_ENV["TERM"] vt220
_ENV["TZ"] US/Pacific
_ENV["_INIT_NET_STRATEGY"] none
_ENV["_INIT_PREV_LEVEL"] S
_ENV["_INIT_RUN_LEVEL"] 3
_ENV["_INIT_RUN_NPREV"] 0
_ENV["_INIT_UTS_ISA"] sparc
_ENV["_INIT_UTS_MACHINE"] sun4u
_ENV["_INIT_UTS_NODENAME"] leo
_ENV["_INIT_UTS_PLATFORM"] SUNW,Ultra-4
_ENV["_INIT_UTS_RELEASE"] 5.8
_ENV["_INIT_UTS_SYSNAME"] SunOS
_ENV["_INIT_UTS_VERSION"] Generic_108528-18
_ENV["WD_PIPE_FD"] 0
_ENV["NLSPATH"] /usr/dt/lib/nls/msg/%L/%N.cat
_ENV["XFILESEARCHPATH"] /usr/dt/app-defaults/%L/Dt
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. if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following :
KeepAlive
MaxKeepAliveRequests
KeepAliveTimeout
MinSpareServers
MaxSpareServers
StartServers
MaxClients
12. what version of vB are you running ?
2.3.0
__________________
Steve Machol, vBulletin Team Member and Webmaster of OptiBoard Discussion Forums
Please do not email or PM me for vBulletin support. I will try to answer your questions on the vB Forums and in the support system.
Report Post | IP: Logged
Posts: 27,473
I notice the php.ini from the phpinfo() is incorrect for my server.
The php.ini is on /usr/local/tmp/php-4.3.2/pear/tests/php.ini
and not /usr/local/lib and here is the content of php.ini
; php.ini for PEAR tests
include_path=..
1. is this on dedicated or shared virual server
Dedicated
2. your server specs. For example:
2 CPU SUNW, ULTRA-4;
RAM: 1 GB
Virtual RAM: 2.7 GB
HD: 133 GB
OS: SUN Solaris 5.8
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
# mysql --version
mysql Ver 12.20 Distrib 4.0.13, for sun-solaris2.8 (sparc)
I don't know what innodb is.
It contain the bareboon Mysql DB created by VBulletin during
installation. It has no datasbase used by any other application
other can VBulletin.
4. if possible how mysql was compiled/installed
The MySQl installation source is binary code.
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> tar xvf *.tar
shell> ln -s /usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc mysql
shell> cd mysql
shell> scripts/mysql_install_db
shell> chown -R root .
shell> chown -R mysql data
shell> chgrp -R mysql .
shell> bin/mysqld_safe --user=mysql &
or
shell> bin/mysqld_safe --user=mysql &
if you are running MySQL 4.x
After the MySql installation, to check for which version of MySQl installed
# mysql --version
mysql Ver 12.20 Distrib 4.0.13, for sun-solaris2.8 (sparc)
/usr/local/mysql/bin/mysql --version
5. your top stats
Please explain 'top stats'.
6. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf if on Windows server if you don't have that file you need to log into telnet and as root user type
mysqladmin -u root -p variables
copy and paste output here
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| back_log | 50 |
| basedir | /usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set | latin1 |
| character_sets | latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert | ON |
| connect_timeout | 5 |
| convert_character_set | |
| datadir | /usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/data/ |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_min_word_len | 4 |
| ft_max_word_len | 254 |
| ft_max_word_len_for_sort | 20 |
| ft_stopword_file | (built-in) |
| have_bdb | NO |
| have_crypt | YES |
| have_innodb | YES |
| have_isam | YES |
| have_raid | NO |
| have_symlink | YES |
| have_openssl | NO |
| have_query_cache | YES |
| init_file | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| 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 |
| innodb_max_dirty_pages_pct | 90 |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 8388600 |
| language | /usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/share/mysql/english/ |
| large_files_support | ON |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_update | OFF |
| log_bin | OFF |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_warnings | OFF |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_table_names | OFF |
| 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 | 268435456 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_repair_threads | 1 |
| myisam_recover_options | OFF |
| myisam_sort_buffer_size | 8388608 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| open_files_limit | 0 |
| pid_file | /usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/data/leo.pid |
| log_error | |
| port | 3306 |
| protocol_version | 10 |
| read_buffer_size | 131072 |
| read_rnd_buffer_size | 262144 |
| rpl_recovery_rank | 0 |
| query_cache_limit | 1048576 |
| query_cache_size | 0 |
| query_cache_type | ON |
| server_id | 0 |
| slave_net_timeout | 3600 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slow_launch_time | 2 |
| socket | /tmp/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | 0 |
| table_cache | 64 |
| table_type | MYISAM |
| thread_cache_size | 0 |
| thread_concurrency | 10 |
| thread_stack | 196608 |
| tx_isolation | REPEATABLE-READ |
| timezone | PDT |
| tmp_table_size | 33554432 |
| tmpdir | /var/tmp/ |
| version | 4.0.13-standard |
| wait_timeout | 28800 |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
7. your mysql extended-status output either still telnet as root user type
mysqladmin -u root -p extended-status
copy and paste output here
+--------------------------+---------+
| Variable_name | Value |
+--------------------------+---------+
| Aborted_clients | 206 |
| Aborted_connects | 12 |
| Bytes_received | 2246839 |
| Bytes_sent | 8362358 |
| Com_admin_commands | 0 |
| Com_alter_table | 8 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 1302 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 80 |
| Com_delete | 191 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 80 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 2195 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 0 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 6044 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 4 |
| Com_show_fields | 160 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 3 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 10 |
| Com_show_variables | 3 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 2068 |
| Connections | 1333 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_tables | 198 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 2 |
| Handler_commit | 0 |
| Handler_delete | 120 |
| Handler_read_first | 4002 |
| Handler_read_key | 5634 |
| Handler_read_next | 1317 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 3148 |
| Handler_read_rnd_next | 108117 |
| Handler_rollback | 0 |
| Handler_update | 1167 |
| Handler_write | 2516 |
| Key_blocks_used | 108 |
| Key_read_requests | 15378 |
| Key_reads | 0 |
| Key_write_requests | 3171 |
| Key_writes | 3165 |
| Max_used_connections | 2 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 22 |
| Open_files | 41 |
| Open_streams | 0 |
| Opened_tables | 212 |
| Questions | 13899 |
| Qcache_queries_in_cache | 0 |
| Qcache_inserts | 0 |
| Qcache_hits | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_free_memory | 0 |
| Qcache_free_blocks | 0 |
| Qcache_total_blocks | 0 |
| Rpl_status | NULL |
| Select_full_join | 6 |
| Select_full_range_join | 0 |
| Select_range | 44 |
| Select_range_check | 0 |
| Select_scan | 900 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 0 |
| Sort_rows | 3148 |
| Sort_scan | 539 |
| Table_locks_immediate | 12681 |
| Table_locks_waited | 2 |
| Threads_cached | 0 |
| Threads_created | 1332 |
| Threads_connected | 1 |
| Threads_running | 1 |
| Uptime | 1107073 |
+--------------------------+---------+
or preferred is to installed extended-status output script which is either located
- in your vB 2.2.6 or higher vB version's zip file extra's folder, upload mysqlinfo.php script to your site or if you're on an pre vB 2.2.6 install go to
- http://vbulletin.com/forum/showthread.php?threadid=3477 and install that scrip making sure to edit $mysqllogin line with your own mysqlusername and password
and post url to that here
Mon Jun 30 10:27:42 PDT 2003
Http processes currently running = 0
Mysql processes currently running = 0
Netstat information summary
+---------------------------+-----------------+
| Variable_name | Value |
+---------------------------+-----------------+
| Aborted_clients | 206 |
| Aborted_connects | 12 |
| Bytes_received | 2246901 |
| Bytes_sent | 8369042 |
| Com_admin_commands | 0 |
| Com_alter_table | 8 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 1302 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 80 |
| Com_delete | 191 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 80 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 2195 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 0 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 6044 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 4 |
| Com_show_fields | 160 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 4 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 10 |
| Com_show_variables | 4 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 2068 |
| Connections | 1334 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_tables | 198 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 2 |
| Handler_commit | 0 |
| Handler_delete | 120 |
| Handler_read_first | 4002 |
| Handler_read_key | 5634 |
| Handler_read_next | 1317 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 3148 |
| Handler_read_rnd_next | 108117 |
| Handler_rollback | 0 |
| Handler_update | 1167 |
| Handler_write | 2516 |
| Key_blocks_used | 108 |
| Key_read_requests | 15378 |
| Key_reads | 0 |
| Key_write_requests | 3171 |
| Key_writes | 3165 |
| Max_used_connections | 2 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 22 | 34% of table_cache in use
| Open_files | 41 |
| Open_streams | 0 |
| Opened_tables | 212 |
| Questions | 13902 |
| Qcache_queries_in_cache | 0 |
| Qcache_inserts | 0 |
| Qcache_hits | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_free_memory | 0 |
| Qcache_free_blocks | 0 |
| Qcache_total_blocks | 0 |
| Rpl_status | NULL |
| Select_full_join | 6 |
| Select_full_range_join | 0 |
| Select_range | 44 |
| Select_range_check | 0 |
| Select_scan | 900 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 | (execution time > 10 secs)
| Sort_merge_passes | 0 |
| Sort_range | 0 |
| Sort_rows | 3148 |
| Sort_scan | 539 |
| Table_locks_immediate | 12681 |
| Table_locks_waited | 2 |
| Threads_cached | 0 |
| Threads_created | 1333 |
| Threads_connected | 1 |
| Threads_running | 1 |
| Uptime | 1107442 | 12 days 19 hrs 37 mins 22 secs
+---------------------------+-----------------+
Key Reads/Key Read Requests = 0.000000 (Cache hit = 100%)
Key Writes/Key Write Requests = 0.998108
Connections/second = 0.001 (/hour = 4.336)
KB received/second = 0.002 (/hour = 7.132)
KB sent/second = 0.007 (/hour = 26.565)
Temporary Tables Created/second = 0.000 (/hour = 0.644)
Opened Tables/second = 0.000 (/hour = 0.689)
Slow Queries/second = 0.000 (/hour = 0.000)
% of slow queries = 0.000%
Queries/second = 0.013 (/hour = 45.192)
8. oh and is your vB the only thing on the server? or other scripts? sites?
Has some Java.
9. how many average and max concurrent users on your vB forum ?
Just I, the web admin.
10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
<?
phpinfo();
?>
i.e. yourdomain.com/phpinfo.php
This is an intranet and this is from cut and paste:
PHP Version 4.3.2
System SunOS leo 5.8 Generic_108528-18 sun4u
Build Date Jun 17 2003 15:15:11
Configure Command './configure' '--with-mysql=/usr/local/mysql' '--with-nsapi=/usr/local/nshome' '--enable-track-vars' '--enable-libgcc'
Server API NSAPI
Virtual Directory Support enabled
Configuration File (php.ini) Path /usr/local/lib
PHP API 20020918
PHP Extension 20020429
Zend Extension 20021010
Debug Build no
Thread Safety enabled
Registered PHP Streams php, http, ftp
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 On On
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 On On
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 no value no value
expose_php On On
extension_dir /usr/local/lib/php/extensions/no-debug-zts-20020429 /usr/local/lib/php/extensions/no-debug-zts-20020429
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/local/lib/php .:/usr/local/lib/php
log_errors Off Off
log_errors_max_len 1024 1024
magic_quotes_gpc On On
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
max_execution_time 30 30
max_input_time -1 -1
open_basedir no value no value
output_buffering 0 0
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 /usr/local/php/bin /usr/local/php/bin
safe_mode_gid Off Off
safe_mode_include_dir no value no value
sendmail_from no value no value
sendmail_path /usr/lib/sendmail -t -i /usr/lib/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 no value no value
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
ctype
ctype functions enabled
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 4.0.13
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE -I/usr/local/mysql/include
MYSQL_LIBS -L/usr/local/mysql/lib -lmysqlclient
Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout -1 -1
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
overload
User-Space Object Overloading Support enabled
pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 3.92 11-Sep-2002
posix
Revision $Revision: 1.51.2.2 $
session
Session Support enabled
Registered save handlers files user
Directive Local Value Master Value
session.auto_start Off Off
session.bug_compat_42 On On
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 100 100
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 /tmp /tmp
session.serialize_handler php php
session.use_cookies On On
session.use_only_cookies Off Off
session.use_trans_sid Off Off
standard
Regex Library Bundled library enabled
Dynamic Library Support enabled
Path to sendmail /usr/lib/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,form=,fieldset= a=href,area=href,frame=src,form=,fieldset=
user_agent no value no value
tokenizer
Tokenizer Support enabled
xml
XML Support active
XML Namespace Support active
EXPAT Version 1.95.2
Additional Modules
Module Name
Environment
Variable Value
CLASSPATH /usr/j2se/bin:/usr/local/nshome/bin/https/jar/servlet.jar
HOME /web/users/hsiaok
HZ 100
LC_COLLATE en_US.ISO8859-1
LC_CTYPE en_US.ISO8859-1
LC_MESSAGES C
LC_MONETARY en_US.ISO8859-1
LC_NUMERIC en_US.ISO8859-1
LC_TIME en_US.ISO8859-1
LD_LIBRARY_PATH /usr/j2se/jre/lib/sparc/server:/usr/j2se/jre/lib/sparc:/usr/j2se/jre/lib/sparc/classic:/usr/j2se/jre/lib/sparc/native_threads:/usr/local/nshome/bin/https/lib:
LIBPATH :/usr/j2se/jre/lib/sparc/server:/usr/j2se/jre/lib/sparc:/usr/j2se/jre/lib/sparc/classic:/usr/j2se/jre/lib/sparc/native_threads:/usr/local/nshome/bin/https/lib::/usr/lib/threads:/usr/ibmcxx/lib:/usr/lib:/lib
LOGNAME hsiaok
MAIL /var/mail/hsiaok
NES_SERVER_HOME /usr/local/nshome
NSES_CLASSPATH /usr/local/nshome/bin/https/jar/NSServletLayer.jar:/usr/local/nshome/bin/https/jar/NSJavaUtil.jar:/usr/local/nshome/bin/https/jar/NSJavaMiscUtil.jar:/usr/local/nshome/bin/https/jar/servlet.jar:/usr/local/nshome/bin/https/jar/jspengine.jar:/usr/local/nshome/bin/https/jar/jakarta-naming.jar
NSES_JDK /usr/j2se
NSES_JDK_RUNTIME_CLASSPATH /usr/j2se/jre/lib/ext/iiimp.jar:/usr/j2se/jre/lib/i18n.jar:/usr/j2se/jre/lib/rt.jar:/usr/j2se/lib/tools.jar:/usr/j2se/lib/dt.jar
NSES_JRE /usr/j2se/jre
NSES_JRE_RUNTIME_LIBPATH /usr/j2se/jre/lib/sparc/server:/usr/j2se/jre/lib/sparc:/usr/j2se/jre/lib/sparc/classic:/usr/j2se/jre/lib/sparc/native_threads
NSES_SERVER_HOME /usr/local/nshome
NS_HTTPS_HOME /usr/local/nshome/bin/https
NS_SERVER_HOME /usr/local/nshome
PATH /usr/local/nshome/bin/https/bin:/usr/sbin:/usr/bin
PS1 #
SHELL /bin/sh
SHLIB_PATH :/usr/j2se/jre/lib/sparc/server:/usr/j2se/jre/lib/sparc:/usr/j2se/jre/lib/sparc/classic:/usr/j2se/jre/lib/sparc/native_threads:/usr/local/nshome/bin/https/lib:
TERM vt220
TZ US/Pacific
_INIT_NET_STRATEGY none
_INIT_PREV_LEVEL S
_INIT_RUN_LEVEL 3
_INIT_RUN_NPREV 0
_INIT_UTS_ISA sparc
_INIT_UTS_MACHINE sun4u
_INIT_UTS_NODENAME leo
_INIT_UTS_PLATFORM SUNW,Ultra-4
_INIT_UTS_RELEASE 5.8
_INIT_UTS_SYSNAME SunOS
_INIT_UTS_VERSION Generic_108528-18
WD_PIPE_FD 0
NLSPATH /usr/dt/lib/nls/msg/%L/%N.cat
XFILESEARCHPATH /usr/dt/app-defaults/%L/Dt
PHP Variables
Variable Value
_REQUEST["bblastvisit"] 1055959585
_REQUEST["bbuserid"] 1
_REQUEST["bbpassword"] 90be705fcbf7a13d116c6e0929a37329
_REQUEST["sessionhash"] 90e41013791c815b78e1dc9742c4f977
_REQUEST["bbadminon"] 1
_COOKIE["bblastvisit"] 1055959585
_COOKIE["bbuserid"] 1
_COOKIE["bbpassword"] 90be705fcbf7a13d116c6e0929a37329
_COOKIE["sessionhash"] 90e41013791c815b78e1dc9742c4f977
_COOKIE["bbadminon"] 1
_SERVER["REQUEST_LINE"] GET /forums/admin/phpinfo.php HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["PHP_SELF"] /forums/admin/phpinfo.php
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["HTTP_ACCEPT"] */*
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-us
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; T312461)
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
_SERVER["HTTP_HOST"] intranet.losangeles.af.mil
_SERVER["HTTP_CONNECTION"] Keep-Alive
_SERVER["HTTP_COOKIE"] bblastvisit=1055959585; bbuserid=1; bbpassword=90be705fcbf7a13d116c6e0929a37329; ; bbadminon=1
_SERVER["SCRIPT_FILENAME"] /web/prod/docs/forums/admin/phpinfo.php
_SERVER["REMOTE_ADDR"] 138.13.69.13
_SERVER["REMOTE_HOST"] 138.13.69.13
_SERVER["SERVER_PORT"] 80
_SERVER["SERVER_NAME"] leo.losangeles.af.mil
_SERVER["SERVER_URL"] http://intranet.losangeles.af.mil
_SERVER["SERVER_SOFTWARE"] Netscape-Enterprise/6.1
_SERVER["HTTPS"] OFF
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["DOCUMENT_ROOT"] /web/prod/docs
_SERVER["REQUEST_URI"] /forums/admin/phpinfo.php
_SERVER["SCRIPT_NAME"] /forums/admin/phpinfo.php
_SERVER["argv"] Array
(
)
_SERVER["argc"] 0
_ENV["CLASSPATH"] /usr/j2se/bin:/usr/local/nshome/bin/https/jar/servlet.jar
_ENV["HOME"] /web/users/hsiaok
_ENV["HZ"] 100
_ENV["LC_COLLATE"] en_US.ISO8859-1
_ENV["LC_CTYPE"] en_US.ISO8859-1
_ENV["LC_MESSAGES"] C
_ENV["LC_MONETARY"] en_US.ISO8859-1
_ENV["LC_NUMERIC"] en_US.ISO8859-1
_ENV["LC_TIME"] en_US.ISO8859-1
_ENV["LD_LIBRARY_PATH"] /usr/j2se/jre/lib/sparc/server:/usr/j2se/jre/lib/sparc:/usr/j2se/jre/lib/sparc/classic:/usr/j2se/jre/lib/sparc/native_threads:/usr/local/nshome/bin/https/lib:
_ENV["LIBPATH"] :/usr/j2se/jre/lib/sparc/server:/usr/j2se/jre/lib/sparc:/usr/j2se/jre/lib/sparc/classic:/usr/j2se/jre/lib/sparc/native_threads:/usr/local/nshome/bin/https/lib::/usr/lib/threads:/usr/ibmcxx/lib:/usr/lib:/lib
_ENV["LOGNAME"] hsiaok
_ENV["MAIL"] /var/mail/hsiaok
_ENV["NES_SERVER_HOME"] /usr/local/nshome
_ENV["NSES_CLASSPATH"] /usr/local/nshome/bin/https/jar/NSServletLayer.jar:/usr/local/nshome/bin/https/jar/NSJavaUtil.jar:/usr/local/nshome/bin/https/jar/NSJavaMiscUtil.jar:/usr/local/nshome/bin/https/jar/servlet.jar:/usr/local/nshome/bin/https/jar/jspengine.jar:/usr/local/nshome/bin/https/jar/jakarta-naming.jar
_ENV["NSES_JDK"] /usr/j2se
_ENV["NSES_JDK_RUNTIME_CLASSPATH"] /usr/j2se/jre/lib/ext/iiimp.jar:/usr/j2se/jre/lib/i18n.jar:/usr/j2se/jre/lib/rt.jar:/usr/j2se/lib/tools.jar:/usr/j2se/lib/dt.jar
_ENV["NSES_JRE"] /usr/j2se/jre
_ENV["NSES_JRE_RUNTIME_LIBPATH"] /usr/j2se/jre/lib/sparc/server:/usr/j2se/jre/lib/sparc:/usr/j2se/jre/lib/sparc/classic:/usr/j2se/jre/lib/sparc/native_threads
_ENV["NSES_SERVER_HOME"] /usr/local/nshome
_ENV["NS_HTTPS_HOME"] /usr/local/nshome/bin/https
_ENV["NS_SERVER_HOME"] /usr/local/nshome
_ENV["PATH"] /usr/local/nshome/bin/https/bin:/usr/sbin:/usr/bin
_ENV["PS1"] #
_ENV["SHELL"] /bin/sh
_ENV["SHLIB_PATH"] :/usr/j2se/jre/lib/sparc/server:/usr/j2se/jre/lib/sparc:/usr/j2se/jre/lib/sparc/classic:/usr/j2se/jre/lib/sparc/native_threads:/usr/local/nshome/bin/https/lib:
_ENV["TERM"] vt220
_ENV["TZ"] US/Pacific
_ENV["_INIT_NET_STRATEGY"] none
_ENV["_INIT_PREV_LEVEL"] S
_ENV["_INIT_RUN_LEVEL"] 3
_ENV["_INIT_RUN_NPREV"] 0
_ENV["_INIT_UTS_ISA"] sparc
_ENV["_INIT_UTS_MACHINE"] sun4u
_ENV["_INIT_UTS_NODENAME"] leo
_ENV["_INIT_UTS_PLATFORM"] SUNW,Ultra-4
_ENV["_INIT_UTS_RELEASE"] 5.8
_ENV["_INIT_UTS_SYSNAME"] SunOS
_ENV["_INIT_UTS_VERSION"] Generic_108528-18
_ENV["WD_PIPE_FD"] 0
_ENV["NLSPATH"] /usr/dt/lib/nls/msg/%L/%N.cat
_ENV["XFILESEARCHPATH"] /usr/dt/app-defaults/%L/Dt
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. if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following :
KeepAlive
MaxKeepAliveRequests
KeepAliveTimeout
MinSpareServers
MaxSpareServers
StartServers
MaxClients
12. what version of vB are you running ?
2.3.0
__________________
Steve Machol, vBulletin Team Member and Webmaster of OptiBoard Discussion Forums
Please do not email or PM me for vBulletin support. I will try to answer your questions on the vB Forums and in the support system.
Report Post | IP: Logged
Posts: 27,473