Differences

This shows you the differences between two versions of the page.

--- mysql:problemresolution [2013/07/23 15:18] – rlunaro
+++ mysql:problemresolution [2013/10/04 10:10] (current) – removed rlunaro
@@ Line 1: / Line 1: @@
-====== Problem Resolution ======
-===== The fucking problem =====
-<code>
-/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.
-</code>
-===== Some tools =====
-This will show you the current connections:
-<code>
-show status like '%onn%';
-</code>
-Example of output:
-<code>
-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     |
-+--------------------------+-------+
-rows in set (0.00 sec)
-</code>
-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 =====
-<code>
-show variables like "max_connections";
-</code>