Hi, Forget any SQL to store logs, it is a bad juju as Bazsi mentioned. It will be painfully slow and far from ideal. Move to ElasticSearch or even Graylog (both free with paid options), you'll be more happier :) My recent personal favorite is Graylog, which can scale both horizontally, vertically and financially :) https://www.graylog.org/downloads#open-source L: On Sun, Mar 22, 2020 at 8:34 PM Sync IT <syncit-bd@live.com> wrote:
Hi I have installed syslog-ng on a ubuntu machine. Mysql has been used to store the logs. But i keep seeing the logs are missed. that means logs are not storing properly. any idea what is wrong with it. it normally happened at the end of the day close to 12am. Kindly help. Thanks
______________________________________________________________________________ Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng FAQ: http://www.balabit.com/wiki/syslog-ng-faq