PDA

View Full Version : Optimization request


Chris 96 WS6
Wed 14th Mar '07, 12:17pm
1. Server: VPS

2. Specs:
cpu speed/type single or dual cpus): quad core Xeon 2.0ghz
how much memory installed: 512mb ram
hard drive type/configuration: unknown/requesting info from host
linux distributor or windows version: centos-4-x86_64
apache/IIS version: apache 1.3.37
PHP version: php 4.4.6
MySQL version: mysql 4.1.21

3. VB ver. 3.6.5

4. no innodb databases/tables

5. as delivered from host, I don't know

6. Top stats:

top - 10:13:59 up 2 days, 56 min, 2 users, load average: 1.29, 1.08, 0.77
Tasks: 72 total, 1 running, 66 sleeping, 0 stopped, 5 zombie
Cpu(s): 0.0% us, 0.1% sy, 0.0% ni, 90.4% id, 9.5% wa, 0.0% hi, 0.0% si
Mem: 524288k total, 249580k used, 274708k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1529 mailman 15 0 44944 1804 38m S 0 0.3 0:06.82 python2.4
13673 nobody 16 0 114m 15m 109m S 0 3.1 0:00.35 httpd
1 root 16 0 4756 508 4536 S 0 0.1 0:00.52 init
32489 root 15 0 3632 552 3444 S 0 0.1 0:04.87 syslogd
32519 root 15 0 2520 420 2348 S 0 0.1 0:00.00 courierlogger
32520 root 16 0 9028 512 8628 S 0 0.1 0:00.00 authdaemond
32521 root 16 0 9028 600 8628 S 0 0.1 0:00.76 authdaemond
32522 root 16 0 9028 568 8628 S 0 0.1 0:00.67 authdaemond
32523 root 16 0 9028 592 8628 S 0 0.1 0:00.69 authdaemond
32524 root 16 0 9028 568 8628 S 0 0.1 0:00.72 authdaemond
32525 root 16 0 9028 568 8628 S 0 0.1 0:00.67 authdaemond
32533 root 15 0 21924 1304 20m S 0 0.2 0:05.03 sshd
32544 root 17 0 8716 620 8336 S 0 0.1 0:00.00 xinetd
32554 root 17 0 6404 1004 6200 S 0 0.2 0:00.00 mysqld_safe
32584 mysql 15 0 46680 21m 18m S 0 4.2 0:21.87 mysqld
32615 root 16 0 2524 484 2348 S 0 0.1 0:00.07 courierlogger
32616 root 15 0 4684 516 4508 S 0 0.1 0:00.19 couriertcpd
7. mysql config:

