Very high CPU usage httpd, mysqld, FOGMulticastManager FOG trunk@5224

[Wayne Workman]

@Kiweegie go into mysql via CLI and look at the actual data, and let us see what you see.

mysql
use fog
select * from hosts;

[Wayne Workman]

@Kiweegie Lots of improvements in the last week to the new client, can you update and see if this affects the CPU load at all?

I suspect there will be a quite dramatic decrease after moving to client 010.5

[Kiweegie]

@Wayne-Workman Hi Wayne

apologies for not getting back to you til now, other projects keep piling up… I’ve checked the DB as you suggested via the cli and although only 3 hosts are listed in the GUI the cli shows 270 hosts…

|    270 | FOG01-current   |                                              |        |         3 |            0 | 2016-05-21 11:28:20 | 2016-05-21 11:44:32 | foguser        | 0         |                    |                                                    |                   |                                                                                                    |                  |                                                                                                    |                  |                |            |            |             |            |              | 0000-00-00 00:00:00 | 6            |              |             | 1           |

Above is last snippet.

I guess I can just drop the DB and start over?

cheers Kiweegie.

[Sebastian Roth]

@Kiweegie There have been a lot of improvements in the last two weeks! Mainly in the FOG client. Please upgrade to the latest version (first try the client, then FOG server) and see if things have changed for you as well.

[Kiweegie]

@Sebastian-Roth Just upgraded trunk (5554) using git now and getting this error on install

./bin/installfog.sh: line 452: installPackages: command not found

 * Confirming package installation

./bin/installfog.sh: line 456: confirmPackageInstallation: command not found

 * Configuring services


 * What is the storage location for your images directory? (/images)

[Quazz]

@Kiweegie You have to run installfog.sh while inside the bin directory otherwise it will fail in more way than one (just checked this on my installation to be sure)

[Kiweegie]

@Quazz Thanks Quazz but I am inside the bin directory as my screenshot shows I believe. It would fail well before there if not.

[Quazz]

@Kiweegie No, you ran this command

./bin/installfog.sh

which indicates you are not in the bin directory.

[Kiweegie]

@Quazz You’re quite right, apologies Quazz I stand corrected. I was in /opt/git/trunk and presumed running ./bin/installfog.sh would suffice. Must not be enough caffeine in the system this morning…

[Quazz]

@Kiweegie Any update on this? Is it better now?

[Kiweegie]

@Quazz Hi Quazz yes main problem of high cpu usage appears to be much better - main server with most number of hosts is sitting at 5-30% CPU load roughly with no active tasks running. I’m testing now with images running to double check under load.

cheers Kiweegie.