@tesparza Fixed by increase the number of connections.

mysql
SET GLOBAL max_connections = 200;
flush hosts;

login as root into the database.

@george1421 Thanks, snponyl.efi worked. It also worked with all the other models of PCs we have, thaknk you.

@george1421

Running smooth so far. Yes it had 4GB before.

@george1421 Okay I have upgraded the RAM to 16gb. Will see how it goes. Thank you.

@george1421 Okay it seems to be running smoother, I will add more RAM, eventually I will transfer to a server.

@george1421 Okay interval changed to 300

@george1421

2000 + clients

Interval checkin time it 60 seconds

@george1421 Okay now everything is InnoDB, Server is running bad, web gui taking long time to load, can’t image. CPU usage is around 40%

FYI this is running of a Optiplex 7010 i5 quad core, 8gb ram

Do I maybe need to switch to a server?

@george1421 Okay I did the commands, some did error out saying they dont exist but this are the results of the final command. Website seems to be running smoother. Will continue to monitor.

+------------------------+--------+
| TABLE_NAME             | ENGINE |
+------------------------+--------+
| clientUpdates          | InnoDB |
| dirCleaner             | InnoDB |
| fileChecksums          | MyISAM |
| globalSettings         | InnoDB |
| greenFog               | InnoDB |
| groupMembers           | InnoDB |
| groups                 | InnoDB |
| history                | InnoDB |
| hookEvents             | InnoDB |
| hostAutoLogOut         | InnoDB |
| hostMAC                | InnoDB |
| hostScreenSettings     | InnoDB |
| hosts                  | InnoDB |
| hoststatus             | MyISAM |
| imageGroupAssoc        | InnoDB |
| imagePartitionTypes    | InnoDB |
| imageTypes             | InnoDB |
| images                 | InnoDB |
| imagingLog             | InnoDB |
| inventory              | InnoDB |
| ipxeTable              | InnoDB |
| keySequence            | InnoDB |
| location               | InnoDB |
| locationAssoc          | InnoDB |
| moduleStatusByHost     | InnoDB |
| modules                | InnoDB |
| multicastSessions      | InnoDB |
| multicastSessionsAssoc | InnoDB |
| nfsFailures            | InnoDB |
| nfsGroupMembers        | InnoDB |
| nfsGroups              | InnoDB |
| notifyEvents           | InnoDB |
| os                     | InnoDB |
| oui                    | InnoDB |
| plugins                | InnoDB |
| powerManagement        | InnoDB |
| printerAssoc           | InnoDB |
| printers               | InnoDB |
| pxeMenu                | InnoDB |
| scheduledTasks         | InnoDB |
| schemaVersion          | InnoDB |
| snapinAssoc            | InnoDB |
| snapinGroupAssoc       | InnoDB |
| snapinJobs             | InnoDB |
| snapinTasks            | InnoDB |
| snapins                | InnoDB |
| supportedOS            | InnoDB |
| taskLog                | InnoDB |
| taskStates             | InnoDB |
| taskTypes              | InnoDB |
| tasks                  | InnoDB |
| userCleanup            | InnoDB |
| userTracking           | InnoDB |
| users                  | InnoDB |
| virus                  | InnoDB |
+------------------------+--------+
55 rows in set (0.00 sec)

@george1421 I copy pasted the command but its not giving the results. Im running CentOS and MariaDB

@george1421 The command is not returning anything. Its blank Global and Session boxes

@george1421 Okay how can I fix my database issue?