[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock

skip-locking
safe-show-database
skip-innodb

max_connections = 200
max_allowed_packet = 16M
max_connect_errors = 10
wait_timeout = 10800
connect_timeout = 10

key_buffer = 8M
myisam_sort_buffer_size = 8M
join_buffer_size = 512K
read_buffer_size = 512K
sort_buffer_size = 1M
table_cache = 150
thread_cache_size = 3
tmp_table_size = 8M

query_cache_limit = 1M
query_cache_size = 6M
query_cache_type = 1
8. Mysql stats:


+---------------------------------+------------------------------------------+
| Variable_name | Value |
+---------------------------------+------------------------------------------+
| back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 10 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | NO |
| have_bdb | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | DISABLED |
| have_isam | NO |
| have_ndbcluster | NO |
| have_merge_engine | YES |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 28800 |
| join_buffer_size | 520192 |
| key_buffer_size | 8388608 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| lc_time_names | en_US |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_error | |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 16776192 |
| max_binlog_cache_size | 18446744073709551615 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 200 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 18446744073709551615 |
| max_length_for_sort_data | 1024 |
| max_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 18446744073709551615 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 18446744073709551615 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 9223372036854775807 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 8388608 |
| myisam_stats_method | nulls_unequal |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 1024 |
| pid_file | /var/lib/mysql/vps.ls1lt1.com.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 6291456 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 520192 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 0 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slave_transaction_retries | 0 |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 1048568 |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | ON |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| system_time_zone | CDT |
| table_cache | 150 |
| table_type | MyISAM |
| thread_cache_size | 3 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 8388608 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.21-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os | unknown-linux-gnu |
| wait_timeout | 10800 |
+---------------------------------+------------------------------------------+
+----------------------------+-------------+
| Variable_name | Value |
+----------------------------+-------------+
| Aborted_clients | 2566 |
| Aborted_connects | 0 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 326792679 |
| Bytes_sent | 13569027311 |
| Com_admin_commands | 1 |
| Com_alter_db | 0 |
| Com_alter_table | 30 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 402165 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 3 |
| Com_create_function | 0 |
| Com_create_index | 26 |
| Com_create_table | 20 |
| Com_dealloc_sql | 0 |
| Com_delete | 3949 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 3 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 37 |
| Com_grant | 19 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 27067 |
| Com_insert_select | 106 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 258 |
| Com_optimize | 0 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 3175 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 199040 |
| Com_set_option | 361598 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 1124 |
| Com_show_databases | 18 |
| Com_show_errors | 0 |
| Com_show_fields | 1155 |
| Com_show_grants | 56 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 578 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 4 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 1216 |
| Com_show_variables | 132 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 274 |
| Com_update | 365588 |
| Com_update_multi | 32 |
| Connections | 403099 |
| Created_tmp_disk_tables | 611 |
| Created_tmp_files | 4 |
| Created_tmp_tables | 5293 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 13466 |
| Handler_discover | 0 |
| Handler_read_first | 50148 |
| Handler_read_key | 2780826 |
| Handler_read_next | 2624825 |
| Handler_read_prev | 154507 |
| Handler_read_rnd | 188343 |
| Handler_read_rnd_next | 29961980 |
| Handler_rollback | 0 |
| Handler_update | 373864 |
| Handler_write | 82960 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 2813 |
| Key_blocks_used | 5283 |
| Key_read_requests | 11859432 |
| Key_reads | 25626 |
| Key_write_requests | 60232 |
| Key_writes | 45358 |
| Max_used_connections | 19 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 291 |
| Open_streams | 0 |
| Open_tables | 150 |
| Opened_tables | 5514 |
| Qcache_free_blocks | 270 |
| Qcache_free_memory | 1504264 |
| Qcache_hits | 758663 |
| Qcache_inserts | 197491 |
| Qcache_lowmem_prunes | 41446 |
| Qcache_not_cached | 363 |
| Qcache_queries_in_cache | 315 |
| Qcache_total_blocks | 1292 |
| Questions | 2528359 |
| Rpl_status | NULL |
| Select_full_join | 24 |
| Select_full_range_join | 0 |
| Select_range | 39792 |
| Select_range_check | 0 |
| Select_scan | 35720 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 59 |
| Sort_merge_passes | 2 |
| Sort_range | 57728 |
| Sort_rows | 514964 |
| Sort_scan | 3724 |
| Table_locks_immediate | 796431 |
| Table_locks_waited | 11465 |
| Threads_cached | 2 |
| Threads_connected | 2 |
| Threads_created | 2535 |
| Threads_running | 1 |
| Uptime | 173062 |
+----------------------------+-------------+
Uptime: 173062 Threads: 2 Questions: 2528360 Slow queries: 59 Opens: 5514 Flush tables: 1 Open tables: 150 Queries per second avg: 14.610
mysqladmin Ver 8.41 Distrib 4.1.21, for unknown-linux-gnu on x86_64
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 4.1.21-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 2 days 4 min 22 sec

Threads: 2 Questions: 2528360 Slow queries: 59 Opens: 5514 Flush tables: 1 Open tables: 150 Queries per second avg: 14.610
9. VB the only thing on the server? No. I have a smaller VB, 60 members and two other non-vb mysql driven site, that are easily moved to a shared hosting account...

10. Avg users 50 at any given time (including spiders), usually 8-15 members and 5-10 real guests, the rest spiders. Max would be around 20 members/20 guests and 50 spiders.

11. PHPinfo

PHP Version 4.4.4

System Linux host.nashvillespeed.com 2.6.9-022stab078.21-smp #1 SMP Fri Sep 8 22:16:16 MSD 2006 x86_64
Build Date Sep 8 2006 21:55:15
Configure Command './configure' '--enable-pic' '--with-apxs=/usr/local/apache/bin/apxs' '--with-libdir=lib64' '--prefix=/usr/local' '--with-xml' '--enable-ftp' '--with-gd' '--with-jpeg-dir=/usr/local' '--with-png-dir=/usr' '--with-xpm-dir=/usr/X11R6' '--enable-magic-quotes' '--with-mysqli' '--with-mysql=/usr' '--enable-discard-path' '--with-pear' '--enable-sockets' '--enable-track-vars' '--with-ttf' '--with-freetype-dir=/usr' '--enable-gd-native-ttf' '--with-zlib'
Server API Apache
Virtual Directory Support disabled
Configuration File (php.ini) Path /usr/local/lib/php.ini
PHP API 20020918
PHP Extension 20020429
Zend Extension 20050606
Debug Build no
Zend Memory Manager enabled
Thread Safety disabled
Registered PHP Streams php, http, ftp, compress.zlib

Zend logo This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies with eAccelerator v0.9.3, Copyright (c) 2004-2005 eAccelerator, by eAccelerator

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 error_log error_log
error_prepend_string no value no value
error_reporting 2039 2039
expose_php On On
extension_dir ./ ./
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/lib/php:/usr/local/lib/php .:/usr/lib/php:/usr/local/lib/php
log_errors On On
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 60 60
open_basedir /home/lsaltac:/usr/lib/php:/usr/local/lib/php:/tmp no value
output_buffering no value no value
output_handler no value no value
post_max_size 8M 8M
precision 12 12
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

apache
APACHE_INCLUDE no value
APACHE_TARGET no value
Apache Version Apache/1.3.37 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.4.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a
Apache Release 10337100
Apache API Version 19990320
Hostname:Port www.ls1lt1.com:80 (http://www.ls1lt1.com:80)
User/Group nobody(99)/99
Max Requests Per Child: 100 - Keep Alive: off - Max Per Connection: 100
Timeouts Connection: 300 - Keep-Alive: 15
Server Root /usr/local/apache
Loaded Modules mod_security, mod_auth_passthrough, mod_log_bytes, mod_bwlimited, mod_php4, mod_frontpage, mod_ssl, mod_setenvif, mod_so, mod_expires, mod_auth, mod_access, mod_rewrite, mod_alias, mod_userdir, mod_actions, mod_imap, mod_asis, mod_cgi, mod_dir, mod_autoindex, mod_include, mod_status, mod_negotiation, mod_mime, mod_log_config, mod_env, http_core

Directive Local Value Master Value
child_terminate 0 0
engine 1 1
last_modified 0 0
xbithack 0 0

Apache Environment
Variable Value
DOCUMENT_ROOT /home/lsaltac/public_html
HTTP_ACCEPT text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_CHARSET ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING gzip,deflate
HTTP_ACCEPT_LANGUAGE en-us,en;q=0.5
HTTP_CONNECTION keep-alive
HTTP_COOKIE __utma=10191912.1287505645.1165848959.1166018679.1 166106089.6; __utmz=10191912.1165873157.4.2.utmccn=(referral)|u tmcsr=sitepoint.com|utmcct=/forums/showthread.php|utmcmd=referral; bblastvisit=1173737114; bbpassword=099202c24c29b6e68472f3b46ea29b24; bbuserid=1; bblastactivity=0; vbulletin_collapse=; bbsessionhash=0811e4696181042930f991c531e1714e; bbcpsession=33a0a731f28297ae64fe2909f4fc37e9
HTTP_HOST www.ls1lt1.com (http://www.ls1lt1.com)
HTTP_KEEP_ALIVE 300
HTTP_REFERER http://www.ls1lt1.com/forum/admincp/index.php?do=nav
HTTP_USER_AGENT Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.10) Gecko/20070216 Firefox/1.5.0.10
PATH /bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin:/usr/local/sbin
REMOTE_ADDR 160.129.157.25
REMOTE_PORT 4155
SCRIPT_FILENAME /home/lsaltac/public_html/forum/admincp/index.php
SERVER_ADDR 64.22.66.235
SERVER_ADMIN webmaster@ls1lt1.com
SERVER_NAME www.ls1lt1.com (http://www.ls1lt1.com)
SERVER_PORT 80
SERVER_SIGNATURE <ADDRESS>Apache/1.3.37 Server at www.ls1lt1.com (http://www.ls1lt1.com) Port 80</ADDRESS>
SERVER_SOFTWARE Apache/1.3.37 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.4.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING do=phpinfo
REQUEST_URI /forum/admincp/index.php?do=phpinfo
SCRIPT_NAME /forum/admincp/index.php

HTTP Headers Information
HTTP Request Headers
HTTP Request GET /forum/admincp/index.php?do=phpinfo HTTP/1.1
Accept text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
Accept-Charset ISO-8859-1,utf-8;q=0.7,*;q=0.7
Accept-Encoding gzip,deflate
Accept-Language en-us,en;q=0.5
Connection keep-alive
Cookie __utma=10191912.1287505645.1165848959.1166018679.1 166106089.6; __utmz=10191912.1165873157.4.2.utmccn=(referral)|u tmcsr=sitepoint.com|utmcct=/forums/showthread.php|utmcmd=referral; bblastvisit=1173737114; bbpassword=099202c24c29b6e68472f3b46ea29b24; bbuserid=1; bblastactivity=0; vbulletin_collapse=; bbsessionhash=0811e4696181042930f991c531e1714e; bbcpsession=33a0a731f28297ae64fe2909f4fc37e9
Host www.ls1lt1.com (http://www.ls1lt1.com)
Keep-Alive 300
Referer http://www.ls1lt1.com/forum/admincp/index.php?do=nav
User-Agent Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.10) Gecko/20070216 Firefox/1.5.0.10
HTTP Response Headers
X-Powered-By PHP/4.4.4
Expires 0
Cache-Control private, post-check=0, pre-check=0, max-age=0
Pragma no-cache
Connection close
Transfer-Encoding chunked
Content-Type text/html; charset=ISO-8859-1

ctype
ctype functions enabled

eAccelerator
eAccelerator support enabled
Version 0.9.3
Caching Enabled true
Optimizer Enabled true
Memory Size 67,108,792 Bytes
Memory Available 13,900,200 Bytes
Memory Allocated 53,208,592 Bytes
Cached Scripts 349
Removed Scripts 0
Cached Keys 0

Directive Local Value Master Value
eaccelerator.cache_dir /mmcache /mmcache
eaccelerator.check_mtime 1 1
eaccelerator.compress 1 1
eaccelerator.compress_level 9 9
eaccelerator.content shm_and_disk shm_and_disk
eaccelerator.debug 0 0
eaccelerator.enable 1 1
eaccelerator.filter no value no value
eaccelerator.keys shm_and_disk shm_and_disk
eaccelerator.name_space no value no value
eaccelerator.optimizer 1 1
eaccelerator.sessions shm_and_disk shm_and_disk
eaccelerator.shm_max 0 0
eaccelerator.shm_only 1 1
eaccelerator.shm_prune_period 0 0
eaccelerator.shm_size 64 64
eaccelerator.shm_ttl 0 0

ftp
FTP support enabled

gd
GD Support enabled
GD Version bundled (2.0.28 compatible)
FreeType Support enabled
FreeType Linkage with freetype
GIF Read Support enabled
GIF Create Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled

mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 1
Client API version 4.1.21
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib64 -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

overload
User-Space Object Overloading Support enabled

pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 6.6 06-Feb-2006

posix
Revision $Revision: 1.51.2.4.2.1 $

session
Session Support enabled
Registered save handlers files user eaccelerator

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

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=,fieldse t= a=href,area=href,frame=src,input=src,form=,fieldse t=
user_agent no value no value

tokenizer
Tokenizer Support enabled

xml
XML Support active
XML Namespace Support active
EXPAT Version 1.95.6

zlib
ZLib Support enabled
Compiled Version 1.2.1.2
Linked Version 1.2.1.2

Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value

Additional Modules
Module Name

Environment
Variable Value
PATH /bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin:/usr/local/sbin
PWD /
SHLVL 1
RESTARTSRV 1
_ /usr/local/apache/bin/httpd

PHP Variables
Variable Value
_REQUEST["do"] phpinfo
_REQUEST["s"] no value
_REQUEST["styleid"] 0
_REQUEST["langid"] 0
_REQUEST["redirect"] no value
_REQUEST["nojs"] 0
_REQUEST["navprefs"] no value
_GET["do"] phpinfo
_POST["adminhash"] no value
_COOKIE["__utma"] 10191912.1287505645.1165848959.1166018679.11661060 89.6
_COOKIE["__utmz"] 10191912.1165873157.4.2.utmccn=(referral)|utmcsr=s itepoint.com|utmcct=/forums/showthread.php|utmcmd=referral
_COOKIE["bblastvisit"] 1173737114
_COOKIE["bbpassword"] 099202c24c29b6e68472f3b46ea29b24
_COOKIE["bbuserid"] 1
_COOKIE["bblastactivity"] 0
_COOKIE["vbulletin_collapse"] no value
_COOKIE["bbsessionhash"] 0811e4696181042930f991c531e1714e
_COOKIE["bbcpsession"] 33a0a731f28297ae64fe2909f4fc37e9
_COOKIE["bbreferrerid"] 0
_COOKIE["bbthreadedmode"] no value
_COOKIE["bbstyleid"] 0
_COOKIE["bblanguageid"] 0
_SERVER["DOCUMENT_ROOT"] /home/lsaltac/public_html
_SERVER["HTTP_ACCEPT"] text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
_SERVER["HTTP_ACCEPT_CHARSET"] ISO-8859-1,utf-8;q=0.7,*;q=0.7
_SERVER["HTTP_ACCEPT_ENCODING"] gzip,deflate
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-us,en;q=0.5
_SERVER["HTTP_CONNECTION"] keep-alive
_SERVER["HTTP_COOKIE"] __utma=10191912.1287505645.1165848959.1166018679.1 166106089.6; __utmz=10191912.1165873157.4.2.utmccn=(referral)|u tmcsr=sitepoint.com|utmcct=/forums/showthread.php|utmcmd=referral; bblastvisit=1173737114; bbpassword=099202c24c29b6e68472f3b46ea29b24; bbuserid=1; bblastactivity=0; vbulletin_collapse=; bbsessionhash=0811e4696181042930f991c531e1714e; bbcpsession=33a0a731f28297ae64fe2909f4fc37e9
_SERVER["HTTP_HOST"] www.ls1lt1.com (http://www.ls1lt1.com)
_SERVER["HTTP_KEEP_ALIVE"] 300
_SERVER["HTTP_REFERER"] http://www.ls1lt1.com/forum/admincp/index.php?do=nav
_SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.10) Gecko/20070216 Firefox/1.5.0.10
_SERVER["PATH"] /bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin:/usr/local/sbin
_SERVER["REMOTE_ADDR"] 160.129.157.25
_SERVER["REMOTE_PORT"] 4155
_SERVER["SCRIPT_FILENAME"] /home/lsaltac/public_html/forum/admincp/index.php
_SERVER["SERVER_ADDR"] 64.22.66.235
_SERVER["SERVER_ADMIN"] webmaster@ls1lt1.com
_SERVER["SERVER_NAME"] www.ls1lt1.com (http://www.ls1lt1.com)
_SERVER["SERVER_PORT"] 80
_SERVER["SERVER_SIGNATURE"] <ADDRESS>Apache/1.3.37 Server at www.ls1lt1.com (http://www.ls1lt1.com) Port 80</ADDRESS>
_SERVER["SERVER_SOFTWARE"] Apache/1.3.37 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.4.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_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["PATH_TRANSLATED"] /home/lsaltac/public_html/forum/admincp/index.php
_SERVER["PHP_SELF"] /forum/admincp/index.php
_SERVER["argv"]

Array
(
[0] => do=phpinfo
)

_SERVER["argc"] 1
_ENV["PATH"] /bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin:/usr/local/sbin
_ENV["PWD"] /
_ENV["SHLVL"] 1
_ENV["RESTARTSRV"] 1
_ENV["_"] /usr/local/apache/bin/httpd
[/quote]

12.
KeepAlive off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 1
MaxSpareServers 5
StartServers 2
MaxClients 50

AND Maxrequestsperchild value = 100

13. No files over 2gb

14. Uname:

Linux host.nashvillespeed.com 2.6.9-022stab078.21-smp #1 SMP Fri Sep 8 22:16:16 MSD 2006 x86_64 x86_64 x86_64 GNU/Linux
ulimit:

Linux host.nashvillespeed.com 2.6.9-022stab078.21-smp #1 SMP Fri Sep 8 22:16:16 MSD 2006 x86_64 x86_64 x86_64 GNU/Linux
root@host [~]# ulimit -aH
core file size (blocks, -c) 1000000
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 4096
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited

cat /proc/cpuinfo:
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
stepping : 6
cpu MHz : 2000.142
cache size : 64 KB
physical id : 0
siblings : 2
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall lm pni monitor ds_cpl est cmpxchg16b
bogomips : 3940.35
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
stepping : 6
cpu MHz : 2000.142
cache size : 64 KB
physical id : 3
siblings : 2
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall lm pni monitor ds_cpl est cmpxchg16b
bogomips : 3997.69
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 2
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
stepping : 6
cpu MHz : 2000.142
cache size : 64 KB
physical id : 0
siblings : 2
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall lm pni monitor ds_cpl est cmpxchg16b
bogomips : 3997.69
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 3
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
stepping : 6
cpu MHz : 2000.142
cache size : 64 KB
physical id : 3
siblings : 2
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall lm pni monitor ds_cpl est cmpxchg16b
bogomips : 3997.69
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:

eva2000
Sat 17th Mar '07, 9:19am
I'd update your linux kernel as there's known bugs with the kernel you're on - read http://www.vbulletin.com/forum/showthread.php?t=171071

Also update to MySQL 4.1.22 and recompile PHP 4.4.6

then repost output for question #8

Chris 96 WS6
Sat 17th Mar '07, 8:51pm
My host won't let me upgrade kernel, since I'm on a VPS the kernel is shared with the other users.

I don't have any newer PHP versions available in Cpanel....I should be able to upgrade mysql though.

Assuming I am stuck with the above though, what should be done to optimize

I was having problems during high usage where users would get page inaccessible errors in IE and php file download prompts in Firefox, but an upgrade to a newer version of eAccelerator seems to have fixed it.

eva2000
Sun 18th Mar '07, 5:23am
the outdated buggy kernel can be a problem..

Just noticed you're on a VPS server but have innodb disabled ... usually plesk requires innodb enabled ?

but try this anyway

Edit /etc/my.cnf and place the following mysql server settings in /etc/my.cnf and restart mysql server afterwards


[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
safe-show-database
old_passwords
back_log = 75
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 = 1800
thread_cache_size = 384
wait_timeout = 25
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 2M
query_cache_size = 32M
query_cache_type = 1
query_prealloc_size = 163840
query_alloc_block_size = 32768
default-storage-engine = MyISAM

[mysqld_safe]
#nice = -5
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

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

[mysqlhotcopy]
interactive-timeout

Chris 96 WS6
Sun 18th Mar '07, 4:39pm
I'm on a Cpanel VPS, not plesk.

Thanks for the recommendations. I'll give them a try.

eva2000
Mon 19th Mar '07, 9:56am
I see :)