Heavy DB and Network Load from blacklisted macaddr - Githubissues

OCSInventory-NG / OCSInventory-Server

Communication server of OCS Inventory

http://www.ocsinventory-ng.org/

GNU General Public License v2.0

344 stars 139 forks source link

Heavy DB and Network Load from blacklisted macaddr #396

Closed EldoBam closed 1 year ago

EldoBam commented 2 years ago

General informations

Operating system : CentOS 7

Server informations

Perl version : 5.16.3 Mysql / Mariadb / Percona version : 10.2.XXX

OCS Inventory informations

Ocs server version : 2.9.2 Construct: 2 Frontend Server and 1 DB Server

Problem's description

In a bigger environment, ~40k Clients. The inventory causes a heavy DB and network load. 2 FE Server 16 Cores cpu at 100% 1 DB Server 16 Cores at 100%

I already found a fix and created a pull request #395

gillesdubois commented 2 years ago

Hi @EldoBam

We are going to review all the pull requests when the team is back from holidays :)

Regards, Gilles.