- 论坛徽章:
- 0
|
我用的是自己写的连接池管理,
用show processlist查看状态, mysql线程在运行的就是6个左右,其他有1000多个都是sleeping 的
而且是在逐步增加的 ,运行时间越长,线程开的越多,直到数据库抱了too manay connections ,
最大连接数设置为300个的
下面是状态,希望大家指点
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 140 |
| Aborted_connects | 0 |
| Bytes_received | 517883997 |
| Bytes_sent | 2675658743 |
| Com_admin_commands | 1 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 1033 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 53 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_delete | 33041 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 118956 |
| Com_insert_select | 2352 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_purge | 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_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 3614727 |
| Com_set_option | 856 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 1 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 9 |
| Com_show_slave_hosts | 1 |
| Com_show_slave_status | 0 |
| Com_show_status | 11 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 17 |
| Com_show_variables | 750 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 1279451 |
| Connections | 1465 |
| Created_tmp_disk_tables | 396 |
| Created_tmp_tables | 160992 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 2 |
| Handler_commit | 0 |
| Handler_delete | 101366 |
| Handler_read_first | 27691 |
| Handler_read_key | 20563017 |
| Handler_read_next | 64860651 |
| Handler_read_prev | 46591473 |
| Handler_read_rnd | 4432395 |
| Handler_read_rnd_next | 4069077911 |
| Handler_rollback | 0 |
| Handler_update | 1415512 |
| Handler_write | 1911475 |
| Key_blocks_used | 47780 |
| Key_read_requests | 85308767 |
| Key_reads | 38004 |
| Key_write_requests | 97003 |
| Key_writes | 84991 |
| Max_used_connections | 300 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 250 |
| Open_files | 414 |
| Open_streams | 0 |
| Opened_tables | 11493 |
| Questions | 5219336 |
| Qcache_queries_in_cache | 0 |
| Qcache_inserts | 0 |
| Qcache_hits | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_free_memory | 0 |
| Qcache_free_blocks | 0 |
| Qcache_total_blocks | 0 |
| Rpl_status | NULL |
| Select_full_join | 17004 |
| Select_full_range_join | 0 |
| Select_range | 9655 |
| Select_range_check | 709 |
| Select_scan | 920573 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 106 |
| Slow_queries | 619 |
| Sort_merge_passes | 0 |
| Sort_range | 33462 |
| Sort_rows | 5371424 |
| Sort_scan | 152949 |
| Table_locks_immediate | 5317603 |
| Table_locks_waited | 108710 |
| Threads_cached | 0 |
| Threads_created | 1464 |
| Threads_connected | 301 |
| Threads_running | 2 |
| Uptime | 45488 | |
|
免费注册
发表于 2006-10-28 11:25
发表于 2006-10-29 10:24
