audit log plugin truncates sqlquery to 512 bytes
Bug #1557293 reported by
Jeremy Tinley
This bug affects 4 people
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.1 |
Invalid
|
Undecided
|
Unassigned | |||
5.5 |
Won't Fix
|
Medium
|
Unassigned | |||
5.6 |
Fix Released
|
Medium
|
Sergei Glushchenko | |||
5.7 |
Fix Released
|
Medium
|
Sergei Glushchenko |
Bug Description
https:/
512 feels arbitrary and counterintuitive to the point of logging queries. A reasonably long INSERT / ON DUPLICATE KEY UPDATE can easily pass 512 bytes and it leaves users in the dark about what's wrong. The plugin is supposed to be used to help fulfill requirements around HIPAA and SOX and truncated data doesn't fit that goal.
Suggestion:
Increase to a larger length or make it a configuration variable.
To post a comment you must log in.
https:/ /github. com/percona/ percona- server/ pull/572 /github. com/percona/ percona- server/ pull/573
https:/