Announcement

Announcement Module
Collapse
No announcement yet.

Maximum used connections forever growing

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Maximum used connections forever growing

    We've a situation where munin monitoring is showing that the maximum used connections grows (by periodic jumps) but never falls. It continues to do this until the mysql server is rebooted, when it goes back to the starting level and the process starts all over again.

    It is puzzling why the number of connections is growing - numbers of threads connected or new connections are pretty steady. And running "show processlist" frequently shows only a handful of active processes.

    What could be causing the apparently never ending growth in maximum used connections?

  • #2
    This variable is a "high-water mark" so it never decreases.

    Comment


    • #3
      OK, that makes sense - up to a point.

      But it's not clear why the maximum should be pushed up further as time goes by rather than hitting a peak within, say, 24 hours when a complete cycle of activities has been completed.

      A graph of connections per second is attached. The maximum used figure can stay constant for a couple of days, but then bumps up. The same thing appears to keep happening - it's not clear why the server hasn't reached a steady state. The increase seems to go on and on. We're concerned about the apparent memory requirement on a server that on the face of it is over specified for the load imposed on it.

      Average figures from munin can hide spikes. But why would there be ever higher spikes over a period of many days?

      Comment


      • #4
        Or looking at the graph over a month, the max connections keeps bumping up, but there's no sign of anything special happening in threads connected or new connections.

        Comment


        • #5
          You have some intermittent spikes in Threads_connected that you are not detecting. I would install pt-stalk and pt-collect from Percona Toolkit and make it trigger on Threads_connected > 10 to find out what is happening during these times.

          Comment

          Working...
          X