Announcement

**Wayne Luke** · Mon 28 Oct '02, 4:33pm

And this site is the only thing on the server? If so, it sounds like you need to optimize MySQL and Apache to work more efficiently.

You should check in the Server Configuration forum for help. SitePointForums runs on roughly similar equipment and similar usage. If the load average climbs above .5 then we think there is a problem. Never happens though.

**George L** · Mon 28 Oct '02, 8:59pm

let's have a look

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 ?

**Male_LadyBug** · Tue 29 Oct '02, 10:24am

http://hawaaworld.com/info.php

**Male_LadyBug** · Tue 29 Oct '02, 12:06pm

Tue Oct 29 21:59:03 EST 2002

9:59pm up 4 days, 23:34, 0 users, load average: 34.64, 28.73, 27.99
318 processes: 282 sleeping, 36 running, 0 zombie, 0 stopped
CPU0 states: 51.6% user, 48.2% system, 0.0% nice, 0.0% idle
CPU1 states: 55.4% user, 44.3% system, 0.0% nice, 0.0% idle
Mem: 1030984K av, 1004828K used, 26156K free, 0K shrd, 37040K buff
Swap: 1052248K av, 80288K used, 971960K free 340220K cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
6833 mysql 20 0 40336 36M 2124 R 0.4 3.6 0:00 mysqld

Http processes currently running = 167
Mysql processes currently running = 107

Netstat information summary
1 LAST_ACK
1 SYN_RECV
22 LISTEN
23 CLOSE_WAIT
40 ESTABLISHED
62 TIME_WAIT

+---------------------------+-----------------+
| Variable_name | Value |
+---------------------------+-----------------+
| Aborted_clients | 599 |
| Aborted_connects | 2689 |
| Bytes_received | 278025515 |
| Bytes_sent | 4114998142 |
| Com_admin_commands | 0 |
| Com_alter_table | 66 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 4 |
| Com_change_db | 94988 |
| Com_change_master | 0 |
| Com_check | 88 |
| Com_commit | 4 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 12 |
| Com_delete | 8728 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 4 |
| Com_flush | 1 |
| Com_grant | 0 |
| Com_insert | 17392 |
| Com_insert_select | 601 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 86 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 817 |
| Com_replace_select | 93 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 1949449 |
| Com_set_option | 160 |
| Com_show_binlogs | 0 |
| Com_show_create | 160 |
| Com_show_databases | 7 |
| Com_show_fields | 164 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_stat | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_stat | 0 |
| Com_show_status | 785 |
| Com_show_tables | 9 |
| Com_show_variables | 5 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 186675 |
| Connections | 50765 |
| Created_tmp_disk_tables | 13 |
| Created_tmp_tables | 26925 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 17699 |
| Handler_read_first | 21985 |
| Handler_read_key | 11624585 |
| Handler_read_next | 255373685 |
| Handler_read_prev | 30326 |
| Handler_read_rnd | 13221178 |
| Handler_read_rnd_next | 1681057830 |
| Handler_update | 420215 |
| Handler_write | 1496452 |
| Key_blocks_used | 7793 |
| Key_read_requests | 62901311 |
| Key_reads | 116809 |
| Key_write_requests | 83862 |
| Key_writes | 35163 |
| Max_used_connections | 100 | Max. connections reached

| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 64 | 100% of table_cache in use
| Open_files | 85 |
| Open_streams | 0 |
| Opened_tables | 2039 |
| Questions | 2306893 |
| Select_full_join | 13 |
| Select_full_range_join | 0 |
| Select_range | 214547 |
| Select_range_check | 0 |
| Select_scan | 322145 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 2 |
| Slow_queries | 3290 | (execution time > 10 secs)
| Sort_merge_passes | 0 |
| Sort_range | 235675 |
| Sort_rows | 13318776 |
| Sort_scan | 133203 |
| Table_locks_immediate | 2412827 |
| Table_locks_waited | 4593 |
| Threads_cached | 0 |
| Threads_created | 50764 |
| Threads_connected | 101 |
| Threads_running | 1 |
| Uptime | 165385 | 1 day 21 hrs 56 mins 25 secs
+---------------------------+-----------------+

