求解
近日用Webserver Stress Tool 7做网站压力测试，只压到50人的点击，网站页面就反应迟缓了，通过show status 查看数据库的状态，但是不知道哪有问题，希望有经验的朋友，能帮助分析一下。用的是innodb引擎，会不会是死锁了呢？或者是其他什么原因？下面是我的数据库状态值
Variable_nameValue
Aborted_clients0
Aborted_connects0
Binlog_cache_disk_use0
Binlog_cache_use0
Bytes_received299
Bytes_sent44158
CompressionOFF
Connections3013
Created_tmp_disk_tables0
Created_tmp_files5
Created_tmp_tables1
Delayed_errors0
Delayed_insert_threads0
Delayed_writes0
Flush_commands1
Handler_commit0
Handler_delete0
Handler_discover0
Handler_prepare0
Handler_read_first0
Handler_read_key0
Handler_read_next0
Handler_read_prev0
Handler_read_rnd0
Handler_read_rnd_next2
Handler_rollback0
Handler_savepoint0
Handler_savepoint_rollback0
Handler_update0
Handler_write1
Innodb_buffer_pool_pages_data960
Innodb_buffer_pool_pages_dirty0
Innodb_buffer_pool_pages_flushed24
Innodb_buffer_pool_pages_free14198
Innodb_buffer_pool_pages_misc10
Innodb_buffer_pool_pages_total15168
Innodb_buffer_pool_read_ahead_rnd5
Innodb_buffer_pool_read_ahead_seq0
Innodb_buffer_pool_read_requests268531
Innodb_buffer_pool_reads708
Innodb_buffer_pool_wait_free0
Innodb_buffer_pool_write_requests1163
Innodb_data_fsyncs26
Innodb_data_pending_fsyncs0
Innodb_data_pending_reads0
Innodb_data_pending_writes0
Innodb_data_read17829888
Innodb_data_reads965
Innodb_data_writes43
Innodb_data_written936448
Innodb_dblwr_pages_written24
Innodb_dblwr_writes5
Innodb_log_waits0
Innodb_log_write_requests474
Innodb_log_writes7
Innodb_os_log_fsyncs14
Innodb_os_log_pending_fsyncs0
Innodb_os_log_pending_writes0
Innodb_os_log_written146432
Innodb_page_size16384
Innodb_pages_created5
Innodb_pages_read955
Innodb_pages_written24
Innodb_row_lock_current_waits0
Innodb_row_lock_time0
Innodb_row_lock_time_avg0
Innodb_row_lock_time_max0
Innodb_row_lock_waits0
Innodb_rows_deleted0
Innodb_rows_inserted216
Innodb_rows_read1722907
Innodb_rows_updated2
Key_blocks_not_flushed0
Key_blocks_unused109352
Key_blocks_used0
Key_read_requests0
Key_reads0
Key_write_requests0
Key_writes0
Last_query_cost10.499000
Max_used_connections38
Not_flushed_delayed_rows0
Open_files16
Open_streams0
Open_table_definitions54
Open_tables51
Opened_files101
Opened_table_definitions0
Opened_tables0
Prepared_stmt_count0
Qcache_free_blocks1
Qcache_free_memory83701872
Qcache_hits2120
Qcache_inserts79
Qcache_lowmem_prunes0
Qcache_not_cached174
Qcache_queries_in_cache77
Qcache_total_blocks183
Queries9044
Questions11
Rpl_statusNULL
Select_full_join0
Select_full_range_join0
Select_range0
Select_range_check0
Select_scan1
Slave_open_temp_tables0
Slave_retried_transactions0
Slave_runningOFF
Slow_launch_threads0
Slow_queries0
Sort_merge_passes0
Sort_range0
Sort_rows0
Sort_scan0
Ssl_accept_renegotiates0
Ssl_accepts0
Ssl_callback_cache_hits0
Ssl_cipher
Ssl_cipher_list
Ssl_client_connects0
Ssl_connect_renegotiates0
Ssl_ctx_verify_depth0
Ssl_ctx_verify_mode0
Ssl_default_timeout0
Ssl_finished_accepts0
Ssl_finished_connects0
Ssl_session_cache_hits0
Ssl_session_cache_misses0
Ssl_session_cache_modeNONE
Ssl_session_cache_overflows0
Ssl_session_cache_size0
Ssl_session_cache_timeouts0
Ssl_sessions_reused0
Ssl_used_session_cache_entries0
Ssl_verify_depth0
Ssl_verify_mode0
Ssl_version
Table_locks_immediate590
Table_locks_waited0
Tc_log_max_pages_used0
Tc_log_page_size0
Tc_log_page_waits0
Threads_cached37
Threads_connected1
Threads_created38
Threads_running1
Uptime572
Uptime_since_flush_status572
页:
[1]