• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 62
  • Last Modified:

MYSQL Connections Help

How can I figure out why I have so many connections on my MYSQL Server?

In the monitor area I'm showing around 90-100k connections at any given time and there are only a handful of people on the website at any given time.  

Is there some way I can start drilling down to see what the issue is?

MYSQL Monitor Screenshot
Thanks!
0
Nathan Riley
Asked:
Nathan Riley
1 Solution
 
David FavorLinux/LXD/WordPress/Hosting SavantCommented:
This is best answered by getting into all your system logs - syslog + Apache + PHP-FPM + MySQL.

No way to answer with a great deal of context.

Best to get into your logs + trace one Apache request through all your logs + ensure your MySQL connections go through buildup + teardown correctly.

If you're using custom code, it may be that teardown is failing... so connections remain open for very long amounts of time.
0
 
arnoldCommented:
Look at the MySQL processlist to make sure your issue does not stem from connections hanging around for an extended period of times.

Look at the webserver log stats, requests per second/minute which pages, etc.

What is the setup?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now