Key Reads/Key Read Requests = 0.001857 (Cache hit = 99.998143%)
Key Writes/Key Write Requests = 0.419296
Connections/second = 0.307 (/hour = 1105.022)
KB received/second = 1.642 (/hour = 5910.043)
KB sent/second = 12.680 (/hour = 45649.506)
Temporary Tables Created/second = 0.163 (/hour = 586.087)
Opened Tables/second = 0.012 (/hour = 44.384)
Slow Queries/second = 0.020 (/hour = 71.615)
% of slow queries = 0.143%
Queries/second = 13.949 (/hour = 50215.042)

**Male_LadyBug** · Tue 29 Oct '02, 1:49pm

/etc/my.cnf

PHP Code:


[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

     

[mysql.server]

user=mysql

basedir=/var/lib



[safe_mysqld]

err-log=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

**George L** · Tue 29 Oct '02, 7:49pm

change your my.cnf contents to the below one and restart mysql

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max_connections=450
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
set-variable = wait_timeout=9600
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10

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

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit=8192

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[myisamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M

**Male_LadyBug** · Wed 30 Oct '02, 12:35pm

I do it ... but the problem still until now !!

Wed Oct 30 22:40:15 EST 2002

10:40pm up 6 days, 15 min, 1 user, load average: 18.64, 9.97, 4.95
225 processes: 207 sleeping, 18 running, 0 zombie, 0 stopped
CPU0 states: 57.0% user, 42.0% system, 0.0% nice, 0.0% idle
CPU1 states: 44.0% user, 55.1% system, 0.0% nice, 0.0% idle
Mem: 1030984K av, 1012980K used, 18004K free, 0K shrd, 92820K buff
Swap: 1052248K av, 63136K used, 989112K free 342308K cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
3151 mysql 15 0 13196 12M 2164 R 0.0 1.2 0:03 mysqld

Http processes currently running = 142
Mysql processes currently running = 36

Netstat information summary
5 SYN_SENT
6 CLOSE_WAIT
22 LISTEN
23 ESTABLISHED
87 TIME_WAIT

+---------------------------+-----------------+
| Variable_name | Value |
+---------------------------+-----------------+
| Aborted_clients | 0 |
| Aborted_connects | 677 |
| Bytes_received | 6096292 |
| Bytes_sent | 121987641 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 2312 |
| 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 | 0 |
| Com_delete | 237 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_insert | 643 |
| Com_insert_select | 104 |
| Com_kill | 0 |
| Com_load | 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 | 106 |
| Com_replace_select | 45 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 39708 |
| Com_set_option | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 1 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_stat | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_stat | 0 |
| Com_show_status | 36 |
| Com_show_tables | 0 |
| Com_show_variables | 35 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 2410 |
| Connections | 1921 |
| Created_tmp_disk_tables | 1 |
| Created_tmp_tables | 890 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 204 |
| Handler_read_first | 1573 |
| Handler_read_key | 237499 |
| Handler_read_next | 4890450 |
| Handler_read_prev | 2 |
| Handler_read_rnd | 321923 |
| Handler_read_rnd_next | 2929161 |
| Handler_update | 2168 |
| Handler_write | 55706 |
| Key_blocks_used | 3942 |
| Key_read_requests | 1261294 |
| Key_reads | 3641 |
| Key_write_requests | 24775 |
| Key_writes | 4347 |
| Max_used_connections | 28 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 74 | 7% of table_cache in use
| Open_files | 130 |
| Open_streams | 0 |
| Opened_tables | 88 |
| Questions | 46856 |
| Select_full_join | 1 |
| Select_full_range_join | 0 |
| Select_range | 4562 |
| Select_range_check | 0 |
| Select_scan | 6693 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 0 | (execution time > 10 secs)
| Sort_merge_passes | 0 |
| Sort_range | 4110 |
| Sort_rows | 324969 |
| Sort_scan | 2895 |
| Table_locks_immediate | 48988 |
| Table_locks_waited | 11 |
| Threads_cached | 6 |
| Threads_created | 29 |
| Threads_connected | 23 |
| Threads_running | 1 |
| Uptime | 3187 | 53 mins 7 secs
+---------------------------+-----------------+

Key Reads/Key Read Requests = 0.002887 (Cache hit = 99.997113%)
Key Writes/Key Write Requests = 0.175459
Connections/second = 0.603 (/hour = 2169.940)
KB received/second = 1.868 (/hour = 6724.443)
KB sent/second = 37.379 (/hour = 134565.673)
Temporary Tables Created/second = 0.279 (/hour = 1005.334)
Opened Tables/second = 0.028 (/hour = 99.404)
Slow Queries/second = 0.000 (/hour = 0.000)
% of slow queries = 0.000%
Queries/second = 14.702 (/hour = 52928.020)

**Male_LadyBug** · Wed 30 Oct '02, 12:54pm

Wed Oct 30 23:03:00 EST 2002

11:03pm up 6 days, 38 min, 0 users, load average: 38.66, 37.21, 26.85
282 processes: 243 sleeping, 39 running, 0 zombie, 0 stopped
CPU0 states: 48.2% user, 51.0% system, 0.0% nice, 0.0% idle
CPU1 states: 52.0% user, 47.2% system, 0.0% nice, 0.0% idle
Mem: 1030984K av, 1009152K used, 21832K free, 0K shrd, 92352K buff
Swap: 1052248K av, 63140K used, 989108K free 265104K cached

**Male_LadyBug** · Thu 31 Oct '02, 5:49pm

now load average up to 110 !!

**George L** · Thu 31 Oct '02, 6:23pm

hi i used your server info in your support ticket and checked your server looks like both your cpus are 100% maxed out all the time with 0% idle time on both cpus for long periods of time...

you can try upgrading apache to 1.3.27 and linux kernel to lastest 2.4.x smp kernel and see if that helps could be bugs in kernel causing this or could be you need to upgrade your cpus

other possible issue is your slow 40GB EIDE hdd which is more cpu resource intensive than scsi disks...

you can upgrade apache and linux kernel first and see if that helps after a few days of use then upgrade your hdd from EIDE to scsi based and see if that helps first before upgrading cpus

**Male_LadyBug** · Tue 5 Nov '02, 5:43am

apache and kernel r upgraded yes

the drive is good we have been running vb on a similar one before

daul p111 1ghz i think is more than enough

when i close the vb everything goes back to normal????

**Male_LadyBug** · Tue 5 Nov '02, 6:40am

http://www.hawaaworld.com/vb/admin/

look admin cpanel runs smoothly and fine perfect

http://www.hawaaworld.com/vb/index.php
http://hawaaworld.com/vb/forumdisplay.php?s=&forumid=4
http://hawaaworld.com/vb/showthread....threadid=47464

takes ages to browse board and open threads

definelty something wrong with th vb script

**George L** · Tue 5 Nov '02, 9:08am

Originally posted by Male_LadyBug
http://www.hawaaworld.com/vb/admin/

look admin cpanel runs smoothly and fine perfect

http://www.hawaaworld.com/vb/index.php
http://hawaaworld.com/vb/forumdisplay.php?s=&forumid=4
http://hawaaworld.com/vb/showthread....threadid=47464

takes ages to browse board and open threads

definelty something wrong with th vb script

install a 2nd test dummy copy of vBulletin (same version as you're running on the above forum and check if the stock vB loads index and forums properly

**Male_LadyBug** · Tue 5 Nov '02, 10:14am

i did this is a second one
freshly downloaded from vb site last night

and tried the original templates that came with vb

Announcement

my cpu load is a nightmare 50

my cpu load is a nightmare 50

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment