We gave our server 32 GBs of Ram, 6 core Xeon processor, 10 GB Ethernet link, and 1 TB of SSD storage. It transfer at about 15 GB per minute while imaging 15 computers. The server specs are important, but having a good network to transfer the images on is just as important.
@george1421 That is some good information! Thank you!
@george1421 That did the trick! Thank you very much! In that same file that I opened, could I also increase the amount of handlers? Is that recommend? Is there any settings I could change to try and lower the amount of CPU usage the handlers need?
@george1421 I’m running the latest dev-branch, 1.5.9.36.
@sebastian-roth Hey man! I’m not able to view all of the hosts on the web ui. Whenever I click on list all hosts, it gives me an “HTTP ERROR 500”. We have over a 1,000 hosts registered in fog, is there a limit on how many you can view at one time? The same thing happens when we try to view the whole image history log or try and export all of our hosts. Any suggestions?
@george1421 I believe I got it! The overall processor usage has dropped, but I still see a lot of php-fpm in the “top” view in terminal. Thank you so much for your help!
I do have the access control plugin installed on our fog server. I figured that’s what the remaining MyISAM are from.
@george1421 I had to change the permissions of that file in order for me to add the text into that file. Now when I log into fog, I get this message.
This is the result.
@george1421 Still no luck. Here is the screenshot you requested.
@george1421 So I inserted the file that you sent the link to in the /var/lib/mysql folder. I tried and followed all of the steps and I’m still getting this error when I the script to change the type.
I’m using CentOS8 and running Fog server version 1.5.9-RC2.11
@george1421 When I followed the innodb steps on the link you sent me, I got some errors. For example, on the ALTER TABLE for tasks, I get this error “ERROR 1292 (22007): Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘ilFinishTime’ at row 2599” These are all of the effected ones that did not change. Any suggestions on how to fix this? CPU usage still seems to be high.
@george1421 Currently, mysql is using 1,415% of the processor. That doesn’t seem to be good. We have about 2,000 machines with the fog client installed. The main fog server has 32 GB of ram with 22 logical processors on it. My 6 storage nodes have 16gb of ram with 4 logical processors.
