Syslog Performance

Started by Staj, November 15, 2018, 07:10:55 AM

Previous topic - Next topic

Staj

Does anyone else on here use the syslog feature with InnoDB? We keep having catastrophic performance issues when using it in any production capacity. How do others deal with this?

Victor Kirhenshtein

Hi,

what NetXMS version you are using? How many syslog records you are receiving? I know there are quite big installations on PostgreSQL that are writing lot of syslog messages. You can try to increase server configuration parameter DBWriter.MaxRecordsPerTransaction - that can increase transaction size and speed up inserts.

Best regards,
Victor