Update auditlog_rotation_time

Help
1

Please guide us on how to update the auditlog_rotation_time from 1 hour to 24 hours. We are encountering the below error.

memsql> set global auditlog_rotation_time=86400;
ERROR 1238 (HY000): Variable ‘auditlog_rotation_time’ is a read only and only settable at startup variable

2

You have to update the variable in the configuration file, then restart the cluster. The preferred method is with SingleStore Tools (sdb-admin update-config). See

2 Likes
3

This worked, Many Thanks

1 Like