server optimization help

[AllCdnBoy]

1. Dedicated Server
2.
- Duel Xeon 2.4
- 2 GB RAM
- 2 x 73 GB HD, IDE
- redhat enterprise w/ Ensim 3.7
- apache 2.0
- php 4.3.2 (in the process of upgrading to 4.3.10)
- mysql 4.0.18

3. innodb enabled
4. not sure where to find this - some help should maybe be posted in the sticky on what to include here

5. TOP:

23:10:34 up 79 days, 23:09, 2 users, load average: 4.49, 5.27, 4.29
267 processes: 264 sleeping, 3 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 22.5% 0.0% 2.7% 0.1% 0.3% 4.2% 69.9%
cpu00 25.0% 0.0% 3.7% 0.3% 0.5% 7.5% 62.6%
cpu01 16.0% 0.0% 2.1% 0.1% 0.1% 0.5% 80.7%
cpu02 27.0% 0.0% 2.5% 0.0% 0.1% 8.3% 61.8%
cpu03 21.8% 0.0% 2.3% 0.0% 0.3% 0.5% 74.7%
Mem: 2061552k av, 1880004k used, 181548k free, 0k shrd, 34372k buff
1207696k actv, 175388k in_d, 27032k in_c
Swap: 2048276k av, 82052k used, 1966224k free 868728k cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
846 apache 15 0 16016 15M 5000 S 1.7 0.7 0:02 1 httpd
2748 apache 15 0 16284 15M 5096 S 1.2 0.7 0:01 2 httpd
3449 apache 15 0 15412 14M 5056 S 1.2 0.7 0:00 1 httpd
757 apache 15 0 15356 14M 5160 S 1.0 0.7 0:01 2 httpd
915 apache 15 0 18528 17M 5632 S 1.0 0.8 0:02 0 httpd
2752 apache 15 0 15100 14M 5180 S 0.8 0.7 0:01 2 httpd
2830 apache 15 0 15952 15M 5160 S 0.8 0.7 0:01 0 httpd
32310 apache 15 0 16216 15M 5244 S 0.7 0.7 0:03 0 httpd
32690 apache 16 0 16256 15M 5208 S 0.7 0.7 0:14 3 httpd
3700 apache 15 0 14800 14M 4992 S 0.7 0.7 0:00 3 httpd
2754 apache 15 0 14920 14M 4988 S 0.6 0.7 0:00 0 httpd


6.
[mysqld]
socket=/home/virtual/FILESYSTEMTEMPLATE/.mysqlsock/mysql.sock
datadir=/var/lib/mysql
skip-locking
#skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=14400
connect_timeout=10
thread_cache_size=128
key_buffer=150M
join_buffer=1M
max_allowed_packet=16M
table_cache=1500
record_buffer=1M
sort_buffer_size=1M
read_buffer_size=1M
max_connect_errors=10
thread_concurrency=4
myisam_sort_buffer_size=64M
log-bin
server-id=1

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

[mysqldump]
quick
max_allowed_packet = 16M

[safe_mysqld]
open_files_limit = 8192
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
socket=/home/virtual/FILESYSTEMTEMPLATE/.mysqlsock/mysql.sock

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


