-
Marek Szymczak authored
Problem ======= Audit API defined events of the 'MYSQL_AUDIT_TABLE_ACCESS_CLASS' class were not generated. Solution ======== Following events of the 'MYSQL_AUDIT_TABLE_ACCESS_CLASS' class are generated during execution of the listed queries: - MYSQL_AUDIT_TABLE_ACCESS_READ - SELECT - INSERT ... SELECT (table referenced in the SELECT clause) - UPDATE ... WHERE (tables referenced in the WHERE clause) - REPLACE ... SELECT (tables referenced in the SELECT clause) - HANDLER ... READ - MYSQL_AUDIT_TABLE_ACCESS_INSERT - INSERT - INSERT ... SELECT (table referenced in the INSERT clause) - REPLACE - REPLACE ... SELECT (table referenced in the REPLACE clause) - LOAD DATA INFILE - LOAD XML INFILE - MYSQL_AUDIT_TABLE_ACCESS_UPDATE - UPDATE - UPDATE ... WHERE (table or tables referenced in the UPDATE clause) - MYSQL_AUDIT_TABLE_ACCESS_DELETE - DELETE - TRUNCATE Queries executed from stored procedures or triggers generate exact table access events as executed separately. Execution of the prepared statement generate events depending on the content of the statement. Every event of a given subtype for a table is generated only once during a single query or subquery. Table access event generation does not reflect real I/O operation on a given table. Events are generated before the tables are being accessed. Events are also generated, when no real table access takes place, but there was intention to do so during preparing tables before the execution takes place. Events are not generated for temporary tables, views, information schema and performance schema tables. Reviewers ========= Marc Alff <marc.alff@oracle.com> Ramil Kalimullin <ramil.kalimullin@oracle.com>
Marek Szymczak authoredProblem ======= Audit API defined events of the 'MYSQL_AUDIT_TABLE_ACCESS_CLASS' class were not generated. Solution ======== Following events of the 'MYSQL_AUDIT_TABLE_ACCESS_CLASS' class are generated during execution of the listed queries: - MYSQL_AUDIT_TABLE_ACCESS_READ - SELECT - INSERT ... SELECT (table referenced in the SELECT clause) - UPDATE ... WHERE (tables referenced in the WHERE clause) - REPLACE ... SELECT (tables referenced in the SELECT clause) - HANDLER ... READ - MYSQL_AUDIT_TABLE_ACCESS_INSERT - INSERT - INSERT ... SELECT (table referenced in the INSERT clause) - REPLACE - REPLACE ... SELECT (table referenced in the REPLACE clause) - LOAD DATA INFILE - LOAD XML INFILE - MYSQL_AUDIT_TABLE_ACCESS_UPDATE - UPDATE - UPDATE ... WHERE (table or tables referenced in the UPDATE clause) - MYSQL_AUDIT_TABLE_ACCESS_DELETE - DELETE - TRUNCATE Queries executed from stored procedures or triggers generate exact table access events as executed separately. Execution of the prepared statement generate events depending on the content of the statement. Every event of a given subtype for a table is generated only once during a single query or subquery. Table access event generation does not reflect real I/O operation on a given table. Events are generated before the tables are being accessed. Events are also generated, when no real table access takes place, but there was intention to do so during preparing tables before the execution takes place. Events are not generated for temporary tables, views, information schema and performance schema tables. Reviewers ========= Marc Alff <marc.alff@oracle.com> Ramil Kalimullin <ramil.kalimullin@oracle.com>
Loading