http://sarin.iteye.com/blog/580311
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)
分享到:
相关推荐
com.mysql.jdbc.CommunicationsException Communications link failure due to underlying exception:
如果单独写一个类,并编译执行访问数据库,正常,但是用web应用来调这个类连接数据库,就会出现错误:com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ...
The book is in two parts: the underlying structure of a computer, and programming in a high level language and programming methodology. To understand the computer, the authors introduce the LC-3 and ...
new ʻvisualizationsʼ are an attempt to explain the underlying information with a powerful visual impact. They take complex ideas and distil them into beautiful graphics revealing the ...
It includes methodologies and results related to link-level and system-level evaluations of LTE-Advanced. It provides understanding and insight into the advanced underlying technologies in LTE-...
His careful presentation of the underlying theories of fluids is still timely and applicable, even in these days of almost limitless computer power. This reissue ensures that a new generation of ...
A Practical Introduction to Machine Learning Concepts for Actuaries Alan Chalk, FIA, MSc, and Conan McMurtrie MSc Abstract Motivation. Supervised Learning - building predictive models based on past ...
Each section starts with a brief description of the statistic that is covered and important underlying assumptions, which help students select appropriate statistics. Each section describes how to ...
An Introduction to Mathematical Cryptography provides an introduction to public key cryptography and underlying mathematics that is required for the subject. Each of the eight chapters expands on a ...
After detection, the tracking of the multilevel patch features is closely coupled to the underlying extended Kalman filter (EKF) by directly using the intensity errors as innovation term during the ...
Visualizing data in plots and figures exposes the underlying patterns in the data and provides insights. Good visualizations also help you communicate your data to others, and are useful to data ...
an underlying two-dimensional cluster feature, we propose a two-dimensional sparse Bayesian learning method without a priori knowledge of two-dimensional angular spread patterns. It essentially ...
It is aimed at executives who would like to use machine learning in their business and want to understand the underlying mechanics, and for anyone else who wants to understand more about the ...
A Brief Review of ChatGPT: Its Value and the Underlying GPT TechnologyA Brief Review of ChatGPT: Its Value and the Underlying GPT TechnologyA Brief Review of ChatGPT: Its Value and the Underlying GPT ...
This textbook enables readers to design digital systems using the modern HDL approach while ensuring they have a solid foundation of knowledge of the underlying hardware and theory of their designs....
Need to learn how to wrap your head around Git, but don't need a lot of hand holding? Grab this book if you're new to Git, not to the world of programming. Git tasks displayed on two-page spreads ...
This textbook enables readers to design digital systems using the modern HDL approach while ensuring they have a solid foundation of knowledge of the underlying hardware and theory of their designs....
This textbook enables readers to design digital systems using the modern HDL approach while ensuring they have a solid foundation of knowledge of the underlying hardware and theory of their designs....
Building upon Mark Sobell's A Practical Guide to the UNIX System, this book provides step-by-step tutorials for OS X users eager to get the most from the underlying UNIX system. Peter Seebach and ...
in mineral processing industry due to the inherently chaotic nature of the underlying microscopic phenomena and the lack of sufficiently accurate process measurements. Digital image processing is a ...