Communications link failure due to underlying exception

最新推荐文章于 2024-11-16 00:04:07 发布

原创最新推荐文章于 2024-11-16 00:04:07 发布 · 252 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#MySQL #.net #Blog

收录于

网上技术解答专栏收录该内容

41 篇文章

订阅专栏

本文展示了如何查看MySQL中各种超时设置，并演示了如何修改连接超时和交互超时等参数，以适应不同应用场景的需求。

[url]http://sarin.iteye.com/blog/580311[/url]　　

mysql> show variables like '%timeout';
+----------------------------+-------+
| Variable_name | Value |
+----------------------------+-------+
| connect_timeout | 10 |
| delayed_insert_timeout | 300 |
| innodb_lock_wait_timeout | 50 |
| innodb_rollback_on_timeout | OFF |
| interactive_timeout | 28800 |
| net_read_timeout | 30 |
| net_write_timeout | 60 |
| slave_net_timeout | 3600 |
| table_lock_wait_timeout | 50 |
| wait_timeout | 28800 |
+----------------------------+-------+
10 rows in set (0.00 sec)

mysql> set wait_timeout = 36000;
Query OK, 0 rows affected (0.00 sec)

mysql> set interactive_timeout = 36000;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like '%timeout';
+----------------------------+-------+
| Variable_name | Value |
+----------------------------+-------+
| connect_timeout | 10 |
| delayed_insert_timeout | 300 |
| innodb_lock_wait_timeout | 50 |
| innodb_rollback_on_timeout | OFF |
| interactive_timeout | 36000 |
| net_read_timeout | 30 |
| net_write_timeout | 60 |
| slave_net_timeout | 3600 |
| table_lock_wait_timeout | 50 |
| wait_timeout | 36000 |
+----------------------------+-------+
10 rows in set (0.00 sec)