qxh
Thu 28th Aug '03, 9:07am
1. dedicated
2. cpu speed/type single or dual cpus): single celeron 1.3ghz
how much memory installed: 512mb ram
hard drive type/configuration: 60GB EIDE non raid
linux distributor or windows version: redhat linux 7.2
apache/IIS version: apache 1.3.27
PHP version: php 4.3.2
MySQL version: mysql 4.0.14
3. nope
4. either up2date or a cpanel update
5. 3:04pm up 2:47, 1 user, load average: 0.00, 0.05, 0.02
82 processes: 80 sleeping, 2 running, 0 zombie, 0 stopped
CPU states: 0.1% user, 0.3% system, 0.0% nice, 99.4% idle
Mem: 505868K av, 479852K used, 26016K free, 0K shrd, 28892K buff
Swap: 1020116K av, 0K used, 1020116K free 327312K cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
10961 root 15 0 1060 1060 828 R 0.3 0.2 0:00 top
1 root 15 0 524 524 456 S 0.0 0.1 0:05 init
2 root 15 0 0 0 0 SW 0.0 0.0 0:00 keventd
3 root 15 0 0 0 0 SW 0.0 0.0 0:00 kapmd
4 root 34 19 0 0 0 SWN 0.0 0.0 0:00 ksoftirqd_CPU0
5 root 15 0 0 0 0 SW 0.0 0.0 0:00 kswapd
6 root 25 0 0 0 0 SW 0.0 0.0 0:00 bdflush
7 root 15 0 0 0 0 SW 0.0 0.0 0:00 kupdated
8 root 25 0 0 0 0 SW 0.0 0.0 0:00 mdrecoveryd
12 root 15 0 0 0 0 SW 0.0 0.0 0:01 kjournald
88 root 15 0 0 0 0 SW 0.0 0.0 0:00 khubd
211 root 15 0 0 0 0 SW 0.0 0.0 0:00 kjournald
539 root 15 0 0 0 0 SW 0.0 0.0 0:00 eth0
670 root 15 0 592 592 488 S 0.0 0.1 0:00 syslogd
675 root 15 0 1228 1228 444 S 0.0 0.2 0:00 klogd
850 named 17 0 3796 3796 2004 S 0.0 0.7 0:00 named
852 named 15 0 3796 3796 2004 S 0.0 0.7 0:00 named
853 named 15 0 3796 3796 2004 S 0.0 0.7 0:06 named
854 named 15 0 3796 3796 2004 S 0.0 0.7 0:00 named
855 named 15 0 3796 3796 2004 S 0.0 0.7 0:00 named
876 root 15 0 1260 1260 1124 S 0.0 0.2 0:00 sshd
910 root 15 0 984 984 780 S 0.0 0.1 0:00 xinetd
1011 nobody 17 0 624 624 384 S 0.0 0.1 0:00 melange
1038 root 15 0 3224 3224 2004 S 0.0 0.6 0:00 whostmgrd
1213 root 15 0 716 716 596 S 0.0 0.1 0:00 crond
1265 root 15 0 1260 1260 1064 S 0.0 0.2 0:00 antirelayd
1276 root 16 0 1032 1032 848 S 0.0 0.2 0:00 mysqld_safe
1318 mysql 15 0 11444 11M 1900 S 0.0 2.2 0:00 mysqld
1344 xfs 15 0 2832 2832 868 S 0.0 0.5 0:00 xfs
1421 mysql 15 0 11444 11M 1900 S 0.0 2.2 0:00 mysqld
1422 mysql 20 0 11444 11M 1900 S 0.0 2.2 0:00 mysqld
1423 mysql 15 0 11444 11M 1900 S 0.0 2.2 0:00 mysqld
1424 mysql 15 0 11444 11M 1900 S 0.0 2.2 0:00 mysqld
1425 mysql 20 0 11444 11M 1900 S 0.0 2.2 0:00 mysqld
1441 root 16 0 608 608 528 S 0.0 0.1 0:00 rhnsd
1469 root 17 0 508 508 432 S 0.0 0.1 0:00 portsentry
1490 mysql 15 0 11444 11M 1900 S 0.0 2.2 0:00 mysqld
1491 mysql 15 0 11444 11M 1900 S 0.0 2.2 0:09 mysqld
6. | back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set | latin1 |
| character_sets | latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert | ON |
| connect_timeout | 5 |
| convert_character_set | |
| datadir | /var/lib/mysql/ |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_min_word_len | 4 |
| ft_max_word_len | 254 |
| ft_max_word_len_for_sort | 20 |
| ft_stopword_file | (built-in) |
| have_bdb | NO |
| have_crypt | YES |
| have_innodb | YES |
| have_isam | YES |
| have_raid | NO |
| have_symlink | YES |
| have_openssl | NO |
| have_query_cache | YES |
| init_file | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_file_io_threads | 4 |
| innodb_force_recovery | 0 |
| innodb_thread_concurrency | 8 |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_fast_shutdown | ON |
| innodb_flush_method | |
| innodb_lock_wait_timeout | 50 |
| innodb_log_arch_dir | ./ |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| innodb_mirrored_log_groups | 1 |
| innodb_max_dirty_pages_pct | 90 |
| interactive_timeout | 200 |
| join_buffer_size | 131072 |
| key_buffer_size | 8388600 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_update | OFF |
| log_bin | OFF |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_warnings | OFF |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_table_names | OFF |
| max_allowed_packet | 16776192 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connections | 1500 |
| max_connect_errors | 10 |
| max_delayed_threads | 20 |
| max_heap_table_size | 16777216 |
| max_join_size | 4294967295 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_user_connections | 200 |
| max_tmp_tables | 32 |
| max_write_lock_count | 4294967295 |
| myisam_max_extra_sort_file_size | 268435456 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_repair_threads | 1 |
| myisam_recover_options | OFF |
| myisam_sort_buffer_size | 8388608 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| open_files_limit | 0 |
| pid_file | /var/lib/mysql/oyrx.gamewizards.net.pid |
| log_error | |
| port | 3306 |
| protocol_version | 10 |
| read_buffer_size | 131072 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| rpl_recovery_rank | 0 |
| query_cache_limit | 1048576 |
| query_cache_size | 0 |
| query_cache_type | ON |
| server_id | 0 |
| slave_net_timeout | 3600 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | 0 |
| table_cache | 64 |
| table_type | MYISAM |
| thread_cache_size | 0 |
| thread_stack | 126976 |
| tx_isolation | REPEATABLE-READ |
| timezone | BST |
| tmp_table_size | 33554432 |
| tmpdir | /tmp/ |
| version | 4.0.14-standard |
| wait_timeout | 9600 |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
7. +--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| Aborted_clients | 0 |
| Aborted_connects | 1 |
| Bytes_received | 9865 |
| Bytes_sent | 19481 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 0 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 3 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 12 |
| Com_delete | 1 |
| 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 | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 0 |
| Com_insert_select | 0 |
| 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 | 6 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 0 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 0 |
| Com_show_fields | 0 |
| 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 | 35 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 0 |
| Com_show_variables | 2 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 2 |
| Connections | 63 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_tables | 0 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 0 |
| Handler_read_first | 6 |
| Handler_read_key | 0 |
| Handler_read_next | 48 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 6 |
| Handler_read_rnd_next | 643 |
| Handler_rollback | 0 |
| Handler_update | 10 |
| Handler_write | 6 |
| Key_blocks_used | 15 |
| Key_read_requests | 21 |
| Key_reads | 15 |
| Key_write_requests | 0 |
| Key_writes | 0 |
| Max_used_connections | 1 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 0 |
| Open_files | 0 |
| Open_streams | 0 |
| Opened_tables | 31 |
| Questions | 127 |
| Qcache_queries_in_cache | 0 |
| Qcache_inserts | 0 |
| Qcache_hits | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_free_memory | 0 |
| Qcache_free_blocks | 0 |
| Qcache_total_blocks | 0 |
| Rpl_status | NULL |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 0 |
| Select_range_check | 0 |
| Select_scan | 0 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 0 |
| Sort_rows | 0 |
| Sort_scan | 0 |
| Table_locks_immediate | 40 |
| Table_locks_waited | 0 |
| Threads_cached | 0 |
| Threads_created | 62 |
| Threads_connected | 1 |
| Threads_running | 1 |
| Uptime | 10035 |
+--------------------------+-------+
8. we have this vbulletin, a few other forums, and a few sites.. ~10 accounts on the server.
9. adverage is around 20 now as we get a few guests, max is around 1500 when we had a ddos
10. http://oryx.gamewizards.net/~gamewiza/phpinfo.php
11. KeepAlive on
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 170
12. vb 3.0.0 beta 5
btw should i have Optimize EIDE Harddrives enabled? it says "Warning: Optimizing drives may cause the system to lock up, or other wise crash in some way if you are using some older buggy chipsets. However you can gain SIGNIFICANT speed and performance. Proceed at your own risk. "
thanks :)
2. cpu speed/type single or dual cpus): single celeron 1.3ghz
how much memory installed: 512mb ram
hard drive type/configuration: 60GB EIDE non raid
linux distributor or windows version: redhat linux 7.2
apache/IIS version: apache 1.3.27
PHP version: php 4.3.2
MySQL version: mysql 4.0.14
3. nope
4. either up2date or a cpanel update
5. 3:04pm up 2:47, 1 user, load average: 0.00, 0.05, 0.02
82 processes: 80 sleeping, 2 running, 0 zombie, 0 stopped
CPU states: 0.1% user, 0.3% system, 0.0% nice, 99.4% idle
Mem: 505868K av, 479852K used, 26016K free, 0K shrd, 28892K buff
Swap: 1020116K av, 0K used, 1020116K free 327312K cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
10961 root 15 0 1060 1060 828 R 0.3 0.2 0:00 top
1 root 15 0 524 524 456 S 0.0 0.1 0:05 init
2 root 15 0 0 0 0 SW 0.0 0.0 0:00 keventd
3 root 15 0 0 0 0 SW 0.0 0.0 0:00 kapmd
4 root 34 19 0 0 0 SWN 0.0 0.0 0:00 ksoftirqd_CPU0
5 root 15 0 0 0 0 SW 0.0 0.0 0:00 kswapd
6 root 25 0 0 0 0 SW 0.0 0.0 0:00 bdflush
7 root 15 0 0 0 0 SW 0.0 0.0 0:00 kupdated
8 root 25 0 0 0 0 SW 0.0 0.0 0:00 mdrecoveryd
12 root 15 0 0 0 0 SW 0.0 0.0 0:01 kjournald
88 root 15 0 0 0 0 SW 0.0 0.0 0:00 khubd
211 root 15 0 0 0 0 SW 0.0 0.0 0:00 kjournald
539 root 15 0 0 0 0 SW 0.0 0.0 0:00 eth0
670 root 15 0 592 592 488 S 0.0 0.1 0:00 syslogd
675 root 15 0 1228 1228 444 S 0.0 0.2 0:00 klogd
850 named 17 0 3796 3796 2004 S 0.0 0.7 0:00 named
852 named 15 0 3796 3796 2004 S 0.0 0.7 0:00 named
853 named 15 0 3796 3796 2004 S 0.0 0.7 0:06 named
854 named 15 0 3796 3796 2004 S 0.0 0.7 0:00 named
855 named 15 0 3796 3796 2004 S 0.0 0.7 0:00 named
876 root 15 0 1260 1260 1124 S 0.0 0.2 0:00 sshd
910 root 15 0 984 984 780 S 0.0 0.1 0:00 xinetd
1011 nobody 17 0 624 624 384 S 0.0 0.1 0:00 melange
1038 root 15 0 3224 3224 2004 S 0.0 0.6 0:00 whostmgrd
1213 root 15 0 716 716 596 S 0.0 0.1 0:00 crond
1265 root 15 0 1260 1260 1064 S 0.0 0.2 0:00 antirelayd
1276 root 16 0 1032 1032 848 S 0.0 0.2 0:00 mysqld_safe
1318 mysql 15 0 11444 11M 1900 S 0.0 2.2 0:00 mysqld
1344 xfs 15 0 2832 2832 868 S 0.0 0.5 0:00 xfs
1421 mysql 15 0 11444 11M 1900 S 0.0 2.2 0:00 mysqld
1422 mysql 20 0 11444 11M 1900 S 0.0 2.2 0:00 mysqld
1423 mysql 15 0 11444 11M 1900 S 0.0 2.2 0:00 mysqld
1424 mysql 15 0 11444 11M 1900 S 0.0 2.2 0:00 mysqld
1425 mysql 20 0 11444 11M 1900 S 0.0 2.2 0:00 mysqld
1441 root 16 0 608 608 528 S 0.0 0.1 0:00 rhnsd
1469 root 17 0 508 508 432 S 0.0 0.1 0:00 portsentry
1490 mysql 15 0 11444 11M 1900 S 0.0 2.2 0:00 mysqld
1491 mysql 15 0 11444 11M 1900 S 0.0 2.2 0:09 mysqld
6. | back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set | latin1 |
| character_sets | latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert | ON |
| connect_timeout | 5 |
| convert_character_set | |
| datadir | /var/lib/mysql/ |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_min_word_len | 4 |
| ft_max_word_len | 254 |
| ft_max_word_len_for_sort | 20 |
| ft_stopword_file | (built-in) |
| have_bdb | NO |
| have_crypt | YES |
| have_innodb | YES |
| have_isam | YES |
| have_raid | NO |
| have_symlink | YES |
| have_openssl | NO |
| have_query_cache | YES |
| init_file | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_file_io_threads | 4 |
| innodb_force_recovery | 0 |
| innodb_thread_concurrency | 8 |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_fast_shutdown | ON |
| innodb_flush_method | |
| innodb_lock_wait_timeout | 50 |
| innodb_log_arch_dir | ./ |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| innodb_mirrored_log_groups | 1 |
| innodb_max_dirty_pages_pct | 90 |
| interactive_timeout | 200 |
| join_buffer_size | 131072 |
| key_buffer_size | 8388600 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_update | OFF |
| log_bin | OFF |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_warnings | OFF |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_table_names | OFF |
| max_allowed_packet | 16776192 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connections | 1500 |
| max_connect_errors | 10 |
| max_delayed_threads | 20 |
| max_heap_table_size | 16777216 |
| max_join_size | 4294967295 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_user_connections | 200 |
| max_tmp_tables | 32 |
| max_write_lock_count | 4294967295 |
| myisam_max_extra_sort_file_size | 268435456 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_repair_threads | 1 |
| myisam_recover_options | OFF |
| myisam_sort_buffer_size | 8388608 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| open_files_limit | 0 |
| pid_file | /var/lib/mysql/oyrx.gamewizards.net.pid |
| log_error | |
| port | 3306 |
| protocol_version | 10 |
| read_buffer_size | 131072 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| rpl_recovery_rank | 0 |
| query_cache_limit | 1048576 |
| query_cache_size | 0 |
| query_cache_type | ON |
| server_id | 0 |
| slave_net_timeout | 3600 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | 0 |
| table_cache | 64 |
| table_type | MYISAM |
| thread_cache_size | 0 |
| thread_stack | 126976 |
| tx_isolation | REPEATABLE-READ |
| timezone | BST |
| tmp_table_size | 33554432 |
| tmpdir | /tmp/ |
| version | 4.0.14-standard |
| wait_timeout | 9600 |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
7. +--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| Aborted_clients | 0 |
| Aborted_connects | 1 |
| Bytes_received | 9865 |
| Bytes_sent | 19481 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 0 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 3 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 12 |
| Com_delete | 1 |
| 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 | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 0 |
| Com_insert_select | 0 |
| 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 | 6 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 0 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 0 |
| Com_show_fields | 0 |
| 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 | 35 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 0 |
| Com_show_variables | 2 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 2 |
| Connections | 63 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_tables | 0 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 0 |
| Handler_read_first | 6 |
| Handler_read_key | 0 |
| Handler_read_next | 48 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 6 |
| Handler_read_rnd_next | 643 |
| Handler_rollback | 0 |
| Handler_update | 10 |
| Handler_write | 6 |
| Key_blocks_used | 15 |
| Key_read_requests | 21 |
| Key_reads | 15 |
| Key_write_requests | 0 |
| Key_writes | 0 |
| Max_used_connections | 1 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 0 |
| Open_files | 0 |
| Open_streams | 0 |
| Opened_tables | 31 |
| Questions | 127 |
| Qcache_queries_in_cache | 0 |
| Qcache_inserts | 0 |
| Qcache_hits | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_free_memory | 0 |
| Qcache_free_blocks | 0 |
| Qcache_total_blocks | 0 |
| Rpl_status | NULL |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 0 |
| Select_range_check | 0 |
| Select_scan | 0 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 0 |
| Sort_rows | 0 |
| Sort_scan | 0 |
| Table_locks_immediate | 40 |
| Table_locks_waited | 0 |
| Threads_cached | 0 |
| Threads_created | 62 |
| Threads_connected | 1 |
| Threads_running | 1 |
| Uptime | 10035 |
+--------------------------+-------+
8. we have this vbulletin, a few other forums, and a few sites.. ~10 accounts on the server.
9. adverage is around 20 now as we get a few guests, max is around 1500 when we had a ddos
10. http://oryx.gamewizards.net/~gamewiza/phpinfo.php
11. KeepAlive on
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 170
12. vb 3.0.0 beta 5
btw should i have Optimize EIDE Harddrives enabled? it says "Warning: Optimizing drives may cause the system to lock up, or other wise crash in some way if you are using some older buggy chipsets. However you can gain SIGNIFICANT speed and performance. Proceed at your own risk. "
thanks :)