I begun testing Perona Audit Plugin on MySQL Community Edition 5.5 and I’ve noticed that some long queries are being truncated. MySQL documentations says that the field might be truncated: “SQLTEXT
A string representing the text of an SQL statement. The value can be empty. Long values may be truncated. This attribute appears only if the NAME value is “Query” or “Execute”. ()”
but I was curious if there is any way to avoid this. We were planning on using audit in order to monitor queries executed on our databases, if the an update is truncated from the “where” clause, let’s say, it becomes diffcult to track back exactly which rows were affected.