VB running like a 3 legged Dog ;-(

[Gizmo99]

Please be gental bit new this ;)

Be hosted a VPS server provided by Verio

FreeBSD 4.1-RELEASE i386
VB 2.2.8
MySQL 3.23.46
PHP Version 4.0.4pl1
Apache/1.3.14 Ben-SSL/1.42


Max RequestsPer Child: 500
Keep Alive: off
Max Per Connection: 20
Timeouts Connection: 600
Keep-Alive: 5

back_log 50
basedir /usr/local/mysql-3.23.46/
binlog_cache_size 32768
character_set latin1
character_sets latin1 big5 czech euc_kr gb2312 gbk 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
datadir ****************
delay_key_write ON
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
flush OFF
flush_time 0
have_bdb NO
have_gemini NO
have_innodb NO
have_isam YES
have_raid NO
have_openssl NO
init_file
interactive_timeout 28800
join_buffer_size 131072
key_buffer_size 8388600
language **********english/
large_files_support ON
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 1000000
net_write_timeout 60
open_files_limit 0
pid_file ***********rsowners.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 OFF
skip_networking OFF
skip_show_database OFF
slow_launch_time 2
socket /tmp/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 MST
tmp_table_size 33554432
tmpdir /var/tmp/
version 3.23.46
wait_timeout 28800


under Myadmin I get that we have a MySql Client API version 3.23.22-beta

Please Help

[eva2000]

forgive the standard text copy and paste but this is the info i need from you to diagnose your problems :)

please provide the following

1. your server specs, such as mysql and php version
2. if possible how mysql was compiled/installed
3. your top stats
4. 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

5. your mysql extended-status output either still telnet as root user type

mysqladmin -u root -p extended-status

copy and paste output here

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

6. oh and is your vB the only thing on the server? or other scripts? sites?

7. how many average and max concurrent users on your vB forum ?

8. 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

9. 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

10. what version of vB are you running ?

[Gizmo99]

last pid: 671506432; load averag 4.12, 3.80, 3.673.67 up 27+16:00:36 22:27:12
49 processes: 5 running, 44 sleeping
CPU states: 79.2% user, 0.0% nice, 18.5% system, 2.0% interrupt, 0.3% idle
Mem: 600M Active, 154M Inact, 161M Wired, 48M Cache, 112M Buf, 41M Free
Swap: 1024M Total, 53M Used, 971M Free, 5% Inuse

PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND
80404 rsowners 30 0 16928K 14072K RUN 9:36 2.54% 2.54% mysqld
30521 rsowners 2 0 8576K 7360K sbwait 0:04 0.98% 0.98% httpd
31876 rsowners 2 0 8448K 7224K sbwait 0:04 0.88% 0.88% httpd
31859 rsowners 2 0 8924K 7708K select 0:02 0.88% 0.88% httpd
30792 rsowners 2 0 8656K 7360K sbwait 0:03 0.83% 0.83% httpd
34856 rsowners 30 0 1436K 1072K RUN 0:00 8.71% 0.83% top
32178 rsowners 2 0 8804K 7432K sbwait 0:02 0.73% 0.73% httpd
30703 rsowners -6 0 8556K 7348K piperd 0:04 0.63% 0.63% httpd
31240 rsowners 2 0 8560K 7240K select 0:03 0.54% 0.54% httpd
34860 rsowners 30 0 3412K 3072K RUN 0:00 5.13% 0.49% perl
31161 rsowners 2 0 8592K 7296K sbwait 0:04 0.34% 0.34% httpd
30799 rsowners 2 0 8484K 7264K select 0:03 0.29% 0.29% httpd
30519 rsowners 2 0 8616K 7380K sbwait 0:04 0.15% 0.15% httpd
32182 rsowners 2 0 8380K 7160K select 0:02 0.15% 0.15% httpd
32169 rsowners 2 0 8584K 7300K sbwait 0:02 0.10% 0.10% httpd
29066 rsowners 2 0 8516K 7308K sbwait 0:05 0.00% 0.00% httpd

mysqladmin -u root -p variables

back_log 50
basedir /usr/local/mysql-3.23.46/
binlog_cache_size 32768
character_set latin1
character_sets latin1 big5 czech euc_kr gb2312 gbk 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
datadir ****************
delay_key_write ON
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
flush OFF
flush_time 0
have_bdb NO
have_gemini NO
have_innodb NO
have_isam YES
have_raid NO
have_openssl NO
init_file
interactive_timeout 28800
join_buffer_size 131072
key_buffer_size 8388600
language **********english/
large_files_support ON
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 1000000
net_write_timeout 60
open_files_limit 0
pid_file ***********rsowners.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 OFF
skip_networking OFF
skip_show_database OFF
slow_launch_time 2
socket /tmp/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 MST
tmp_table_size 33554432
tmpdir /var/tmp/
version 3.23.46
wait_timeout 28800

mysqladmin -u root -p extended-status

| Variable_name | Value |
+--------------------------+-----------+
| Aborted_clients | 920 |
| Aborted_connects | 3 |
| Bytes_received | 46578476 |
| Bytes_sent | 625143050 |
| Connections | 970 |
| Created_tmp_disk_tables | 2942 |
| Created_tmp_tables | 14447 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 3930 |
| Handler_read_first | 19637 |
| Handler_read_key | 2306983 |
| Handler_read_next | 25948809 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 3164568 |
| Handler_read_rnd_next | 7500798 |
| Handler_update | 21212 |
| Handler_write | 1346042 |
| Key_blocks_used | 7793 |
| Key_read_requests | 11039669 |
| Key_reads | 54901 |
| Key_write_requests | 11939 |
| Key_writes | 11180 |
| Max_used_connections | 41 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 64 |
| Open_files | 84 |
| Open_streams | 0 |
| Opened_tables | 59329 |
| Questions | 244727 |
| Select_full_join | 2943 |
| Select_full_range_join | 0 |
| Select_range | 40313 |
| Select_range_check | 0 |
| Select_scan | 39993 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 29 |
| Slow_queries | 7426 |
| Sort_merge_passes | 0 |
| Sort_range | 29610 |
| Sort_rows | 3178770 |
| Sort_scan | 35569 |
| Table_locks_immediate | 256825 |
| Table_locks_waited | 27252 |
| Threads_cached | 0 |
| Threads_created | 969 |
| Threads_connected | 14 |
| Threads_running | 2 |
| Uptime | 45840 |
+--------------------------+-----------+

KeepAlive OFF
MaxKeepAliveRequests 20
KeepAliveTimeout 5
MinSpareServers NOT SET
MaxSpareServers NOT SET
StartServers NOT SET
MaxClients NOT SET

VB version 2.2.8
Max Users 200 around 3-100 average
Other Scripts on the server NUFFING ;-( only Html and a Counter script

Just for Good Measure

FreeBSD 4.1-RELEASE i386
VB 2.2.8
MySQL 3.23.46
PHP Version 4.0.4pl1
Apache/1.3.14 Ben-SSL/1.42

Max RequestsPer Child: 500
Keep Alive: off
Max Per Connection: 20
Timeouts Connection: 600
Keep-Alive: 5

Any More for Any More :D :D

bbs.rsownersclub.co.uk

Giz

[eva2000]

i got your support ticket too.. would you like to continue with this thread or take it to the support ticket ? :)

[Gizmo99]

Do it through support then we will post the fix if any ;) Here

Huggs

Giz