mysql:problemresolution
This is an old revision of the document!
Table of Contents
Problem Resolution
The fucking problem
07/20 01:38:26 hibernate.util.JDBCExceptionReporter - Communications link failure The last packet successfully received from the server was 7.202.618 milliseconds ago. The last packet sent successfully to the server was 7.202.618 milliseconds ago.
Some tools
This will show you the current connections:
show status like '%onn%';
Example of output:
mysql> show status like '%onn%'; +--------------------------+-------+ | Variable_name | Value | +--------------------------+-------+ | Aborted_connects | 0 | | Connections | 50 | | Max_used_connections | 9 | | Ssl_client_connects | 0 | | Ssl_connect_renegotiates | 0 | | Ssl_finished_connects | 0 | | Threads_connected | 8 | +--------------------------+-------+ 7 rows in set (0.00 sec)
Pay attention to the data “Threads_connected”, which is similar to the result of the show processlist
.
What are the maximum connections that mysql can have
show variables like "max_connections";
What are the maximum timeout that a connection will be kept open
mysql> show variables like '%imeout%'; +----------------------------+----------+ | Variable_name | Value | +----------------------------+----------+ | connect_timeout | 10 | | delayed_insert_timeout | 300 | | innodb_lock_wait_timeout | 50 | | innodb_rollback_on_timeout | OFF | | interactive_timeout | 28800 | | lock_wait_timeout | 31536000 | | net_read_timeout | 30 | | net_write_timeout | 60 | | slave_net_timeout | 3600 | | wait_timeout | 28800 | +----------------------------+----------+ 10 rows in set (0.00 sec)
mysql/problemresolution.1374593528.txt.gz · Last modified: 2022/12/02 21:02 (external edit)