查看mysql数据库最大连接数和已经连接的数量

MySQL报错Can not connect to MySQL server. Too many connections，报错，很明确，与MySQL的连接数满了。
首先我们先查看下数据线程池的一些数据
查看最大连接数
mysqladmin -uroot -p processlist
一般这个时候会提醒你连接数已经够多了，你已经进入不了数据库了，所有还是使用你当前的客户端工具查看吧

 SHOW PROCESSLIST;
 SHOW STATUS;
 SHOW VARIABLES LIKE "max_connections";

1.SHOW PROCESSLIST查看当前数据库连接
如果是root帐号，你能看到所有用户的当前连接。如果是其它普通帐号，只能看到自己占用的连接。
show processlist;只列出前100条，如果想全列出请使用show full processlist;

2.SHOW VARIABLES LIKE “max_connections” 查看最大连接数Threads_connected;

3.show status可查看当前已连接的数量

Variable_name	Value
Aborted_clients	1750
Aborted_connects	271
Binlog_cache_disk_use	0
Binlog_cache_use	0
Binlog_stmt_cache_disk_use	0
Binlog_stmt_cache_use	0
Bytes_received	39810
Bytes_sent	321179
Com_admin_commands	0
Com_assign_to_keycache	0
Com_alter_db	0
Com_alter_db_upgrade	0
Com_alter_event	0
Com_alter_function	0
Com_alter_procedure	0
Com_alter_server	0
Com_alter_table	2
Com_alter_tablespace	0
Com_alter_user	0
Com_analyze	0
Com_begin	0
Com_binlog	0
Com_call_procedure	0
Com_change_db	11
Com_change_master	0
Com_check	0
Com_checksum	0
Com_commit	0
Com_create_db	0
Com_create_event	0
Com_create_function	0
Com_create_index	0
Com_create_procedure	0
Com_create_server	0
Com_create_table	7
Com_create_trigger	0
Com_create_udf	0
Com_create_user	0
Com_create_view	0
Com_dealloc_sql	0
Com_delete	0
Com_delete_multi	0
Com_do	0
Com_drop_db	0
Com_drop_event	0
Com_drop_function	0
Com_drop_index	0
Com_drop_procedure	0
Com_drop_server	0
Com_drop_table	2
Com_drop_trigger	0
Com_drop_user	0
Com_drop_view	0
Com_empty_query	0
Com_execute_sql	0
Com_flush	0
Com_get_diagnostics	0
Com_grant	0
Com_ha_close	0
Com_ha_open	0
Com_ha_read	0
Com_help	0
Com_insert	41
Com_insert_select	0
Com_install_plugin	0
Com_kill	0
Com_load	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_release_savepoint	0
Com_rename_table	0
Com_rename_user	0
Com_repair	0
Com_replace	0
Com_replace_select	0
Com_reset	0
Com_resignal	0
Com_revoke	0
Com_revoke_all	0
Com_rollback	0
Com_rollback_to_savepoint	0
Com_savepoint	0
Com_select	69
Com_set_option	55
Com_signal	0
Com_show_binlog_events	0
Com_show_binlogs	0
Com_show_charsets	4
Com_show_collations	4
Com_show_create_db	5
Com_show_create_event	0
Com_show_create_func	0
Com_show_create_proc	0
Com_show_create_table	29
Com_show_create_trigger	0
Com_show_databases	5
Com_show_engine_logs	0
Com_show_engine_mutex	0
Com_show_engine_status	0
Com_show_events	0
Com_show_errors	0
Com_show_fields	31
Com_show_function_code	0
Com_show_function_status	5
Com_show_grants	0
Com_show_keys	31
Com_show_master_status	0
Com_show_open_tables	0
Com_show_plugins	0
Com_show_privileges	0
Com_show_procedure_code	0
Com_show_procedure_status	5
Com_show_processlist	7
Com_show_profile	0
Com_show_profiles	12
Com_show_relaylog_events	0
Com_show_slave_hosts	0
Com_show_slave_status	0
Com_show_status	36
Com_show_storage_engines	0
Com_show_table_status	12
Com_show_tables	10
Com_show_triggers	5
Com_show_variables	33
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_reprepare	0
Com_stmt_reset	0
Com_stmt_send_long_data	0
Com_truncate	0
Com_uninstall_plugin	0
Com_unlock_tables	0
Com_update	87
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	ON
Connection_errors_accept	0
Connection_errors_internal	0
Connection_errors_max_connections	1370
Connection_errors_peer_address	0
Connection_errors_select	0
Connection_errors_tcpwrap	0
Connections	12310
Created_tmp_disk_tables	103
Created_tmp_files	13110
Created_tmp_tables	309
Delayed_errors	0
Delayed_insert_threads	0
Delayed_writes	0
Flush_commands	1
Handler_commit	142
Handler_delete	0
Handler_discover	0
Handler_external_lock	316
Handler_mrr_init	0
Handler_prepare	0
Handler_read_first	28
Handler_read_key	726
Handler_read_last	0
Handler_read_next	0
Handler_read_prev	0
Handler_read_rnd	192
Handler_read_rnd_next	5482
Handler_rollback	0
Handler_savepoint	0
Handler_savepoint_rollback	0
Handler_update	516
Handler_write	5064
Innodb_buffer_pool_dump_status	not started
Innodb_buffer_pool_load_status	not started
Innodb_buffer_pool_pages_data	3845
Innodb_buffer_pool_bytes_data	62996480
Innodb_buffer_pool_pages_dirty	0
Innodb_buffer_pool_bytes_dirty	0
Innodb_buffer_pool_pages_flushed	301814
Innodb_buffer_pool_pages_free	4218
Innodb_buffer_pool_pages_misc	128
Innodb_buffer_pool_pages_total	8191
Innodb_buffer_pool_read_ahead_rnd	0
Innodb_buffer_pool_read_ahead	127
Innodb_buffer_pool_read_ahead_evicted	0
Innodb_buffer_pool_read_requests	126411955
Innodb_buffer_pool_reads	3187
Innodb_buffer_pool_wait_free	0
Innodb_buffer_pool_write_requests	612176
Innodb_data_fsyncs	397006
Innodb_data_pending_fsyncs	0
Innodb_data_pending_reads	0
Innodb_data_pending_writes	0
Innodb_data_read	54480896
Innodb_data_reads	3598
Innodb_data_writes	552289
Innodb_data_written	10014147584
Innodb_dblwr_pages_written	301814
Innodb_dblwr_writes	70817
Innodb_have_atomic_builtins	ON
Innodb_log_waits	0
Innodb_log_write_requests	68955
Innodb_log_writes	108688
Innodb_os_log_fsyncs	179512
Innodb_os_log_pending_fsyncs	0
Innodb_os_log_pending_writes	0
Innodb_os_log_written	88069120
Innodb_page_size	16384
Innodb_pages_created	525
Innodb_pages_read	3320
Innodb_pages_written	301814
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	91
Innodb_rows_inserted	9110
Innodb_rows_read	298911691
Innodb_rows_updated	108767
Innodb_num_open_files	276
Innodb_truncated_status_writes	0
Innodb_available_undo_logs	128
Key_blocks_not_flushed	0
Key_blocks_unused	6698
Key_blocks_used	0
Key_read_requests	0
Key_reads	0
Key_write_requests	0
Key_writes	0
Last_query_cost	10.499000
Last_query_partial_plans	1
Max_used_connections	215
Not_flushed_delayed_rows	0
Open_files	46
Open_streams	0
Open_table_definitions	358
Open_tables	395
Opened_files	44624
Opened_table_definitions	8
Opened_tables	2
Performance_schema_accounts_lost	0
Performance_schema_cond_classes_lost	0
Performance_schema_cond_instances_lost	0
Performance_schema_digest_lost	0
Performance_schema_file_classes_lost	0
Performance_schema_file_handles_lost	0
Performance_schema_file_instances_lost	0
Performance_schema_hosts_lost	0
Performance_schema_locker_lost	0
Performance_schema_mutex_classes_lost	0
Performance_schema_mutex_instances_lost	0
Performance_schema_rwlock_classes_lost	0
Performance_schema_rwlock_instances_lost	0
Performance_schema_session_connect_attrs_lost	0
Performance_schema_socket_classes_lost	0
Performance_schema_socket_instances_lost	0
Performance_schema_stage_classes_lost	0
Performance_schema_statement_classes_lost	0
Performance_schema_table_handles_lost	0
Performance_schema_table_instances_lost	0
Performance_schema_thread_classes_lost	0
Performance_schema_thread_instances_lost	0
Performance_schema_users_lost	0
Prepared_stmt_count	0
Qcache_free_blocks	1
Qcache_free_memory	1031352
Qcache_hits	0
Qcache_inserts	0
Qcache_lowmem_prunes	0
Qcache_not_cached	1389061
Qcache_queries_in_cache	0
Qcache_total_blocks	1
Queries	2094615
Questions	511
Rsa_public_key	
Select_full_join	0
Select_full_range_join	0
Select_range	0
Select_range_check	0
Select_scan	213
Slave_heartbeat_period	
Slave_last_heartbeat	
Slave_open_temp_tables	0
Slave_received_heartbeats	
Slave_retried_transactions	
Slave_running	OFF
Slow_launch_threads	0
Slow_queries	0
Sort_merge_passes	0
Sort_range	0
Sort_rows	351
Sort_scan	20
Ssl_accept_renegotiates	0
Ssl_accepts	0
Ssl_callback_cache_hits	0
Ssl_cipher	
Ssl_cipher_list	
Ssl_client_connects	0
Ssl_connect_renegotiates	0
Ssl_ctx_verify_depth	0
Ssl_ctx_verify_mode	0
Ssl_default_timeout	0
Ssl_finished_accepts	0
Ssl_finished_connects	0
Ssl_server_not_after	
Ssl_server_not_before	
Ssl_session_cache_hits	0
Ssl_session_cache_misses	0
Ssl_session_cache_mode	NONE
Ssl_session_cache_overflows	0
Ssl_session_cache_size	0
Ssl_session_cache_timeouts	0
Ssl_sessions_reused	0
Ssl_used_session_cache_entries	0
Ssl_verify_depth	0
Ssl_verify_mode	0
Ssl_version	
Table_locks_immediate	863932
Table_locks_waited	0
Table_open_cache_hits	1411
Table_open_cache_misses	1
Table_open_cache_overflows	0
Tc_log_max_pages_used	0
Tc_log_page_size	0
Tc_log_page_waits	0
Threads_cached	9
Threads_connected	162
Threads_created	1193
Threads_running	1
Uptime	887001
Uptime_since_flush_status	887001

