1 Antwort
- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
1
Hello.
The log is the rdsadmin operation log.
rdsadmin is a user who performs administrative operations on the AWS side.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MysQL.Concepts.UsersAndPrivileges.html
If you do not want rdsadmin logs to be output, add "rdsadmin" to "SERVER_AUDIT_EXCL_USERS" in the options group.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.MySQL.Options.AuditPlugin.html
Relevanter Inhalt
- AWS OFFICIALAktualisiert vor 3 Jahren
- AWS OFFICIALAktualisiert vor 3 Jahren
- AWS OFFICIALAktualisiert vor einem Jahr
thank you Added "rdsadmin" to "SERVER_AUDIT_EXCL_USERS" so there are no logs related to rdsadmin. I set performance.schema to 0 in parameter group, but performance_schema log remains Is there a way to not save this log?
The "performance_schema" is a static parameter and requires a restart of RDS to take effect.
Thanks for your answer. Tried rebooting, but SELECT st.* FROM performance_schema.events_statements_current st JOIN performance_schema.threads thr ON thr.thread_id = st.thread_id WHERE thr.processlist_id = 10',0, and 'SELECT st.* FROM performance_schema.events_stages_history_long st WHERE st . nesting_event_id = 0',0, and 'SELECT st.* FROM performance_schema.events_waits_history_long st WHERE st.nesting_event_id = 0',0,, Logs are saved. Whenever a select query is attempted, these three logs are saved together.
Since it is an execution of the DML language (Select), it may not be a problem if it is left in the audit log.
All right. Then we will save and use the three logs together. Thank you for answer.