Hi, syslog-ng can automatically create tables if you use macros in the table names. As for additional options, newer syslog-ng versions have a dbd-option() that can be used to set database options when syslog-ng connects the database (it might or might not be enough for your needs), see https://www.balabit.com/documents/syslog-ng-ose-latest-guides/en/syslog-ng-o... HTH, Robert On Mon, Mar 6, 2017 at 6:44 PM, Nik Ambrosch <nik@ambrosch.com> wrote:
When creating a table in a mysql destination, I have not found a way to specify additional options - I’d like to add row_format in order to enable innodb compression. A regular mysql query would look like this:
create table “my_table_yyyymmdd” (columns here) ROW_FORMAT=COMPRESSED;
Is it possible to tell syslog-ng to make this happen with syslog-ng or will i need to cron an external job to create the tables daily?
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