Solved Fog Box CPU utilization maxed
My fog database computer CPU is being maxed so logging and changing tabs takes a while. the webpage crashes when i try to look at the logs.
this led me to try and run the Database Maintenance Commands listed here :
when i try to run this it tells me there are too many connections
ERROR 1040 (HY000): Too many connections
at this point im not sure what to do as i am not a SQL guy nor a Linux guy so i dont know where to look or what to look at to fix the connections issues
Stats of My box:
2 CPU with 2 cores @ 2ghz each
6 gigs ram
Cento os 7
fog version 1.5.0
max_connectionsis too low if you have a good amount of clients in your network having the FOG client software installed. Here is how you check and change that value in the live DB:
mysql> show variables like 'max_connections'; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_connections | 151 | +-----------------+-------+ mysql> set global max_connections = 500;
If you see this is helping you, take a look at the mysql configs and change setting there as well. Make sure you read this as well as we have seen issues with upping the max connection limit sometimes: https://www.rfc3092.net/2017/06/mysql-max_connections-limited-to-214-on-ubuntu-foo/ (just needs a bit of working around in some cases)
forgive me im not versed in sql, how do i grant myself the priveleges necessary to make that change?
@jherron Should be fine to connect as root to the DB:
shell> mysql -u root -p Password: ... mysql> ...
Thanks for all the help! things seem to be back in order!