On 04/01/2015 12:51 PM, C.L. Martinez wrote:
Hi all,
In the following weeks, I need to install a syslog collector server
using mysql as a backend to store all logs (and I would like to use
OpenBSD 5.7 to accomplish that).
I expect +/- 5k-6k EPS from our servers (unix, linux, windows). As a
syslog process I will use syslog-ng or rsyslog. But my question is about
using mysql under OpenBSD.
Due to the log volume, I will need to do, probably, some type of
"tuning" in mysql side.
Somebody uses mysql in production environments with a respectable
amount of inserts under OpenBSD? Tips & tricks about what options to use
under fstab where mysql stores all data, memory limits, etc?
Thanks.
Please, any inputs?
