查看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_clo