Insert statements every Hour

Question

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')

Answer 1

Hi,

Have you installed and enabled cve inventory ?

Regards

Frank

Answer 2

Hi,

cve inventory is not enabled.

regards

uwe

Answer 3

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.

Answer 4

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

Answer 5

can you try this to optimize database server performance?

https://2bits.com/articles/reduce-your-servers-resource-usage-moving-mysql-temporary-directory-ram-disk.html

Kind regards