mysql获取数据超时_Mysql 数据库超时

org.springframework.transaction.TransactionSystemException: Could not roll back JDBC transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.

The last packet successfully received from the server was 63,104 milliseconds ago.  The last packet sent successfully to the server was 0 milliseconds ago.​

1)interactive_timeout:

参数含义：服务器关闭交互式连接前等待活动的秒数。交互式客户端定义为在mysql_real_connect()中使用CLIENT_INTERACTIVE选项的客户端。

参数默认值：28800秒(8小时)

(2)wait_timeout:

参数含义：服务器关闭非交互连接之前等待活动的秒数。

在线程启动时，根据全局wait_timeout值或全局interactive_timeout值初始化会话wait_timeout值，取决于客户端类型(由mysql_real_connect()的连接选项CLIENT_INTERACTIVE定义)。

参数默认值：28800秒(8小时)

请检查如下设置

【mysqld】

wait_timeout=100

interactive_timeout=100

100单位为秒

MySQL命令行里通过SET来设置ÿ