7. sorry, but i just restarted mysql to enable innodb (but haven't changed any tables yet)

+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 0 |
| Aborted_connects | 1 |
| Bytes_received | 21874278 |
| Bytes_sent | 1425392373 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 7611 |
| 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 | 210 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 3128 |
| Com_insert_select | 30 |
| 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 | 225 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 25283 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 2 |
| Com_show_databases | 3 |
| Com_show_fields | 4 |
| Com_show_grants | 0 |
| Com_show_keys | 1 |
| 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 | 104 |
| Com_show_variables | 6 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 9105 |
| Connections | 7283 |
| Created_tmp_disk_tables | 23 |
| Created_tmp_tables | 1360 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 358 |
| Handler_read_first | 3804 |
| Handler_read_key | 899205 |
| Handler_read_next | 713352 |
| Handler_read_prev | 10546 |
| Handler_read_rnd | 263783 |
| Handler_read_rnd_next | 4700865 |
| Handler_rollback | 0 |
| Handler_update | 11668 |
| Handler_write | 81775 |
| Key_blocks_used | 19217 |
| Key_read_requests | 2260870 |
| Key_reads | 19164 |
| Key_write_requests | 6310 |
| Key_writes | 5691 |
| Max_used_connections | 44 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 1033 |
| Open_files | 1756 |
| Open_streams | 0 |
| Opened_tables | 1039 |
| Questions | 83249 |
| Qcache_queries_in_cache | 2816 |
| Qcache_inserts | 25005 |
| Qcache_hits | 30256 |
| Qcache_lowmem_prunes | 786 |
| Qcache_not_cached | 278 |
| Qcache_free_memory | 5008184 |
| Qcache_free_blocks | 1221 |
| Qcache_total_blocks | 8091 |
| Rpl_status | NULL |
| Select_full_join | 6 |
| Select_full_range_join | 19 |
| Select_range | 4516 |
| Select_range_check | 0 |
| Select_scan | 4973 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 8 |
| Sort_merge_passes | 0 |
| Sort_range | 4408 |
| Sort_rows | 3123589 |
| Sort_scan | 2224 |
| Table_locks_immediate | 74671 |
| Table_locks_waited | 401 |
| Threads_cached | 42 |
| Threads_created | 45 |
| Threads_connected | 3 |
| Threads_running | 1 |
| Uptime | 1244 |
+--------------------------+------------+


8. there are about 40 sites - 30 of them are vB

9. avg. 500, max 800 or 900 concurrent users - 900 seconds

10. http://www.abnehmen.com/ip.php

11.
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 15
StartServers 8
MinSpareServers 5
MaxSpareServers 20
MaxClients 150

12.
vB.303 & 305

[absolut]

Could you post here output of "ps -Afw" command? It is hard to realize what caused overload.

[AllCdnBoy]

ps -Awf:

UID PID PPID C STIME TTY TIME CMD
root 1 0 0 2004 ? 00:03:34 init [3]
root 2 0 0 2004 ? 00:00:00 [migration/0]
root 3 0 0 2004 ? 00:00:00 [migration/1]
root 4 0 0 2004 ? 00:00:00 [migration/2]
root 5 0 0 2004 ? 00:00:00 [migration/3]
root 6 1 0 2004 ? 00:00:00 [keventd]
root 7 1 0 2004 ? 00:00:00 [ksoftirqd/0]
root 8 1 0 2004 ? 00:00:00 [ksoftirqd/1]
root 9 1 0 2004 ? 00:00:00 [ksoftirqd/2]
root 10 1 0 2004 ? 00:00:00 [ksoftirqd/3]
root 13 1 0 2004 ? 00:00:14 [bdflush]
root 11 1 0 2004 ? 00:41:42 [kswapd]
root 12 1 0 2004 ? 00:38:13 [kscand]
root 14 1 0 2004 ? 00:27:29 [kupdated]
root 15 1 0 2004 ? 00:00:00 [mdrecoveryd]
root 24 1 0 2004 ? 02:22:09 [kjournald]
root 80 1 0 2004 ? 00:00:00 [khubd]
root 579 1 0 2004 ? 00:00:00 [kjournald]
root 1546 1 0 2004 ? 00:06:46 irqbalance
root 1612 1 0 2004 ttyS2 00:00:00 pppd call racser
racvnc 1684 1 0 2004 ? 00:00:01 racXvnc :1 -desktop Dell_Remote_Service -auth /var/racvnc/.Xauthority -geometry 1024
racvnc 1701 1 0 2004 ? 00:00:00 xterm -display :1 -geometry 80x24+10+10 -ls -bg white -fg black -title Dell_Remote_S
racvnc 1702 1 0 2004 ? 00:00:00 twm -display :1 -f /var/racvnc/rac.twmrc
root 1769 1 0 2004 ? 00:23:48 syslogd -m 0 -a /home/virtual/FILESYSTEMTEMPLATE/log-
racvnc 1773 1701 0 2004 pts/0 00:00:00 -bash
root 1906 1 0 2004 ? 00:00:12 klogd
root 1943 1 0 2004 ? 00:00:00 /usr/sbin/snmpd -s -l /dev/null -P /var/run/snmpd -a
root 2014 1 0 2004 ? 00:00:00 /usr/sbin/sshd
root 2025 1 0 2004 ? 00:00:00 sshd -f /etc/ssh/sshd-rb_config
root 2040 1 0 2004 ? 00:00:02 xinetd -stayalive -pidfile /var/run/xinetd.pid
clamav 2056 1 0 2004 ? 00:00:03 /usr/bin/freshclam -d --checks=24 --log=/var/log/clamav/clamav-update.log --on-updat
root 2367 1 0 2004 ? 00:00:04 /usr/bin/spamd -d -c -a
postgres 2646 1 0 2004 ? 00:01:27 /usr/bin/postmaster -p 5432
postgres 2648 2646 0 2004 ? 00:00:11 postgres: stats buffer process
postgres 2649 2648 0 2004 ? 00:00:38 postgres: stats collector process
root 2787 1 0 2004 ? 00:03:55 /usr/sbin/ocwhttpd -DSSL -d /usr/lib/opcenter -f fastcgi/httpd.conf
root 2835 1 0 2004 ? 00:03:36 /usr/bin/ensim-python /usr/lib/opcenter/ocwstart.pyc --fcgi --daemon
root 2853 1 0 2004 ? 01:01:24 /usr/sbin/bandwidth_manager
root 2863 1 0 2004 ? 00:00:12 crond
xfs 2889 1 0 2004 ? 00:00:00 xfs -droppriv -daemon
daemon 2898 1 0 2004 ? 00:00:02 /usr/sbin/atd
root 2908 1 0 2004 ? 00:00:01 /usr/sbin/saslauthd -m /var/run/saslauthd -a pam
root 2910 2908 0 2004 ? 00:00:01 /usr/sbin/saslauthd -m /var/run/saslauthd -a pam
root 2911 2908 0 2004 ? 00:00:01 /usr/sbin/saslauthd -m /var/run/saslauthd -a pam
root 2912 2908 0 2004 ? 00:00:01 /usr/sbin/saslauthd -m /var/run/saslauthd -a pam
root 2913 2908 0 2004 ? 00:00:01 /usr/sbin/saslauthd -m /var/run/saslauthd -a pam
root 2923 1 0 2004 ? 00:00:00 rhnsd --interval 240
root 2935 1 0 2004 ? 00:00:00 racsrvc -w5 -zAUTO
root 2953 1 0 2004 tty1 00:00:00 /sbin/mingetty tty1
root 2954 1 0 2004 tty2 00:00:00 /sbin/mingetty tty2
root 2955 1 0 2004 tty3 00:00:00 /sbin/mingetty tty3
root 2956 1 0 2004 tty4 00:00:00 /sbin/mingetty tty4
root 2957 1 0 2004 tty5 00:00:00 /sbin/mingetty tty5
root 2958 1 0 2004 tty6 00:00:00 /sbin/mingetty tty6
root 2959 1 0 2004 ttyS0 00:00:00 /sbin/agetty -L 9600 ttyS0 vt100
root 2967 2935 0 2004 ? 00:01:18 racsrvc -w5 -zAUTO
named 5144 1 0 2004 ? 00:01:52 named -u named
root 11807 1 0 2004 ? 00:00:25 proftpd: (accepting connections)
root 25839 11807 0 2004 ? 00:01:25 proftpd: (accepting connections)nobody 20119 2787 0 Jan01 ? 00:00:00 /usr/sbin/fcgi-pm -DSSL -d /usr/lib/opcenter -f fastcgi/httpd.conf
nobody 20120 2787 0 Jan01 ? 00:00:00 /usr/sbin/ocwhttpd -DSSL -d /usr/lib/opcenter -f fastcgi/httpd.conf
nobody 20121 2787 0 Jan01 ? 00:00:00 /usr/sbin/ocwhttpd -DSSL -d /usr/lib/opcenter -f fastcgi/httpd.conf
nobody 20122 2787 0 Jan01 ? 00:00:00 /usr/sbin/ocwhttpd -DSSL -d /usr/lib/opcenter -f fastcgi/httpd.conf
nobody 20123 2787 0 Jan01 ? 00:00:00 /usr/sbin/ocwhttpd -DSSL -d /usr/lib/opcenter -f fastcgi/httpd.conf
nobody 20124 2787 0 Jan01 ? 00:00:00 /usr/sbin/ocwhttpd -DSSL -d /usr/lib/opcenter -f fastcgi/httpd.conf
nobody 24631 2787 0 Jan01 ? 00:00:00 /usr/sbin/ocwhttpd -DSSL -d /usr/lib/opcenter -f fastcgi/httpd.conf
nobody 7528 2787 0 Jan01 ? 00:00:00 /usr/sbin/ocwhttpd -DSSL -d /usr/lib/opcenter -f fastcgi/httpd.conf
root 4952 1 0 Jan08 ? 00:00:14 sendmail: accepting connections
root 4960 1 0 Jan08 ? 00:00:00 sendmail: Queue runner@01:00:00 for /home/virtual/FILESYSTEMTEMPLATE/services/sendma
smmsp 4969 1 0 Jan08 ? 00:00:00 sendmail: Queue runner@01:00:00 for /var/spool/clientmqueue
root 5314 1 0 Jan08 ? 00:00:00 /usr/bin/perl -I/usr/lib/MailScanner /usr/sbin/MailScanner /etc/MailScanner/MailScan
nobody 16855 2787 0 Jan09 ? 00:00:00 /usr/sbin/ocwhttpd -DSSL -d /usr/lib/opcenter -f fastcgi/httpd.conf
root 18851 1 0 Jan09 ? 00:00:04 cupsd
root 2620 1 0 Jan09 ? 00:00:00 /bin/sh /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/
mysql 2669 2620 0 Jan09 ? 00:00:38 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ --datadir=/var/lib/mysql --
50 more of these

ntp 3554 1 0 04:44 ? 00:00:03 ntpd -U ntp -p /var/run/ntpd.pid
root 3950 1 0 04:45 ? 00:00:34 /usr/sbin/httpd -DSSL -DSSL.default -D mod_fastcgi_module -D product_wp_module -D vw
root 4701 3950 0 04:52 ? 00:01:32 /usr/local/bin/exclog /var/log/httpd/access_log
root 4711 3950 0 04:52 ? 00:00:00 /usr/sbin/httpd -DSSL -DSSL.default -D mod_fastcgi_module -D product_wp_module -D vw
mysql 5778 2679 0 13:57 ? 00:00:36 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ --datadir=/var/lib/mysql --
root 7221 5314 0 14:04 ? 00:00:23 /usr/bin/perl -I/usr/lib/MailScanner /usr/sbin/MailScanner /etc/MailScanner/MailScan
root 9138 5314 0 14:16 ? 00:00:26 /usr/bin/perl -I/usr/lib/MailScanner /usr/sbin/MailScanner /etc/MailScanner/MailScan
root 9344 5314 0 14:18 ? 00:00:23 /usr/bin/perl -I/usr/lib/MailScanner /usr/sbin/MailScanner /etc/MailScanner/MailScan
root 10702 5314 0 14:24 ? 00:00:24 /usr/bin/perl -I/usr/lib/MailScanner /usr/sbin/MailScanner /etc/MailScanner/MailScan
root 12578 5314 0 14:33 ? 00:00:23 /usr/bin/perl -I/usr/lib/MailScanner /usr/sbin/MailScanner /etc/MailScanner/MailScan
apache 2351 3950 0 16:30 ? 00:00:28 /usr/sbin/httpd -DSSL -DSSL.default -D mod_fastcgi_module -D product_wp_module -D vw
apache 2741 3950 0 16:33 ? 00:00:24 /usr/sbin/httpd -DSSL -DSSL.default -D mod_fastcgi_module -D product_wp_module -D vw
apache 4364 3950 0 16:40 ? 00:00:31 /usr/sbin/httpd -DSSL -DSSL.default -D mod_fastcgi_module -D product_wp_module -D vw
apache 4510 3950 0 16:41 ? 00:00:21 /usr/sbin/httpd -DSSL -DSSL.default -D mod_fastcgi_module -D product_wp_module -D vw
apache 4536 3950 1 16:41 ? 00:00:39 /usr/sbin/httpd -DSSL -DSSL.default -D mod_fastcgi_module -D product_wp_module -D vw
200 more of these (not exagerrating)

admin11 15729 2741 0 17:22 ? 00:00:00 /usr/bin/perl chat.pl
root 20916 9344 0 17:37 ? 00:00:00 /bin/sh /usr/lib/MailScanner/clamav-wrapper /usr/local -r --disable-summary --stdout
root 20917 20916 89 17:37 ? 00:00:00 /usr/bin/clamscan --unzip --unarj --unrar --tar --tgz --lha --unzip -r --disable-sum
admin25 20924 13299 1 17:37 ? 00:00:00 /bin/bash php-script
admin25 20925 20924 26 17:37 ? 00:00:00 /usr/bin/php
root 20926 20440 0 17:37 pts/1 00:00:00 ps -Afw
root 20928 4952 0 17:37 ? 00:00:00 sendmail: j0AGbZuu020928 localhost.localdomain [127.0.0.1]: DATA
root 20929 20661 0 17:37 ? 00:00:00 /usr/sbin/sendmail -q -ODeliveryMode=background -OQueueDirectory=/var/spool/mqueue.s



extended-status:

+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 6 |
| Aborted_connects | 5 |
| Bytes_received | 972057681 |
| Bytes_sent | 1140098631 |
| Com_admin_commands | 0 |
| Com_alter_table | 6 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 309223 |
| 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 | 2 |
| Com_delete | 10134 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 5 |
| Com_grant | 6 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 119285 |
| Com_insert_select | 1622 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 30 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 9193 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 1055683 |
| Com_set_option | 2140 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 2143 |
| Com_show_databases | 7 |
| Com_show_fields | 2161 |
| Com_show_grants | 0 |
| Com_show_keys | 3 |
| 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 | 5 |
| Com_show_innodb_status | 1 |
| Com_show_tables | 2477 |
| Com_show_variables | 9 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 30 |
| Com_update | 391139 |
| Connections | 308302 |
| Created_tmp_disk_tables | 1524 |
| Created_tmp_tables | 70106 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 2 |
| Handler_commit | 0 |
| Handler_delete | 68549 |
| Handler_read_first | 162398 |
| Handler_read_key | 52048063 |
| Handler_read_next | 38427649 |
| Handler_read_prev | 708174 |
| Handler_read_rnd | 17538341 |
| Handler_read_rnd_next | 218262866 |
| Handler_rollback | 1 |
| Handler_update | 583668 |
| Handler_write | 8916314 |
| Key_blocks_used | 146290 |
| Key_read_requests | 128689381 |
| Key_reads | 152250 |
| Key_write_requests | 432459 |
| Key_writes | 240624 |
| Max_used_connections | 66 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 1500 |
| Open_files | 2387 |
| Open_streams | 0 |
| Opened_tables | 5363 |
| Questions | 3598966 |
| Qcache_queries_in_cache | 2766 |
| Qcache_inserts | 1045542 |
| Qcache_hits | 1385392 |
| Qcache_lowmem_prunes | 87794 |
| Qcache_not_cached | 10168 |
| Qcache_free_memory | 6664280 |
| Qcache_free_blocks | 2016 |
| Qcache_total_blocks | 9805 |
| Rpl_status | NULL |
| Select_full_join | 693 |
| Select_full_range_join | 273 |
| Select_range | 184617 |
| Select_range_check | 0 |
| Select_scan | 215248 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 105 |
| Sort_merge_passes | 0 |
| Sort_range | 182476 |
| Sort_rows | 113122148 |
| Sort_scan | 102023 |
| Table_locks_immediate | 3111027 |
| Table_locks_waited | 7835 |
| Threads_cached | 50 |
| Threads_created | 67 |
| Threads_connected | 17 |
| Threads_running | 1 |
| Uptime | 67193 |
+--------------------------+------------+


and this is currently what is going on in the forums:
forum -- current users online -- number of posts
deejayforum.de - 102 - 175,000
125er-forum.de - 39 - 176,000
workout.de - 111 - 43,000
spielen.com - 131 - 73,000
reitforum.de - 142 - 121,000
ketose.com - 25 - 16,000
abnehmen.com - 276 - 335,000

another 75 users between all the other forums

[AllCdnBoy]

should i be posting this somewhere else ... or is there just too much info here for someone to look at (i know how that feels)?? I would really like some help and I'm not above begging...

[AllCdnBoy]

i guess i'm on the wrong place to ask for help ... not to be rude (ok, maybe a little), but i hope these moderators aren't getting paid to post on here, because i'd hate to think that the money i spent with all these forums is being wasted

[orban]

73GB IDE? Isn't 73 always SCSI?

[Zachery]

I've found that most of SCSI Disks are the actual GB refrence, instead of what most manufactures tell us there is.

[Steve Machol]

i guess i'm on the wrong place to ask for help ... not to be rude (ok, maybe a little), but i hope these moderators aren't getting paid to post on here, because i'd hate to think that the money i spent with all these forums is being wasted
Please note that we do this as a courtesy but optimizing servers is not really a part of vBulletin support. The main person who does this is eva2000 and he is not online everyday. I'm afraid you'll just need to be patient.

[eva2000]

i guess i'm on the wrong place to ask for help ... not to be rude (ok, maybe a little), but i hope these moderators aren't getting paid to post on here, because i'd hate to think that the money i spent with all these forums is being wasted
sorry for the delays

I need some clarification, do you use innodb databases at all, or just enabled innodb anyway when you don't use innodb databases ? If you don't use innodb database tables I'd disable them.

Other suggestions

1. if innodb isn't used try this new my.cnf which disables innodb as well as the cpu/server resource hog of mysql binary logging


[client]
socket=/home/virtual/FILESYSTEMTEMPLATE/.mysqlsock/mysql.sock

[mysqld]
socket=/home/virtual/FILESYSTEMTEMPLATE/.mysqlsock/mysql.sock
datadir=/var/lib/mysql
skip-locking
skip-innodb
max_connections = 650
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 64
wait_timeout = 10800
connect_timeout = 10
tmp_table_size = 32M
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1

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

[mysqldump]
quick
max_allowed_packet = 16M

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

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




restart mysql server afterwards

2. also 500-900 users over 900 s cookie timeout is an activity level that normally does demand much more powerful hardware - in fact it's probably requiring 2x dual cpu servers to split web and database serving functions but i'll see what the first suggestion above does for you.

3. ensure that you have latest MySQL 4.0.23 and PHP 4.3.10 installed and seeing as you have many forums and sites using php you may want to install Turck Mmache as well http://www.vbulletin.com/forum/showthread.php?t=75878

4. If you're dead set on only 1x server for now, I'd probably recommend at least Dual P4 3.06GHZ Xeon with 4GB of ram and separate SCSI disks for web/OS and mysql data partition. With extra 4GB of ram I'd probably need to recommend a revised my.cnf to better allocate more memory to mysql memory buffers. But that MAY only delay the need for 2x dual cpu servers - but I'd wait to see outcome of first suggestion :)

5. some folks have found performance boost by recompiling and updating to latest stable smp 2.6.x linux kernel also

[AllCdnBoy]

sorry for being rude, but the server load was sitting above 30 during the high parts of the day and i really, really, really needed the help.

I enabled innodb because i read that it was faster, so i was going to change some of the tables ... is that not a good idea?

I've made the changes and i'm crossing my fingers. I've also passed along the suggestion to get a second server to the financial department (my client ;)) ... he makes enough money that it'll probably be our route. I'll update you on how the changes took.

I have Zend optimizer installed instead Mmcache ...

THanks so much for the help.

[eva2000]

stick with MyISAM tables for now instead of Innodb until you see how the above recommended changes affect your loads