Nick0r
Thu 15th Jun '06, 4:02pm
Things have been slow when we get to ~200 users online.
1. 4-6 sites (only one that's more than fairly busy)
2.
cpu speed/type single or dual cpus): celeron 2.4ghz
how much memory installed: 1.5gb ram
hard drive type/configuration: 80GB EIDE non raid
linux distributor or windows version: debian
apache/IIS version: apache 1.3.34
PHP version: PHP 4.3.10-16
MySQL version: mysql 5.0.22
3. N/a
4. apt-get
5. top - 19:46:36 up 132 days, 17:35, 1 user, load average: 0.07, 0.25, 0.25
Tasks: 142 total, 1 running, 141 sleeping, 0 stopped, 0 zombie
Cpu(s): 11.7% user, 0.7% system, 0.0% nice, 87.6% idle
Mem: 1550252k total, 1036528k used, 513724k free, 9252k buffers
Swap: 2097136k total, 47536k used, 2049600k free, 712416k cached
6.
[mysqld]
max_connections = 500
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 = 60
connect_timeout = 30
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
skip-innodb
log-slow-queries = /var/log/mysql/mysql-slow.log
#log = /var/log/mysql/mysql.log
#bind-address = 127.0.0.1
socket = /var/run/mysqld/mysqld.sock
[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
[client]
socket = /var/run/mysqld/mysqld.sock
7. MySQL stats from ssh telnet as root user type:
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 125848 |
| Aborted_connects | 11 |
| Bytes_received | 2537295212 |
| Bytes_sent | 1924599388 |
| Com_admin_commands | 343310 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 616625 |
| Com_change_master | 0 |
| Com_check | 6569 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_delete | 21045 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 16 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 350139 |
| Com_insert_select | 1311 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 534 |
| Com_optimize | 125 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 70005 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 2055423 |
| Com_set_option | 8080 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 16 |
| Com_show_create | 8080 |
| Com_show_databases | 1 |
| Com_show_fields | 8760 |
| 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 | 1 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 2 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 9748 |
| Com_show_variables | 39 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 534 |
| Com_update | 535090 |
| Com_update_multi | 0 |
| Connections | 487786 |
| Created_tmp_disk_tables | 10410 |
| Created_tmp_tables | 90109 |
| Created_tmp_files | 214 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 187203 |
| Handler_read_first | 462478 |
| Handler_read_key | 71797997 |
| Handler_read_next | 99333670 |
| Handler_read_prev | 24228504 |
| Handler_read_rnd | 154169880 |
| Handler_read_rnd_next | 1367071922 |
| Handler_rollback | 0 |
| Handler_update | 93140655 |
| Handler_write | 100323013 |
| Key_blocks_used | 62345 |
| Key_read_requests | 400091708 |
| Key_reads | 4014685 |
| Key_write_requests | 14240546 |
| Key_writes | 1459622 |
| Max_used_connections | 71 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 1023 |
| Open_files | 1540 |
| Open_streams | 0 |
| Opened_tables | 7255 |
| Questions | 6520837 |
| Qcache_queries_in_cache | 3613 |
| Qcache_inserts | 2032042 |
| Qcache_hits | 2403701 |
| Qcache_lowmem_prunes | 44643 |
| Qcache_not_cached | 23381 |
| Qcache_free_memory | 6723768 |
| Qcache_free_blocks | 2325 |
| Qcache_total_blocks | 11744 |
| Rpl_status | NULL |
| Select_full_join | 497 |
| Select_full_range_join | 0 |
| Select_range | 490088 |
| Select_range_check | 0 |
| Select_scan | 555139 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 301 |
| Sort_merge_passes | 107 |
| Sort_range | 426032 |
| Sort_rows | 86570783 |
| Sort_scan | 246107 |
| Table_locks_immediate | 5712736 |
| Table_locks_waited | 542 |
| Threads_cached | 52 |
| Threads_created | 72 |
| Threads_connected | 12 |
| Threads_running | 1 |
| Uptime | 689607 |
+--------------------------+------------+
Uptime: 689607 Threads: 12 Questions: 6520838 Slow queries: 301 Opens: 7255 Flush tables: 1 Open tables: 1023 Queries per second avg: 9.456
8. 3 lots of vb but two are tiny (~5 users at once)
9. Average: 100-150, Max: ~300 (struggles when it gets towards this). These figures include guests too. Members it's normally ~30-40 online at once, peak is about 100.
11. 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 Off
MaxKeepAliveRequests 250
KeepAliveTimeout 5
MinSpareServers 10
MaxSpareServers 30
StartServers 5
MaxClients 400
Maxrequestsperchild 500
12. what version of vB are you running ?
3.5.X
13. there was one, not anymore
14. Post output from these 3 commands
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 7168
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 3
model name : Intel(R) Celeron(R) CPU 2.40GHz
stepping : 4
cpu MHz : 2400.169
cache size : 256 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe pni monitor ds_cpl cid
bogomips : 4784.12
1. 4-6 sites (only one that's more than fairly busy)
2.
cpu speed/type single or dual cpus): celeron 2.4ghz
how much memory installed: 1.5gb ram
hard drive type/configuration: 80GB EIDE non raid
linux distributor or windows version: debian
apache/IIS version: apache 1.3.34
PHP version: PHP 4.3.10-16
MySQL version: mysql 5.0.22
3. N/a
4. apt-get
5. top - 19:46:36 up 132 days, 17:35, 1 user, load average: 0.07, 0.25, 0.25
Tasks: 142 total, 1 running, 141 sleeping, 0 stopped, 0 zombie
Cpu(s): 11.7% user, 0.7% system, 0.0% nice, 87.6% idle
Mem: 1550252k total, 1036528k used, 513724k free, 9252k buffers
Swap: 2097136k total, 47536k used, 2049600k free, 712416k cached
6.
[mysqld]
max_connections = 500
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 = 60
connect_timeout = 30
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
skip-innodb
log-slow-queries = /var/log/mysql/mysql-slow.log
#log = /var/log/mysql/mysql.log
#bind-address = 127.0.0.1
socket = /var/run/mysqld/mysqld.sock
[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
[client]
socket = /var/run/mysqld/mysqld.sock
7. MySQL stats from ssh telnet as root user type:
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 125848 |
| Aborted_connects | 11 |
| Bytes_received | 2537295212 |
| Bytes_sent | 1924599388 |
| Com_admin_commands | 343310 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 616625 |
| Com_change_master | 0 |
| Com_check | 6569 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_delete | 21045 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 16 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 350139 |
| Com_insert_select | 1311 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 534 |
| Com_optimize | 125 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 70005 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 2055423 |
| Com_set_option | 8080 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 16 |
| Com_show_create | 8080 |
| Com_show_databases | 1 |
| Com_show_fields | 8760 |
| 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 | 1 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 2 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 9748 |
| Com_show_variables | 39 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 534 |
| Com_update | 535090 |
| Com_update_multi | 0 |
| Connections | 487786 |
| Created_tmp_disk_tables | 10410 |
| Created_tmp_tables | 90109 |
| Created_tmp_files | 214 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 187203 |
| Handler_read_first | 462478 |
| Handler_read_key | 71797997 |
| Handler_read_next | 99333670 |
| Handler_read_prev | 24228504 |
| Handler_read_rnd | 154169880 |
| Handler_read_rnd_next | 1367071922 |
| Handler_rollback | 0 |
| Handler_update | 93140655 |
| Handler_write | 100323013 |
| Key_blocks_used | 62345 |
| Key_read_requests | 400091708 |
| Key_reads | 4014685 |
| Key_write_requests | 14240546 |
| Key_writes | 1459622 |
| Max_used_connections | 71 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 1023 |
| Open_files | 1540 |
| Open_streams | 0 |
| Opened_tables | 7255 |
| Questions | 6520837 |
| Qcache_queries_in_cache | 3613 |
| Qcache_inserts | 2032042 |
| Qcache_hits | 2403701 |
| Qcache_lowmem_prunes | 44643 |
| Qcache_not_cached | 23381 |
| Qcache_free_memory | 6723768 |
| Qcache_free_blocks | 2325 |
| Qcache_total_blocks | 11744 |
| Rpl_status | NULL |
| Select_full_join | 497 |
| Select_full_range_join | 0 |
| Select_range | 490088 |
| Select_range_check | 0 |
| Select_scan | 555139 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 301 |
| Sort_merge_passes | 107 |
| Sort_range | 426032 |
| Sort_rows | 86570783 |
| Sort_scan | 246107 |
| Table_locks_immediate | 5712736 |
| Table_locks_waited | 542 |
| Threads_cached | 52 |
| Threads_created | 72 |
| Threads_connected | 12 |
| Threads_running | 1 |
| Uptime | 689607 |
+--------------------------+------------+
Uptime: 689607 Threads: 12 Questions: 6520838 Slow queries: 301 Opens: 7255 Flush tables: 1 Open tables: 1023 Queries per second avg: 9.456
8. 3 lots of vb but two are tiny (~5 users at once)
9. Average: 100-150, Max: ~300 (struggles when it gets towards this). These figures include guests too. Members it's normally ~30-40 online at once, peak is about 100.
11. 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 Off
MaxKeepAliveRequests 250
KeepAliveTimeout 5
MinSpareServers 10
MaxSpareServers 30
StartServers 5
MaxClients 400
Maxrequestsperchild 500
12. what version of vB are you running ?
3.5.X
13. there was one, not anymore
14. Post output from these 3 commands
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 7168
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 3
model name : Intel(R) Celeron(R) CPU 2.40GHz
stepping : 4
cpu MHz : 2400.169
cache size : 256 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe pni monitor ds_cpl cid
bogomips : 4784.12