-=Moosa=-
Sat 19th Aug '06, 4:38pm
1. Dedicated
2.Server Specs:
CPU: Intel Pentium 4 3.06 GHz
Memory: 2,048 MB DDR RAM
HDD: 120 GB IDE hard drive
OS: FC II
Webserver: Apache 2.0.51-2.9.5
PHP: 4.4.2-3
MySQL: 4.1.20-1
3. Yes, Plesk and PHP-Nuke use Innodb
4. Plesk 7.5.1 Installed.
5.# top
top - 15:15:18 up 21:31, 1 user, load average: 34.45, 27.48, 24.76
Tasks: 213 total, 37 running, 176 sleeping, 0 stopped, 0 zombie
Cpu(s): 84.9% us, 12.4% sy, 0.0% ni, 2.0% id, 0.0% wa, 0.0% hi, 0.6% si
Mem: 2073752k total, 2014220k used, 59532k free, 4280k buffers
Swap: 2048276k total, 84776k used, 1963500k free, 802132k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
947 mysql 15 0 167m 35m 3272 S 70.2 1.8 703:11.13 mysqld
17421 apache 16 0 39968 19m 3816 R 6.9 1.0 0:02.46 httpd
17006 apache 16 0 41416 21m 3828 R 6.0 1.0 0:03.24 httpd
17043 apache 16 0 40812 20m 3832 R 5.7 1.0 0:04.87 httpd
17721 apache 16 0 39004 18m 3768 S 5.7 0.9 0:01.24 httpd
16998 apache 16 0 40544 20m 3836 R 5.4 1.0 0:03.15 httpd
17780 apache 16 0 39364 19m 3752 R 5.0 1.0 0:01.01 httpd
17763 apache 15 0 38008 17m 3772 S 4.4 0.9 0:00.96 httpd
16336 apache 16 0 40896 20m 3844 R 3.5 1.0 0:08.22 httpd
17900 apache 16 0 36572 16m 3792 R 3.5 0.8 0:01.50 httpd
17010 apache 15 0 40532 20m 3668 S 3.2 1.0 0:02.38 httpd
17136 apache 15 0 40812 20m 3800 S 3.2 1.0 0:03.11 httpd
17433 apache 15 0 38756 18m 3828 S 3.2 0.9 0:02.82 httpd
17335 apache 15 0 40440 20m 3764 S 2.8 1.0 0:02.00 httpd
17699 apache 16 0 38700 18m 3832 R 2.8 0.9 0:02.15 httpd
17716 apache 15 0 40540 20m 3632 S 2.8 1.0 0:00.57 httpd
18085 apache 16 0 34008 13m 3664 R 2.8 0.7 0:00.17 httpd
6.# tail /etc/my.cnf
skip-networking
set-variable=max_connections=200
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
7.# mysqladmin -u root -p var ext stat ver
+---------------------------------+---------------------------------------------
-----------+
| Variable_name | Value
|
+---------------------------------+---------------------------------------------
-----------+
| back_log | 50
|
| basedir | /usr/
|
| bdb_cache_size | 8388600
|
| bdb_home | /var/lib/mysql/
|
| bdb_log_buffer_size | 32768
|
| bdb_logdir |
|
| bdb_max_lock | 10000
|
| bdb_shared_data | OFF
|
| bdb_tmpdir | /tmp/
|
| 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 | 5
|
| 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 | YES
|
| have_blackhole_engine | NO
|
| have_compress | YES
|
| have_crypt | YES
|
| have_csv | NO
|
| have_example_engine | NO
|
| have_geometry | YES
|
| have_innodb | YES
|
| have_isam | YES
|
| have_ndbcluster | NO
|
| have_openssl | YES
|
| 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 | ibdata1:10M:autoextend
|
| 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 | 131072
|
| key_buffer_size | 8388600
|
| 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 | 1048576
|
| max_binlog_cache_size | 4294967295
|
| max_binlog_size | 1073741824
|
| max_connect_errors | 10
|
| max_connections | 200
|
| 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_prepared_stmt_count | 16382
|
| 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 | 8388608
|
| 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 | ON
|
| open_files_limit | 1024
|
| pid_file | /var/run/mysqld/mysqld.pid
|
| port | 0
|
| preload_buffer_size | 32768
|
| prepared_stmt_count | 0
|
| protocol_version | 10
|
| query_alloc_block_size | 8192
|
| query_cache_limit | 1048576
|
| query_cache_min_res_unit | 4096
|
| query_cache_size | 0
|
| query_cache_type | ON
|
| query_cache_wlock_invalidate | OFF
|
| query_prealloc_size | 8192
|
| range_alloc_block_size | 2048
|
| read_buffer_size | 131072
|
| 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 | ON
|
| 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 | ON
|
| sql_warnings | ON
|
| storage_engine | MyISAM
|
| sync_binlog | 0
|
| sync_frm | ON
|
| sync_replication | 0
|
| sync_replication_slave_id | 0
|
| sync_replication_timeout | 0
|
| system_time_zone | EDT
|
| table_cache | 64
|
| table_type | MyISAM
|
| thread_cache_size | 0
|
| thread_stack | 196608
|
| time_format | %H:%i:%s
|
| time_zone | SYSTEM
|
| tmp_table_size | 33554432
|
| tmpdir |
|
| transaction_alloc_block_size | 8192
|
| transaction_prealloc_size | 4096
|
| tx_isolation | REPEATABLE-READ
|
| version | 4.1.20
|
| version_bdb | Sleepycat Software: Berkeley DB 4.1.24: (May
24, 2006) |
| version_comment | Source distribution
|
| version_compile_machine | i686
|
| version_compile_os | redhat-linux-gnu
|
| wait_timeout | 28800
|
+---------------------------------+---------------------------------------------
-----------+
+--------------------------------+------------+
| Variable_name | Value |
+--------------------------------+------------+
| Aborted_clients | 12 |
| Aborted_connects | 78 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 2094209030 |
| Bytes_sent | 2543946918 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 1573 |
| Com_change_db | 284713 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 1573 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 15566 |
| Com_dealloc_sql | 0 |
| Com_delete | 42330 |
| 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 | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 31242 |
| Com_insert_select | 543 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 84 |
| 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 | 264553 |
| Com_replace_select | 1 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 10841958 |
| Com_set_option | 18451 |
| 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 | 3 |
| Com_show_create_table | 16739 |
| Com_show_databases | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 16739 |
| Com_show_grants | 0 |
| 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 | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 16804 |
| Com_show_variables | 5 |
| 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 | 21 |
| Com_unlock_tables | 84 |
| Com_update | 402508 |
| Com_update_multi | 0 |
| Connections | 282682 |
| Created_tmp_disk_tables | 10005 |
| Created_tmp_files | 388 |
| Created_tmp_tables | 90599 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 1576 |
| Handler_delete | 29298 |
| Handler_discover | 0 |
| Handler_read_first | 923295 |
| Handler_read_key | 500561161 |
| Handler_read_next | 1359462142 |
| Handler_read_prev | 2325099 |
| Handler_read_rnd | 14661313 |
| Handler_read_rnd_next | 791923754 |
| Handler_rollback | 1655 |
| Handler_update | 52595548 |
| Handler_write | 48799697 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 4945 |
| Key_blocks_used | 5002 |
| Key_read_requests | 2101482583 |
| Key_reads | 7231041 |
| Key_write_requests | 333522 |
| Key_writes | 206590 |
| Max_used_connections | 110 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 114 |
| Open_streams | 0 |
| Open_tables | 64 |
| Opened_tables | 2346880 |
| Qcache_free_blocks | 0 |
| Qcache_free_memory | 0 |
| Qcache_hits | 0 |
| Qcache_inserts | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_queries_in_cache | 0 |
| Qcache_total_blocks | 0 |
| Questions | 12248224 |
| Rpl_status | NULL |
| Select_full_join | 13818 |
| Select_full_range_join | 171 |
| Select_range | 828827 |
| Select_range_check | 0 |
| Select_scan | 2184853 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 4460 |
| Slow_queries | 705 |
| Sort_merge_passes | 192 |
| Sort_range | 152172 |
| Sort_rows | 41715047 |
| Sort_scan | 1123324 |
| Ssl_accept_renegotiates | 0 |
| Ssl_accepts | 0 |
| Ssl_callback_cache_hits | 0 |
| Ssl_cipher | |
| Ssl_cipher_list | |
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_ctx_verify_depth | 0 |
| Ssl_ctx_verify_mode | 0 |
| Ssl_default_timeout | 0 |
| Ssl_finished_accepts | 0 |
| Ssl_finished_connects | 0 |
| Ssl_session_cache_hits | 0 |
| Ssl_session_cache_misses | 0 |
| Ssl_session_cache_mode | NONE |
| Ssl_session_cache_overflows | 0 |
| Ssl_session_cache_size | 0 |
| Ssl_session_cache_timeouts | 0 |
| Ssl_sessions_reused | 0 |
| Ssl_used_session_cache_entries | 0 |
| Ssl_verify_depth | 0 |
| Ssl_verify_mode | 0 |
| Ssl_version | |
| Table_locks_immediate | 13151936 |
| Table_locks_waited | 157272 |
| Threads_cached | 0 |
| Threads_connected | 20 |
| Threads_created | 282681 |
| Threads_running | 17 |
| Uptime | 77677 |
+--------------------------------+------------+
Uptime: 77677 Threads: 20 Questions: 12248233 Slow queries: 705 Opens: 23468
83 Flush tables: 1 Open tables: 64 Queries per second avg: 157.682
mysqladmin Ver 8.41 Distrib 4.1.20, for redhat-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.20
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 21 hours 34 min 37 sec
Threads: 20 Questions: 12248235 Slow queries: 705 Opens: 2346883 Flush table
s: 1 Open tables: 64 Queries per second avg: 157.682
8.im running vBulletin and PHP-Nuke on my Dedicated Server
9.Online Users: 483: 250 members and 233 guests
Cookietime: 3000s ( lol )
10.PHPInfo: http://www.iranproud.com/?do=phpinfo
12.I'm Running vB3.5.4
13. #uname -a
Linux iranproud.com 2.6.14-051115a #1 SMP Tue Nov 15 13:06:41 CET 2005 i686 i686 i386 GNU/Linux
#ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) 32
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) 16369
virtual memory (kbytes, -v) unlimited
# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Pentium(R) 4 CPU 3.00GHz
stepping : 1
cpu MHz : 2993.031
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
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 xtpr
bogomips : 5993.49
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Pentium(R) 4 CPU 3.00GHz
stepping : 1
cpu MHz : 2993.031
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
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 xtpr
bogomips : 5985.45
Thanks Eva;)
2.Server Specs:
CPU: Intel Pentium 4 3.06 GHz
Memory: 2,048 MB DDR RAM
HDD: 120 GB IDE hard drive
OS: FC II
Webserver: Apache 2.0.51-2.9.5
PHP: 4.4.2-3
MySQL: 4.1.20-1
3. Yes, Plesk and PHP-Nuke use Innodb
4. Plesk 7.5.1 Installed.
5.# top
top - 15:15:18 up 21:31, 1 user, load average: 34.45, 27.48, 24.76
Tasks: 213 total, 37 running, 176 sleeping, 0 stopped, 0 zombie
Cpu(s): 84.9% us, 12.4% sy, 0.0% ni, 2.0% id, 0.0% wa, 0.0% hi, 0.6% si
Mem: 2073752k total, 2014220k used, 59532k free, 4280k buffers
Swap: 2048276k total, 84776k used, 1963500k free, 802132k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
947 mysql 15 0 167m 35m 3272 S 70.2 1.8 703:11.13 mysqld
17421 apache 16 0 39968 19m 3816 R 6.9 1.0 0:02.46 httpd
17006 apache 16 0 41416 21m 3828 R 6.0 1.0 0:03.24 httpd
17043 apache 16 0 40812 20m 3832 R 5.7 1.0 0:04.87 httpd
17721 apache 16 0 39004 18m 3768 S 5.7 0.9 0:01.24 httpd
16998 apache 16 0 40544 20m 3836 R 5.4 1.0 0:03.15 httpd
17780 apache 16 0 39364 19m 3752 R 5.0 1.0 0:01.01 httpd
17763 apache 15 0 38008 17m 3772 S 4.4 0.9 0:00.96 httpd
16336 apache 16 0 40896 20m 3844 R 3.5 1.0 0:08.22 httpd
17900 apache 16 0 36572 16m 3792 R 3.5 0.8 0:01.50 httpd
17010 apache 15 0 40532 20m 3668 S 3.2 1.0 0:02.38 httpd
17136 apache 15 0 40812 20m 3800 S 3.2 1.0 0:03.11 httpd
17433 apache 15 0 38756 18m 3828 S 3.2 0.9 0:02.82 httpd
17335 apache 15 0 40440 20m 3764 S 2.8 1.0 0:02.00 httpd
17699 apache 16 0 38700 18m 3832 R 2.8 0.9 0:02.15 httpd
17716 apache 15 0 40540 20m 3632 S 2.8 1.0 0:00.57 httpd
18085 apache 16 0 34008 13m 3664 R 2.8 0.7 0:00.17 httpd
6.# tail /etc/my.cnf
skip-networking
set-variable=max_connections=200
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
7.# mysqladmin -u root -p var ext stat ver
+---------------------------------+---------------------------------------------
-----------+
| Variable_name | Value
|
+---------------------------------+---------------------------------------------
-----------+
| back_log | 50
|
| basedir | /usr/
|
| bdb_cache_size | 8388600
|
| bdb_home | /var/lib/mysql/
|
| bdb_log_buffer_size | 32768
|
| bdb_logdir |
|
| bdb_max_lock | 10000
|
| bdb_shared_data | OFF
|
| bdb_tmpdir | /tmp/
|
| 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 | 5
|
| 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 | YES
|
| have_blackhole_engine | NO
|
| have_compress | YES
|
| have_crypt | YES
|
| have_csv | NO
|
| have_example_engine | NO
|
| have_geometry | YES
|
| have_innodb | YES
|
| have_isam | YES
|
| have_ndbcluster | NO
|
| have_openssl | YES
|
| 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 | ibdata1:10M:autoextend
|
| 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 | 131072
|
| key_buffer_size | 8388600
|
| 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 | 1048576
|
| max_binlog_cache_size | 4294967295
|
| max_binlog_size | 1073741824
|
| max_connect_errors | 10
|
| max_connections | 200
|
| 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_prepared_stmt_count | 16382
|
| 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 | 8388608
|
| 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 | ON
|
| open_files_limit | 1024
|
| pid_file | /var/run/mysqld/mysqld.pid
|
| port | 0
|
| preload_buffer_size | 32768
|
| prepared_stmt_count | 0
|
| protocol_version | 10
|
| query_alloc_block_size | 8192
|
| query_cache_limit | 1048576
|
| query_cache_min_res_unit | 4096
|
| query_cache_size | 0
|
| query_cache_type | ON
|
| query_cache_wlock_invalidate | OFF
|
| query_prealloc_size | 8192
|
| range_alloc_block_size | 2048
|
| read_buffer_size | 131072
|
| 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 | ON
|
| 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 | ON
|
| sql_warnings | ON
|
| storage_engine | MyISAM
|
| sync_binlog | 0
|
| sync_frm | ON
|
| sync_replication | 0
|
| sync_replication_slave_id | 0
|
| sync_replication_timeout | 0
|
| system_time_zone | EDT
|
| table_cache | 64
|
| table_type | MyISAM
|
| thread_cache_size | 0
|
| thread_stack | 196608
|
| time_format | %H:%i:%s
|
| time_zone | SYSTEM
|
| tmp_table_size | 33554432
|
| tmpdir |
|
| transaction_alloc_block_size | 8192
|
| transaction_prealloc_size | 4096
|
| tx_isolation | REPEATABLE-READ
|
| version | 4.1.20
|
| version_bdb | Sleepycat Software: Berkeley DB 4.1.24: (May
24, 2006) |
| version_comment | Source distribution
|
| version_compile_machine | i686
|
| version_compile_os | redhat-linux-gnu
|
| wait_timeout | 28800
|
+---------------------------------+---------------------------------------------
-----------+
+--------------------------------+------------+
| Variable_name | Value |
+--------------------------------+------------+
| Aborted_clients | 12 |
| Aborted_connects | 78 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 2094209030 |
| Bytes_sent | 2543946918 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 1573 |
| Com_change_db | 284713 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 1573 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 15566 |
| Com_dealloc_sql | 0 |
| Com_delete | 42330 |
| 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 | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 31242 |
| Com_insert_select | 543 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 84 |
| 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 | 264553 |
| Com_replace_select | 1 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 10841958 |
| Com_set_option | 18451 |
| 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 | 3 |
| Com_show_create_table | 16739 |
| Com_show_databases | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 16739 |
| Com_show_grants | 0 |
| 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 | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 16804 |
| Com_show_variables | 5 |
| 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 | 21 |
| Com_unlock_tables | 84 |
| Com_update | 402508 |
| Com_update_multi | 0 |
| Connections | 282682 |
| Created_tmp_disk_tables | 10005 |
| Created_tmp_files | 388 |
| Created_tmp_tables | 90599 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 1576 |
| Handler_delete | 29298 |
| Handler_discover | 0 |
| Handler_read_first | 923295 |
| Handler_read_key | 500561161 |
| Handler_read_next | 1359462142 |
| Handler_read_prev | 2325099 |
| Handler_read_rnd | 14661313 |
| Handler_read_rnd_next | 791923754 |
| Handler_rollback | 1655 |
| Handler_update | 52595548 |
| Handler_write | 48799697 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 4945 |
| Key_blocks_used | 5002 |
| Key_read_requests | 2101482583 |
| Key_reads | 7231041 |
| Key_write_requests | 333522 |
| Key_writes | 206590 |
| Max_used_connections | 110 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 114 |
| Open_streams | 0 |
| Open_tables | 64 |
| Opened_tables | 2346880 |
| Qcache_free_blocks | 0 |
| Qcache_free_memory | 0 |
| Qcache_hits | 0 |
| Qcache_inserts | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_queries_in_cache | 0 |
| Qcache_total_blocks | 0 |
| Questions | 12248224 |
| Rpl_status | NULL |
| Select_full_join | 13818 |
| Select_full_range_join | 171 |
| Select_range | 828827 |
| Select_range_check | 0 |
| Select_scan | 2184853 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 4460 |
| Slow_queries | 705 |
| Sort_merge_passes | 192 |
| Sort_range | 152172 |
| Sort_rows | 41715047 |
| Sort_scan | 1123324 |
| Ssl_accept_renegotiates | 0 |
| Ssl_accepts | 0 |
| Ssl_callback_cache_hits | 0 |
| Ssl_cipher | |
| Ssl_cipher_list | |
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_ctx_verify_depth | 0 |
| Ssl_ctx_verify_mode | 0 |
| Ssl_default_timeout | 0 |
| Ssl_finished_accepts | 0 |
| Ssl_finished_connects | 0 |
| Ssl_session_cache_hits | 0 |
| Ssl_session_cache_misses | 0 |
| Ssl_session_cache_mode | NONE |
| Ssl_session_cache_overflows | 0 |
| Ssl_session_cache_size | 0 |
| Ssl_session_cache_timeouts | 0 |
| Ssl_sessions_reused | 0 |
| Ssl_used_session_cache_entries | 0 |
| Ssl_verify_depth | 0 |
| Ssl_verify_mode | 0 |
| Ssl_version | |
| Table_locks_immediate | 13151936 |
| Table_locks_waited | 157272 |
| Threads_cached | 0 |
| Threads_connected | 20 |
| Threads_created | 282681 |
| Threads_running | 17 |
| Uptime | 77677 |
+--------------------------------+------------+
Uptime: 77677 Threads: 20 Questions: 12248233 Slow queries: 705 Opens: 23468
83 Flush tables: 1 Open tables: 64 Queries per second avg: 157.682
mysqladmin Ver 8.41 Distrib 4.1.20, for redhat-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.20
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 21 hours 34 min 37 sec
Threads: 20 Questions: 12248235 Slow queries: 705 Opens: 2346883 Flush table
s: 1 Open tables: 64 Queries per second avg: 157.682
8.im running vBulletin and PHP-Nuke on my Dedicated Server
9.Online Users: 483: 250 members and 233 guests
Cookietime: 3000s ( lol )
10.PHPInfo: http://www.iranproud.com/?do=phpinfo
12.I'm Running vB3.5.4
13. #uname -a
Linux iranproud.com 2.6.14-051115a #1 SMP Tue Nov 15 13:06:41 CET 2005 i686 i686 i386 GNU/Linux
#ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) 32
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) 16369
virtual memory (kbytes, -v) unlimited
# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Pentium(R) 4 CPU 3.00GHz
stepping : 1
cpu MHz : 2993.031
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
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 xtpr
bogomips : 5993.49
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Pentium(R) 4 CPU 3.00GHz
stepping : 1
cpu MHz : 2993.031
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
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 xtpr
bogomips : 5985.45
Thanks Eva;)