Too Many mysqld processes

4 posts / 0 new
Topic locked
Last post
#1 Tue, 12/19/2017 - 16:57
indicium

Too Many mysqld processes

Hi There,

I have a set-up in AWS (t2.small) running a couple of Wordpress sites, I see increseanly amount of mysqld processes for no reason, the wordpress sites are very low trafic, if any, so there should not be a reason for this consumption. Any ideas ?

Ubuntu 16 installed from "script installer"

Screensthots. https://i.imgur.com/L9KbPPj.png https://i.imgur.com/sycJTpB.png https://i.imgur.com/pobwtif.png

Thanks in advanced.

Wed, 12/20/2017 - 05:45
indicium

No idea ? this is crazy, several set-ups, same issue ( all same settings ubuntu 16 AWS or a VM on a dedicated server)

- Indicium

Thu, 12/21/2017 - 03:31
7stars

Hello, please, what does Virtualmin have to do with "mysqld processes" ?

Of course, you may have a high wait_timeout on the .cnf and so the connections, even if idle, keep opened for a long time and also you need to check your max_connections value... to be related to what you really need...

that's it, no Virtualmin matter here

bye

Thu, 12/21/2017 - 08:58
tpnsolutions
tpnsolutions's picture

Hi,

*** If you're using CentOS 7, MySQL was replaced by MariaDB. In fact most distros did the same things in their latest releases. ***

If you have MariaDB installed, you should be able to find the log file at:

/var/log/mariadb/mariadb.log

*** If it's not there, the location should be listed in /etc/my.cnf ***

Hopefully the log will tell you a little more about what's going on.

Best Regards,
Peter Knowles | TPN Solutions
Email: pknowles@tpnsolutions.com | Skype: tpnassist
Topic locked