DB서버 : Fedora7.0 + MySql 5.0.45
웹서버 : Fedora7.0 + Apache2 + Tomcat5.5
사용중입니다.
DB서버와 웹서버는 IDC에 서로 연결된 상태입니다.
문제는..
웹서버에 MySql을 설치하고 사이트를 띄우면 정상적인 속도로
아무런 문제가 없습니다만.. (DB서버 와 웹 서버를 서버 한대에서 운영할때요..)
웹서버와 MySql을 분리해서 ip로 커넥션을 연결해서 사용하면
쿼리 응답속도가 눈에띄게 매우 느려집니다. (DB서버 와 웹 서버를 분리했을때..)
정상적인 운영이 불가능할 정도이지요..
/etc/hosts 파일에 등록도 했고,
skip-name-resolve 도 설정을 한 상태 입니다.
초기 커넥션 연결시간이 지연되는것 같지는 않습니다.
커넥션 풀을 사용하는데, 커넥션을 하나 끊으면 바로 새로 생성되더군요.
데이터도 10개 미만이라서.. 쿼리 최적화와는 별개라 봅니다.
게시판을 검색해보니 비슷한 문제들이 있었는데,
답변들이 없기에.. 저도 비슷한 질문이지만 올려봅니다..
문제될만한 추측 가능한 어떤 점이 있을지...
경험하시거나, 아시는 고수님들 조언 부탁 드리겠습니다.
show status;
Variable_name Value
--------------------------------- ---------
Aborted_clients 6
Aborted_connects 1
Binlog_cache_disk_use 0
Binlog_cache_use 8
Bytes_received 891
Bytes_sent 9046
Com_admin_commands 0
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 1
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 0
Com_create_user 0
Com_dealloc_sql 0
Com_delete 0
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 0
Com_insert_select 0
Com_kill 0
Com_load 0
Com_load_master_data 0
Com_load_master_table 0
Com_lock_tables 0
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 0
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 1
Com_set_option 4
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 2
Com_show_databases 1
Com_show_errors 0
Com_show_fields 3
Com_show_grants 0
Com_show_innodb_status 0
Com_show_keys 5
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 0
Com_show_triggers 0
Com_show_variables 1
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 0
Com_unlock_tables 0
Com_update 0
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 23
Created_tmp_disk_tables 3
Created_tmp_files 5
Created_tmp_tables 12
Delayed_errors 0
Delayed_insert_threads 0
Delayed_writes 0
Flush_commands 1
Handler_commit 0
Handler_delete 0
Handler_discover 0
Handler_prepare 0
Handler_read_first 0
Handler_read_key 46
Handler_read_next 0
Handler_read_prev 0
Handler_read_rnd 0
Handler_read_rnd_next 90
Handler_rollback 0
Handler_savepoint 0
Handler_savepoint_rollback 0
Handler_update 0
Handler_write 211
Innodb_buffer_pool_pages_data 128
Innodb_buffer_pool_pages_dirty 0
Innodb_buffer_pool_pages_flushed 35
Innodb_buffer_pool_pages_free 24447
Innodb_buffer_pool_pages_latched 0
Innodb_buffer_pool_pages_misc 1
Innodb_buffer_pool_pages_total 24576
Innodb_buffer_pool_read_ahead_rnd 2
Innodb_buffer_pool_read_ahead_seq 0
Innodb_buffer_pool_read_requests 50449
Innodb_buffer_pool_reads 26
Innodb_buffer_pool_wait_free 0
Innodb_buffer_pool_write_requests 61
Innodb_data_fsyncs 55
Innodb_data_pending_fsyncs 0
Innodb_data_pending_reads 0
Innodb_data_pending_writes 0
Innodb_data_read 4280320
Innodb_data_reads 45
Innodb_data_writes 70
Innodb_data_written 1167360
Innodb_dblwr_pages_written 35
Innodb_dblwr_writes 10
Innodb_log_waits 0
Innodb_log_write_requests 7
Innodb_log_writes 21
Innodb_os_log_fsyncs 33
Innodb_os_log_pending_fsyncs 0
Innodb_os_log_pending_writes 0
Innodb_os_log_written 14336
Innodb_page_size 16384
Innodb_pages_created 0
Innodb_pages_read 128
Innodb_pages_written 35
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 18464
Innodb_rows_updated 8
Key_blocks_not_flushed 0
Key_blocks_unused 348841
Key_blocks_used 59
Key_read_requests 1747
Key_reads 59
Key_write_requests 9
Key_writes 4
Last_query_cost 10.499000
Max_used_connections 4
Not_flushed_delayed_rows 0
Open_files 85
Open_streams 0
Open_tables 65
Opened_tables 36
Prepared_stmt_count 0
Qcache_free_blocks 1
Qcache_free_memory 33353560
Qcache_hits 146
Qcache_inserts 85
Qcache_lowmem_prunes 0
Qcache_not_cached 535
Qcache_queries_in_cache 82
Qcache_total_blocks 175
Questions 3976
Rpl_status NULL
Select_full_join 0
Select_full_range_join 0
Select_range 0
Select_range_check 0
Select_scan 12
Slave_open_temp_tables 0
Slave_retried_transactions 0
Slave_running OFF
Slow_launch_threads 0
Slow_queries 0
Sort_merge_passes 0
Sort_range 0
Sort_rows 0
Sort_scan 0
Table_locks_immediate 1121
Table_locks_waited 0
Tc_log_max_pages_used 0
Tc_log_page_size 0
Tc_log_page_waits 0
Threads_cached 3
Threads_connected 1
Threads_created 4
Threads_running 1
Uptime 6905
Uptime_since_flush_status 6905
|