Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

原因:com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:通信链路故障

我将mysql max_conncetions设置为1000,“ SHOW PROCESSLIST ”查询向我显示了许多休眠进程。这些是闲置的吗? 


EDIT:

Setup Mysql (localhost):

[mysqld]

user=mysql

port=3306

socket =/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock

key_buffer=16M

max_allowed_packet=1M

table_open_cache=64

sort_buffer_size=512K

net_buffer_length=8K

read_buffer_size=256K

read_rnd_buffer_size=512K

myisam_sort_buffer_size=8M

max_connections = 1000

wait_timeout = 28800

interactive_timeout = 28800


HikariCP: HikariCP-java6-2.2.5.jar

MySQL Connector: mysql-connector-java-5.1.25-bin.jar

解决方案


两件事。首先,HikariCP、Java和MySQL驱动程序的版本是什么?

第二,一个池中有400个连接?太多了!在每个池中从10到20开始。你会惊讶于每秒可以处理几千个事务。

第三,这是常见问题解答中的第二个问题。阅读答案和链接。您需要将maxLifetime设置为比MySQL本机超时短(1分钟)。

最后,打开调试日志记录,HikariCP没有噪音。每30秒,内务处理线程就会运行并记录池统计信息。



Couple of things. First, What version of HikariCP, Java, and the MySQL driver?

Second, 400 connections in one pool? Way too many! Start with 10 to 20, in each pool. You'll be surprised that you can handle a few thousand transactions per second.

Third, this is the second question in the FAQ. Read the answer and the link. You need to set maxLifetime to something shorter (by 1 minute) than your MySQL native timeout.

Lastly, turn on DEBUG logging, HikariCP is not noisy. Every 30 seconds, the housekeeping thread runs and logs pool statistics.


 ​