@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.
Sweet! Thank you very much! If the processor usage remains high, do you have anymore recommendations? I currently have 6 storage nodes in place to help with the deployment process. The main server seems to be struggling the most.
Hello everyone! Now that school is back in session and all of the computers in the school district are turned on, we noticed the CPU usage on the server has been extremely high. The only thing that we could think that would cause this is all of those machines are now constantly checking into the server. Is there a way to have the clients check less often? The only thing we use the fog client for is to join the hosts to the domain. Any suggestions?
I’m also having this problem with version 1.5.9-RC2.9
Hope you fine folks are doing well! While I’m running the community script to change my Image ID numbers, I get this error at the end of the script. Has anyone else seen this issue? ERROR 1292
@george1421 That is some good information! Thank you!
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.
Hey rhromyko! Thank you for that information! I was having the same problem.