
04-15-2008, 02:43 PM
|
| Junior Member | | Real Name: Fenriz Join Date: Oct 2006 Location: Norway
Posts: 19
| |
| Server Optimization Request. 1CPU, 512Mb dedicated. I've just moved to a dedicated from shared hosting. I am a newbie and think my new dedicated server need some good optimization. Any help is much appreciated.
My forum installed on Скандинавский Информационный Центр - Форумы http://www.ulver.com/info.php
Dedicated with three sites. One dinamic vbulletin+vbdrupal and 2 overs some static html pages. Specs are:
1CPU Celeron 2.4GHz
512mb ram
250GB EIDE non raid
Fedora 7 (Linux ulver.com 2.6.23.15-80.fc7 #1 SMP Sun Feb 10 17:29:10 EST 2008 i686 i686 i386 GNU/Linux)
apache 2.2.8
php 5.2.4
mysql 5.0.45
xcache 1.2.2 installed as a zend_extension, xcache used as a datastore, Template Cache hack, usepconnect. vB 3.6.9 vbSEO 3.1 Top stats: Quote:
top - 04:57:39 up 9 days, 14:01, 2 users, load average: 1.39, 0.81, 0.64
Tasks: 143 total, 1 running, 142 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.3%us, 0.0%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 507036k total, 495928k used, 11108k free, 1420k buffers
Swap: 2096472k total, 560368k used, 1536104k free, 57272k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5382 root 20 0 2256 956 740 R 0.3 0.2 0:02.43 top
1 root 20 0 2136 476 456 S 0.0 0.1 0:08.48 init
2 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 kthreadd
3 root RT -5 0 0 0 S 0.0 0.0 0:00.00 migration/0
4 root 15 -5 0 0 0 S 0.0 0.0 0:00.39 ksoftirqd/0
5 root RT -5 0 0 0 S 0.0 0.0 0:00.01 watchdog/0
6 root 15 -5 0 0 0 S 0.0 0.0 0:05.40 events/0
7 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 khelper
57 root 15 -5 0 0 0 S 0.0 0.0 0:04.40 kblockd/0
60 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 kacpid
61 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 kacpi_notify
143 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/0
145 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 ksuspend_usbd
151 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 khubd
154 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 kseriod
191 root 15 -5 0 0 0 S 0.0 0.0 0:55.09 kswapd0
242 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 aio/0
330 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 khvcd
397 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 kpsmoused
422 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 ata/0
423 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 ata_aux
426 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
427 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1
435 root 15 -5 0 0 0 S 0.0 0.0 1:15.99 kjournald
467 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 kauditd
504 root 16 -4 2920 328 328 S 0.0 0.1 0:00.43 udevd
845 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 kgameportd
977 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 kmpathd/0
1002 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 kjournald
1546 root 20 0 10900 544 520 S 0.0 0.1 0:00.15 restorecond
1561 root 20 0 1800 520 452 S 0.0 0.1 0:11.88 syslogd
1564 root 20 0 1740 376 328 S 0.0 0.1 0:01.95 klogd
1599 root 20 0 2232 432 372 S 0.0 0.1 0:01.60 mcstransd
1615 dbus 20 0 13068 620 524 S 0.0 0.1 0:00.03 dbus-daemon
1662 root 20 0 6156 724 620 S 0.0 0.1 0:11.00 automount
1689 root 20 0 5396 540 540 S 0.0 0.1 0:01.55 sshd
1741 root 20 0 4684 464 464 S 0.0 0.1 0:00.01 mysqld_safe
1801 mysql 20 0 170m 24m 2980 S 0.0 5.0 144:12.83 mysqld
1830 root 20 0 1948 332 284 S 0.0 0.1 0:17.84 dovecot
| httpd.conf: Quote:
Timeout 120 KeepAlive On MaxKeepAliveRequests 0 KeepAliveTimeout 15 StartServers 16 MinSpareServers 16 MaxSpareServers 64 ServerLimit 256 MaxClients 256 MaxRequestsPerChild 4000 | ulimit -aH Quote:
core file size (blocks, -c) unlimited data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 8063 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 real-time priority (-r) 0 stack size (kbytes, -s) unlimited cpu time (seconds, -t) unlimited max user processes (-u) 8063 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited | MySQL Variables Quote: Variable_name Value auto_increment_increment 1 auto_increment_offset 1 automatic_sp_privileges ON back_log 50 basedir /usr/ bdb_cache_size 8388600 bdb_home /var/lib/mysql/ bdb_log_buffer_size 102400 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 utf8 character_set_connection utf8 character_set_database latin1 character_set_filesystem binary character_set_results utf8 character_set_server latin1 character_set_system utf8 character_sets_dir /usr/share/mysql/charsets/ collation_connection utf8_general_ci collation_database latin1_swedish_ci collation_server latin1_swedish_ci completion_type 0 concurrent_insert 1 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 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 NO have_bdb YES have_blackhole_engine NO have_compress YES have_crypt YES have_csv NO have_dynamic_loading YES have_example_engine NO have_federated_engine NO have_geometry YES have_innodb YES have_isam NO have_merge_engine YES have_ndbcluster NO have_openssl DISABLED have_ssl DISABLED have_query_cache YES have_raid NO have_rtree_keys YES have_symlink YES hostname 69-64-71-172.dedicated.abac.net 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 ibdata1:10M:autoextend 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 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 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 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 33553408 max_binlog_cache_size 4294967295 max_binlog_size 1073741824 max_connect_errors 10 max_connections 100 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_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 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 optimizer_prune_level 1 optimizer_search_depth 62 pid_file /var/run/mysqld/mysqld.pid port 3306 preload_buffer_size 32768 profiling OFF profiling_history_size 15 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 secure_file_priv 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 PDT table_cache 200 table_lock_wait_timeout 50 table_type MyISAM thread_cache_size 0 thread_stack 196608 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.45 version_bdb Sleepycat Software: Berkeley DB 4.1.24: (July 4, 2007) version_comment Source distribution version_compile_machine i386 version_compile_os redhat-linux-gnu wait_timeout 28800 |
8) MySQL Status Quote: Variable_name Value Aborted_clients 6 Aborted_connects 613 Binlog_cache_disk_use 0 Binlog_cache_use 0 Bytes_received 1404296207 Bytes_sent 3352744183 Com_admin_commands 4863 Com_alter_db 0 Com_alter_table 0 Com_analyze 0 Com_backup_table 0 Com_begin 0 Com_call_procedure 0 Com_change_db 226058 Com_change_master 0 Com_check 0 Com_checksum 0 Com_commit 1 Com_create_db 3 Com_create_function 0 Com_create_index 0 Com_create_table 1164 Com_create_user 0 Com_dealloc_sql 0 Com_delete 8175 Com_delete_multi 217 Com_do 0 Com_drop_db 1 Com_drop_function 0 Com_drop_index 0 Com_drop_table 1021 Com_drop_user 0 Com_execute_sql 0 Com_flush 8 Com_grant 3 Com_ha_close 0 Com_ha_open 0 Com_ha_read 0 Com_help 0 Com_insert 181017 Com_insert_select 896 Com_kill 0 Com_load 0 Com_load_master_data 0 Com_load_master_table 0 Com_lock_tables 559 Com_optimize 2052 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 17254 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 3564345 Com_set_option 279259 Com_show_binlog_events 0 Com_show_binlogs 0 Com_show_charsets 1 Com_show_collations 0 Com_show_column_types 0 Com_show_create_db 0 Com_show_create_table 0 Com_show_databases 50 Com_show_errors 0 Com_show_fields 255 Com_show_grants 0 Com_show_innodb_status 0 Com_show_keys 63 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 1 Com_show_slave_hosts 0 Com_show_slave_status 0 Com_show_status 3 Com_show_storage_engines 0 Com_show_tables 43 Com_show_triggers 0 Com_show_variables 10339 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 868 Com_unlock_tables 880 Com_update 153996 Com_update_multi 868 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 224953 Created_tmp_disk_tables 175285 Created_tmp_files 17222 Created_tmp_tables 258015 Delayed_errors 0 Delayed_insert_threads 0 Delayed_writes 0 Flush_commands 1 Handler_commit 0 Handler_delete 99424 Handler_discover 0 Handler_prepare 0 Handler_read_first 319765 Handler_read_key 165042224 Handler_read_next 103971742 Handler_read_prev 1743159 Handler_read_rnd 6049591 Handler_read_rnd_next 831767399 Handler_rollback 0 Handler_savepoint 0 Handler_savepoint_rollback 0 Handler_update 46523951 Handler_write 58548956 Innodb_buffer_pool_pages_data 151 Innodb_buffer_pool_pages_dirty 0 Innodb_buffer_pool_pages_flushed 1 Innodb_buffer_pool_pages_free 361 Innodb_buffer_pool_pages_latched 0 Innodb_buffer_pool_pages_misc 0 Innodb_buffer_pool_pages_total 512 Innodb_buffer_pool_read_ahead_rnd 5 Innodb_buffer_pool_read_ahead_seq 0 Innodb_buffer_pool_read_requests 5575 Innodb_buffer_pool_reads 108 Innodb_buffer_pool_wait_free 0 Innodb_buffer_pool_write_requests 1 Innodb_data_fsyncs 7 Innodb_data_pending_fsyncs 0 Innodb_data_pending_reads 0 Innodb_data_pending_writes 0 Innodb_data_read 4657152 Innodb_data_reads 128 Innodb_data_writes 7 Innodb_data_written 35328 Innodb_dblwr_pages_written 1 Innodb_dblwr_writes 1 Innodb_log_waits 0 Innodb_log_write_requests 0 Innodb_log_writes 2 Innodb_os_log_fsyncs 5 Innodb_os_log_pending_fsyncs 0 Innodb_os_log_pending_writes 0 Innodb_os_log_written 1024 Innodb_page_size 16384 Innodb_pages_created 0 Innodb_pages_read 151 Innodb_pages_written 1 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 727 Innodb_rows_updated 0 Key_blocks_not_flushed 0 Key_blocks_unused 0 Key_blocks_used 7248 Key_read_requests 207366984 Key_reads 1331582 Key_write_requests 1770619 Key_writes 460933 Last_query_cost 0.000000 Max_used_connections 41 Not_flushed_delayed_rows 0 Open_files 364 Open_streams 0 Open_tables 198 Opened_tables 15504 Prepared_stmt_count 0 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 4673764 Rpl_status NULL Select_full_join 211 Select_full_range_join 0 Select_range 997155 Select_range_check 0 Select_scan 402921 Slave_open_temp_tables 0 Slave_retried_transactions 0 Slave_running OFF Slow_launch_threads 0 Slow_queries 0 Sort_merge_passes 8594 Sort_range 597701 Sort_rows 45526752 Sort_scan 270223 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 5971479 Table_locks_waited 114 Tc_log_max_pages_used 0 Tc_log_page_size 0 Tc_log_page_waits 0 Threads_cached 0 Threads_connected 11 Threads_created 224952 Threads_running 1 Uptime 783664 Uptime_since_flush_status 783664 | I am a newbie and think my new dedicated server need some good optimization. Any help is much appreciated. |