jawatkin
Thu 5th Jul '07, 12:46pm
Let me give a rundown of my configuration. I say "a little different" because I'm running lighttpd on :80 to serve static requests for CSS, images, etc, which proxies to apache2 on a different port on the back-end for PHP/HTML (dynamic) requests. I tried to go fully lighty, but I just couldn't get the rewrite engine to match my SEF URLs as I needed them, so proxy was the secondary option. I have a 64M xcache set for apache, with the datastore hack for vB.
1. VPS (unsure of how many share it) through Knownhost.com
2. CPU - 2 x 2GHz Dual-Core AMD Opteron(tm) Processor 2212
RAM - 512 MB min, 2 GB burst
HD - 30 GB, unknown
OS - CentOS 4.4
Apache - 2.2.4
PHP - 5.2.3
MySQL - 5.0.37
3. vb - 3.65 patched
5. Used RPM distro for DirectAdmin. Unsure of compiling options.
6. With 436 on -- (230 members and 206 guests)
top - 11:17:26 up 4 days, 14:11, 1 user, load average: 2.31, 2.71, 2.86
Tasks: 179 total, 6 running, 173 sleeping, 0 stopped, 0 zombie
Cpu(s): 14.7% us, 3.7% sy, 0.0% ni, 80.5% id, 1.1% wa, 0.0% hi, 0.0% si
Mem: 524288k total, 299832k used, 224456k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11859 apache 16 0 85000 25m 18m R 33 5.0 0:19.96 httpd
15964 apache 15 0 83692 23m 18m S 16 4.7 0:09.49 httpd
9675 mysql 16 0 252m 208m 2636 S 10 40.7 3:04.45 mysqld
26595 apache 15 0 83636 21m 15m S 10 4.1 0:04.62 httpd
27723 apache 16 0 83708 21m 15m S 10 4.2 0:05.01 httpd
26581 apache 16 0 86816 25m 17m R 8 4.9 0:05.17 httpd
9579 mysql 15 0 252m 208m 2636 S 6 40.7 3:19.09 mysqld
11280 mysql 15 0 252m 208m 2636 S 4 40.7 3:12.74 mysqld
3208 root 16 0 8612 7568 600 R 4 1.4 1:23.99 lighttpd
30636 apache 15 0 83688 26m 20m S 2 5.1 0:28.16 httpd
21540 apache 16 0 83708 24m 18m S 2 4.8 0:06.70 httpd
26596 apache 16 0 83692 22m 16m S 2 4.4 0:04.41 httpd
27805 apache 15 0 84984 22m 15m R 2 4.4 0:02.99 httpd
1626 apache 16 0 83456 11m 6012 S 2 2.2 0:00.23 httpd
3120 root 15 0 2016 1004 724 R 2 0.2 0:00.01 top
1 root 16 0 1620 600 520 S 0 0.1 0:04.84 init
15709 root 16 0 1524 544 456 S 0 0.1 0:02.58 syslogd
15861 root 16 0 4012 1032 744 S 0 0.2 0:00.00 sshd
15999 root 15 0 2072 812 684 S 0 0.2 0:00.03 xinetd
20096 root 16 0 896 260 224 S 0 0.0 0:07.91 da-popb4smtp
20278 nobody 15 0 6864 1460 1124 S 0 0.3 0:00.32 directadmin
20438 mail 16 0 7260 1168 796 S 0 0.2 0:00.52 exim
22376 ftp 16 0 2396 824 428 S 0 0.2 0:01.87 proftpd
22406 root 16 0 1804 412 320 S 0 0.1 0:00.22 vm-pop3d
22467 root 15 0 2472 924 536 S 0 0.2 0:00.96 crond
22503 root 18 0 4052 804 576 S 0 0.2 0:00.00 saslauthd
22526 root 18 0 4052 464 236 S 0 0.1 0:00.00 saslauthd
5262 named 20 0 68272 3420 1944 S 0 0.7 0:20.19 named
12089 nobody 17 0 6864 604 268 S 0 0.1 0:00.00 directadmin
12180 root 18 0 2144 1132 964 S 0 0.2 0:00.00 mysqld_safe
12224 mysql 15 0 252m 208m 2636 S 0 40.7 1:12.15 mysqld
12226 mysql 16 0 252m 208m 2636 S 0 40.7 0:02.05 mysqld
12227 mysql 16 0 252m 208m 2636 S 0 40.7 3:33.23 mysqld
12238 mysql 15 0 252m 208m 2636 S 0 40.7 8:26.65 mysqld
12241 nobody 17 0 6864 604 268 S 0 0.1 0:00.00 directadmin
12246 nobody 15 0 6864 604 268 S 0 0.1 0:00.00 directadmin
12249 mysql 16 0 252m 208m 2636 S 0 40.7 8:11.18 mysqld
12253 mysql 16 0 252m 208m 2636 S 0 40.7 8:54.22 mysqld
12257 mysql 15 0 252m 208m 2636 S 0 40.7 8:18.66 mysqld
13342 mysql 15 0 252m 208m 2636 S 0 40.7 8:25.13 mysqld
13344 mysql 15 0 252m 208m 2636 S 0 40.7 8:11.37 mysqld
13346 mysql 16 0 252m 208m 2636 S 0 40.7 8:24.77 mysqld
18379 mysql 16 0 252m 208m 2636 S 0 40.7 8:08.87 mysqld
Yes, uptime only 4 days.... That was a big problem with the hosting company, which I'm dealing with. Has nothing to do with server load or anything that I've done.
7.
[mysqld]
skip-locking
skip-innodb
query_cache_limit=8M
query_cache_size=128M
query_cache_type=1
max_connections=500
interactive_timeout=20
wait_timeout=20
connect_timeout=6
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
thread_concurrency=8
myisam_sort_buffer_size=64M
log-slow-queries
[safe_mysqld]
open_files_limit=8192
[mysqldump]
quick
[isamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M
8.
+---------------------------------+-------------------------------------------+
| Variable_name | Value |
+---------------------------------+-------------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| automatic_sp_privileges | ON |
| 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_filesystem | binary |
| 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 |
| completion_type | 0 |
| concurrent_insert | 1 |
| connect_timeout | 6 |
| 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 |
| div_precision_increment | 4 |
| engine_condition_pushdown | OFF |
| 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 | YES |
| have_bdb | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_dynamic_loading | NO |
| have_example_engine | NO |
| have_federated_engine | NO |
| have_geometry | YES |
| have_innodb | DISABLED |
| have_isam | NO |
| have_merge_engine | YES |
| 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_checksums | ON |
| innodb_commit_concurrency | 0 |
| innodb_concurrency_tickets | 500 |
| innodb_data_file_path | |
| innodb_data_home_dir | |
| innodb_doublewrite | ON |
| innodb_fast_shutdown | 1 |
| 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_rollback_on_timeout | OFF |
| innodb_support_xa | ON |
| innodb_sync_spin_loops | 20 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| innodb_thread_sleep_delay | 10000 |
| interactive_timeout | 20 |
| 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 |
| large_page_size | 0 |
| large_pages | OFF |
| lc_time_names | en_US |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_bin_trust_function_creators | OFF |
| log_error | |
| log_queries_not_using_indexes | OFF |
| log_slave_updates | OFF |
| log_slow_queries | ON |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 16776192 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 500 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 18446744073709551615 |
| 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_sp_recursion_depth | 0 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| multi_range_count | 256 |
| myisam_data_pointer_size | 6 |
| 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 | 2558 |
| optimizer_prune_level | 1 |
| optimizer_search_depth | 62 |
| pid_file | /var/lib/mysql/ns1.webkinzinsider.com.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| profiling | OFF |
| profiling_history_size | 15 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 8388608 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 134217728 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 2093056 |
| 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_compressed_protocol | OFF |
| slave_load_tmpdir | /tmp/ |
| slave_net_timeout | 3600 |
| slave_skip_errors | OFF |
| slave_transaction_retries | 10 |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_big_selects | ON |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | OFF |
| ssl_ca | |
| ssl_capath | |
| ssl_cert | |
| ssl_cipher | |
| ssl_key | |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| system_time_zone | EDT |
| table_cache | 1024 |
| table_lock_wait_timeout | 50 |
| table_type | MyISAM |
| thread_cache_size | 128 |
| thread_stack | 126976 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| timed_mutexes | OFF |
| tmp_table_size | 33554432 |
| tmpdir | /tmp/ |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| updatable_views_with_limit | YES |
| version | 5.0.37-standard-log |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 20 |
+---------------------------------+-------------------------------------------+
+-----------------------------------+------------+
| Variable_name | Value |
+-----------------------------------+------------+
| Aborted_clients | 808 |
| Aborted_connects | 5 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 2720683217 |
| Bytes_sent | 3203697464 |
| Com_admin_commands | 1 |
| Com_alter_db | 0 |
| Com_alter_table | 6 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 1116727 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 1 |
| Com_create_user | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 325000 |
| 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 | 359532 |
| Com_insert_select | 17 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 12157 |
| 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 | 84033 |
| 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 | 19226981 |
| Com_set_option | 163439 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 6 |
| Com_show_charsets | 208 |
| Com_show_collations | 208 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 54 |
| Com_show_databases | 208 |
| Com_show_errors | 0 |
| Com_show_fields | 202 |
| Com_show_grants | 113 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 83 |
| 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 | 4 |
| Com_show_tables | 404 |
| Com_show_triggers | 0 |
| Com_show_variables | 477 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 24 |
| Com_unlock_tables | 12157 |
| Com_update | 1641563 |
| Com_update_multi | 0 |
| Com_xa_commit | 0 |
| Com_xa_end | 0 |
| Com_xa_prepare | 0 |
| Com_xa_recover | 0 |
| Com_xa_rollback | 0 |
| Com_xa_start | 0 |
| Compression | OFF |
| Connections | 1100040 |
| Created_tmp_disk_tables | 287545 |
| Created_tmp_files | 72546 |
| Created_tmp_tables | 834710 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 173019 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 878072 |
| Handler_read_key | 323645676 |
| Handler_read_next | 1125607476 |
| Handler_read_prev | 4038418 |
| Handler_read_rnd | 19331876 |
| Handler_read_rnd_next | 2410684438 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 21685772 |
| Handler_write | 63319078 |
| Innodb_buffer_pool_pages_data | 0 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 0 |
| Innodb_buffer_pool_pages_free | 0 |
| Innodb_buffer_pool_pages_latched | 0 |
| Innodb_buffer_pool_pages_misc | 0 |
| Innodb_buffer_pool_pages_total | 0 |
| Innodb_buffer_pool_read_ahead_rnd | 0 |
| Innodb_buffer_pool_read_ahead_seq | 0 |
| Innodb_buffer_pool_read_requests | 0 |
| Innodb_buffer_pool_reads | 0 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 0 |
| Innodb_data_fsyncs | 0 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 0 |
| Innodb_data_reads | 0 |
| Innodb_data_writes | 0 |
| Innodb_data_written | 0 |
| Innodb_dblwr_pages_written | 0 |
| Innodb_dblwr_writes | 0 |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 0 |
| Innodb_log_writes | 0 |
| Innodb_os_log_fsyncs | 0 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 0 |
| Innodb_page_size | 0 |
| Innodb_pages_created | 0 |
| Innodb_pages_read | 0 |
| Innodb_pages_written | 0 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 0 |
| Innodb_row_lock_time_avg | 0 |
| Innodb_row_lock_time_max | 0 |
| Innodb_row_lock_waits | 0 |
| Innodb_rows_deleted | 0 |
| Innodb_rows_inserted | 0 |
| Innodb_rows_read | 0 |
| Innodb_rows_updated | 0 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 0 |
| Key_blocks_used | 14497 |
| Key_read_requests | 1046437720 |
| Key_reads | 1393356 |
| Key_write_requests | 3204499 |
| Key_writes | 2192223 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 269 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 1243 |
| Open_streams | 0 |
| Open_tables | 1024 |
| Opened_tables | 1775 |
| Prepared_stmt_count | 0 |
| Qcache_free_blocks | 14693 |
| Qcache_free_memory | 70719328 |
| Qcache_hits | 16040167 |
| Qcache_inserts | 8796854 |
| Qcache_lowmem_prunes | 62658 |
| Qcache_not_cached | 10421574 |
| Qcache_queries_in_cache | 25956 |
| Qcache_total_blocks | 67730 |
| Questions | 40085844 |
| Rpl_status | NULL |
| Select_full_join | 1763 |
| Select_full_range_join | 0 |
| Select_range | 852799 |
| Select_range_check | 2 |
| Select_scan | 1111291 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 1 |
| Slow_queries | 58 |
| Sort_merge_passes | 36273 |
| Sort_range | 962551 |
| Sort_rows | 561043965 |
| Sort_scan | 844056 |
| Table_locks_immediate | 18452527 |
| Table_locks_waited | 162076 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 127 |
| Threads_connected | 1 |
| Threads_created | 269 |
| Threads_running | 1 |
| Uptime | 167899 |
| Uptime_since_flush_status | 167899 |
+-----------------------------------+------------+
Uptime: 167899 Threads: 1 Questions: 40085845 Slow queries: 58 Opens: 1775 Flush tables: 1 Open tables: 1024 Queries per second avg: 238.750
mysqladmin Ver 8.41 Distrib 5.0.37, for pc-linux-gnu on i686
Copyright (C) 2000-2006 MySQL 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 5.0.37-standard-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 day 22 hours 38 min 19 sec
Threads: 1 Questions: 40085845 Slow queries: 58 Opens: 1775 Flush tables: 1 Open tables: 1024 Queries per second avg: 238.750
9. No, just completed an installation of Joomla for the front end. Using bbpixel's bridge to bridge the user info/login data.
10. Always increasing
Average users (combined members & guests): 300
Max concurrent: 669.
11. www.webkinzinsider.com/phpinfo.php
12.
KeepAlive Off
MaxKeepAliveRequests 20
KeepAliveTimeout 1
StartServers 5
MinSpareServers 5
MaxSpareServers 10
MaxClients 256
MaxRequestsPerChild 0
13. Nope, use cronolog to rotate logs.
14.
[root@ns1 conf]# uname -a
Linux ns1.webkinzinsider.com 2.6.9-023stab043.1-entnosplit #1 SMP Mon Mar 5 17:17:22 MSK 2007 i686 athlon i386 GNU/Linux
[root@ns1 conf]# ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 73728
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
[root@ns1 conf]# cat /proc/cpuinfo
processor : 0
vendor_id : AuthenticAMD
cpu family : 15
model : 65
model name : Dual-Core AMD Opteron(tm) Processor 2212
stepping : 2
cpu MHz : 1995.819
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow pni
bogomips : 4012.86
processor : 1
vendor_id : AuthenticAMD
cpu family : 15
model : 65
model name : Dual-Core AMD Opteron(tm) Processor 2212
stepping : 2
cpu MHz : 1995.819
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow pni
bogomips : 3989.52
processor : 2
vendor_id : AuthenticAMD
cpu family : 15
model : 65
model name : Dual-Core AMD Opteron(tm) Processor 2212
stepping : 2
cpu MHz : 1995.819
cache size : 1024 KB
physical id : 1
siblings : 2
core id : 0
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow pni
bogomips : 3989.50
processor : 3
vendor_id : AuthenticAMD
cpu family : 15
model : 65
model name : Dual-Core AMD Opteron(tm) Processor 2212
stepping : 2
cpu MHz : 1995.819
cache size : 1024 KB
physical id : 1
siblings : 2
core id : 1
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow pni
bogomips : 4037.83
1. VPS (unsure of how many share it) through Knownhost.com
2. CPU - 2 x 2GHz Dual-Core AMD Opteron(tm) Processor 2212
RAM - 512 MB min, 2 GB burst
HD - 30 GB, unknown
OS - CentOS 4.4
Apache - 2.2.4
PHP - 5.2.3
MySQL - 5.0.37
3. vb - 3.65 patched
5. Used RPM distro for DirectAdmin. Unsure of compiling options.
6. With 436 on -- (230 members and 206 guests)
top - 11:17:26 up 4 days, 14:11, 1 user, load average: 2.31, 2.71, 2.86
Tasks: 179 total, 6 running, 173 sleeping, 0 stopped, 0 zombie
Cpu(s): 14.7% us, 3.7% sy, 0.0% ni, 80.5% id, 1.1% wa, 0.0% hi, 0.0% si
Mem: 524288k total, 299832k used, 224456k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11859 apache 16 0 85000 25m 18m R 33 5.0 0:19.96 httpd
15964 apache 15 0 83692 23m 18m S 16 4.7 0:09.49 httpd
9675 mysql 16 0 252m 208m 2636 S 10 40.7 3:04.45 mysqld
26595 apache 15 0 83636 21m 15m S 10 4.1 0:04.62 httpd
27723 apache 16 0 83708 21m 15m S 10 4.2 0:05.01 httpd
26581 apache 16 0 86816 25m 17m R 8 4.9 0:05.17 httpd
9579 mysql 15 0 252m 208m 2636 S 6 40.7 3:19.09 mysqld
11280 mysql 15 0 252m 208m 2636 S 4 40.7 3:12.74 mysqld
3208 root 16 0 8612 7568 600 R 4 1.4 1:23.99 lighttpd
30636 apache 15 0 83688 26m 20m S 2 5.1 0:28.16 httpd
21540 apache 16 0 83708 24m 18m S 2 4.8 0:06.70 httpd
26596 apache 16 0 83692 22m 16m S 2 4.4 0:04.41 httpd
27805 apache 15 0 84984 22m 15m R 2 4.4 0:02.99 httpd
1626 apache 16 0 83456 11m 6012 S 2 2.2 0:00.23 httpd
3120 root 15 0 2016 1004 724 R 2 0.2 0:00.01 top
1 root 16 0 1620 600 520 S 0 0.1 0:04.84 init
15709 root 16 0 1524 544 456 S 0 0.1 0:02.58 syslogd
15861 root 16 0 4012 1032 744 S 0 0.2 0:00.00 sshd
15999 root 15 0 2072 812 684 S 0 0.2 0:00.03 xinetd
20096 root 16 0 896 260 224 S 0 0.0 0:07.91 da-popb4smtp
20278 nobody 15 0 6864 1460 1124 S 0 0.3 0:00.32 directadmin
20438 mail 16 0 7260 1168 796 S 0 0.2 0:00.52 exim
22376 ftp 16 0 2396 824 428 S 0 0.2 0:01.87 proftpd
22406 root 16 0 1804 412 320 S 0 0.1 0:00.22 vm-pop3d
22467 root 15 0 2472 924 536 S 0 0.2 0:00.96 crond
22503 root 18 0 4052 804 576 S 0 0.2 0:00.00 saslauthd
22526 root 18 0 4052 464 236 S 0 0.1 0:00.00 saslauthd
5262 named 20 0 68272 3420 1944 S 0 0.7 0:20.19 named
12089 nobody 17 0 6864 604 268 S 0 0.1 0:00.00 directadmin
12180 root 18 0 2144 1132 964 S 0 0.2 0:00.00 mysqld_safe
12224 mysql 15 0 252m 208m 2636 S 0 40.7 1:12.15 mysqld
12226 mysql 16 0 252m 208m 2636 S 0 40.7 0:02.05 mysqld
12227 mysql 16 0 252m 208m 2636 S 0 40.7 3:33.23 mysqld
12238 mysql 15 0 252m 208m 2636 S 0 40.7 8:26.65 mysqld
12241 nobody 17 0 6864 604 268 S 0 0.1 0:00.00 directadmin
12246 nobody 15 0 6864 604 268 S 0 0.1 0:00.00 directadmin
12249 mysql 16 0 252m 208m 2636 S 0 40.7 8:11.18 mysqld
12253 mysql 16 0 252m 208m 2636 S 0 40.7 8:54.22 mysqld
12257 mysql 15 0 252m 208m 2636 S 0 40.7 8:18.66 mysqld
13342 mysql 15 0 252m 208m 2636 S 0 40.7 8:25.13 mysqld
13344 mysql 15 0 252m 208m 2636 S 0 40.7 8:11.37 mysqld
13346 mysql 16 0 252m 208m 2636 S 0 40.7 8:24.77 mysqld
18379 mysql 16 0 252m 208m 2636 S 0 40.7 8:08.87 mysqld
Yes, uptime only 4 days.... That was a big problem with the hosting company, which I'm dealing with. Has nothing to do with server load or anything that I've done.
7.
[mysqld]
skip-locking
skip-innodb
query_cache_limit=8M
query_cache_size=128M
query_cache_type=1
max_connections=500
interactive_timeout=20
wait_timeout=20
connect_timeout=6
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
thread_concurrency=8
myisam_sort_buffer_size=64M
log-slow-queries
[safe_mysqld]
open_files_limit=8192
[mysqldump]
quick
[isamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M
8.
+---------------------------------+-------------------------------------------+
| Variable_name | Value |
+---------------------------------+-------------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| automatic_sp_privileges | ON |
| 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_filesystem | binary |
| 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 |
| completion_type | 0 |
| concurrent_insert | 1 |
| connect_timeout | 6 |
| 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 |
| div_precision_increment | 4 |
| engine_condition_pushdown | OFF |
| 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 | YES |
| have_bdb | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_dynamic_loading | NO |
| have_example_engine | NO |
| have_federated_engine | NO |
| have_geometry | YES |
| have_innodb | DISABLED |
| have_isam | NO |
| have_merge_engine | YES |
| 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_checksums | ON |
| innodb_commit_concurrency | 0 |
| innodb_concurrency_tickets | 500 |
| innodb_data_file_path | |
| innodb_data_home_dir | |
| innodb_doublewrite | ON |
| innodb_fast_shutdown | 1 |
| 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_rollback_on_timeout | OFF |
| innodb_support_xa | ON |
| innodb_sync_spin_loops | 20 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| innodb_thread_sleep_delay | 10000 |
| interactive_timeout | 20 |
| 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 |
| large_page_size | 0 |
| large_pages | OFF |
| lc_time_names | en_US |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_bin_trust_function_creators | OFF |
| log_error | |
| log_queries_not_using_indexes | OFF |
| log_slave_updates | OFF |
| log_slow_queries | ON |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 16776192 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 500 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 18446744073709551615 |
| 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_sp_recursion_depth | 0 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| multi_range_count | 256 |
| myisam_data_pointer_size | 6 |
| 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 | 2558 |
| optimizer_prune_level | 1 |
| optimizer_search_depth | 62 |
| pid_file | /var/lib/mysql/ns1.webkinzinsider.com.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| profiling | OFF |
| profiling_history_size | 15 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 8388608 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 134217728 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 2093056 |
| 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_compressed_protocol | OFF |
| slave_load_tmpdir | /tmp/ |
| slave_net_timeout | 3600 |
| slave_skip_errors | OFF |
| slave_transaction_retries | 10 |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_big_selects | ON |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | OFF |
| ssl_ca | |
| ssl_capath | |
| ssl_cert | |
| ssl_cipher | |
| ssl_key | |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| system_time_zone | EDT |
| table_cache | 1024 |
| table_lock_wait_timeout | 50 |
| table_type | MyISAM |
| thread_cache_size | 128 |
| thread_stack | 126976 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| timed_mutexes | OFF |
| tmp_table_size | 33554432 |
| tmpdir | /tmp/ |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| updatable_views_with_limit | YES |
| version | 5.0.37-standard-log |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 20 |
+---------------------------------+-------------------------------------------+
+-----------------------------------+------------+
| Variable_name | Value |
+-----------------------------------+------------+
| Aborted_clients | 808 |
| Aborted_connects | 5 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 2720683217 |
| Bytes_sent | 3203697464 |
| Com_admin_commands | 1 |
| Com_alter_db | 0 |
| Com_alter_table | 6 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 1116727 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 1 |
| Com_create_user | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 325000 |
| 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 | 359532 |
| Com_insert_select | 17 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 12157 |
| 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 | 84033 |
| 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 | 19226981 |
| Com_set_option | 163439 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 6 |
| Com_show_charsets | 208 |
| Com_show_collations | 208 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 54 |
| Com_show_databases | 208 |
| Com_show_errors | 0 |
| Com_show_fields | 202 |
| Com_show_grants | 113 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 83 |
| 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 | 4 |
| Com_show_tables | 404 |
| Com_show_triggers | 0 |
| Com_show_variables | 477 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 24 |
| Com_unlock_tables | 12157 |
| Com_update | 1641563 |
| Com_update_multi | 0 |
| Com_xa_commit | 0 |
| Com_xa_end | 0 |
| Com_xa_prepare | 0 |
| Com_xa_recover | 0 |
| Com_xa_rollback | 0 |
| Com_xa_start | 0 |
| Compression | OFF |
| Connections | 1100040 |
| Created_tmp_disk_tables | 287545 |
| Created_tmp_files | 72546 |
| Created_tmp_tables | 834710 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 173019 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 878072 |
| Handler_read_key | 323645676 |
| Handler_read_next | 1125607476 |
| Handler_read_prev | 4038418 |
| Handler_read_rnd | 19331876 |
| Handler_read_rnd_next | 2410684438 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 21685772 |
| Handler_write | 63319078 |
| Innodb_buffer_pool_pages_data | 0 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 0 |
| Innodb_buffer_pool_pages_free | 0 |
| Innodb_buffer_pool_pages_latched | 0 |
| Innodb_buffer_pool_pages_misc | 0 |
| Innodb_buffer_pool_pages_total | 0 |
| Innodb_buffer_pool_read_ahead_rnd | 0 |
| Innodb_buffer_pool_read_ahead_seq | 0 |
| Innodb_buffer_pool_read_requests | 0 |
| Innodb_buffer_pool_reads | 0 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 0 |
| Innodb_data_fsyncs | 0 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 0 |
| Innodb_data_reads | 0 |
| Innodb_data_writes | 0 |
| Innodb_data_written | 0 |
| Innodb_dblwr_pages_written | 0 |
| Innodb_dblwr_writes | 0 |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 0 |
| Innodb_log_writes | 0 |
| Innodb_os_log_fsyncs | 0 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 0 |
| Innodb_page_size | 0 |
| Innodb_pages_created | 0 |
| Innodb_pages_read | 0 |
| Innodb_pages_written | 0 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 0 |
| Innodb_row_lock_time_avg | 0 |
| Innodb_row_lock_time_max | 0 |
| Innodb_row_lock_waits | 0 |
| Innodb_rows_deleted | 0 |
| Innodb_rows_inserted | 0 |
| Innodb_rows_read | 0 |
| Innodb_rows_updated | 0 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 0 |
| Key_blocks_used | 14497 |
| Key_read_requests | 1046437720 |
| Key_reads | 1393356 |
| Key_write_requests | 3204499 |
| Key_writes | 2192223 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 269 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 1243 |
| Open_streams | 0 |
| Open_tables | 1024 |
| Opened_tables | 1775 |
| Prepared_stmt_count | 0 |
| Qcache_free_blocks | 14693 |
| Qcache_free_memory | 70719328 |
| Qcache_hits | 16040167 |
| Qcache_inserts | 8796854 |
| Qcache_lowmem_prunes | 62658 |
| Qcache_not_cached | 10421574 |
| Qcache_queries_in_cache | 25956 |
| Qcache_total_blocks | 67730 |
| Questions | 40085844 |
| Rpl_status | NULL |
| Select_full_join | 1763 |
| Select_full_range_join | 0 |
| Select_range | 852799 |
| Select_range_check | 2 |
| Select_scan | 1111291 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 1 |
| Slow_queries | 58 |
| Sort_merge_passes | 36273 |
| Sort_range | 962551 |
| Sort_rows | 561043965 |
| Sort_scan | 844056 |
| Table_locks_immediate | 18452527 |
| Table_locks_waited | 162076 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 127 |
| Threads_connected | 1 |
| Threads_created | 269 |
| Threads_running | 1 |
| Uptime | 167899 |
| Uptime_since_flush_status | 167899 |
+-----------------------------------+------------+
Uptime: 167899 Threads: 1 Questions: 40085845 Slow queries: 58 Opens: 1775 Flush tables: 1 Open tables: 1024 Queries per second avg: 238.750
mysqladmin Ver 8.41 Distrib 5.0.37, for pc-linux-gnu on i686
Copyright (C) 2000-2006 MySQL 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 5.0.37-standard-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 day 22 hours 38 min 19 sec
Threads: 1 Questions: 40085845 Slow queries: 58 Opens: 1775 Flush tables: 1 Open tables: 1024 Queries per second avg: 238.750
9. No, just completed an installation of Joomla for the front end. Using bbpixel's bridge to bridge the user info/login data.
10. Always increasing
Average users (combined members & guests): 300
Max concurrent: 669.
11. www.webkinzinsider.com/phpinfo.php
12.
KeepAlive Off
MaxKeepAliveRequests 20
KeepAliveTimeout 1
StartServers 5
MinSpareServers 5
MaxSpareServers 10
MaxClients 256
MaxRequestsPerChild 0
13. Nope, use cronolog to rotate logs.
14.
[root@ns1 conf]# uname -a
Linux ns1.webkinzinsider.com 2.6.9-023stab043.1-entnosplit #1 SMP Mon Mar 5 17:17:22 MSK 2007 i686 athlon i386 GNU/Linux
[root@ns1 conf]# ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 73728
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
[root@ns1 conf]# cat /proc/cpuinfo
processor : 0
vendor_id : AuthenticAMD
cpu family : 15
model : 65
model name : Dual-Core AMD Opteron(tm) Processor 2212
stepping : 2
cpu MHz : 1995.819
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow pni
bogomips : 4012.86
processor : 1
vendor_id : AuthenticAMD
cpu family : 15
model : 65
model name : Dual-Core AMD Opteron(tm) Processor 2212
stepping : 2
cpu MHz : 1995.819
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow pni
bogomips : 3989.52
processor : 2
vendor_id : AuthenticAMD
cpu family : 15
model : 65
model name : Dual-Core AMD Opteron(tm) Processor 2212
stepping : 2
cpu MHz : 1995.819
cache size : 1024 KB
physical id : 1
siblings : 2
core id : 0
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow pni
bogomips : 3989.50
processor : 3
vendor_id : AuthenticAMD
cpu family : 15
model : 65
model name : Dual-Core AMD Opteron(tm) Processor 2212
stepping : 2
cpu MHz : 1995.819
cache size : 1024 KB
physical id : 1
siblings : 2
core id : 1
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow pni
bogomips : 4037.83