Welcome to OCS Inventory NG community support, where you can ask questions and receive answers from other members of the community.

Please ask questions only in English or French.

Release 2.11.1 available

The official documentation can be found on http://wiki.ocsinventory-ng.org. Read it before asking your question.

Insert statements every Hour

Hi,

i'm using OCS-Server 2.8 running on RHEL 7.6.

Around 500 insert statements are executed on the table 'software' every full hour. The statements could not be finished. What is the reason for this insert's, a cron inside OCS ?

I've set this in the MySQL-config :

interactive_timeout=600
wait_timeout=600

Example :

INSERT INTO software (HARDWARE_ID,NAME_ID,PUBLISHER_ID,VERSION_ID,FOLDER,COMMENTS,FILENAME,FILESIZE,SOURCE,GUID,LANGUAGE,INSTALLDATE,BITSWIDTH) VALUES('2029','3409','155','1972','','Userspace configuration daemon required for some iSCSI hardware','','188237','0','','','2019-11-29 12:06:04','0')

in OCS Inventory NG server for Unix by (240 points)

5 Answers

0 votes
Hi,

Have you installed and enabled cve inventory ?

Regards

Frank
by (88.5k points)
0 votes
Hi,

cve inventory is not enabled.

regards

uwe
by (240 points)
0 votes
Hi,

What inventory frequency have you configured ? How many machines are inventoried ?

This is normal if frequency is set to 1h and you have about 2 000 machines.
by (88.5k points)
0 votes

Hi,

yes, frequency is set to 1h and we have about 1500 machines. I changed frequency to 1 day and the problem was over. The MySQL database was overloaded with the 1h-frequency, many clients answered at the same time. Do you have a few tips for tuning the db ?

regards

uwe

by (240 points)
0 votes
by (22.6k points)
 
Powered by Question2Answer
...