[GitHub] [cloudstack] GabrielBrascher edited a comment on issue #4657: Management server looses MySQL connection: Timeout waiting for idle object

[GitBox <gi...@apache.org>]

GabrielBrascher edited a comment on issue #4657:
URL: https://github.com/apache/cloudstack/issues/4657#issuecomment-778150967


   @DaanHoogland unfortunately I don't have any due date to a patch on this one. So far we are in debugging process and we see it happening on 4.13.1.0; it might not even happen when we upgrade to 4.15.
   
   What we know so far is that the MySQL connections are not growing much, we have 1/3 or less of maximum connections. Thus, a leak would probably be on the Java side.
   
   
   @weizhouapache here follows some of our MySQL variables:
   ```
   show global variables like "wait_timeout";
   +---------------+-------+
   | Variable_name | Value |
   +---------------+-------+
   | wait_timeout  | 60    |
   +---------------+-------+
   ```
   
   ```
   show status where `variable_name` = 'Threads_connected';
   +-------------------+-------+
   | Variable_name     | Value |
   +-------------------+-------+
   | Threads_connected | 21    |
   +-------------------+-------+
   ```
   
   ```
   SHOW VARIABLES LIKE "max_connections";
   +-----------------+-------+
   | Variable_name   | Value |
   +-----------------+-------+
   | max_connections | 151   |
   +-----------------+-------+
   ```
   
   Maybe we can increase the timeout, what do you think?


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org