Aborted_clients 由于客户没有正确关闭连接已经死掉，已经放弃的连接数量。
Aborted_connects 尝试已经失败的MySQL服务器的连接的次数。
Connections 试图连接MySQL服务器的次数。
Created_tmp_tables 当执行语句时，已经被创造了的隐含临时表的数量。
Delayed_insert_threads 正在使用的延迟插入处理器线程的数量。
Delayed_writes 用INSERT DELAYED写入的行数。
Delayed_errors 用INSERT DELAYED写入的发生某些错误(可能重复键值)的行数。
Flush_commands 执行FLUSH命令的次数。
Handler_delete 请求从一张表中删除行的次数。
Handler_read_first 请求读入表中第一行的次数。
Handler_read_key 请求数字基于键读行。
Handler_read_next 请求读入基于一个键的一行的次数。
Handler_read_rnd 请求读入基于一个固定位置的一行的次数。
Handler_update 请求更新表中一行的次数。
Handler_write 请求向表中插入一行的次数。
Key_blocks_used 用于关键字缓存的块的数量。
Key_read_requests 请求从缓存读入一个键值的次数。
Key_reads 从磁盘物理读入一个键值的次数。
Key_write_requests 请求将一个关键字块写入缓存次数。
Key_writes 将一个键值块物理写入磁盘的次数。
Max_used_connections 同时使用的连接的最大数目。
Not_flushed_key_blocks 在键缓存中已经改变但是还没被清空到磁盘上的键块。
Not_flushed_delayed_rows 在INSERT DELAY队列中等待写入的行的数量。
Open_tables 打开表的数量。
Open_files 打开文件的数量。
Open_streams 打开流的数量(主要用于日志记载）
Opened_tables 已经打开的表的数量。
Questions 发往服务器的查询的数量。
Slow_queries 要花超过long_query_time时间的查询数量。
Threads_connected 当前打开的连接的数量。
Threads_running 不在睡眠的线程数量。
Uptime 服务器工作了多少秒。

当前已经连接的数量如果达到最大连接数，再启动项目肯定就连接不上了，下一篇我会编辑下处理的办法。