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 | +--------+------------+------------------+--------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ | 423595 | adminmv | 10.20.1.30:59874 | tn_movie | Sleep | 3353 | | NULL | | 426244 | adminmv | 10.20.1.30:60541 | tn_movie | Sleep | 3413 | | NULL | | 427624 | adminmv | 10.20.1.30:32833 | tn_movie | Sleep | 3445 | | NULL | | 427917 | adminmv | 10.20.1.30:32971 | tn_movie | Sleep | 3409 | | NULL | | 427942 | adminmv | 10.20.1.30:33048 | tn_movie | Sleep | 3392 | | NULL | | 444825 | tnraovat | 10.20.1.1:56173 | raoban | Sleep | 1774 | | NULL | | 445409 | adminmv | 10.20.1.30:37864 | tn_movie | Sleep | 1721 | | NULL | | 445410 | adminmv | 10.20.1.30:37865 | tn_movie | Sleep | 1721 | | NULL | | 445413 | adminmv | 10.20.1.30:37866 | tn_movie | Sleep | 1721 | | NULL | | 445463 | adminmv | 10.20.1.30:37879 | tn_movie | Sleep | 1711 | | NULL | | 445508 | adminmv | 10.20.1.30:37961 | tn_movie | Sleep | 1714 | | NULL | | 445563 | adminmv | 10.20.1.30:37982 | tn_movie | Sleep | 1709 | | NULL | | 445853 | adminmv | 10.20.1.30:38037 | tn_movie | Sleep | 1682 | | NULL | | 446248 | root | localhost | NULL | Query | 0 | NULL | show processlist | | 449328 | tnnetshop | 10.20.1.1:33166 | tn_netshop | Sleep | 1340 | | NULL | | 449796 | tnraovat | 10.20.1.1:33814 | raoban | Sleep | 1289 | | NULL | | 450786 | tnnews | 10.20.1.1:35181 | tn_news | Sleep | 215 | | NULL | | 451386 | tnraovat | 10.20.1.1:36108 | raoban | Sleep | 152 | | NULL | | 452891 | tnnews | 10.20.1.1:37940 | tn_news | Sleep | 0 | | NULL | | 452893 | tnnhipsong | 10.20.1.1:37942 | tn_lifestyle | Sleep | 0 | | NULL | | 452895 | tnmusic | 10.20.1.31:36947 | tn_music | Sleep | 1 | | NULL | | 452896 | tnu01 | 10.20.1.30:40923 | giaitri | Sleep | 1 | | NULL | | 452897 | tnmusic | 10.20.1.30:40924 | tn_music | Sleep | 1 | | NULL | | 452898 | tnmusic | 10.20.1.30:40925 | tn_music | Sleep | 1 | | NULL | | 452899 | tnnetshop | 10.20.1.1:37944 | tn_netshop | Sleep | 0 | | NULL | | 452900 | tnnetshop | 10.20.1.1:37945 | tn_netshop | Sleep | 0 | | NULL | | 452902 | tnnetshop | 10.20.1.1:37947 | tn_netshop | Query | 0 | Copying to tmp table | SELECT net_url.* , net_url.neturl_show as show_ FROM net_url LEFT JOIN net_url_customer ON net_url. | | 452903 | adminnews | 10.20.1.1:37948 | tn_news | Sleep | 0 | | NULL | | 452905 | tnu04 | 10.20.1.1:37950 | new_v2 | Sleep | 0 | | NULL | | 452907 | tnnews | 10.20.1.1:37952 | tn_news | Sleep | 0 | | NULL | | 452908 | tnmusic | 10.20.1.30:40930 | tn_music | Connect | 0 | Reading from net | NULL | | 452910 | tnmusic | 10.20.1.30:40931 | NULL | Connect | NULL | Reading from net | NULL | | 452911 | tnnhipsong | 10.20.1.1:37963 | tn_lifestyle | Sleep | 0 | | NULL | | 452912 | tnraovat | 10.20.1.1:37964 | raoban | Sleep | 0 | | NULL | | 452913 | tnraovat | 10.20.1.1:37966 | raoban | Sleep | 0 | | NULL | | 452914 | tnnetshop | 10.20.1.1:37967 | NULL | Connect | 0 | Reading from net | NULL | +--------+------------+------------------+--------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ 36 rows in set (0.00 sec)