RC10 Broken Items on upgrade
-
Ok, so I can just SVN up? and Where would I increase max_connections, and by how much?
-
@adukes40 The RC working is done purely through git as branching is greatly simplified. So svn up will not work in your case.
I dont know the os fog is running on but it normally is found in /etc/my.cnf or /etc/mysql/my.cnf but your location might vary.
I’d say start by setting max_connections to 300. Once you make the change you will have to restart the MySQL service.
-
@adukes40, I only know how with git. Message me and I’ll give you the commands.
-
@Tom-Elliott Before I read this I found the my.cnf file. It currently shows:
#max_connections = 100
Do I also need to remove the # sign?
-
@adukes40 yes the Linux class you’re taking probably hasn’t told you yet, typically # in scripting means a comment so anything after that point will not be executed for that line.
-
@Tom-Elliott Ok, so max_connections is now set to 300
when I type mysql it lets me in now. it was saying too many connections before. However the GUI is still the same. can’t load/slow. I haven’t updated yet though. -
BTW its almost feels like the slowness when one of the remote nodes can’t contact the master, and causes it to load slower. except in this situation when I see the dashboard, it cannot see any of the remote sites. It shows then on the graph, but this is all I see.
-
@adukes40 to test your theory just disable graph enabled on all nodes. For now it’s likely faster to do this than to try testing potentially many other unknowns. Of course this could all be fixed in RC 11 already but I doubt it. There is minimal reliance on nodes being available or not though. It really only needs “access” to see if the node is available or not. This shouldn’t hurt anything but it may delay load up of dashboard page by two seconds per node that’s disabled. This is because I have to check twice if the page is available to generate my URL lists for bandwidth and client checks. I’ll rework it tonight to generate the list of URLs only once on initial load up of the page. This should help limit redundant checks and improve overall availability
If you can
-
@Tom-Elliott It is brutal, but I will try to disable the nodes first.Good news is that imaging actually works here at the master site. Takes a bit longer to get to the image part, but its actually makes it. Just anytime it needs to communicate to the DB it takes its sweet time.
-
OK, all disabled except the master, but no change in performance.
-
@adukes40 graph disabled and node disabled are two different things. Graph disabled just doesn’t report disk usage or bandwidth usage. The node still operates fully.
-
@Wayne-Workman All graphs are now disabled. Still having issues connecting to home page. and still looks like this:
-
@adukes40 check your cpu usage on your desktop when accessing the web interface. See how much power the browser is using.
Also, the output from
top
on the server when trying to access the dashboard would be useful. -
@Wayne-Workman Computer CPU - Chrome hit 02% max…
here is best I could get you from TOP
-
@adukes40 apache is working pretty hard. And I’m not positive but it looks like some of those apache processes have been running a long time. @Tom-Elliott @george1421?
-
@adukes40 said in RC10 Broken Items on upgrade:
Can you reset all host encryption data? Do this from mysql cli
Connect by:
mysql -u root fog
Run command
update hosts set hostSecToc='';
-
@Tom-Elliott root@MSDCATS09:~# mysql -u fog
ERROR 1045 (28000): Access denied for user ‘fog’@‘localhost’ (using password: NO) -
@adukes40 please see same post after edit sorry I forgot to add root for the -u arg
-
@Tom-Elliott mysql> update hosts set hostSecToc=‘’;
ERROR 1054 (42S22): Unknown column ‘hostSecToc’ in ‘field list’ -
@adukes40 can you get output of
describe hosts \G