This is mysql status and peocess list log: mysql> show status; +----------------------------+------------+ | Variable_name | Value | +----------------------------+------------+ | Aborted_clients | 222551 | | Aborted_connects | 892 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 0 | | Bytes_received | 2160195433 | | Bytes_sent | 729218894 | | Com_admin_commands | 15998 | | Com_alter_db | 0 | | Com_alter_table | 0 | | Com_analyze | 0 | | Com_backup_table | 0 | | Com_begin | 0 | | Com_change_db | 673946 | | Com_change_master | 0 | | Com_check | 522 | | Com_checksum | 0 | | Com_commit | 0 | | Com_create_db | 0 | | Com_create_function | 0 | | Com_create_index | 0 | | Com_create_table | 0 | | Com_dealloc_sql | 0 | | Com_delete | 29647 | | Com_delete_multi | 0 | | Com_do | 0 | | Com_drop_db | 0 | | Com_drop_function | 0 | | Com_drop_index | 0 | | Com_drop_table | 1 | | Com_drop_user | 0 | | Com_execute_sql | 0 | | Com_flush | 9 | | Com_grant | 16 | | Com_ha_close | 0 | | Com_ha_open | 0 | | Com_ha_read | 0 | | Com_help | 0 | | Com_insert | 7685 | | Com_insert_select | 0 | | Com_kill | 138659 | | Com_load | 0 | | Com_load_master_data | 0 | | Com_load_master_table | 0 | | Com_lock_tables | 0 | | Com_optimize | 2 | | 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 | 2215438 | | Com_set_option | 513 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 90 | | Com_show_charsets | 103 | | Com_show_collations | 103 | | Com_show_column_types | 0 | | Com_show_create_db | 4 | | Com_show_create_table | 104 | | Com_show_databases | 10 | | Com_show_errors | 0 | | Com_show_fields | 50 | | Com_show_grants | 8 | | 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 | 53722 | | Com_show_slave_hosts | 0 | | Com_show_slave_status | 0 | | Com_show_status | 13 | | Com_show_storage_engines | 0 | | Com_show_tables | 78 | | Com_show_variables | 212 | | Com_show_warnings | 0 | | Com_slave_start | 0 | | Com_slave_stop | 0 | | Com_stmt_close | 0 | | Com_stmt_execute | 0 | | Com_stmt_prepare | 0 | | Com_stmt_reset | 0 | | Com_stmt_send_long_data | 0 | | Com_truncate | 0 | | Com_unlock_tables | 0 | | Com_update | 270089 | | Com_update_multi | 0 | | Connections | 433488 | | Created_tmp_disk_tables | 179911 | | Created_tmp_files | 0 | | Created_tmp_tables | 1489003 | | Delayed_errors | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Flush_commands | 1 | | Handler_commit | 0 | | Handler_delete | 790 | | Handler_discover | 0 | | Handler_read_first | 51608 | | Handler_read_key | 1211448640 | | Handler_read_next | 1425761034 | | Handler_read_prev | 67086052 | | Handler_read_rnd | 18226111 | | Handler_read_rnd_next | 198115306 | | Handler_rollback | 0 | | Handler_update | 1330864 | | Handler_write | 182461241 | | Key_blocks_not_flushed | 0 | | Key_blocks_unused | 420187 | | Key_blocks_used | 43734 | | Key_read_requests | 2253647438 | | Key_reads | 69131 | | Key_write_requests | 1213563 | | Key_writes | 64025 | | Max_used_connections | 79 | | Not_flushed_delayed_rows | 0 | | Open_files | 1119 | | Open_streams | 0 | | Open_tables | 699 | | Opened_tables | 723 | | Qcache_free_blocks | 9224 | | Qcache_free_memory | 31021376 | | Qcache_hits | 5712228 | | Qcache_inserts | 1909570 | | Qcache_lowmem_prunes | 119383 | | Qcache_not_cached | 305550 | | Qcache_queries_in_cache | 24283 | | Qcache_total_blocks | 58298 | | Questions | 9418678 | | Rpl_status | NULL | | Select_full_join | 92268 | | Select_full_range_join | 0 | | Select_range | 30294 | | Select_range_check | 0 | | Select_scan | 701615 | | Slave_open_temp_tables | 0 | | Slave_retried_transactions | 0 | | Slave_running | OFF | | Slow_launch_threads | 0 | | Slow_queries | 30 | | Sort_merge_passes | 0 | | Sort_range | 396530 | | Sort_rows | 30994482 | | Sort_scan | 1620506 | | Table_locks_immediate | 6074811 | | Table_locks_waited | 34 | | Threads_cached | 65 | | Threads_connected | 14 | | Threads_created | 79 | | Threads_running | 2 | | Uptime | 67685 | +----------------------------+------------+ 163 rows in set (0.01 sec) mysql> show processlist; +---------+------------+------------------+--------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+------------+------------------+--------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ | 3412428 | root | localhost | NULL | Query | 0 | NULL | show processlist | | 3417991 | tnnews | 10.20.1.1:44888 | tn_news | Sleep | 48 | | NULL | | 3418326 | tnraovat | 10.20.1.1:45366 | raoban | Sleep | 24 | | NULL | | 3418331 | tnnews | 10.20.1.1:45372 | tn_news | Sleep | 18 | | NULL | | 3418333 | tnraovat | 10.20.1.1:45374 | raoban | Sleep | 23 | | NULL | | 3418496 | tnu01 | 10.20.1.30:44557 | new_v2 | Sleep | 3 | | NULL | | 3418505 | tnnetshop | 10.20.1.1:45564 | tn_netshop | Sleep | 1 | | NULL | | 3418506 | tnnhipsong | 10.20.1.1:45565 | tn_lifestyle | Query | 0 | Copying to tmp table | SELECT na.narticle_id, na.narticle_title, na.narticle_pic, na.narticle_note, na.narticle_subcontent, | | 3418509 | tnraovat | 10.20.1.1:45566 | raoban | Sleep | 1 | | NULL | | 3418512 | tnmusic | 10.20.1.30:44560 | tn_music | Sleep | 0 | | NULL | +---------+------------+------------------+--------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ 10 rows in set (0.00 sec)