spinaltoad
Thu 18th Mar '04, 9:38pm
I have a dedicated server.
P4 2.8 gig with 1gig ram.
4x80 gig western digital with 8 meg buffers
Adaptec 2400 ide raid card with 128megs cache
Raid 10
FreeBSD 4.9
mysql-client-4.0.18_1 with linux threads
php4-4.3.4_6
I installed it according to the howto I wrote at http://www.bsdforums.com/forums/showthread.php?threadid=18868
Top Stats
last pid: 20935; load averages: 0.97, 0.93, 1.04 up 13+03:39:25 19:28:19
396 processes: 3 running, 393 sleeping
CPU states: 46.9% user, 5.1% nice, 13.7% system, 0.7% interrupt, 33.6% idle
Mem: 619M Active, 117M Inact, 219M Wired, 35M Cache, 112M Buf, 12M Free
Swap: 2031M Total, 230M Used, 1801M Free, 11% Inuse, 176K In
PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND
18693 mysql 18 14 279M 45608K pause 7:23 1.76% 1.76% mysqld
20273 www 2 0 32984K 18112K accept 0:04 1.51% 1.51% httpd
20935 root 32 0 2372K 1024K RUN 0:01 4.04% 1.46% top
20928 www 2 0 21496K 6880K sbwait 0:01 2.10% 1.37% httpd
19612 www 2 0 32992K 17896K sbwait 0:06 0.93% 0.93% httpd
94013 mysql 18 14 279M 45608K pause 3:43 0.88% 0.88% mysqld
20864 www 2 0 32216K 17548K sbwait 0:01 0.90% 0.88% httpd
20443 www 2 0 21436K 6784K sbwait 0:02 0.83% 0.83% httpd
20831 www 2 0 21380K 6772K sbwait 0:01 0.78% 0.78% httpd
93907 mysql 18 14 279M 45608K pause 3:51 0.68% 0.68% mysqld
20867 www 2 0 20924K 6252K sbwait 0:00 0.65% 0.63% httpd
20052 www 2 0 32920K 9088K sbwait 0:04 0.49% 0.49% httpd
20877 www 2 0 21992K 7396K sbwait 0:00 0.50% 0.49% httpd
3365 mysql 18 14 279M 45608K pause 7:51 0.44% 0.44% mysqld
49832 mysql 18 14 279M 45608K pause 3:15 0.44% 0.44% mysqld
20157 www 2 0 21420K 5260K sbwait 0:03 0.44% 0.44% httpd
20852 www 2 0 21408K 6756K select 0:00 0.45% 0.44% httpd
49891 mysql 18 14 279M 45608K pause 3:16 0.39% 0.39% mysqld
19925 www 2 0 32372K 17092K sbwait 0:02 0.34% 0.34% httpd
20860 www 2 0 32972K 18464K accept 0:01 0.35% 0.34% httpd
20910 www 2 0 21396K 6776K accept 0:00 0.41% 0.34% httpd
20924 www 2 0 21340K 6728K sbwait 0:00 0.53% 0.34% httpd
19957 www 2 0 42660K 18284K accept 0:07 0.29% 0.29% httpd
20861 www 2 0 22120K 7428K sbwait 0:00 0.30% 0.29% httpd
20842 www 2 0 21040K 6424K sbwait 0:00 0.30% 0.29% httpd
20830 www 2 0 21384K 6724K sbwait 0:00 0.29% 0.29% httpd
49816 mysql 18 14 279M 45608K pause 3:23 0.24% 0.24% mysqld
20644 www 2 0 21432K 6768K sbwait 0:01 0.24% 0.24% httpd
20925 www 2 0 21956K 7368K sbwait 0:00 0.38% 0.24% httpd
20849 www 2 0 21456K 6792K sbwait 0:01 0.20% 0.20% httpd
20919 www 2 0 20996K 6364K sbwait 0:00 0.29% 0.20% httpd
20858 www 2 0 21996K 7380K sbwait 0:00 0.15% 0.15% httpd
93891 mysql 18 14 279M 45608K pause 4:06 0.10% 0.10% mysqld
93941 mysql 18 14 279M 45608K pause 4:02 0.10% 0.10% mysqld
20326 www 2 0 32972K 8804K sbwait 0:03 0.10% 0.10% httpd
20917 www 2 0 20916K 6248K sbwait 0:00 0.14% 0.10% httpd
20907 www 2 0 21412K 6788K sbwait 0:00 0.12% 0.10% httpd
3375 mysql 18 14 279M 45608K pause 7:41 0.05% 0.05% mysqld
49823 mysql 18 14 279M 45608K pause 3:28 0.05% 0.05% mysqld
/etc/my.cnf
[mysqld]
socket=/tmp/mysql.sock
set-variable = max_connections=400
set-variable = key_buffer=128M
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=100
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
skip-innodb
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1M
[safe_mysqld]
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
mysqladmin -u root -p extended-status
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 9659 |
| Aborted_connects | 265 |
| Bytes_received | 3789187499 |
| Bytes_sent | 2965110031 |
| Com_admin_commands | 1249 |
| Com_alter_table | 7 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 109914 |
| Com_change_db | 6033150 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 89660 |
| Com_create_db | 4 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 1625 |
| Com_delete | 411834 |
| Com_delete_multi | 0 |
| Com_drop_db | 2 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 1510 |
| Com_flush | 3 |
| Com_grant | 2 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 212003 |
| Com_insert_select | 6224 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 36240 |
| Com_optimize | 138 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 337489 |
| Com_replace_select | 107 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 22107 |
| Com_savepoint | 0 |
| Com_select | 90879493 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 2 |
| Com_show_fields | 12 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| 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 | 13 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 9 |
| Com_show_variables | 3 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 2 |
| Com_unlock_tables | 37222 |
| Com_update | 5690307 |
| Connections | 5763630 |
| Created_tmp_disk_tables | 3262 |
| Created_tmp_tables | 1395848 |
| Created_tmp_files | 8 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 13898 |
| Delayed_errors | 7 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 263581 |
| Handler_read_first | 1958921 |
| Handler_read_key | 883397504 |
| Handler_read_next | 1085608877 |
| Handler_read_prev | 11038356 |
| Handler_read_rnd | 1197074054 |
| Handler_read_rnd_next | 4243939255 |
| Handler_rollback | 0 |
| Handler_update | 374207341 |
| Handler_write | 113347183 |
| Key_blocks_used | 124690 |
| Key_read_requests | 1806026661 |
| Key_reads | 335045 |
| Key_write_requests | 2233730 |
| Key_writes | 1622931 |
| Max_used_connections | 317 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 1024 |
| Open_files | 1174 |
| Open_streams | 0 |
| Opened_tables | 6682 |
| Questions | 109626679 |
| Qcache_queries_in_cache | 0 |
| Qcache_inserts | 0 |
| Qcache_hits | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 90879487 |
| Qcache_free_memory | 33545616 |
| Qcache_free_blocks | 1 |
| Qcache_total_blocks | 1 |
| Rpl_status | NULL |
| Select_full_join | 324556 |
| Select_full_range_join | 0 |
| Select_range | 15685979 |
| Select_range_check | 0 |
| Select_scan | 9500492 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 1 |
| Slow_queries | 5314 |
| Sort_merge_passes | 4 |
| Sort_range | 7334665 |
| Sort_rows | 1202471809 |
| Sort_scan | 5143271 |
| Table_locks_immediate | 105822333 |
| Table_locks_waited | 121977 |
| Threads_cached | 255 |
| Threads_created | 320 |
| Threads_connected | 1 |
| Threads_running | 1 |
| Uptime | 1136515 |
+--------------------------+------------+
Here are the live statistics
http://www.clublexus.com/forums/test.php
http://www.clublexus.com/phpinfo.php
vbulletin 2.2.9
We are also running phpadsnew, photopost, and ezpublisher on the same server. Currently ezpublisher, photopost, and vbuleltin share the same database because that's how the last design team made it. We will be seperating the databases in the future. Currently we cannot update vbulletin to the latest version becase all the hacks are undocumented.
We usually get an average of of 150 users off peak 210 users peak. Max will be around 300, or 450 when a new car model comes out.
httpd.conf
KeepAlive On
MaxKeepAliveRequests 1000
KeepAliveTimeout 15
MinSpareServers 10
MaxSpareServers 10
StartServers 500
MaxClients 500
oh, the site is not sluggish. I'm just a speed deamon.
I just rebuilt this machine 2 weeks agoe :-D.
P4 2.8 gig with 1gig ram.
4x80 gig western digital with 8 meg buffers
Adaptec 2400 ide raid card with 128megs cache
Raid 10
FreeBSD 4.9
mysql-client-4.0.18_1 with linux threads
php4-4.3.4_6
I installed it according to the howto I wrote at http://www.bsdforums.com/forums/showthread.php?threadid=18868
Top Stats
last pid: 20935; load averages: 0.97, 0.93, 1.04 up 13+03:39:25 19:28:19
396 processes: 3 running, 393 sleeping
CPU states: 46.9% user, 5.1% nice, 13.7% system, 0.7% interrupt, 33.6% idle
Mem: 619M Active, 117M Inact, 219M Wired, 35M Cache, 112M Buf, 12M Free
Swap: 2031M Total, 230M Used, 1801M Free, 11% Inuse, 176K In
PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND
18693 mysql 18 14 279M 45608K pause 7:23 1.76% 1.76% mysqld
20273 www 2 0 32984K 18112K accept 0:04 1.51% 1.51% httpd
20935 root 32 0 2372K 1024K RUN 0:01 4.04% 1.46% top
20928 www 2 0 21496K 6880K sbwait 0:01 2.10% 1.37% httpd
19612 www 2 0 32992K 17896K sbwait 0:06 0.93% 0.93% httpd
94013 mysql 18 14 279M 45608K pause 3:43 0.88% 0.88% mysqld
20864 www 2 0 32216K 17548K sbwait 0:01 0.90% 0.88% httpd
20443 www 2 0 21436K 6784K sbwait 0:02 0.83% 0.83% httpd
20831 www 2 0 21380K 6772K sbwait 0:01 0.78% 0.78% httpd
93907 mysql 18 14 279M 45608K pause 3:51 0.68% 0.68% mysqld
20867 www 2 0 20924K 6252K sbwait 0:00 0.65% 0.63% httpd
20052 www 2 0 32920K 9088K sbwait 0:04 0.49% 0.49% httpd
20877 www 2 0 21992K 7396K sbwait 0:00 0.50% 0.49% httpd
3365 mysql 18 14 279M 45608K pause 7:51 0.44% 0.44% mysqld
49832 mysql 18 14 279M 45608K pause 3:15 0.44% 0.44% mysqld
20157 www 2 0 21420K 5260K sbwait 0:03 0.44% 0.44% httpd
20852 www 2 0 21408K 6756K select 0:00 0.45% 0.44% httpd
49891 mysql 18 14 279M 45608K pause 3:16 0.39% 0.39% mysqld
19925 www 2 0 32372K 17092K sbwait 0:02 0.34% 0.34% httpd
20860 www 2 0 32972K 18464K accept 0:01 0.35% 0.34% httpd
20910 www 2 0 21396K 6776K accept 0:00 0.41% 0.34% httpd
20924 www 2 0 21340K 6728K sbwait 0:00 0.53% 0.34% httpd
19957 www 2 0 42660K 18284K accept 0:07 0.29% 0.29% httpd
20861 www 2 0 22120K 7428K sbwait 0:00 0.30% 0.29% httpd
20842 www 2 0 21040K 6424K sbwait 0:00 0.30% 0.29% httpd
20830 www 2 0 21384K 6724K sbwait 0:00 0.29% 0.29% httpd
49816 mysql 18 14 279M 45608K pause 3:23 0.24% 0.24% mysqld
20644 www 2 0 21432K 6768K sbwait 0:01 0.24% 0.24% httpd
20925 www 2 0 21956K 7368K sbwait 0:00 0.38% 0.24% httpd
20849 www 2 0 21456K 6792K sbwait 0:01 0.20% 0.20% httpd
20919 www 2 0 20996K 6364K sbwait 0:00 0.29% 0.20% httpd
20858 www 2 0 21996K 7380K sbwait 0:00 0.15% 0.15% httpd
93891 mysql 18 14 279M 45608K pause 4:06 0.10% 0.10% mysqld
93941 mysql 18 14 279M 45608K pause 4:02 0.10% 0.10% mysqld
20326 www 2 0 32972K 8804K sbwait 0:03 0.10% 0.10% httpd
20917 www 2 0 20916K 6248K sbwait 0:00 0.14% 0.10% httpd
20907 www 2 0 21412K 6788K sbwait 0:00 0.12% 0.10% httpd
3375 mysql 18 14 279M 45608K pause 7:41 0.05% 0.05% mysqld
49823 mysql 18 14 279M 45608K pause 3:28 0.05% 0.05% mysqld
/etc/my.cnf
[mysqld]
socket=/tmp/mysql.sock
set-variable = max_connections=400
set-variable = key_buffer=128M
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=100
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
skip-innodb
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1M
[safe_mysqld]
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
mysqladmin -u root -p extended-status
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 9659 |
| Aborted_connects | 265 |
| Bytes_received | 3789187499 |
| Bytes_sent | 2965110031 |
| Com_admin_commands | 1249 |
| Com_alter_table | 7 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 109914 |
| Com_change_db | 6033150 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 89660 |
| Com_create_db | 4 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 1625 |
| Com_delete | 411834 |
| Com_delete_multi | 0 |
| Com_drop_db | 2 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 1510 |
| Com_flush | 3 |
| Com_grant | 2 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 212003 |
| Com_insert_select | 6224 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 36240 |
| Com_optimize | 138 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 337489 |
| Com_replace_select | 107 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 22107 |
| Com_savepoint | 0 |
| Com_select | 90879493 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 2 |
| Com_show_fields | 12 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| 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 | 13 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 9 |
| Com_show_variables | 3 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 2 |
| Com_unlock_tables | 37222 |
| Com_update | 5690307 |
| Connections | 5763630 |
| Created_tmp_disk_tables | 3262 |
| Created_tmp_tables | 1395848 |
| Created_tmp_files | 8 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 13898 |
| Delayed_errors | 7 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 263581 |
| Handler_read_first | 1958921 |
| Handler_read_key | 883397504 |
| Handler_read_next | 1085608877 |
| Handler_read_prev | 11038356 |
| Handler_read_rnd | 1197074054 |
| Handler_read_rnd_next | 4243939255 |
| Handler_rollback | 0 |
| Handler_update | 374207341 |
| Handler_write | 113347183 |
| Key_blocks_used | 124690 |
| Key_read_requests | 1806026661 |
| Key_reads | 335045 |
| Key_write_requests | 2233730 |
| Key_writes | 1622931 |
| Max_used_connections | 317 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 1024 |
| Open_files | 1174 |
| Open_streams | 0 |
| Opened_tables | 6682 |
| Questions | 109626679 |
| Qcache_queries_in_cache | 0 |
| Qcache_inserts | 0 |
| Qcache_hits | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 90879487 |
| Qcache_free_memory | 33545616 |
| Qcache_free_blocks | 1 |
| Qcache_total_blocks | 1 |
| Rpl_status | NULL |
| Select_full_join | 324556 |
| Select_full_range_join | 0 |
| Select_range | 15685979 |
| Select_range_check | 0 |
| Select_scan | 9500492 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 1 |
| Slow_queries | 5314 |
| Sort_merge_passes | 4 |
| Sort_range | 7334665 |
| Sort_rows | 1202471809 |
| Sort_scan | 5143271 |
| Table_locks_immediate | 105822333 |
| Table_locks_waited | 121977 |
| Threads_cached | 255 |
| Threads_created | 320 |
| Threads_connected | 1 |
| Threads_running | 1 |
| Uptime | 1136515 |
+--------------------------+------------+
Here are the live statistics
http://www.clublexus.com/forums/test.php
http://www.clublexus.com/phpinfo.php
vbulletin 2.2.9
We are also running phpadsnew, photopost, and ezpublisher on the same server. Currently ezpublisher, photopost, and vbuleltin share the same database because that's how the last design team made it. We will be seperating the databases in the future. Currently we cannot update vbulletin to the latest version becase all the hacks are undocumented.
We usually get an average of of 150 users off peak 210 users peak. Max will be around 300, or 450 when a new car model comes out.
httpd.conf
KeepAlive On
MaxKeepAliveRequests 1000
KeepAliveTimeout 15
MinSpareServers 10
MaxSpareServers 10
StartServers 500
MaxClients 500
oh, the site is not sluggish. I'm just a speed deamon.
I just rebuilt this machine 2 weeks agoe :-D.