Solved Fog Box CPU utilization maxed

[jherron]

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 :
https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL#Database_Maintenance_Commands

when i try to run this it tells me there are too many connections
ERROR 1040 (HY000): Too many connections
[btsdit@localhost ~]$

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

[jherron]

Thanks for all the help! things seem to be back in order!

[Sebastian Roth]

@jherron Should be fine to connect as root to the DB:

shell> mysql -u root -p
Password:
...
mysql> ...

[jherron]

forgive me im not versed in sql, how do i grant myself the priveleges necessary to make that change?

[Sebastian Roth]

@jherron Usually max_connections is 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)