User perf_inventory already has more than 'max_user_connections' active connections

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: User perf_inventory already has more than 'max_user_connections' active connections

意思是这个用户已经达到最大的连接数，不能再连接获得更多连接。

max_connections 的意思是实例最多提供连接数，再多就会怎样呢？

mysql> show variables like "%connections";          
+----------------------+-------+
| Variable_name        | Value |
+----------------------+-------+
| max_connections      | 3000  |
| max_user_connections | 0     |
+----------------------+-------+

mysql> select @@max_user_connections;
+------------------------+
| @@max_user_connections |
+------------------------+
|                      0 |
+------------------------+

怎么查看某个用户已经用了多少连接？

mysql> show full processlist;  #查看用户
+----+------+-----------------+------+---------+------+-------+-----------------------+
| Id | User | Host            | db   | Command | Time | State | Info                  |
+----+------+-----------------+------+---------+------+-------+-----------------------+
|  4 | root | localhost:65325 | NULL | Query   |    1 | NULL  | show full processlist |
+----+------+-----------------+------+---------+------+-------+-----------------------+
1 row in set (0.06 sec)

mysql> show  processlist;
+----+------+-----------------+------+---------+------+-------+-------------------+
| Id | User | Host            | db   | Command | Time | State | Info              |
+----+------+-----------------+------+---------+------+-------+-------------------+
|  4 | root | localhost:65325 | NULL | Query   |    0 | NULL  | show  processlist |
+----+------+-----------------+------+---------+------+-------+-------------------+