<div>
Look at the MySQL processlist to make sure your issue does not stem from connections hanging around for an extended period of times.<br />
<br />
Look at the webserver log stats, requests per second/minute which pages, etc.<br />
<br />
What is the setup?
</div>


<div>
<div class="content wysiwyg-content">
How can I figure out why I have so many connections on my MYSQL Server?<br />
<br />
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. &nbsp;<br />
<br />
Is there some way I can start drilling down to see what the issue is?<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w48/1213242/Untitled-1.png" target="_blank" title="MYSQL Monitor Screenshot (240 KB)"><img alt="MYSQL Monitor Screenshot" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2017/11_w48/800_1213242/Untitled-1.png" /></a><br />
Thanks!
</div>
</div>


Untitled-1.png

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?



Thanks!

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?

MYSQL Connections Help

How can I figure out why I have so many connections on my MYSQL Server?

In the monitor area I&#39;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?



Thanks!

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.