NitroXploit
Sun 23rd Apr '06, 6:15pm
1. Dedicates with two forums.
2. your server specs. For example:
cpu speed/type single or dual cpus): Dual Xeon 2.4GHz
how much memory installed: 3GB ram
hard drive type/configuration: 2x120GB EIDE
linux distributor or windows version: RHE 3.0 Taroon update 7
apache/IIS version: apache 1.3.34
PHP version: php 4.4.2
MySQL version: mysql 4.1
3. No
4. Cpanel Compilation
5.
22:03:25 up 1 day, 8:10, 1 user, load average: 10.03, 16.96, 21.54
448 processes: 394 sleeping, 52 running, 2 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 77.9% 0.0% 16.9% 0.0% 3.8% 0.0% 1.2%
cpu00 67.0% 0.0% 16.3% 0.0% 14.5% 0.0% 1.9%
cpu01 82.6% 0.0% 16.9% 0.0% 0.3% 0.0% 0.0%
cpu02 82.4% 0.0% 16.3% 0.0% 0.1% 0.0% 0.9%
cpu03 79.6% 0.0% 18.1% 0.0% 0.1% 0.0% 1.9%
Mem: 3082416k av, 2982712k used, 99704k free, 0k shrd, 71400k buff
1911448k actv, 679236k in_d, 48740k in_c
Swap: 2040244k av, 0k used, 2040244k free 2250860k cached
6.
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
max_connections = 700
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 900
connect_timeout = 10
tmp_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
thread_concurrency = 4
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384
#flush-time=1800
#log-slow-queries = /var/log/mysql_slow_query_log
#long_query_time = 5
[mysql.server]
user=mysql
basedir=/var/lib
[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
[mysql]
no-auto-rehash
#safe-updates
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=24M
write_buffer=24M
7.
+---------------------------------+-------------------------------------------+
| Variable_name | Value |
+---------------------------------+-------------------------------------------+
| back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 10 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | NO |
| have_bdb | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | DISABLED |
| have_isam | NO |
| have_ndbcluster | NO |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| 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_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 28800 |
| join_buffer_size | 1044480 |
| key_buffer_size | 16777216 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_error | |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 67107840 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 700 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| max_length_for_sort_data | 1024 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 67108864 |
| myisam_stats_method | nulls_unequal |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 4310 |
| pid_file | /var/lib/mysql/marta.nitrohosting.org.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| protocol_version | 10 |
| query_alloc_block_size | 16384 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 33554432 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 16384 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 0 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slave_transaction_retries | 0 |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | |
| sql_notes | OFF |
| sql_warnings | OFF |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| system_time_zone | WEST |
| table_cache | 1800 |
| table_type | MyISAM |
| thread_cache_size | 384 |
| thread_stack | 126976 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 67108864 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.18-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 900 |
+---------------------------------+-------------------------------------------+
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 38 |
| Aborted_connects | 1 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 2056869832 |
| Bytes_sent | 3810878632 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 2694 |
| Com_change_db | 1016745 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 2691 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 227828 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 24 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 194302 |
| Com_insert_select | 3625 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 69 |
| Com_optimize | 0 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 15816 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 2640963 |
| Com_set_option | 625 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 245 |
| Com_show_databases | 12 |
| Com_show_errors | 0 |
| Com_show_fields | 256 |
| Com_show_grants | 31 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 387 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 287 |
| Com_show_variables | 16 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 70 |
| Com_update | 767155 |
| Com_update_multi | 24 |
| Connections | 1017657 |
| Created_tmp_disk_tables | 903 |
| Created_tmp_files | 8070 |
| Created_tmp_tables | 64573 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 189408 |
| Handler_discover | 0 |
| Handler_read_first | 223062 |
| Handler_read_key | 345494515 |
| Handler_read_next | 2643121608 |
| Handler_read_prev | 2374638 |
| Handler_read_rnd | 18347294 |
| Handler_read_rnd_next | 4246973052 |
| Handler_rollback | 0 |
| Handler_update | 185999363 |
| Handler_write | 18672357 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 0 |
| Key_blocks_used | 14497 |
| Key_read_requests | 641863555 |
| Key_reads | 11414313 |
| Key_write_requests | 1259444 |
| Key_writes | 951511 |
| Max_used_connections | 147 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 1597 |
| Open_streams | 0 |
| Open_tables | 1430 |
| Opened_tables | 1436 |
| Qcache_free_blocks | 3002 |
| Qcache_free_memory | 22254920 |
| Qcache_hits | 2738015 |
| Qcache_inserts | 2627771 |
| Qcache_lowmem_prunes | 50058 |
| Qcache_not_cached | 12974 |
| Qcache_queries_in_cache | 5322 |
| Qcache_total_blocks | 13900 |
| Questions | 8629604 |
| Rpl_status | NULL |
| Select_full_join | 39 |
| Select_full_range_join | 0 |
| Select_range | 340553 |
| Select_range_check | 0 |
| Select_scan | 334738 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 157 |
| Sort_merge_passes | 4035 |
| Sort_range | 519506 |
| Sort_rows | 606855725 |
| Sort_scan | 104311 |
| Table_locks_immediate | 7048768 |
| Table_locks_waited | 151254 |
| Threads_cached | 128 |
| Threads_connected | 19 |
| Threads_created | 147 |
| Threads_running | 3 |
| Uptime | 115940 |
+----------------------------+------------+
Uptime: 115940 Threads: 19 Questions: 8629605 Slow queries: 157 Opens: 1436 Flush tables: 1 Open tables: 1430 Queries per second avg: 74.432
mysqladmin Ver 8.41 Distrib 4.1.18, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.1.18-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 day 8 hours 12 min 20 sec
Threads: 19 Questions: 8629605 Slow queries: 157 Opens: 1436 Flush tables: 1 Open tables: 1430 Queries per second avg: 74.432
MySQL 4.1.18-standard uptime 1 9:54:18 Sun Apr 23 23:47:39 2006
__ Key __________________________________________________ _______________
Buffer usage 14.16M of 16.00M %Used: 88.48
Write ratio 0.76
Read ratio 0.02
__ Questions __________________________________________________ _________
Total 9.34M 76.49/s
DMS 4.16M 34.11/s %Total: 44.59
QC Hits 2.96M 24.28/s 31.75
Com_ 1.11M 9.08/s 11.87
COM_QUIT 1.10M 9.02/s 11.79
+Unknown 88 0.00/s 0.00
Slow 197 0.00/s 0.00 %DMS: 0.00
DMS 4.16M 34.11/s 44.59
SELECT 2.85M 23.36/s 30.54 68.50
UPDATE 833.27k 6.83/s 8.93 20.02
DELETE 247.84k 2.03/s 2.65 5.95
INSERT 213.30k 1.75/s 2.28 5.12
REPLACE 16.83k 0.14/s 0.18 0.40
Com_ 1.11M 9.08/s 11.87
change_db 1.10M 9.01/s 11.78
begin 2.85k 0.02/s 0.03
commit 2.85k 0.02/s 0.03
__ SELECT and Sort __________________________________________________ ___
Scan 360.81k 2.96/s %SELECT: 12.65
Range 366.41k 3.00/s 12.85
Full join 43 0.00/s 0.00
Range check 0 0.00/s 0.00
Full rng join 0 0.00/s 0.00
Sort scan 112.16k 0.92/s
Sort range 559.88k 4.59/s
Sort mrg pass 4.24k 0.03/s
__ Query Cache __________________________________________________ _______
Memory usage 9.96M of 32.00M %Used: 31.12
Block Fragmnt 27.08%
Hits 2.96M 24.28/s
Inserts 2.84M 23.24/s
Prunes 53.68k 0.44/s
Insrt:Prune 52.83:1 22.80/s
Hit:Insert 1.05:1
__ Table Locks __________________________________________________ _______
Waited 182.13k 1.49/s %Total: 2.34
Immediate 7.59M 62.21/s
__ Tables __________________________________________________ ____________
Open 1.43k of 1800 %Cache: 79.61
Opened 1.44k 0.01/s
__ Connections __________________________________________________ _______
Max used 147 of 700 %Max: 21.00
Total 1.10M 9.02/s
__ Created Temp __________________________________________________ ______
Disk table 958 0.01/s
Table 69.25k 0.57/s
File 8.48k 0.07/s
__ Threads __________________________________________________ ___________
Running 6 of 35
Cache 112 %Hit: 99.99
Created 147 0.00/s
Slow 0 0.00/s
__ Aborted __________________________________________________ ___________
Clients 38 0.00/s
Connects 1 0.00/s
__ Bytes __________________________________________________ _____________
Sent 1.02G 8.35k/s
Received 2.22G 18.22k/s
8. A forum with vbulletin and phpADsNew and another website with just a forum
9. Cookie 1200, Vbulletin average 300 users online Max 500, and the other forum average 400 Max 650.
10. www.imagensonline.com/phpinfo.php
11.
KeepAlive On
MaxKeepAliveRequests 200
KeepAliveTimeout 3
MinSpareServers 10
MaxSpareServers 15
StartServers 10
MaxClients 190
AND Maxrequestsperchild value = 500
12. 3.54
13. alot of errors like, find: /proc/xxxx: No such file or directory
14.
core file size (blocks, -c) 1000000
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) 4
max memory size (kbytes, -m) unlimited
open files (-n) 4096
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimited
2. your server specs. For example:
cpu speed/type single or dual cpus): Dual Xeon 2.4GHz
how much memory installed: 3GB ram
hard drive type/configuration: 2x120GB EIDE
linux distributor or windows version: RHE 3.0 Taroon update 7
apache/IIS version: apache 1.3.34
PHP version: php 4.4.2
MySQL version: mysql 4.1
3. No
4. Cpanel Compilation
5.
22:03:25 up 1 day, 8:10, 1 user, load average: 10.03, 16.96, 21.54
448 processes: 394 sleeping, 52 running, 2 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 77.9% 0.0% 16.9% 0.0% 3.8% 0.0% 1.2%
cpu00 67.0% 0.0% 16.3% 0.0% 14.5% 0.0% 1.9%
cpu01 82.6% 0.0% 16.9% 0.0% 0.3% 0.0% 0.0%
cpu02 82.4% 0.0% 16.3% 0.0% 0.1% 0.0% 0.9%
cpu03 79.6% 0.0% 18.1% 0.0% 0.1% 0.0% 1.9%
Mem: 3082416k av, 2982712k used, 99704k free, 0k shrd, 71400k buff
1911448k actv, 679236k in_d, 48740k in_c
Swap: 2040244k av, 0k used, 2040244k free 2250860k cached
6.
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
max_connections = 700
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 900
connect_timeout = 10
tmp_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
thread_concurrency = 4
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384
#flush-time=1800
#log-slow-queries = /var/log/mysql_slow_query_log
#long_query_time = 5
[mysql.server]
user=mysql
basedir=/var/lib
[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
[mysql]
no-auto-rehash
#safe-updates
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=24M
write_buffer=24M
7.
+---------------------------------+-------------------------------------------+
| Variable_name | Value |
+---------------------------------+-------------------------------------------+
| back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 10 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | NO |
| have_bdb | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | DISABLED |
| have_isam | NO |
| have_ndbcluster | NO |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| 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_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 28800 |
| join_buffer_size | 1044480 |
| key_buffer_size | 16777216 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_error | |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 67107840 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 700 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| max_length_for_sort_data | 1024 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 67108864 |
| myisam_stats_method | nulls_unequal |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 4310 |
| pid_file | /var/lib/mysql/marta.nitrohosting.org.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| protocol_version | 10 |
| query_alloc_block_size | 16384 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 33554432 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 16384 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 0 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slave_transaction_retries | 0 |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | |
| sql_notes | OFF |
| sql_warnings | OFF |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| system_time_zone | WEST |
| table_cache | 1800 |
| table_type | MyISAM |
| thread_cache_size | 384 |
| thread_stack | 126976 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 67108864 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.18-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 900 |
+---------------------------------+-------------------------------------------+
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 38 |
| Aborted_connects | 1 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 2056869832 |
| Bytes_sent | 3810878632 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 2694 |
| Com_change_db | 1016745 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 2691 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 227828 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 24 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 194302 |
| Com_insert_select | 3625 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 69 |
| Com_optimize | 0 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 15816 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 2640963 |
| Com_set_option | 625 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 245 |
| Com_show_databases | 12 |
| Com_show_errors | 0 |
| Com_show_fields | 256 |
| Com_show_grants | 31 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 387 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 287 |
| Com_show_variables | 16 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 70 |
| Com_update | 767155 |
| Com_update_multi | 24 |
| Connections | 1017657 |
| Created_tmp_disk_tables | 903 |
| Created_tmp_files | 8070 |
| Created_tmp_tables | 64573 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 189408 |
| Handler_discover | 0 |
| Handler_read_first | 223062 |
| Handler_read_key | 345494515 |
| Handler_read_next | 2643121608 |
| Handler_read_prev | 2374638 |
| Handler_read_rnd | 18347294 |
| Handler_read_rnd_next | 4246973052 |
| Handler_rollback | 0 |
| Handler_update | 185999363 |
| Handler_write | 18672357 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 0 |
| Key_blocks_used | 14497 |
| Key_read_requests | 641863555 |
| Key_reads | 11414313 |
| Key_write_requests | 1259444 |
| Key_writes | 951511 |
| Max_used_connections | 147 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 1597 |
| Open_streams | 0 |
| Open_tables | 1430 |
| Opened_tables | 1436 |
| Qcache_free_blocks | 3002 |
| Qcache_free_memory | 22254920 |
| Qcache_hits | 2738015 |
| Qcache_inserts | 2627771 |
| Qcache_lowmem_prunes | 50058 |
| Qcache_not_cached | 12974 |
| Qcache_queries_in_cache | 5322 |
| Qcache_total_blocks | 13900 |
| Questions | 8629604 |
| Rpl_status | NULL |
| Select_full_join | 39 |
| Select_full_range_join | 0 |
| Select_range | 340553 |
| Select_range_check | 0 |
| Select_scan | 334738 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 157 |
| Sort_merge_passes | 4035 |
| Sort_range | 519506 |
| Sort_rows | 606855725 |
| Sort_scan | 104311 |
| Table_locks_immediate | 7048768 |
| Table_locks_waited | 151254 |
| Threads_cached | 128 |
| Threads_connected | 19 |
| Threads_created | 147 |
| Threads_running | 3 |
| Uptime | 115940 |
+----------------------------+------------+
Uptime: 115940 Threads: 19 Questions: 8629605 Slow queries: 157 Opens: 1436 Flush tables: 1 Open tables: 1430 Queries per second avg: 74.432
mysqladmin Ver 8.41 Distrib 4.1.18, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.1.18-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 day 8 hours 12 min 20 sec
Threads: 19 Questions: 8629605 Slow queries: 157 Opens: 1436 Flush tables: 1 Open tables: 1430 Queries per second avg: 74.432
MySQL 4.1.18-standard uptime 1 9:54:18 Sun Apr 23 23:47:39 2006
__ Key __________________________________________________ _______________
Buffer usage 14.16M of 16.00M %Used: 88.48
Write ratio 0.76
Read ratio 0.02
__ Questions __________________________________________________ _________
Total 9.34M 76.49/s
DMS 4.16M 34.11/s %Total: 44.59
QC Hits 2.96M 24.28/s 31.75
Com_ 1.11M 9.08/s 11.87
COM_QUIT 1.10M 9.02/s 11.79
+Unknown 88 0.00/s 0.00
Slow 197 0.00/s 0.00 %DMS: 0.00
DMS 4.16M 34.11/s 44.59
SELECT 2.85M 23.36/s 30.54 68.50
UPDATE 833.27k 6.83/s 8.93 20.02
DELETE 247.84k 2.03/s 2.65 5.95
INSERT 213.30k 1.75/s 2.28 5.12
REPLACE 16.83k 0.14/s 0.18 0.40
Com_ 1.11M 9.08/s 11.87
change_db 1.10M 9.01/s 11.78
begin 2.85k 0.02/s 0.03
commit 2.85k 0.02/s 0.03
__ SELECT and Sort __________________________________________________ ___
Scan 360.81k 2.96/s %SELECT: 12.65
Range 366.41k 3.00/s 12.85
Full join 43 0.00/s 0.00
Range check 0 0.00/s 0.00
Full rng join 0 0.00/s 0.00
Sort scan 112.16k 0.92/s
Sort range 559.88k 4.59/s
Sort mrg pass 4.24k 0.03/s
__ Query Cache __________________________________________________ _______
Memory usage 9.96M of 32.00M %Used: 31.12
Block Fragmnt 27.08%
Hits 2.96M 24.28/s
Inserts 2.84M 23.24/s
Prunes 53.68k 0.44/s
Insrt:Prune 52.83:1 22.80/s
Hit:Insert 1.05:1
__ Table Locks __________________________________________________ _______
Waited 182.13k 1.49/s %Total: 2.34
Immediate 7.59M 62.21/s
__ Tables __________________________________________________ ____________
Open 1.43k of 1800 %Cache: 79.61
Opened 1.44k 0.01/s
__ Connections __________________________________________________ _______
Max used 147 of 700 %Max: 21.00
Total 1.10M 9.02/s
__ Created Temp __________________________________________________ ______
Disk table 958 0.01/s
Table 69.25k 0.57/s
File 8.48k 0.07/s
__ Threads __________________________________________________ ___________
Running 6 of 35
Cache 112 %Hit: 99.99
Created 147 0.00/s
Slow 0 0.00/s
__ Aborted __________________________________________________ ___________
Clients 38 0.00/s
Connects 1 0.00/s
__ Bytes __________________________________________________ _____________
Sent 1.02G 8.35k/s
Received 2.22G 18.22k/s
8. A forum with vbulletin and phpADsNew and another website with just a forum
9. Cookie 1200, Vbulletin average 300 users online Max 500, and the other forum average 400 Max 650.
10. www.imagensonline.com/phpinfo.php
11.
KeepAlive On
MaxKeepAliveRequests 200
KeepAliveTimeout 3
MinSpareServers 10
MaxSpareServers 15
StartServers 10
MaxClients 190
AND Maxrequestsperchild value = 500
12. 3.54
13. alot of errors like, find: /proc/xxxx: No such file or directory
14.
core file size (blocks, -c) 1000000
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) 4
max memory size (kbytes, -m) unlimited
open files (-n) 4096
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimited