Skip to content

Instantly share code, notes, and snippets.

@crainte

crainte/gist:abf7b44ad74da0bac342

Created February 10, 2015 22:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save crainte/abf7b44ad74da0bac342 to your computer and use it in GitHub Desktop.
Save crainte/abf7b44ad74da0bac342 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
connect_timeout = 15
wait_timeout = 120
@crainte
Copy link
Author

crainte commented Feb 10, 2015 

mysql> show variables like '%wait%';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| innodb_lock_wait_timeout | 50    |
| innodb_spin_wait_delay   | 6     |
| table_lock_wait_timeout  | 50    |
| wait_timeout             | 28800 |
+--------------------------+-------+
4 rows in set (0.01 sec)

mysql> show global variables like '%wait%';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| innodb_lock_wait_timeout | 50    |
| innodb_spin_wait_delay   | 6     |
| table_lock_wait_timeout  | 50    |
| wait_timeout             | 120   |
+--------------------------+-------+
4 rows in set (0.00 sec)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment