vissa
Thu 13th Jan '05, 11:15pm
1. Owned server with about 13 sites (3 VBs). 1 interactive "moodle" site with light traffic, and the others are static with light to moderate usage.
2. Dual Xeon 2.4 (hyperthreading on)
4GB RAM
3 70GB SCSI Hard Drives in Raid 5 Configuration
RHE with Cpanel/WHM
Apache 1.3.33
PHP 4.3.10
MYSQL 4.0.22-standard
Kernel: 2.4.21-4.0.1.ELsmp
3. innodb type databases/table
Don't know / don't think so
4. unknown install method of mysql
5.
18:31:55 up 3 days, 1:37, 1 user, load average: 1.67, 1.23, 0.88
130 processes: 129 sleeping, 1 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 14.2% 0.0% 1.9% 0.0% 0.0% 0.0% 83.8%
cpu00 15.6% 0.0% 1.9% 0.0% 0.0% 0.0% 82.3%
cpu01 8.8% 0.0% 2.9% 0.0% 0.0% 0.0% 88.2%
cpu02 11.7% 0.0% 0.9% 0.0% 0.0% 0.0% 87.2%
cpu03 20.5% 0.0% 1.9% 0.0% 0.0% 0.0% 77.4%
Mem: 4063324k av, 4022188k used, 41136k free, 0k shrd, 157972k buff
1104052k actv, 4k in_d, 69412k in_c
Swap: 2048276k av, 0k used, 2048276k free 3115240k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
7398 nobody 15 0 8708 8708 3904 S 4.1 0.2 0:05 1 httpd
7911 nobody 16 0 8116 8116 3884 S 3.9 0.1 0:00 0 httpd
816 nobody 16 0 11128 10M 4176 S 3.4 0.2 7:04 2 httpd
7909 nobody 16 0 8904 8904 3904 S 2.2 0.2 0:02 1 httpd
2627 mysql 16 0 99200 96M 1612 S 0.9 2.4 3:35 1 mysqld
2218 mysql 15 0 99200 96M 1612 S 0.4 2.4 4:26 3 mysqld
30189 mysql 15 0 99200 96M 1612 S 0.4 2.4 2:41 1 mysqld
1395 mailman 16 0 4684 4684 1844 S 0.2 0.1 0:23 0 python2
7954 root 20 0 1156 1156 892 R 0.2 0.0 0:00 1 top
1 root 15 0 500 500 448 S 0.0 0.0 0:07 0 init
2 root RT 0 0 0 0 SW 0.0 0.0 0:00 0 migration/0
3 root RT 0 0 0 0 SW 0.0 0.0 0:00 1 migration/1
4 root RT 0 0 0 0 SW 0.0 0.0 0:00 2 migration/2
5 root RT 0 0 0 0 SW 0.0 0.0 0:00 3 migration/3
6 root 15 0 0 0 0 SW 0.0 0.0 0:00 2 keventd
7 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0 ksoftirqd/0
8 root 34 19 0 0 0 SWN 0.0 0.0 0:00 1 ksoftirqd/1
9 root 34 19 0 0 0 SWN 0.0 0.0 0:00 2 ksoftirqd/2
10 root 34 19 0 0 0 SWN 0.0 0.0 0:00 3 ksoftirqd/3
13 root 15 0 0 0 0 SW 0.0 0.0 0:00 3 bdflush
11 root 15 0 0 0 0 SW 0.0 0.0 0:05 3 kswapd
12 root 15 0 0 0 0 SW 0.0 0.0 0:03 3 kscand
14 root 15 0 0 0 0 SW 0.0 0.0 0:23 0 kupdated
15 root 25 0 0 0 0 SW 0.0 0.0 0:00 2 mdrecoveryd
25 root 15 0 0 0 0 SW 0.0 0.0 1:34 3 kjournald
80 root 25 0 0 0 0 SW 0.0 0.0 0:00 2 khubd
383 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
1162 root 15 0 572 572 492 S 0.0 0.0 0:05 0 syslogd
1166 root 15 0 472 472 408 S 0.0 0.0 0:01 1 klogd
1176 root 15 0 448 448 388 S 0.0 0.0 0:13 3 irqbalance
1239 nobody 15 0 2312 2312 1632 S 0.0 0.0 0:02 0 proftpd
1249 root 16 0 1560 1560 1316 S 0.0 0.0 0:03 1 sshd
1263 root 16 0 928 928 804 S 0.0 0.0 0:00 2 xinetd
1288 root 19 0 2724 2724 1420 S 0.0 0.0 0:05 0 chkservd
1403 root 15 0 4508 4508 3252 S 0.0 0.1 0:44 3 httpd
1424 root 15 0 648 648 556 S 0.0 0.0 0:00 1 crond
1483 root 25 0 1160 1160 1020 S 0.0 0.0 0:00 2 mysqld_safe
1525 mysql 15 0 99200 96M 1612 S 0.0 2.4 0:21 0 mysqld
1671 mysql 15 0 99200 96M 1612 S 0.0 2.4 0:02 1 mysqld
1672 mysql 15 0 99200 96M 1612 S 0.0 2.4 0:09 3 mysqld
1681 mysql 15 0 99200 96M 1612 S 0.0 2.4 4:04 1 mysqld
1682 mysql 15 0 99200 96M 1612 S 0.0 2.4 3:39 3 mysqld
1736 mysql 15 0 99200 96M 1612 S 0.0 2.4 3:41 0 mysqld
1768 mysql 15 0 99200 96M 1612 S 0.0 2.4 4:18 2 mysqld
1791 mysql 15 0 99200 96M 1612 S 0.0 2.4 3:51 2 mysqld
6.
[mysqld]
skip-innodb
max_connections = 650
key_buffer = 64M
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 = 1800
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 2M
query_cache_size = 64M
query_cache_type = 1
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
7.
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 270 |
| Aborted_connects | 28 |
| Bytes_received | 880262651 |
| Bytes_sent | 1129413129 |
| Com_admin_commands | 519 |
| Com_alter_table | 27 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 3 |
| Com_change_db | 202715 |
| Com_change_master | 0 |
| Com_check | 88 |
| Com_commit | 3 |
| Com_create_db | 5 |
| Com_create_function | 0 |
| Com_create_index | 22 |
| Com_create_table | 26 |
| Com_delete | 13762 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 14 |
| Com_grant | 27 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 103761 |
| Com_insert_select | 1321 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 4492 |
| Com_optimize | 94 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 20676 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 967980 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 13 |
| Com_show_fields | 346 |
| Com_show_grants | 0 |
| Com_show_keys | 2 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 888 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 2 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 204 |
| Com_show_variables | 5 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 4492 |
| Com_update | 384141 |
| Connections | 205186 |
| Created_tmp_disk_tables | 2763 |
| Created_tmp_tables | 42442 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 40733 |
| Handler_read_first | 218833 |
| Handler_read_key | 326039526 |
| Handler_read_next | 230120851 |
| Handler_read_prev | 615557 |
| Handler_read_rnd | 5246169 |
| Handler_read_rnd_next | 116641781 |
| Handler_rollback | 0 |
| Handler_update | 132536281 |
| Handler_write | 6107464 |
| Key_blocks_used | 56325 |
| Key_read_requests | 491068207 |
| Key_reads | 47362 |
| Key_write_requests | 814883 |
| Key_writes | 287308 |
| Max_used_connections | 26 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 474 |
| Open_files | 789 |
| Open_streams | 0 |
| Opened_tables | 715 |
| Questions | 2890322 |
| Qcache_queries_in_cache | 5441 |
| Qcache_inserts | 966694 |
| Qcache_hits | 979992 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 1240 |
| Qcache_free_memory | 47569192 |
| Qcache_free_blocks | 2556 |
| Qcache_total_blocks | 14069 |
| Rpl_status | NULL |
| Select_full_join | 153 |
| Select_full_range_join | 0 |
| Select_range | 200769 |
| Select_range_check | 0 |
| Select_scan | 119745 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 6 |
| Sort_merge_passes | 0 |
| Sort_range | 155012 |
| Sort_rows | 10999305 |
| Sort_scan | 64399 |
| Table_locks_immediate | 3131645 |
| Table_locks_waited | 2421 |
| Threads_cached | 24 |
| Threads_created | 27 |
| Threads_connected | 3 |
| Threads_running | 1 |
| Uptime | 266362 |
+--------------------------+------------+
8. There are 3 VBs on this server and there is a "moodle" mysql/php program running with light access.
9. (all 3 forums on same server) - Top forum: Max online = 219, average = about 40-60, Second forum: Max online = 183, average = about 14, Third forum: Max = 94, Average about 4
Cookie timeout = 900 for all sites
10. http://www.horsegroomingsupplies.com/zzz/phpinfo.php
11.
KeepAlive = On
MaxKeepAliveRequests = 100
KeepAliveTimeout = 15
MinSpareServers = 5
MaxSpareServers = 10
StartServers = 5
MaxClients = 150
12. vb 3.03 (with the updated init.php file)
2. Dual Xeon 2.4 (hyperthreading on)
4GB RAM
3 70GB SCSI Hard Drives in Raid 5 Configuration
RHE with Cpanel/WHM
Apache 1.3.33
PHP 4.3.10
MYSQL 4.0.22-standard
Kernel: 2.4.21-4.0.1.ELsmp
3. innodb type databases/table
Don't know / don't think so
4. unknown install method of mysql
5.
18:31:55 up 3 days, 1:37, 1 user, load average: 1.67, 1.23, 0.88
130 processes: 129 sleeping, 1 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 14.2% 0.0% 1.9% 0.0% 0.0% 0.0% 83.8%
cpu00 15.6% 0.0% 1.9% 0.0% 0.0% 0.0% 82.3%
cpu01 8.8% 0.0% 2.9% 0.0% 0.0% 0.0% 88.2%
cpu02 11.7% 0.0% 0.9% 0.0% 0.0% 0.0% 87.2%
cpu03 20.5% 0.0% 1.9% 0.0% 0.0% 0.0% 77.4%
Mem: 4063324k av, 4022188k used, 41136k free, 0k shrd, 157972k buff
1104052k actv, 4k in_d, 69412k in_c
Swap: 2048276k av, 0k used, 2048276k free 3115240k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
7398 nobody 15 0 8708 8708 3904 S 4.1 0.2 0:05 1 httpd
7911 nobody 16 0 8116 8116 3884 S 3.9 0.1 0:00 0 httpd
816 nobody 16 0 11128 10M 4176 S 3.4 0.2 7:04 2 httpd
7909 nobody 16 0 8904 8904 3904 S 2.2 0.2 0:02 1 httpd
2627 mysql 16 0 99200 96M 1612 S 0.9 2.4 3:35 1 mysqld
2218 mysql 15 0 99200 96M 1612 S 0.4 2.4 4:26 3 mysqld
30189 mysql 15 0 99200 96M 1612 S 0.4 2.4 2:41 1 mysqld
1395 mailman 16 0 4684 4684 1844 S 0.2 0.1 0:23 0 python2
7954 root 20 0 1156 1156 892 R 0.2 0.0 0:00 1 top
1 root 15 0 500 500 448 S 0.0 0.0 0:07 0 init
2 root RT 0 0 0 0 SW 0.0 0.0 0:00 0 migration/0
3 root RT 0 0 0 0 SW 0.0 0.0 0:00 1 migration/1
4 root RT 0 0 0 0 SW 0.0 0.0 0:00 2 migration/2
5 root RT 0 0 0 0 SW 0.0 0.0 0:00 3 migration/3
6 root 15 0 0 0 0 SW 0.0 0.0 0:00 2 keventd
7 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0 ksoftirqd/0
8 root 34 19 0 0 0 SWN 0.0 0.0 0:00 1 ksoftirqd/1
9 root 34 19 0 0 0 SWN 0.0 0.0 0:00 2 ksoftirqd/2
10 root 34 19 0 0 0 SWN 0.0 0.0 0:00 3 ksoftirqd/3
13 root 15 0 0 0 0 SW 0.0 0.0 0:00 3 bdflush
11 root 15 0 0 0 0 SW 0.0 0.0 0:05 3 kswapd
12 root 15 0 0 0 0 SW 0.0 0.0 0:03 3 kscand
14 root 15 0 0 0 0 SW 0.0 0.0 0:23 0 kupdated
15 root 25 0 0 0 0 SW 0.0 0.0 0:00 2 mdrecoveryd
25 root 15 0 0 0 0 SW 0.0 0.0 1:34 3 kjournald
80 root 25 0 0 0 0 SW 0.0 0.0 0:00 2 khubd
383 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
1162 root 15 0 572 572 492 S 0.0 0.0 0:05 0 syslogd
1166 root 15 0 472 472 408 S 0.0 0.0 0:01 1 klogd
1176 root 15 0 448 448 388 S 0.0 0.0 0:13 3 irqbalance
1239 nobody 15 0 2312 2312 1632 S 0.0 0.0 0:02 0 proftpd
1249 root 16 0 1560 1560 1316 S 0.0 0.0 0:03 1 sshd
1263 root 16 0 928 928 804 S 0.0 0.0 0:00 2 xinetd
1288 root 19 0 2724 2724 1420 S 0.0 0.0 0:05 0 chkservd
1403 root 15 0 4508 4508 3252 S 0.0 0.1 0:44 3 httpd
1424 root 15 0 648 648 556 S 0.0 0.0 0:00 1 crond
1483 root 25 0 1160 1160 1020 S 0.0 0.0 0:00 2 mysqld_safe
1525 mysql 15 0 99200 96M 1612 S 0.0 2.4 0:21 0 mysqld
1671 mysql 15 0 99200 96M 1612 S 0.0 2.4 0:02 1 mysqld
1672 mysql 15 0 99200 96M 1612 S 0.0 2.4 0:09 3 mysqld
1681 mysql 15 0 99200 96M 1612 S 0.0 2.4 4:04 1 mysqld
1682 mysql 15 0 99200 96M 1612 S 0.0 2.4 3:39 3 mysqld
1736 mysql 15 0 99200 96M 1612 S 0.0 2.4 3:41 0 mysqld
1768 mysql 15 0 99200 96M 1612 S 0.0 2.4 4:18 2 mysqld
1791 mysql 15 0 99200 96M 1612 S 0.0 2.4 3:51 2 mysqld
6.
[mysqld]
skip-innodb
max_connections = 650
key_buffer = 64M
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 = 1800
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 2M
query_cache_size = 64M
query_cache_type = 1
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
7.
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 270 |
| Aborted_connects | 28 |
| Bytes_received | 880262651 |
| Bytes_sent | 1129413129 |
| Com_admin_commands | 519 |
| Com_alter_table | 27 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 3 |
| Com_change_db | 202715 |
| Com_change_master | 0 |
| Com_check | 88 |
| Com_commit | 3 |
| Com_create_db | 5 |
| Com_create_function | 0 |
| Com_create_index | 22 |
| Com_create_table | 26 |
| Com_delete | 13762 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 14 |
| Com_grant | 27 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 103761 |
| Com_insert_select | 1321 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 4492 |
| Com_optimize | 94 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 20676 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 967980 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 13 |
| Com_show_fields | 346 |
| Com_show_grants | 0 |
| Com_show_keys | 2 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 888 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 2 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 204 |
| Com_show_variables | 5 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 4492 |
| Com_update | 384141 |
| Connections | 205186 |
| Created_tmp_disk_tables | 2763 |
| Created_tmp_tables | 42442 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 40733 |
| Handler_read_first | 218833 |
| Handler_read_key | 326039526 |
| Handler_read_next | 230120851 |
| Handler_read_prev | 615557 |
| Handler_read_rnd | 5246169 |
| Handler_read_rnd_next | 116641781 |
| Handler_rollback | 0 |
| Handler_update | 132536281 |
| Handler_write | 6107464 |
| Key_blocks_used | 56325 |
| Key_read_requests | 491068207 |
| Key_reads | 47362 |
| Key_write_requests | 814883 |
| Key_writes | 287308 |
| Max_used_connections | 26 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 474 |
| Open_files | 789 |
| Open_streams | 0 |
| Opened_tables | 715 |
| Questions | 2890322 |
| Qcache_queries_in_cache | 5441 |
| Qcache_inserts | 966694 |
| Qcache_hits | 979992 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 1240 |
| Qcache_free_memory | 47569192 |
| Qcache_free_blocks | 2556 |
| Qcache_total_blocks | 14069 |
| Rpl_status | NULL |
| Select_full_join | 153 |
| Select_full_range_join | 0 |
| Select_range | 200769 |
| Select_range_check | 0 |
| Select_scan | 119745 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 6 |
| Sort_merge_passes | 0 |
| Sort_range | 155012 |
| Sort_rows | 10999305 |
| Sort_scan | 64399 |
| Table_locks_immediate | 3131645 |
| Table_locks_waited | 2421 |
| Threads_cached | 24 |
| Threads_created | 27 |
| Threads_connected | 3 |
| Threads_running | 1 |
| Uptime | 266362 |
+--------------------------+------------+
8. There are 3 VBs on this server and there is a "moodle" mysql/php program running with light access.
9. (all 3 forums on same server) - Top forum: Max online = 219, average = about 40-60, Second forum: Max online = 183, average = about 14, Third forum: Max = 94, Average about 4
Cookie timeout = 900 for all sites
10. http://www.horsegroomingsupplies.com/zzz/phpinfo.php
11.
KeepAlive = On
MaxKeepAliveRequests = 100
KeepAliveTimeout = 15
MinSpareServers = 5
MaxSpareServers = 10
StartServers = 5
MaxClients = 150
12. vb 3.03 (with the updated init.php file)