Server Optimizing Request

محروم.كوم · #1 05-01-2009, 01:40 PM

<div>1. Using dedicated server

2. Intel Xeon 3220-Quad Core [2.4GHz]
RAM : 2GB DDR2
HDD : 2 x 250 GB SATA II
OS : CentOS 5.x 64 bit
apache Version: Apache/2.2.11
PHP Version 5.2.9
MySQL version: mysql 5.0.77

3. Running VB 3.8.2
4 NO InnoDB

5. As an external module.

6. TOP :

Quote:
top - 02:43:45 up 4:44, 1 user, load average: 0.58, 0.61, 0.55
Tasks: 153 total, 2 running, 149 sleeping, 0 stopped, 2 zombie
Cpu(s): 2.4%us, 0.5%sy, 0.0%ni, 96.8%id, 0.1%wa, 0.1%hi, 0.2%si, 0.0%st
Mem: 2075308k total, 1739688k used, 335620k free, 118308k buffers
Swap: 2096472k total, 92k used, 2096380k free, 1165684k cached
7. my.cnf Contents

Quote:
Aborted_clients 2
Aborted_connects 0
Binlog_cache_disk_use 0
Binlog_cache_use 0
Bytes_received 95248025
Bytes_sent 706727868
Com_admin_commands 15657
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 31047
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 45
Com_create_user 0
Com_dealloc_sql 45
Com_delete 1603
Com_delete_multi 2
Com_do 0
Com_drop_db 0
Com_drop_function 0
Com_drop_index 0
Com_drop_table 45
Com_drop_user 0
Com_execute_sql 45
Com_flush 0
Com_grant 0
Com_ha_close 0
Com_ha_open 0
Com_ha_read 0
Com_help 0
Com_insert 15049
Com_insert_select 101
Com_kill 0
Com_load 0
Com_load_master_data 0
Com_load_master_table 0
Com_lock_tables 7853
Com_optimize 0
Com_preload_keys 0
Com_prepare_sql 45
Com_purge 0
Com_purge_before_date 0
Com_rename_table 0
Com_repair 0
Com_replace 1452
Com_replace_select 56
Com_reset 0
Com_restore_table 0
Com_revoke 0
Com_revoke_all 0
Com_rollback 0
Com_savepoint 0
Com_select 103900
Com_set_option 242
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 0
Com_show_databases 0
Com_show_errors 0
Com_show_fields 142
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 62
Com_show_slave_hosts 0
Com_show_slave_status 0
Com_show_status 156

Com_show_storage_engines 0
Com_show_tables 0
Com_show_triggers 0
Com_show_variables 4
Com_show_warnings 0
Com_slave_start 0
Com_slave_stop 0
Com_stmt_close 45
Com_stmt_execute 45
Com_stmt_fetch 0
Com_stmt_prepare 45
Com_stmt_reset 0
Com_stmt_send_long_data 0
Com_truncate 17
Com_unlock_tables 7853
Com_update 27551
Com_update_multi 62
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 17996
Created_tmp_disk_tables 802
Created_tmp_files 46
Created_tmp_tables 2429
Delayed_errors 0
Delayed_insert_threads 0
Delayed_writes 0
Flush_commands 1
Handler_commit 0
Handler_delete 12512
Handler_discover 0
Handler_prepare 0
Handler_read_first 3308
Handler_read_key 20242396
Handler_read_next 21174173
Handler_read_prev 37591
Handler_read_rnd 1294572
Handler_read_rnd_next 45313285
Handler_rollback 0
Handler_savepoint 0
Handler_savepoint_rollback 0
Handler_update 6815582
Handler_write 1379401
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_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 260257
Key_blocks_used 88643
Key_read_requests 41199510
Key_reads 88741
Key_write_requests 87078
Key_writes 49529
Last_query_cost 0.000000
Max_used_connections 44
Ndb_cluster_node_id 0
Ndb_config_from_host
Ndb_config_from_port 0
Ndb_number_of_data_nodes 0
Not_flushed_delayed_rows 0
Open_files 990
Open_streams 0
Open_tables 551
Opened_tables 681
Prepared_stmt_count 0
Qcache_free_blocks 1344
Qcache_free_memory 5950688
Qcache_hits 158322
Qcache_inserts 100725
Qcache_lowmem_prunes 0
Qcache_not_cached 3186
Qcache_queries_in_cache 4548
Qcache_total_blocks 11186
Queries 374040
Questions 374040
Rpl_status NULL
Select_full_join 154
Select_full_range_join 0
Select_range 17817
Select_range_check 0
Select_scan 17829
Slave_open_temp_tables 0
Slave_retried_transactions 0
Slave_running OFF
Slow_launch_threads 0
Slow_queries 10
Sort_merge_passes 23
Sort_range 20388
Sort_rows 4499634
Sort_scan 4500
Table_locks_immediate 289083
Table_locks_waited 202
Tc_log_max_pages_used 0
Tc_log_page_size 0
Tc_log_page_waits 0
Threads_cached 7
Threads_connected 1
Threads_created 44
Threads_running 1
Uptime 9334
Uptime_since_flush_status 374040
8. MySQL Stats:

<div style="margin:20px; margin-top:5px; "> Quote:
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 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
div_precision_increment 4
keep_files_on_create OFF
engine_condition_pushdown OFF
expire_logs_days 0
flush OFF
flush_time 0
ft_boolean_syntax + -> __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
Server Optimizing Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-18-2009 09:10 PM
Server Optimizing Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-14-2009 01:30 PM
Server Optimizing Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-11-2009 01:30 AM
Server Optimizing Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-02-2009 11:10 AM
Server Optimizing Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-01-2009 03:00 PM